Re: [INTERFACES] newbie to both Java and psql trying jdbc-examples

On Wed, 17 Jun 1998, Lam Nguyen wrote:

>     Following the directions closely and I still can't get the
> examples going.  Any pointers are extremely helpfull, as I am running
> out of FAQs. I am trying to run :
>
> /usr/src/pgsql/postgresql-6.3.2/src/interfaces/jdbc$ java
> -Djdbc.driver=postgresql.Driver example.blobtest jdbc:postgresql:mydb
> mylogin mypassword debug
>
> my pg_hba_conf.sample:
>
> local        all                                         password
> host         all         127.0.0.1     255.255.255.255   password

Only the host line affects JDBC. Also, you may want to add a host line for
your hosts network address as well, like:

host    all    192.168.1.1 255.255.255.255 password

> and the result:
>
> PostgreSQL blobtest v6.3 rev 1
>
> DriverManager.initialize: jdbc.drivers = null
> JDBC DriverManager initialized
> registerDriver:
> driver[className=postgresql.Driver,context=null,postgresql.Driver@80c81f9]
> Connecting to Database URL = jdbc:postgresql:mydb
> DriverManager.getConnection("jdbc:postgresql:mydb")
>     trying
> driver[className=postgresql.Driver,context=null,postgresql.Driver@80c81f9]
> -- listing properties --
> password=mypassword
> Protocol=postgresql
> user=mylogin
> PGDBNAME=mydb
> java.sql.SQLException: User authentication failed
>         at postgresql.Connection.<init>(Connection.java:229)

Have you created the user in the database using "create user" ?

--
Peter Mount, peter@maidstone.gov.uk
Postgres email to peter@taer.maidstone.gov.uk & peter@retep.org.uk
Remember, this is my work email, so please CC my home address, as I may
not always have time to reply from work.