Install VSQL Client Driver
Does not apply in a SaaS environment
The Logger host requires the VSQL client to perform the data migration procedure. If the client is not present, follow these steps to install the VSQL Client driver.
-
Download the TAR version of the driver.
Tip: Micro Focus recommends to use the same version for database server and TAR driver. Refer to the Technical Requirements for Arcsight Platform for details on the supported version. -
To extract the TAR from the directory, run the following command:
tar xvfz vertica-client-[version] [OS].tar.gz -C / -
From your home directory, add the PATH:
cd ~ -
Open the file:
vi .bashrc -
On the PATH variable located by default in the /opt/vertica/bin file, add the vsql path:
export PATH-$ANT_HOME/bin:$JAVA_HOME/bin:$PATH:$P4_HOME/bin:/opt/vertica/binIf the PATH variable is not found, create it:
PATH=$PATH:/opt/vertica/bin -
Save the changes:
:wqand press ENTER. -
Refresh the .bashrc file:
source .bashrc -
To verify VSQL has been installed, run the following command:
vsql --version