Re: Password authentication working with psql, but fails with jdbc for me

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