Password authentication failure

From: "Paul Hart" <paul(dot)hart(at)maclaren(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Password authentication failure
Date: 2001-06-05 15:32:27
Message-ID: PMEGKOAGJFDHONNBPEHIEEDACHAA.paul.hart@maclaren.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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Paul Hart 2001-06-05 15:33:16 Password authentication failure
Previous Message Bruce Momjian 2001-06-04 20:10:46 Re: finalize in LargeObject