Re: Password authentication working with psql, but fails with jdbc for me - Mailing list pgsql-jdbc

From Paul Thomas
Subject Re: Password authentication working with psql, but fails with jdbc for me
Date
Msg-id 20030919101057.A1582@bacon
Whole thread Raw
In response to Re: Password authentication working with psql, but fails with jdbc for me  ("Gerald Dalley" <dalleyg@MIT.EDU>)
Responses Re: Password authentication working with psql, but fails with jdbc for me  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
On 18/09/2003 21:33 Gerald Dalley wrote:
> [snip]
>
> > How did you create the db user?
>
> createuser -A -D -E -P <theuser>
> ...type in password as prompted...
>
> > Maybe you got the password wrong or possibly no password at all.
>
> I don't think so, since I have to type in the password when I use psql.
> Just for fun, I tried using a blank password, which fails even in psql.
>
> > Are your
> > psql connections from the same machine because if they IRC, psql will
> > connect using unix sockets instead of tcp/ip so the host lines
> > will not be used.
>
> I'm running psql and the jdbc program from the same machine, which is
> different from the server.  When psql is remote, I'm assuming that it
> uses
> tcp/ip sockets instead of unix sockets.
>
> > I'm sure it must just some simple configuration error as I've been
> > successfully connecting with userid/password since version 7.1.
>
> Agreed.  I'm just having trouble thinking of what else to try.

Maybe use something like tcpdump to see exactly what is being sent across?

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+


pgsql-jdbc by date:

Previous
From: "Gerald Dalley"
Date:
Subject: Re: Password authentication working with psql, but fails with jdbc for me
Next
From: Paul Thomas
Date:
Subject: Re: Specification of "/" in the host name (for Unix socket support)