public inbox for
 help / color / mirror / Atom feed
From: Wei Tjioe <>
Cc: Wei Tjioe <>
Subject: problem with Configuring a Connection to a Database using Visual Explain
Date: Thu, 02 Oct 2003 01:39:00 -0000	[thread overview]
Message-ID: <Pine.GSO.4.58.0310012121530.10907@qew.cs> (raw)

Another observation with Visual Explain is on how it treats PASSWORD

For example: in pg_hba.conf

local   all                                     md5
host    all   md5

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

Test 1: Driver

Test 2: Connection
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   password

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

Visual Explain connects to database successfully.

Testing Database Connection: testdb
Test1: Driver

Test2: Connection

If there's a safer alternative, please post.


             reply	other threads:[~2003-10-02  1:39 UTC|newest]

Thread overview: 11+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2003-10-02  1:39 Wei Tjioe [this message]
2003-10-02 20:07 ` Fernando Nasser
2003-10-02 20:28   ` Wei Tjioe
2003-10-02 21:13     ` Fernando Nasser
2003-10-02 22:44       ` Wei Tjioe
2003-10-03  0:41   ` Fernando Nasser
2003-10-03  1:16     ` Wei Tjioe
2003-10-03  1:53       ` Fernando Nasser
2003-10-03  2:21         ` Wei Tjioe
  -- strict thread matches above, loose matches on Subject: below --
2003-09-18  8:25 huwang wang
2003-09-18 14:36 ` Patrick Macdonald

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=Pine.GSO.4.58.0310012121530.10907@qew.cs \ \ \

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).