Re: jdbc for postgresql.

[forwarding to interfaces list]

On Tue, 12 May 1998, Michael Tung wrote:

> Hi, Peter:
>
>     After I rebuilt the jdbc in interfaces/jdbc and ran the examples, I
> got the error:
>
> PostgreSQL basic test v6.3 rev 1
>
> Connecting to Database URL = jdbc:postgresql:regression
> Exception caught.
> java.sql.SQLException: Failed to authenticate client as Postgres user 'mike' using <unknown authentication type>:
be_recvauth:unrecognized message type: 65536 
>
> java.sql.SQLException: Failed to authenticate client as Postgres user 'mike' using <unknown authentication type>:
be_recvauth:unrecognized message type: 65536 
>
>         at postgresql.Connection.<init>(Connection.java:229)
>         at postgresql.Driver.connect(Driver.java:87)
>         at java.sql.DriverManager.getConnection(DriverManager.java:91)
>         at java.sql.DriverManager.getConnection(DriverManager.java:134)
>         at example.basic.<init>(basic.java:32)
>         at example.basic.main(basic.java:166)
>
> It seems to be authentication problem.  How do you set up pg_hba.conf in
> $PGDATA?

Here's my pg_hba.conf (although I'm a little worried about the auth
number).

local        all                                         password
host         all         127.0.0.1     255.255.255.255   password
host         all         192.0.0.0     255.255.255.0   crypt
host         all         158.152.22.37 255.255.255.255 crypt

Here all connections that go over a wire use crypt, and those that don't
use the non crypted password authentication.

--
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