The database connection properties are stored in an encrypted file in the xMatters installation folder. If you change the login ID or password, you must update the encrypted properties file or xMatters will not be able to access the database.
To change the xMatters database connection credentials:
- Navigate to the xMatters installation folder.
- In the \common\ subfolder, locate the common.properties file. This file is encrypted and must be decrypted before you can edit it.
- To decrypt the common.properties file, run the following command:
APSecure.bat decrypt common\common.properties common.txt
- Once the file is decrypted, open it in a text editor and locate the following section:
#Mon Mar 10 15:23:10 PDT 2008 JDBC_DRIVER_CLASS_NAME=net.sourceforge.jtds.jdbc.Driver JDBC_USERNAME=ALARMPOINT321 JDBC_URL=jdbc\:jtds\:sqlserver\://192.168.3.157\:1433 JDBC_PASSWORD=password
- Edit the properties as required, using the following descriptions as a guide:
- JDBC_DRIVER_CLASS_NAME: Name of the JDBC driver used to connect to the database. Note that MS SQL Server and Oracle require different drivers.
- JDBC_USERNAME: Login ID or User Name xMatters uses to connect to the database.
- JDBC_URL: Type of database server, IP, and port for the database connection.
- JDBC_PASSWORD: Password that matches the Login ID or User Name.
- Save and close the common.properties file, and then run the following command to encrypt the file again:
APSecure.bat encrypt common.txt common\common.properties
- Restart the xMatters Node and the xMatters web server.
JDN-1073 Originally created by Don Clark