How to connect to SQL in RSA Authentication Manager 8.x
Originally Published: 2013-10-09
Article Number
Applies To
RSA Product/Service Type: RSA Authentication Manager
RSA Version/Condition: 8.x
Issue
Resolution
- SSH to the primary Authentication Manager server.
- Navigate to /opt/rsa/am/utils.
- Obtain the password for rsa_dba user:
rsaadmin@am8p:/opt/rsa/am> cd /opt/rsa/am/utils
rsaadmin@am8p:/opt/rsa/am/utils>./rsautil manage-secrets -a get com.rsa.db.dba.password
Please enter OC Administrator username: <enter Operations Console administrator user name>
Please enter OC Administrator password: <enter Operations Console administrator password>
com.rsa.db.dba.password: fPzg9Z9FRSMNkLXCSX22S2L0hhdikV
- This value is unique for each installation of Authentication Manager. Copy the com.rsa.db.dba.password value that you see to a text editor.
- Navigate to /opt/rsa/am/pgsql/bin.
- Connect to psql:
rsaadmin@am8p:/opt/rsa/ampgsql/bin> ./psql -p 7050 -h localhost -d db -U rsa_dba
Password for user rsa_dba: <enter the com.rsa.db.dba.password value from step 4>
psql.bin (9.1.8)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.
Related Articles
Error: 'Error running sdrepmgmt. Unable to connect to database. A replica management session may already be running. Only … 53Number of Views Access Manager is unable to connect to Active Directory even after expired Domain Controller certificate is replaced 39Number of Views v7.0.0 installation fails during configuring wildfly Failed to set session cookie. Error message - Unable to connect to co… 59Number of Views Error: '[Date/Time] Unable to connect to session server: Connection refused' in KCA/KRA admin-error.log 49Number of Views AAOP in tomcat 6 'Unable to connect to the DB connection for the image service'<DATASTORE_ERROR ' Unable to get DB connect… 90Number of Views
Trending Articles
RSA Release Notes for RSA Authentication Manager 8.8 Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA Authentication Manager 8.9 Release Notes (January 2026) How to create and configure certificates for HTTPS access when using intermediate CA certs in RSA Identity Governance & Li… Authentication Manager Supported Hardware and Upgrade Paths
Don't see what you're looking for?