Thread: password authentication failure

password authentication failure

From
"System Consult"
Date:
I was able able to create my database and create a Admin role with a password with which i was able to sign on to the database using the prompt. However, an attempt to access the database via my java application using jdbc gave this response
 
FATAL: password authentication failed for user "Admin"

 

please assist

Re: password authentication failure

From
Mark Lewis
Date:
Try to connect to the database using the command-line tool and
specifying the host parameter, to force a network connection (same type
of connection that the JDBC driver uses).

So run:
psql -h whatever_server_jdbc_uses

If that doesn't work, then you have an authentication problem; read the
PG documentation about configuring authentication with pg_hba.conf.

If it does work, then please supply the version of the driver you're
using, the JDBC URL you're using, a code snippet showing how you're
attempting to connect, and some basic info about your server (version,
host it's running on).

-- Mark Lewis


On Thu, 2006-07-13 at 16:45 +0100, System Consult wrote:
> I was able able to create my database and create a Admin role with a
> password with which i was able to sign on to the database using the
> prompt. However, an attempt to access the database via my java
> application using jdbc gave this response
>
> FATAL: password authentication failed for user "Admin"
>
>
>
> please assist
>