To install the NSP auxiliary database software
Purpose
The following steps describe how to install and initialize the NSP auxiliary database software.
Note: You must perform the procedure in each auxiliary database cluster of a geo-redundant NSP deployment.
Note: You require root user privileges on each auxiliary database 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 to any auxiliary database station as the root user. Note: The software is installed on one station, and then automatically propagated to the other stations in the cluster. | |||||||||||
2 |
Open a console window. | |||||||||||
3 |
Enter the following: # cp /opt/nsp/nfmp/auxdb/install/config/install.config.default /opt/nsp/nfmp/auxdb/install/config/install.config ↵ | |||||||||||
4 |
If you are performing the installation as a non-root user and intend to allow non-root users other than the NSP super user to edit the file, perform one of the following.
| |||||||||||
5 |
Open the /opt/nsp/nfmp/auxdb/install/config/install.config file using a plain-text editor such as vi. | |||||||||||
6 |
Changing a parameter in the auxiliary database install.config file can have serious consequences that include service disruption. Do not change any parameter in the install.config file, other than the parameters described in the step, without guidance from technical support. Edit the following lines in the file to read: hosts=internal_IP1,internal_IP2...internal_IPn export_hosts=internal_IP1[export_IP1],internal_IP2[export_IP2]...internal_IPn[export_IPn] where internal_IP1, internal_IP2...internal_IPn are the IP addresses that the auxiliary database stations use to communicate with each other export_IP1, export_IP2...export_IPn are the IP addresses that the stations use for communication with other components in the deployment The following is an export_hosts configuration example; see Table 14-1, Auxiliary database station addressing for more information. export_hosts=10.1.1.10[198.51.100.10],10.1.1.11[198.51.100.11],10.1.1.12[198.51.100.12] Table 14-1: Auxiliary database station addressing
Notes:
| |||||||||||
7 |
Edit the following lines in the file to read as shown below: secure=true pki_server=address pki_server_port=80 where address is one of the following in the platform—ingressApplications—ingressController section of the nsp-config.yml file on the local NSP deployer host: In the internalAddresses subsection, if configured, otherwise, in the clientAddresses subsection: | |||||||||||
8 |
Save and close the install.config file. | |||||||||||
9 |
Enter the following: # /opt/nsp/nfmp/auxdb/install/bin/auxdbAdmin.sh install ↵ The script sequentially prompts you to enter and re-enter new passwords for the following user accounts: Note: The password that you specify for a user must be the same on each station in each auxiliary database cluster. | |||||||||||
10 |
At each prompt, enter or re-enter a password, as required. The script then sequentially prompts for the root user password of each auxiliary database station. | |||||||||||
11 |
At each prompt, enter the required password. Messages like the following are displayed as the software is installed on each station and the database is created: Populating auxiliary database user passwords in the vault Installing auxiliary database on IP_address .... Cleaning auxiliary database host(s) in ssh known_hosts for root and samauxdb users. Creating auxiliary database cluster Successfully created auxiliary database cluster Creating auxiliary database Distributing changes to cluster. Creating database samdb Starting bootstrap node node_name (IP_address) Starting bootstrap node node_name (IP_address) . . . Starting nodes: node_name (IP_address node_name (IP_address . . . Starting Vertica on all nodes. Please wait, databases with a large catalog may take a while to initialize. Installing OS_package package Success: package OS_package installed Database creation SQL tasks completed successfully. Database samdb created successfully. Successfully created auxiliary database Performing post install configuration tasks Creating public interface for host node_name (IP_address Creating public interface for host node_name (IP_address . . . CREATE NETWORK INTERFACE ALTER NODE Setting DB samdb restart policy to never and replicating to cluster... Database samdb policy set to never Installing user defined extension libraries and functions. Unzipping Python libraries. Setting sticky bit on all nodes. INFO: About to configure TLS .... Generating TLS certificates INFO: About to validate key and certificate Make sure the certificate has not expired and that the specified date range is current and valid. Not Before: date Not After : date INFO: Complete validating key and certificate INFO: Adding certificate to AuxDB Distributing configuration to all nodes Post install configuration tasks completed successfully. Successfully installed auxiliary database. Output captured in /opt/nsp/nfmp/auxdb/install/log/auxdbAdmin.sh.timestamp.log The script installs the software on each station. | |||||||||||
12 |
When the script execution is complete, if you are deploying a geo-redundant auxiliary database, perform the following steps on each station in the current auxiliary database cluster.
| |||||||||||
13 |
Start the database proxy on each station in the current cluster.
| |||||||||||
14 |
Close the open console windows. End of steps |