On Fri, 12 Jun 1998, Natali Kolker wrote:
> I compiled JDBC sources , that comes with version 6.3 .
If possible, upgrade to 6.3.2, as it has a more fuller JDBC
implementation, and fewer bugs.
> When I am trying to connect to data base ,
>
> "DriverManager.getConnection("jdbc:postgresql://haver:5432/natali",
> "natali", "Elina);"
> I got a response:
> >
> > java.sql.SQLException: User authentication failed
What do you have set in your pg_hba.conf file?
> My jdbc drivers in dir $CLASSPATH/postgresql,
> I created my database with command:
> createdb -u natali
> Username : natali,
> Password: Elina
>
> In perl I write : $conn = Pg::connectdb("dbname = natali");,
> and I have connection.
>
> If somebody can help me , with my " authentification" problem , I would
> really appriciate it.
JDBC only works using TCP/IP, but (someone correct me if I'm wrong), the
Perl interface can use Unix domain sockets, so if you have a different
setting in pg_hba.conf, it can cause the fact that perl can connect, but
JDBC not.
Also, if you defined pg_hba.conf to use password or crypt authentication,
ensure you have defined the user in the database, AND a password. A blank
password doesn't work.
Postgresql-JDBC FAQ: http://www.retep.org.uk/postgres
--
Peter T Mount peter@retep.org.uk or petermount@earthling.net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk