Modifying PostreSQL connection settings

If your PostgreSQL configuration changes for your AX Server database, you need to update the connection settings for AX Server, and for AX Engine Node and AX Exception if they are part of your ACL Analytics Exchange implementation.

To modify your PostgreSQL connection settings:

  1. Modify the aclDatabase.xml and aclQuartz.properties template configuration files with the settings required for your database. The aclQuartz.properties file is not used if AX Exception is installed on a separate server. For non-SSL configurations use the files in the PostgreSQL folder, and for SSL configurations use the PostreSQL_SSL subfolder.

    The template folders are located in the Installation_Backup\Configuration subfolder where the ACL Analytics Exchange application server you are updating is installed. Save and close the file after you have made the necessary changes.

  2. Modify the db-resource-adapter XML file for your configuration with the connection information for your server. The DatabaseName, ServerName, and PortNumber must have the correct settings to connect to your AX Server database. Save and close the file after you have made the necessary changes.
  3. Copy aclDatabase.xml and aclQuartz.properties from the template folder to the geronimo\var\config subfolder. You should delete the database account information from the aclDatabase.xml template file after you copy the file to the config subfolder.
  4. Redeploy the database layer. The required uid and pwd values are the username and password you use to log in to the Geronimo Console web application and the AX Server Configuration web application. You also need to replace <version_number> with the correct version number for your installation.

    Non-SSL

    java -jar %GERONIMO_HOME%\bin\deployer.jar --user uid --password pwd redeploy tranql-connector-postgresql-local-1.2-20091005.194848-4.rar db-resource-adapter-postgres.xml com.acl.ax.server/AclAuditExchangeDbPool/<version_number>/rar

    SSL

    java -jar %GERONIMO_HOME%\bin\deployer.jar --user uid --password pwd redeploy tranql-connector-postgresql-local-1.2-20091005.194848-4.rar db-resource-adapter-postgres-ssl.xml com.acl.ax.server/AclAuditExchangeDbPool/<version_number>/rar
  5. Restart the Geronimo application server service.
  6. Navigate to the Geronimo Console and start any components that have not started automatically in the Web App Wars and Application EARs pages under Applications in the Console Navigation treeview.

    AX Server

    • com.acl.ax.server/db/<version_number>/car

    • com.acl.cas/cas-server/<version_number>/war

    • com.acl.ax.server/AclAuditExchange/<version_number>/car

    • com.acl/gateway-backend/<version_number>/war

    • com.acl.ax/webclient/<version_number>/war

    • com.acl.ax.server/AXSystemAdministration/<version_number>/car

    • com.acl.ax.server/rest/<version_number>/car

    AX Engine Node

    • com.acl.ax.server/db/<version_number>/car

    • com.acl.ax.server/AclSchedulingNode/<version_number>/car

    AX Exception

    • com.acl/ax-em_admin/<version_number>/war

    • com.acl/exceptionmgmt/<version_number>/war

Related tasks
Related reference

(C) 2015 ACL Services Ltd. All Rights Reserved.