Configuring the DBMS account for work with PostgreSQL and Postgres Pro

Prerequisites

Before you assign rights to the DBMS account, perform the following actions:

1. Make sure that you log in to the system under the local administrator account.
2. Install an environment for working with PostgreSQL and Postgres Pro.
3. Configure the PostgreSQL or Postgres Pro server for working with Kaspersky Security Center Linux.

Configuring the DBMS accounts to install Administration Server

To configure the DBMS accounts for the Administration Server installation:

1. Run an environment for working with Postgres.
2. Log in under the Postgres user in the Postgres database.
3. Create a new Postgres role (in this example, the role is KSCAdmin):

   CREATE USER "KSCAdmin" WITH PASSWORD '<password>';

4. Create an Administration Server database (in this example, the Administration Server database name is KAV):

   CREATE DATABASE "KAV" ENCODING 'UTF8' OWNER "KSCAdmin";

   If the error "New encoding (UTF8) is incompatible with the encoding of the template database" occurs, create a database by using the command:
   CREATE DATABASE "KAV" ENCODING 'UTF8' OWNER "KSCAdmin" TEMPLATE template0;
   instead of:
   CREATE DATABASE "KAV" ENCODING 'UTF8' OWNER "KSCAdmin";

5. Grant all privileges to the role on the Administration Server database:

   GRANT ALL PRIVILEGES ON DATABASE "KAV" TO "KSCAdmin";

   Make sure that the role has the default CONNECT and TEMPORARY privileges on the Administration Server database.

6. Grant the following privileges to the created Postgres role:
   • Privileges on all tables in the public schema: ALL
   • Privileges on all sequences in the public schema: ALL

   To do this, log in under the Postgres user in the Server database, and then run the following script (in this script, the role is KSCAdmin):

   GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA "public" TO "KSCAdmin";

   GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA "public" TO "KSCAdmin";

7. Install Administration Server.

After the installation finishes, the Administration Server will use the created database to store the Administration Server data. Administration Server is ready to use.

Page top