problem with Configuring a Connection to a Database using Visual Explain

[Wei Tjioe <wtjioe@cs.toronto.edu>]

Another observation with Visual Explain is on how it treats PASSWORD
authentication.

For example: in pg_hba.conf

local   all                                     md5
host    all     127.0.0.1     255.255.255.255   md5

This causes Visual Explain to refuse connection based on Password
(although connection request through psql, both local and -h, succeeded).

Test 1: Driver
PASSED

Test 2: Connection
FAILED
Unable to connect to database.
Reason: Something ....Please report this exception: Exception:
java.sql.SQLException: FATAL 1:
Password authentication failed for use "me"


When authentication is switched to clear text:

local   all                                     md5
host    all     127.0.0.1     255.255.255.255   password

[root@darwin data]# pg_ctl reload
postmaster successfully signaled
...

Visual Explain connects to database successfully.

Testing Database Connection: testdb
Test1: Driver
PASSED

Test2: Connection
PASSED


If there's a safer alternative, please post.


Wei