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(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)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(at)maidstone(dot)gov(dot)uk