This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Remedy Single Sign On
Remedy Single Sign On
As of RSSO 19.08 in which is now compatible with Postgres 10
This is a guide line to install and configure Postgresql 10 in linux RH7.5 to use it for RSSO 19.08.
If you install Postgresql 10 in RHEL 7.5 for various purposes where RSSO 19.08 is in target, I recommend you to follow below helpful steps given in this external url: https://tecadmin.net/install-postgresql-server-centos/
Step 1 – Add Postgres Yum Repository
rpm -Uvh https://yum.postgresql.org/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm
Step 2 – Install PostgreSQL 10 Server
yum install postgresql10-server postgresql10
Step 3 – Initialize PGDATA
Step 4 – Start PostgreSQL Server
systemctl start postgresql-10.service
systemctl enable postgresql-10.service
Output: Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-10.service to /usr/lib/systemd/system/postgresql-10.service.
Step 5 – Verify PostgreSQL Installation
After completing above steps, you have installed PostgreSQL 10 on your server, Let’s log in to postfix to verify that installation completed successfully.
su - postgres -c "psql"
Type "help" for help.
You may create a password for user postgres for security purpose.
postgres=# \password postgres
IMPORTANT: You need to ensure you modify this file /var/lib/pgsql/10/data/pg_hba.conf and change indent setting to trust in the IPv4 and IPv6 settings due to the default settings are set as Indent which prevents external connections due not being trusted.
$ vi /var/lib/pgsql/10/data/pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
Otherwise you will not be able to connect to database and get errors during the installation like below:
"Unable connect to database with administrator's credentials and URL jdbc:postgresql://localhost:5432/ Cause: FATAL: Ident authentication failed for user "postgres" "
Once you modify the connection type you need to restart the service and run the RSSO Installer as usual.