Our app runs on Tomcat. On startup, we read a properties file that is expected to be at a certain location on the server. Among other things the properties file contains the details for connecting to a database.
Each of our clients have their own instance of the app. It is either hosted by us or is run on a server in their facility.
One of our clients is worried about the password required to connect to the database being stored as plain text in this properties file. A lot of ideas are being discussed in the team about encrypting the password in the file using a shared key or public-private key etc. But none seem like a good solution to me. The fact that a key would have to be hardcoded in the source code seems like a bad idea.
I feel it would be better to prompt the client somehow for a password anytime they start tomcat and let them manually specify the password.
Have you dealt with a similar situation? What solutions have you used.
Thanks.