hi,
i'm trying to create a connection from a postgres 8.0.0 client to a
remote server running postgres 7.4.6 that requires ssl.
this connection worked on the client machine when connecting using a
7.4.6 postgres client, and still works when connecting from a 3rd
machine with 7.4.6. so i think that narrows it down to some change in
the new postgres 8.0.0 client.
client was configured with ./configure --with-openssl.
psql (lack of) output:
$ psql -U user -h remoteIP db
psql: [j@localhost]$
php output:
Warning: pg_connect() [function.pg-connect]: Unable to connect to
PostgreSQL server: in ...
for each failed connection, the server log contains the line:
LOG: could not initialize SSL connection: No SSL error reported
there is no root.crt file on the server, and no certificates present on
the client.
server tuns fedora core 1, openssl-0.9.7a-33.10 (rpm), client runs
fedora core 3, openssl-0.9.7a-40 (rpm).
i'm not sure where to go from here, any help appreciated.
cheers,
jackson
--
Play Alienballs at www.j.uklinux.net