When connecting to the database using a newly created read-only user, the below error appears.
psql: SSL error: sslv3 alert handshake failure
FATAL: no pg_hba.conf entry for host "$ipaddress", user "rouser", database "db", SSL off
1. Create a new database read only user using below command (If not previously created)
/opt/rsa/am/utils/rsautil manage-readonly-dbusers -a create -o <Operations_Console_username> -u <Username_Of_ReadOnly_User -i $ipaddress
2. View the /opt/rsa/am/rsapgdata/pg_hba.conf file and confirm that newly created user is shown as below:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
host db rsa_radius_db_user samehost trust
host all all samehost md5
host all <new_username> ::1/128 md5
3. Point the application at variable PGDATA for reading the configuration file (pg_hba.conf):
export PGDATA=/opt/rsa/am/rsapgdata
rsaadmin@local:~> export PGDATA=/opt/rsa/am/rsapgdata
4. Signal the database to reload the file again using the below command:
/opt/rsa/am/pgsql/bin/pg_ctl reload
rsaadmin@local:~> /opt/rsa/am/pgsql/bin/pg_ctl reload
server signaled
