Re: connecting with a 8.0.0 client with ssl

On Thu, 2005-01-20 at 14:14 +0000, Jackson Pauls wrote:

> 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(at)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).

... adding to my own post. i just noticed errors aren't being reported
in psql in the 8.0.0 client (connected to a local 8.0.0 server):

db=> select 'a' + 1;
db=>

but do appear in the local server log: 'ERROR: invalid input syntax for
integer: "a"'

i'm using the default settings for error reporting and logging.

is there is a way to reinstate error messages in psql? it might be
trying to tell me something useful when i'm trying to connect to the
remote server.

cheers,

j

--
Play Alienballs at www.j.uklinux.net