SEO

#1 (**permalink**) 04-16-2008, 12:12 AM

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

#2 (**permalink**) 04-16-2008, 12:12 AM

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
>

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

password authentication failure