From: | "Jeff Waugh" <jaw(at)ic(dot)net> |
---|---|
To: | "Paul Hart" <paul(dot)hart(at)maclaren(dot)com>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Password authentication failure |
Date: | 2001-06-11 18:41:48 |
Message-ID: | 054f01c0f2a6$a97ae3b0$0201a8c0@wilbur |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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(dot)hart(at)maclaren(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)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(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-06-11 22:11:10 | Re: Couple of patches for jdbc driver |
Previous Message | Dave Cramer | 2001-06-11 14:51:46 | Re: Failed Connection (again) |