Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0641

D toc

As needed, you can perform manual creation of users and individual databases used by the 

D s platform
rtrue
.

Tip

Tip: In most installation scenarios, manual database installs are not needed.

Pre-requisites

  1. The database server must be installed and available:
    1. See Install Databases for PostgreSQL.
    2. See Install Databases for MySQL.
  2. The databases must be initialized.

    Info

    NOTE: If you are using non-standard database names, users, passwords, port numbers, that information must be applied during installation and afterwards in the

    D s platform
    configuration.

    For more information, see Configure the Databases.

Manual DB Install for PostgreSQL

Excerpt

Use the following steps to manually create the users and databases required by the platform in PostgreSQL.

Launch PostgreSQL

Pre-requisites for PostgreSQL:

  • The installing user must have write permissions to the directory from which the commands are executed.
  • The installing user must have sudo privileges.
  1. Switch to the Postgres user. Launch psql.

    Code Block
    sudo su - postgres
    Info

    NOTE: Unless the port number for postgres has been modified, it should be listening at the default value: 5432.

  2. Launch psql using the following command, applying the admin password when prompted:

    Code Block
    psql --host=${POSTGRES_HOST_NAME} --port=${POSTGRES_HOST_PORT} --username=${POSTGRES_ADMIN_USERNAME} --password=${POSTGRES_ADMIN_PASSWORD}

    where:

    ParameterDescription
    hostPublic DNS value for database server instance
    portPort number value for database server instance
    usernameAdmin username for database server instance
    passwordPassword for admin username
  3. Execute the following commands using the postgres user.

    Info

    NOTE: The values in platform configuration must match the values that you use below. Below are the default values.

D s item
itemdatabase

Code Block
CREATE ROLE trifacta LOGIN ENCRYPTED PASSWORD '<pwd_trifacta>';
CREATE DATABASE trifacta WITH OWNER trifacta;

Jobs database

Code Block
CREATE ROLE trifactaactiviti WITH LOGIN ENCRYPTED PASSWORD '<pwd_trifactaactiviti>';
CREATE DATABASE "trifacta-activiti" WITH OWNER trifactaactiviti;

Scheduling database

Code Block
CREATE ROLE trifactaschedulingservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactaschedulingservice>';
CREATE DATABASE trifactaschedulingservice WITH OWNER trifactaschedulingservice;

For more information on scheduling, see Configure Automator.

Time-based Trigger database

Code Block
CREATE ROLE trifactatimebasedtriggerservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactatimebasedtriggerservice>';
CREATE DATABASE trifactatimebasedtriggerservice WITH OWNER trifactatimebasedtriggerservice;

For more information on scheduling, see Configure Automator.

Configuration Service database

Code Block
CREATE ROLE trifactaconfigurationservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactaconfigurationservice>';
CREATE DATABASE trifactaconfigurationservice WITH OWNER trifactaconfigurationservice;

Artifact Storage Service database

Code Block
CREATE ROLE trifactaartifactstorageservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactaartifactstorageservice>';
CREATE DATABASE trifactaartifactstorageservice WITH OWNER trifactaartifactstorageservice;

Job Metadata Service database

Code Block
CREATE ROLE trifactajobmetadataservice LOGIN ENCRYPTED PASSWORD '<pwd_trifactajobmetadataservice>';
CREATE DATABASE trifactajobmetadataservice WITH OWNER trifactajobmetadataservice;

Manual DB Install for MySQL

Use the following steps to manually initialize the databases required by the platform in MySQL.

Launch MySQL

Pre-requisites for MySQL:

  • The installing user must have write permissions to the directory from which the commands are executed.
  • The installing user must have sudo privileges.
  1. Login to MySQL as the root user. When prompted, enter the password for root user:

    Code Block
    mysql -u root -p
  2. Execute the following commands using the root user.

    Info

    NOTE: The values in platform configuration must match the values that you use below. Below are the default values.

D s item
itemdatabase

Code Block
Create USER 'trifacta' IDENTIFIED BY '<pwd_trifacta>';
CREATE DATABASE trifacta;
Grant all on trifacta.* to trifacta;

Jobs database

Code Block
Create USER 'trifactaactiviti' IDENTIFIED BY '<pwd_trifactaactiviti>';
CREATE DATABASE trifactaactiviti;
Grant all on trifactaactiviti.* to trifactaactiviti;

Scheduling database

Code Block
Create USER 'trifactaschedulingservice' IDENTIFIED BY '<pwd_trifactaschedulingservice>';
CREATE DATABASE trifactaschedulingservice;
Grant all on trifactaschedulingservice.* to trifactaschedulingservice;

For more information on scheduling, see Configure Automator.

Time-based Trigger database

Code Block
Create USER 'trifactatimebasedtriggerservice' IDENTIFIED BY '<pwd_trifactatimebasedtriggerservice>';
CREATE DATABASE trifactatimebasedtriggerservice;
Grant all on trifactatimebasedtriggerservice.* to trifactatimebasedtriggerservice;

For more information on scheduling, see Configure Automator.

Configuration Service database

Code Block
Create USER 'trifactaconfigurationservice' IDENTIFIED BY '<pwd_trifactaconfigurationservice>';
CREATE DATABASE trifactaconfigurationservice;
Grant all on trifactaconfigurationservice.* to trifactaconfigurationservice;

Artifact Storage Service database

Code Block
Create USER 'trifactaartifactstorageservice' IDENTIFIED BY '<pwd_trifactaartifactstorageservice>';
CREATE DATABASE trifactaartifactstorageservice;
Grant all on trifactaartifactstorageservice.* to trifactaartifactstorageservice;

Job Metadata Service database

Code Block
Create USER 'trifactajobmetadataservice' IDENTIFIED BY '<pwd_trifactajobmetadataservice>';
CREATE DATABASE trifactajobmetadataservice;
Grant all on trifactajobmetadataservice.* to trifactajobmetadataservice;