Before continuing, access the primary's Operations Console and back up the database (Maintenance > Backup and Restore > Backup Now).
- Access the primary Authentication Manager server via local console or SSH session.
- Logon to the server with the rsaadmin operating system account.
login as: rsaadmin Using keyboard-interactive authentication. Password: <enter operating system password> Last login: Tue Mar 27 10:53:48 2018 from jumphost.vcloud.local RSA Authentication Manager Installation Directory: /opt/rsa/am rsaadmin@am82p:~> cd /opt/rsa/am/utils rsaadmin@am82p:/opt/rsa/am/utils> ./rsautil manage-secrets -a get com.rsa.db.dba.password
- When prompted, enter the Operations Console admin user name and password. This returns the database password. On this primary the com.rsa.db.dba.password value is vDBh1Rb005S7nX9t304v8jy3eHFFGI but will be different in each deployment.
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: vDBh1Rb005S7nX9t304v8jy3eHFFGI
- Connect to the PostgreSQL database with the command /opt/rsa/am/pgsql/bin/psql -h localhost -p 7050 -d db -U rsa_dba.
- Enter the password for the rsa_dba user captured in step 3. In the SSH console highlight the password value and and right click to paste. The pasted value will not display. Be sure to only paste once.
rsaadmin@am82p:/opt/rsa/am/utils> /opt/rsa/am/pgsql/bin/psql -h localhost -p 7050 -d db -U rsa_dba Password for user rsa_dba: <paste in the com.rsa.db.dba.password captured above>
- If successful, you will get the db# prompt:
psql.bin (9.4.1) SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-SHA, bits: 256, compression: off) Type "help" for help.
db=#
- To see the disk space critical notification, check the interval and free space thresholds run the following SELECT statement from the db# SQL prompt. There should be two rows of output.
db=# SELECT name, value FROM ims_config_value WHERE name LIKE '%ims.critical_notification.disk%'; name | value --------------------------------------------------------------------------- ims.critical_notification.disk_space_check.free_space_threshold | 5000 ims.critical_notification.disk_space_check.interval | 15 (2 rows)
- The disk is checked every 15 minutes. The default threshold is 5,000 MB or about 5 GB. To be sure you are going to change the correct setting, run a SELECT statement to get just the threshold, not the interval setting:
db=# SELECT name, value FROM ims_config_value WHERE name LIKE '%ims.critical_notification.disk_space_check.free%'; name | value --------------------------------------------------------------------------- ims.critical_notification.disk_space_check.free_space_threshold | 5000 (1 row)
- Run the following UPDATE command to change the threshold:
db=# UPDATE ims_config_value SET VALUE = '10000' WHERE NAME LIKE '%ims.critical_notification.disk_space_check.free%'; UPDATE 1
- Run the SELECT statement again to confirm the value change:
db=# SELECT name, value FROM ims_config_value WHERE name LIKE '%ims.critical_notification.disk_space_check.free%'; name | value --------------------------------------------------------------------------- ims.critical_notification.disk_space_check.free_space_threshold | 10000 (1 row)
|