ODBC Password does not Work

Issue

Whatever entries made in the Password field, IWSVA will always report that the "Connection to the database was successful."

Reason

When accessing the PostgreSQL database from the IWSVA server, IWSVA assumes a PostgreSQL value of "trust". By design, any password entered for the ODBC server from the IWSVA console on the IWSVA machine itself will be "successful".

Solution

If you are using the PostgreSQL database on the IWSVA server, you can alter this default behavior by changing the PostgreSQL authentication method from "trust" to "password" as described below:

  1. Establish an SSH session with the IWSVA server.

  2. Using the text-driven IWSVA menu that appears, open a Linux shell.

  3. Change directories, as shown below:

cd /var/iwss/postgres/pgdata

  1. Using a text editor such as vi, open the database configuration file, pg_hba.conf, and edit the METHOD variable as shown below:

# TYPE  DATABASE  USER  IP-ADDRESS   IP-MASK         METHOD

  host    all     all   10.2.1.0  255.255.255.255   password

  1. Change to the database daemon directory, signal the postmaster to re-read the updated pg_hba.conf file by restarting the daemon (below), and then exit the shell and SSH session.

/usr/iwss/S99Isdatabase reload