000033755 - Obtain the version of PostgreSQL used with RSA Authentication Manager 8.x

Document created by RSA Customer Support Employee on Aug 25, 2016Last modified by RSA Customer Support on Jan 8, 2020
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000033755
Applies ToRSA Product Set: SecurID 
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.x
IssueThis article provides the steps to determine which version of PostgreSQL is being used with RSA Authentication Manager 8.x.
Resolution
  1. Enable Secure Shell on the Appliance.
  2. Log on to the Appliance Operating System with SSH.
  3. Next, capture the database password for user rsa_dba to connect to database.  Note that the password for each RSA AUthentication Manager deployment is different.


login as: rsaadmin
Using keyboard-interactive authentication.
Password: <enter operating system password>
Last login: Tue Jan  7 10:08:28 2020 from jumphost.vcloud.local
RSA Authentication Manager Installation Directory: /opt/rsa/am
rsaadmin@am81p:~> cd /opt/rsa/am/utils
rsaadmin@am81p:/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's password>
com.rsa.db.dba.password: rSKD5bGguLGNL9uGvFWnJoxIcHJah2
rsaadmin@am81p:/opt/rsa/am/utils> cd ../pgsql/bin
rsaadmin@am81p:/opt/rsa/am/pgsql/bin> ./psql -h localhost -p 7050 -d db -U rsa_dba
Password for user rsa_dba: <enter the com.rsa.db.dba.password captured above>


  1. Type the command below to get the version of PostgreSQL:


db=# SELECT version();
                                                   version
---------------------------------------------------------------------------------------------------------------
PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bit
(1 row)

Attachments

    Outcomes