RE: Connection problems with PostgreSQL

Heya Bob,
I have exact same setup minus Postgres (mysql here).  In my configuration, I keep the databaseURL with just the host and the database, then have the username and password be seperate properties in the Ant task (assuming you are using Ant or Maven build scripts).

<middlegen
	databaseurl="postgresql://localhost/airline" 
	username="aslak"
	password="aslak"
...

I doubt it would be that simple, but you never know.  If it's a new Postgres install, maybe make sure the TCPIP Socket property is set to true?

-D


-----Original Message-----
From: Bob Langford [mailto:[email protected]]
Sent: Friday, July 02, 2004 3:32 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.    8207 Stone River Court, Richmond, VA  23235
phone:  804-674-1253      fax:  804-745-7803 
http://www.silicon-masters.com/  




-------------------------------------------------------
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