From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | Michael Tung <mike(at)h178133(dot)nist(dot)gov> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: jdbc for postgresql. |
Date: | 1998-05-12 17:43:40 |
Message-ID: | Pine.LNX.3.95.980512184059.11075C-100000@retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
[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
From | Date | Subject | |
---|---|---|---|
Next Message | Ewan Mellor | 1998-05-12 18:17:35 | Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name' |
Previous Message | Byron Nikolaidis | 1998-05-12 17:00:47 | Re: [INTERFACES] MS Access & PsqlODBC: Invalid field name 'name' |