Add special characters in database.properties file
Im having trouble to configure my database password which have special characters, for example "Pa$$word".
In the database.properties I tried the following configuration:
db.password=Pa$$word but when I tried to start tomcat and exception ocurred, then I decided to escape the specials characters like so:
db.password=Pa\$\$word this time I received an access denied exception.
I know my problem is with the special characters because when I changed the db connection password to Password and configured the database.properties I could start tomcat without any problem.
So can you guys tell me how can I add special characters to the database.properties file?
Im using Bonita 7.5.4,
Why restrict yourself to 8 digits passwords they are known to be easy to break.
Why not use passphases as all security personnel are now recommending. Something that is 16 letters long is much harder to crack than 8 digits with special characters.
After more research I found out what cause the issue.
The setup tool use the values in database.properties to replace tokens defined in bonita.xml file (located in setup/tomcat-templates). In order to perform this search and replace it use replaceAll method that give special meaning to the $ and \ character in the replacement string.
I report the issue and here is a temporary workaround: simply edit the bonita.xml file located in setup/tomcat-templates and manually replace @@ds1.database_connection_password@@ and @@ds1.database_connection_password@@ with your password.
Interesting, after following your instructions and manually replace the password in bonita.xml, in the end I had to replace the password in bitronix-resources.properties that is in the same directory and I had to do it too in the file internal.properties inside of the setup directory.
After doing that I could launch the portal, thanks for your help.