Page History

In most cases, this step is not necessary, but some installations require changing the password When there is a change in the database or a migration of the database user from time to time. This might be done on a schedule or only as needed. If the database password is changed for whatever reason, you must also update the following configuration files in 

Updating the Database Connection Details

1. If the password has been changed, first determine whether the password is encrypted. To do so, check the db.password.encrypted property in the file located at AL-HOME/resources/java/build/local.properties.
   • If the property is set to Yes, the password is encrypted, and you must encrypt the new password using this command in the command prompt: AL-HOME/Agiloft/jre/bin/java -jar AL-HOME//Agiloft/resources/java/lib/encrdecr.jar -e <your-password>
   • If the property is set to No, you can use the password as it is.
2. Next, modify the configuration file. On Windows, this is located at C:\EnterpriseWizardConfig.xml, and on Linux, it is located at /etc/EnterpriseWizardConfig.xml.
3. In the file, review each of the following tags and update them if they have changed:
   • databaseAdminLogin and databaseAdminPassword: the database user name and the corresponding encrypted password
   • databaseEwLogin and databaseEwPassword: the Agiloft's database user name and the corresponding encrypted password
   • databaseReaderLogin and databaseReaderPassword: a read-only user for the Agiloft database, and the corresponding encrypted password
   • databaseName: the name of the database
   • databaseAddress: the host name or IP address of the database
   • databasePort: the port number used for the database connection
4. Save your changes to the file.
5. Next, modify the file at AL-HOME
6. Make sure to stop the services before making changes to the files.
7. Update each file to reflect the updated password:
8. /etc/EnterpriseWizardConfig.xml for Linux, C:\EnterpriseWizardConfig.xml for Windows
ALHOME/resources/java/build/local.properties
9. ALHOME/wildfly/standalone/configuration/agiloft.xml

...

1. .
2. Update the following properties:
   • db.port
   • db.server
   • db.host
   • db.name
   • db.password
   • db.ro_password
   • db.login=ewuser
   • db.ro_login=ewreader
3. Now, stop Agiloft using this command in the command prompt: Execute AL-HOME/bin/ew-control -a stop
4. Next, use this command: AL-HOME\bin\ant -v -f AL-HOME\resources\java\build\build.xml -l <ALHOME>\logs\M_installer_jboss-config.log installer:jboss-config
5. Now, start Agiloft using this command: Execute AL-HOME/bin/ew-control -a start.

If you encounter problems when restarting the application, reach out to Support and include these log files to aid investigation:

• AL-HOME\logs\M_installer_jboss-config.log
• AL-HOME\wildfly\standalone\configuration\agiloft.xml
• AL-HOME\wildfly\standalone\configuration\*.cs
• AL-HOME\wildfly\standalone\log\server.log

...