Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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       crypt passwd

(obviously, the '' 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


pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group