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.
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
DX NetOps Performance Management 20.2.5