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@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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
