Error connecting to postgres 8.1

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
rnaujack
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 04.07.2007, 11:38

Error connecting to postgres 8.1

Post by rnaujack »

I'm trying to connect to a postgresql 8.1 without any ssl active. pgadmin works fine, but zeos can't connect.

With mysql the program works fine, but've like to test postgres instead.

thanks for help
Rudolf
rnaujack
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 04.07.2007, 11:38

Post by rnaujack »

rnaujack wrote:I'm trying to connect to a postgresql 8.1 without any ssl active. pgadmin works fine, but zeos can't connect.

With mysql the program works fine, but've like to test postgres instead.

thanks for help
Rudolf
i've forgotten the error-message:

SQL Error: received invalid response to SSL negotiation: 4.
btrewern
Expert Boarder
Expert Boarder
Posts: 193
Joined: 06.10.2005, 18:51

Post by btrewern »

You'll need the following dlls in your path:

comerr32.dll
iconv.dll
krb5_32.dll
libeay32.dll
libiconv-2.dll
libintl-2.dll
libpq.dll
ssleay32.dll

You can find these in your pgAdmin III program folder.

Regards,

Ben
rnaujack
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 04.07.2007, 11:38

Post by rnaujack »

i've got all these dlls in my path; without them the program complains about missing dlls.
If i us protocol postgres or postgres-8, i get:
SQL Error: received invalid response to SSL negotiation: 4.

If i use protocol postgres-7, i get:
SQL Error: expected authentication request from server, but received 4.

Using perl with DBI::Pg / DBI::PgPP against this server, all works fine.

Against an postgres 8.2 server on windows:
instead of '4' there a '>' in the error-message
Post Reply