Database reindex required after applying Authentication Manager 8.7 SP1 and Authentication Manager 8.7 SP1 patch 1 due to upgrade from SUSE 12 to SUSE 15
Originally Published: 2023-12-01
Article Number
Applies To
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.7 SP1 and 8.7 SP1 patch 1
Issue
Resolution
- Login to your primary via CLI.
- Shut down all services except database service. Make sure that the database service is the only one that is up.
login as: rsaadmin
Using keyboard-interactive authentication.
Password: <enter OS password>
Last login: <om Dec 11 10:27:53 20123 from jumphost.vcloud.local
RSA Authentication Manager Installation Directory: /opt/rsa/am
rsaadmin@primary:~> cd /opt/rsa/am/server
rsaadmin@primary:/opt/rsa/am/server> ./rsaserv stop all
rsaadmin@primary:/opt/rsa/am/server> ./rsaserv start db
Using keyboard-interactive authentication.
Password: <enter OS password>
Last login: <om Dec 11 10:27:53 20123 from jumphost.vcloud.local
RSA Authentication Manager Installation Directory: /opt/rsa/am
rsaadmin@primary:~> cd /opt/rsa/am/server
rsaadmin@primary:/opt/rsa/am/server> ./rsaserv stop all
rsaadmin@primary:/opt/rsa/am/server> ./rsaserv start db
- Connect to PostgreSQL:
rsaadmin@primary:~> 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 admin's name>
Please enter OC Administrator password: <enter Operations Console admin's password>
com.rsa.db.dba.password: rSKD5bGguLGNL9uGvFWnJoxIcHJah2 (your string will be different)
rsaadmin@primary:/opt/rsa/am/utils> cd ../pgsql/bin
rsaadmin@primary:/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>
db=#
rsaadmin@am81p:/opt/rsa/am/utils> ./rsautil manage-secrets -a get com.rsa.db.dba.password
Please enter OC Administrator username: <enter Operations Console admin's name>
Please enter OC Administrator password: <enter Operations Console admin's password>
com.rsa.db.dba.password: rSKD5bGguLGNL9uGvFWnJoxIcHJah2 (your string will be different)
rsaadmin@primary:/opt/rsa/am/utils> cd ../pgsql/bin
rsaadmin@primary:/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>
db=#
- Run the following command to reindex the database:
db=# REINDEX DATABASE db;
- Restart Authentication Manager services:
rsaadmin@primary:~> cd /opt/rsa/am/server
rsaadmin@primary:/opt/rsa/am/server> ./rsaserv start all
rsaadmin@primary:/opt/rsa/am/server> ./rsaserv start all
Notes
- This issue is fixed in Authentication Manager 8.7 SP1 patch 2 (8.7.1.2).
- The replica servers in the deployment will handle authentication requests while the services are down on the primary.
- Depending on the size of your database, the reindex can take some time.
- Replica servers do need to be reindexed.
- Reindex the primary first, then replicas one at a time.
Related Articles
Applying patch or upgrade fails after hardening RSA Authentication Manager appliance Number of Views Authentication Manager 8.5 upgrade to 8.6 fails with error: Unactivated changes are present in the WebLogic Server config.xml Number of Views Authentication Manager 8.x upgrade fails with error "Failed to launch the update installer to apply the update" Number of Views RSA Authentication Manager 8.1 primary instance fails to upgrade to 8.2 with error: Replication flush failed Number of Views RSA Authentication Manager Upgrade Process Number of Views
Trending Articles
Troubleshooting RSA SecurID Access Identity Router to RSA Authentication Manager test connection failures RSA SecurID Software Token 5.0.2 Downloads for Microsoft Windows RSA Authentication Manager 8.9 Release Notes (January 2026) Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.8 Setup and Configuration Guide
Don't see what you're looking for?
