Add special characters in database.properties file

Submitted by mzhu on Mon, 08/07/2017 - 17:16
1
0
-1

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,

Thanks,

database configuration

Comments

Submitted by Sean McP on Tue, 08/08/2017 - 18:42

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.

Permalink
Submitted by mzhu on Wed, 08/09/2017 - 17:03

The 8 digits password was just and example, about the specials characters, well its part of the business policy is not something that I can change easily.

Didn´t hear about passphrases before, ill keep that in mind for the future, thanks for you suggestion.

Permalink
2 answers

Submitted by antoine.mottier on Wed, 08/09/2017 - 11:02
1
0
-1
This one is the BEST answer!

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.

Comments

Submitted by mzhu on Wed, 08/09/2017 - 16:58

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.

Permalink

Submitted by antoine.mottier on Tue, 08/08/2017 - 09:13
1
0
-1

Can you try to escape the $ character by using #{'$'} instead?

Comments

Submitted by mzhu on Tue, 08/08/2017 - 15:52

Thanks for your answer antoine, I configured the file with:
db.password=Pa#{'$'}#{'$'}word
But didn´t work :(, got the acces denied exception again.

Permalink
Notifications