It seems that postgres was not configured to allow local users to connect.

I think i'm going to switch the autentication type (taking Aarons advice).

Thanks for all of the suggestions.
Michael


----- Original Message -----
From: Bogi <[EMAIL PROTECTED]>
Date: Sat, 01 Mar 2003 15:19:04 -0700
To: [EMAIL PROTECTED]
Subject: Re: (clug-talk) Postgres/jdbc 

> hi Michael 
> look up here, this one may shed some light on your problem regardin
> odbc connection to postgresql.
> 
> http://archives.postgresql.org/pgsql-jdbc/2003-01/msg00228.php
> 
> Check the config files, see if tcp/ip is enabled, also check for login from 
> local (unix socket) odbc drivers dont connect with tcp/ip (not in their 
> default setup, but they could be made to use tcp/ip :-)) .. they use local 
> unix sockets to do so, check if local connections via socket are also enabled.
> On Saturday 01 March 2003 14:55, you wrote:
> 
> Hope thisone helped a bit.
> Cheers
> Szemir
> 
> > Hi all,
> >  I'm having a bit of trouble getting jdbc to connect to my postgres db. I
> > can connect to the database fine using psql with a connection string like
> > ./psql -d iala -p 5432 -U postgres -W -h 127.0.0.1
> >
> > When I try to make that same connection with jdbc, i get the following
> > error: IDENT authentication failed for user "postgres"
> >
> > Any ideas on why this would work with psql, but fail to authenticate when
> > using jdbc?
> >
> > Thanks,
> > Michael
> 

-- 
______________________________________________
http://www.linuxmail.org/
Now with e-mail forwarding for only US$5.95/yr

Powered by Outblaze

Reply via email to