Re: Connection problems with PostgreSQL

Not that this is very helpful but I have it working (or had done). It
was a long time back now and can't remeber any problems.

I am using postgreSQL on the main project now. I think the only time I
had a problem was when we migrated over to a diffrent server which ran a
newer version of postgre so the driver had to be upgraded.

Still if anything comes to mind I will let you know.

Tim
On Thu, 2004-07-01 at 00:47, Bob Langford wrote:
> 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!



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