Prerequisites

Install and Configure PostgreSQL

Skip this section if you already have a production PostgreSQL server available in your environment.

Follow the instructions below to configure a PostgreSQL database server to host a database for the Console.

1. Install PostgreSQL.

    yum -y install postgresql-server
   

2. Initialize the database.

    postgresql-setup initdb
   

3. Enable password authentication for localhost.

   This is only necessary if running PostgreSQL on the same system as the Console service.

    sed -i \
        -e '/^host\s*all\s*all\s*[0-9:./]*\s*ident$/ s|ident|md5|' \
        /var/lib/pgsql/data/pg_hba.conf
   

4. Enable and start the database service.

    systemctl enable postgresql --now
   

Create and configure a user and database for Sicura Console.

In the example below, we’re connecting to a local installation of PostgreSQL and using sicura_console for both the database name and the user name. Replace the string REPLACE_ME below with a password generated for the sicura_console database user.

runuser -l postgres -c "psql" <<END
create database sicura_console;
create user sicura_console with encrypted password 'REPLACE_ME';
grant all privileges on database sicura_console to sicura_console;
END