In pg_hba.conf,
use
local   all     127.0.0.1       255.255.255.255 password
instead of md5.  You can only use md5 if you go and convert you password
to an md5 password.  Check the docs in pg_hba.conf



-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob
Langford
Sent: Wednesday, June 30, 2004 7:48 PM
To: [EMAIL PROTECTED]
Subject: [Middlegen-user] Connection problems with PostgreSQL

Hi,
   I'm new to Middlegen, just trying to get the sample app to
work with JBoss and Postgres.  I think I've got everything set
up right, but the 'create-tables' task fails because it can't
connect to Postgres.  I get 
   FATAL: Password authentication failed for user "aslak"

Yet, I can connect via the psql command just fine.  Also, if
I change the Postgres config (pg_hba.conf) to use "trust" instead
of "md5", it works fine from middlegen.  That's not going to 
be good enough, though.
I'm using the  URL
   jdbc:postgresql://localhost/airline
username=aslak, password=aslak
in the Middlegen database config file.  

I've turned on maximum Postres server logging, and it doesn't
show what password is actually being received, although it does
say that it received one.

Has anyone gotten this to work?  Or can you suggest any more debugging
steps to try?

I'm using Fedora Core 1, Postgres 7.3.4, Middlegen 2.0-VO, JBoss 3.2.4, 
and Sun JVM 1.4.2_04 

            Thanks!
-- 
Bob Langford,                   Silicon Masters Consulting, Inc.
[EMAIL PROTECTED]     http://www.silicon-masters.com/
phone:  804-674-1253                          fax:  804-745-7803



-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 - 
digital self defense, top technical experts, no vendor pitches, 
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
middlegen-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/middlegen-user


-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 - 
digital self defense, top technical experts, no vendor pitches, 
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
middlegen-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/middlegen-user

Reply via email to