To prepare a station for NSP auxiliary database installation

Purpose

The following steps describe how to configure a station in advance of NSP auxiliary database software installation.

Note: You require root user privileges on the station.

Note: A leading # character in a command line represents the root user prompt, and is not to be included in a typed command.

Steps


1	Log in as the root user on the proposed auxiliary database station.
2	Open a console window.
3	Add a hostname entry for the new station to the /etc/hosts file on the new station using the following criteria: The first entry for the station hostname in the file must be the station IP address that is reachable by each main server. The hostname must be the fully qualified hostname, and not the short hostname. The hostname must: contain only ASCII alphanumeric and hyphen characters. not begin or end with a hyphen. not begin with a number. comply with the format defined in IETF RFC 1034. use period characters delimit the FQDN components. not exceed 63 characters. Note: Hostnames are case-sensitive.
4	Perform To apply the RHEL 8 swappiness workaround on the station.
5	Download the following installation files to an empty local directory: Note: You must ensure that the directory is empty. Note: In subsequent steps, the directory is called the software directory. nspos-auxdb-R.r.p-rel.v.rpm VerticaSw_PreInstall.sh nspos-jre-R.r.p-rel.v.rpm vertica-R.r.p-rel.tar where R.r.p is the NSP release identifier, in the form MAJOR.minor.patch v is a version number
6	Navigate to the software directory. Note: The directory must contain only the installation files.
7	Enter the following: `#` `chmod +x * ↵`
8	Enter the following: `#` `./VerticaSw_PreInstall.sh ↵` The script displays configuration messages like the following, and a prompt: `Logging Vertica pre install checks to log_file` `INFO: About to set proxy parameters in /etc/profile.d/proxy.sh...` `INFO: Completed setting proxy parameters in /etc/profile.d/proxy.sh...` `INFO: About to set kernel parameters in /etc/sysctl.conf...` `INFO: Completed setting kernel parameters in /etc/sysctl.conf...` `INFO: About to change the current values of the kernel parameters` `INFO: Completed changing the current values of the kernel parameters` `INFO: About to set ulimit parameters in /etc/security/limits.conf...` `INFO: Completed setting ulimit parameters in /etc/security/limits.conf...` `INFO: Backing up /etc/logrotate.conf to /etc/logrotate.conf.orig` `INFO: Removing /var/log/wtmp entry from /etc/logrotate.conf` `INFO: Adding /etc/logrotate.d/wtmp` `Checking user group nsp...` `Adding user group nsp...` `Checking user nsp...` `Adding nsp...` `Checking Vertica user group samauxdb...` `Adding Vertica user group samauxdb...` `Checking Vertica user samauxdb...` `Adding samauxdb...` `Set password for samauxdb... New password:`
9	Enter a password that conforms to the RHEL password criteria. The following prompt is displayed: `Retype new password:`
10	Re-enter the password. Messages like the following are displayed: `Changing password for user samauxdb.` `passwd: all authentication tokens updated successfully.` `Adding samauxdb to /etc/cron.allow` `Moving logfile from /tmp ...` `... to /opt/nsp/nfmp/auxdb/install/log` `Changing ownership of the directory /opt/nsp/nfmp/auxdb/install to samauxdb:samauxdb.` `Removing group write and world permissions from the directory /opt/nsp/nfmp/auxdb/install.` `Appending Vertica section to /opt/nsp/nfmp/auxdb/install/.bashrc ...` `Creating /opt/nsp/nfmp/auxdb/data for Vertica database files.` `Changing ownership of /opt/nsp/nfmp/auxdb files.` `INFO: Creating auxiliary database prep script.` `INFO: Creating nspos-auxdb-prep systemd service.` `INFO: Enabling nspos-auxdb-prep systemd service.` ************************************************************************ Changes were made that require a restart. * Please restart this host before proceeding with Vertica installation.***********************************************************************
11	If the script instructs you to perform a restart, perform the following steps. Enter the following: `#` `systemctl reboot ↵` The station reboots. When the reboot is complete, log in to the station as the root user. Open a console window. Navigate to the software directory.
12	Enter the following: `#` `tar xvf vertica-R.r.p-rel.tar $(tar tf vertica-R.r.p-rel.tar \| sort -V \| tail -1) ↵`
13	Enter the following: `#` `dnf install *.rpm ↵` The dnf utility resolves any package dependencies, and displays the following prompt for each package: `Total size: nn G` `Installed size: nn G` `Is this ok [y/N]:`
14	Enter y. The following and the installation status are displayed as each package is installed: `Downloading Packages:` `Running transaction check` `Transaction check succeeded.` `Running transaction test` `Transaction test succeeded.` `Running transaction` The package installation is complete when the following is displayed: `Complete!`
15	When the package installation is complete, close the console window. End of steps