This is the mail archive of the rhdb@sources.redhat.com mailing list for the RHDB project.


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

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


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]