How to connect to SQL in RSA Authentication Manager 8.x
2 years ago
Originally Published: 2013-10-09
Article Number
000052573
Applies To
RSA Product Set: SecurID
RSA Product/Service Type: RSA Authentication Manager
RSA Version/Condition: 8.x
Issue
This article describes the way to connect to the PostgreSQL interface to query the database using a read-only administrator account.
Resolution
  1. SSH to the primary Authentication Manager server.
  2. Navigate to /opt/rsa/am/utils.
  3. 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   

  1. 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.
  2. Navigate to /opt/rsa/am/pgsql/bin.
  3. 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.