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:langford@xxxxxxxxxxxxxxxxxxx]
Sent: Friday, July 02, 2004 3:32 PM
To: middlegen-user@xxxxxxxxxxxxxxxxxxxxx
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
middlegen-user@xxxxxxxxxxxxxxxxxxxxx
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
|
