ODBC Password does not Work Parent topic

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
  4. 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
  5. 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