From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 32448 invoked by alias); 2 Oct 2003 01:39:31 -0000 Mailing-List: contact rhdb-help@sources.redhat.com; run by ezmlm Precedence: bulk List-Subscribe: List-Post: List-Help: , Sender: rhdb-owner@sources.redhat.com Received: (qmail 32441 invoked from network); 2 Oct 2003 01:39:29 -0000 Received: from unknown (HELO yonge.cs.toronto.edu) (128.100.1.8) by sources.redhat.com with SMTP; 2 Oct 2003 01:39:29 -0000 Received: from jane.cs.toronto.edu ([128.100.3.248]) by yonge.cs.toronto.edu with SMTP id <199997-26963>; Wed, 1 Oct 2003 21:39:28 -0400 Received: from qew.cs.toronto.edu by jane.cs.toronto.edu id <453255-28745>; Wed, 1 Oct 2003 21:39:27 -0400 Date: Thu, 02 Oct 2003 01:39:00 -0000 From: Wei Tjioe X-X-Sender: wtjioe@qew.cs To: rhdb@sources.redhat.com cc: Wei Tjioe Subject: problem with Configuring a Connection to a Database using Visual Explain Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-SW-Source: 2003-q4/txt/msg00000.txt.bz2 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