The following are two ODBC troubleshooting tips.

If IWSVA could not connect to the database specified in the Database Connection Settings page. The IWSVA management console displays the following error message:

JDBC-ODBC BRIDGE: [UNIXODBC] Could not connect to the server; Could not connect to remote socket.

Solution:

Please check the ODBC connection and/or database server and try again.

The IWSVA management console displays an authentication error message.

JDBC-ODBC BRIDGE: [UNIXODBC]FATAL: Password authentication failed for user.

Solution:

Verify the user credential for the PostgreSQL Server and also ensure that the database settings are correct (Administration > IWSVA Configuration > Database | Database Setting). If the problem persists, ensure that the permissions in the /etc/iscan/odbc.ini file are correct.