Not being able to access the database after upgrade
Originally Published: 2020-09-18
Last Modified: 2023-09-22
Article Number
000042508
Applies To
RSA Product Set: RSA SecurID
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.4.0
Platform: null
Platform (Other): null
O/S Version: null
Product Name: null
Product Description: null
Issue
-Receiving the below error when trying to access the database after the upgrade :

rsaadmin@am84p:/opt/rsa/am/pgsql/bin> ./psql -h localhost -p 7050 -d db -U rsa_dba
-bash: ./psql: No such file or directory
 
Cause
- The psql bin file under /opt/rsa/am/pgsql/bin  is corrupted or deleted .
Resolution
1- Moving the bin psql from a replica to the affected primary under /opt/rsa/pgsql  ( it can be moved using thw winscp or any secure tool ).
2- Change the permission on the file using the following command to give the file the default permissions .
chmod 700 /opt/rsa/am/pgsql/bin/psql
User-added image
The above scrrenshot shows the default permissions on the psql file .
3-the database will prompt you to enter the rsa_dba password and after entering it you will be able to access it successfully .
Notes
If no replicas and no other RSA environments are available the RSA technical support can provide the needed file .

Related Articles

Trending Articles

Don't see what you're looking for?