How can I use scripting to switch the ConnectAll Database information in the db.properties if the password is stored encrypted?

Products

• ConnectAll On-Prem
• ConnectALL

Issue/Introduction

How can I use scripting to switch the ConnectAll Database information in the db.properties if the password is stored encrypted?  It was recommended to first run the install with a dummy DB and then switch to the existing Database.

How can we switch the database using the command line (so that it can be automated)? The DB information is stored in /opt/ConnectALL/Core/conf/db.properties. It would be trivial to edit the file except that the password is stored encrypted. 

Is there an API or another way to switch the database information in the configuration?

Resolution

The following just shows the workaround for the encrypted password portion of the scripting:

• Stop all ConnectAll services
• Edit the db.properties file and change the jdbc.pwd to the non-encrypted password.  This will automatically change it back to encrypted after restarting the ConnectAll services
• Start all ConnectAll services