Re: Password authentication failure

Use the password that you specified in your
CREATE USER command.

The password in the specified file is ignored when using
the crypt authentication method.
(However, if you do specify a file, the user must have a
record there.)

HTH
-Jeff

----- Original Message -----
From: "Paul Hart" <paul.hart@maclaren.com>
To: <pgsql-jdbc@postgresql.org>
Sent: Tuesday, June 05, 2001 11:32 AM
Subject: [JDBC] Password authentication failure


> Hi all,
>
> I'm currently running 7.1.2 on OpenBSD 2.9-current. I am attempting to
> connect to a database over IP, so I have the following 'start' command
> in my /etc/rc.local:
>
> su postgres -c '/usr/local/pgsql/bin/pg_ctl -o "-i" -D /web/databases -l
> \
> /web/databases/logfile.log start > /dev/null'
>
> Also, I have the following in my /web/databases/pg_hba.conf
> ('/web/databases' is set up as $PGDATA):
>
> host         all         xxx.xxx.xx.0  255.255.255.0       crypt passwd
>
> (obviously, the 'xxx.xxx.xx.0' is my host set.)
>
> I have also created the file /web/databases/passwd which contains the
> username/password pair I wish to use to connect to the database.
>
> So, after all this, I have a jdbc connection URL of:
>
> jdbc:postgresql://[my host]/[my db]
>
> (as per the spec)
>
> I also pass in the username and password that I set up using pg_passwd.
>
>
> Of course, if it worked, I wouldn't have just written all of that :)
>
> The JDBC driver claims "Password authentication failed for user 'XXXX'"
>
> So, does anyone have any ideas?
>
> Many Thanks,
>
> Paul Hart
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>