From: | "Paul Hart" <paulhart(at)io(dot)com> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Password authentication failure |
Date: | 2001-06-05 15:33:16 |
Message-ID: | PMEGKOAGJFDHONNBPEHIIEDACHAA.paulhart@io.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-06-05 17:10:22 | Re: Password authentication failure |
Previous Message | Paul Hart | 2001-06-05 15:32:27 | Password authentication failure |