Obtain the version of PostgreSQL used with RSA Authentication Manager 8.x
2 months ago
Originally Published: 2016-08-11
Article Number
000065547
Applies To
RSA Product Set: SecurID 
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.x
Issue
This 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: Wed Sep 18 13:07:28 2024 from 192.168.26.100
RSA Authentication Manager Installation Directory: /opt/rsa/am
rsaadmin@bham87:~> cd /opt/rsa/am/utils 
rsaadmin@bham87:/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: UTcXx6rK7EmdOPqdhGFz0NmV88nbIW
rsaadmin@bham87:/opt/rsa/am/utils> cd ../pgsql/bin 
rsaadmin@bham87:/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 SELECT version(); to get the version of PostgreSQL:

Note: The following PostgreSQL version is from RSA Authentication Manager server 8.7 SP2 

db=# SELECT version();
                                        version
---------------------------------------------------------------------------------------
 PostgreSQL 14.11 on x86_64-suse-linux-gnu, compiled by gcc (SUSE Linux) 7.5.0, 64-bit
(1 row)