Prerequisites
Before you assign rights to the DBMS account, perform the following actions:
Configuring the DBMS account to install Administration Server (automatic creation of the Administration Server database)
To configure the DBMS account for the Administration Server installation:
If you use the Postgres user, you do not need to grant additional rights to it.
By default, the Postgres user does not have a password. However, a password is required to install Kaspersky Security Center Linux. To set a password for the Postgres user, run the following script:
ALTER USER "user_name" WITH PASSWORD '<
password
>';
If you want to use a new Postgres role, create this role, and then grant it the CREATEDB privilege. To do this, run the following script (in this script, the role is KSCAdmin):
CREATE USER "KSCAdmin" WITH PASSWORD '<
password
>' CREATEDB;
The created role will be used as an owner of the Administration Server database (hereinafter also referred to as the Server database).
After the installation finishes, the Server database is automatically created and Administration Server is ready to use.
Configuring the DBMS account to install Administration Server (manual creation of the Administration Server database)
To configure the DBMS account for the Administration Server installation:
CREATE USER "KSCAdmin" WITH PASSWORD '<password>';
CREATE DATABASE "KAV" ENCODING 'UTF8' OWNER "KSCAdmin";
GRANT ALL PRIVILEGES ON DATABASE "KAV" TO "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";
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";
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