Message-ID: <3794F733.53967769@dupreeinc.com>
Date: Tue, 20 Jul 1999 15:24:51 -0700
From: Doug Thistlethwaite <doug@dupreeinc.com>
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: pgsql-interface <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] jdbc interface problems with jdk1.2
References: <29471.932480325@sss.pgh.pa.us>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Yes, that was a typo on my part.  I also found out that the MASK should
be 255.255.255.255 if I want only the single system to access my
database...  But that did not fix the problem either.

Any more suggestions would be appriciated!

Doug

Tom Lane wrote:

> Doug Thistlethwaite <doug.t@deltanet.com> writes:
> > Password authentication failed for user 'doug'
> >
> > Does anybody have an idea of what I can try to get this working?
>
> This tells you you are getting pretty far: you are making a TCP
> connection, and the postmaster is recognizing that the entry for
> your IP address in pg_hba demands password authentication.  So,
> either you are supplying the wrong password from the client end,
> or something's wrong with the password file.
>
> There might be more info in the postmaster log file than is reported
> to the client --- did you look there?
>
> One potential typo stands out in your message:
>
> > The password file was created using the command pg_passwd
> > /var/postgresql/passwd
>        ^^^^^^^^^^
> > host         doug        IP.ADDRESS.OF PC 255.255.255.0  password
> > /var/postgres/passwd
>        ^^^^^^^^
>
> Prolly that's just a transcription error in your message, but if
> it's real...
>
>                         regards, tom lane