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
>