The following error is displayed while installing the Data Aggregator:
Error code: 1
Description: unable to execute test to verify that user is a superuser; cause: [Vertica][VJDBC](100161) The connection is closed.
DX NetOps Performance Management 20.2.5
Even though there is no connection issue from the DA machine to the DR machine, the test is failing during the DA installation.
Copied the /opt/vertica/bin/vsql file from the DR to the DA machine and run the following syntax:
./vsql -h <DR_hostname_or_IP> -U dradmin -w dbpass -c 'select version()'
./vsql -h <DR_hostname_or_IP> -U dradmin -w dbpass -c '\dn'
You can find the dradmin password in the drinstall.properties file:
$ cat /opt/CA/IMDataRepository_vertica9/drinstall.properties
# Database password
# Comment out with # to provide password interactively