Installing OpenText Analytics Database on SELinux in Enforcing mode

Use the steps below to install OpenText™ Analytics Database on a server with SELinux in enforcing mode.

As the root user on the server:

1. Copy the OpenText™ Analytics Database rpm from Orchestration server onto the node into /tmp directory.

2. Run the following to install OpenText™ Analytics Database:

rpm -Uvh /tmp/vertica-latest.rhel.x86_64.rpm

3. Run the seinstall_root script to set up the dbadmin user account and group:

/opt/vertica/selinux/seinstall_root.sh

4. If the commands were run using sudo, log out and log back in to apply the new dbadmin SELinux context.

As dbadmin (or the user you specified previously):

1. Run the following on the node and copy the resulting .json and .pem files to /tmp on every node:

/opt/vertica/selinux/gen_httpstls_json.sh

2. Run the seinstall.sh script to set up the vertica node management agent (NMA) on each node:

/opt/vertica/selinux/seinstall.sh 

3. On one node, run the following command to create the database specifying the information for your system:

vcluster create_db --db-name <database name> --hosts <list of hosts> --catalog-path /vertica/data --data-path /vertica/data --depot-path /vertica/data/depot --password <password> --depot-size <depot size> --verbose --communal-storage-location <s3 storage location> --shard-count <shard count>

Example command with system information:

vcluster create_db --db-name selinux_vdb --hosts 10.10.10.1,10.10.10.2,10.10.10.3,10.10.10.4 --catalog-path /vertica/data --data-path /vertica/data --depot-path /vertica/data/depot --password pw --depot-size 80% --communal-storage-location s3://vertica-fleeting/selinux_vdb --shard-count 8

4. On each node, make sure both the NMA and vertica are not running unconfined using ps xfZ. vertica/nma/etc should be running with SELinux context sysadm_u:sysadm_r:vertica_t.