This is the mail archive of the
rhdb@sources.redhat.com
mailing list for the RHDB project.
problem with Configuring a Connection to a Database using VisualExplain
- From: Wei Tjioe <wtjioe at cs dot toronto dot edu>
- To: rhdb at sources dot redhat dot com
- Cc: Wei Tjioe <wtjioe at cs dot toronto dot edu>
- Date: Wed, 1 Oct 2003 21:39:24 -0400
- Subject: problem with Configuring a Connection to a Database using VisualExplain
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