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
v7.0.0 installation fails during configuring wildfly Failed to set session cookie. Error message - Unable to connect to co… 57Number of Views Failed to connect to the database error during upgrade to RSA Identity Governance & Lifecycle 7.0.1 226Number of Views RSA Identity Governance and Lifecycle SSL connectivity fails and throws 'Certificates does not conform to algorithm constr… 139Number of Views On RSA Via Lifecycle and Governance the aveksa_server start returns message: Cannot connect to the database, but the DB is up 672Number of Views Error: Failed to connect to Identity Router, RSA SecurID Access Authenticate app tokencodes fail with an RSA Authenticatio… 210Number of Views
Trending Articles
RSA MFA Agent 2.4.3 for Microsoft Windows Group Policy Object Template Guide RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA MFA Agent 2.4.3 for Microsoft Windows Installation and Administration Guide Downloading RSA Authentication Manager license files or RSA Software token seed records RSA Authentication Manager Upgrade Process
Don't see what you're looking for?