ODBC Troubleshooting

The following are two ODBC troubleshooting tips.

Issue 1

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.

Issue 2

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.