I am not sure if this is a bug.
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all 192.168.0.0/16 trust
hostssl dbm all 192.168.200.201 255.255.255.255 md5
int ret=PQconnectdb("hostaddr=192.168.200.10 dbname=dbm user=postgres
' ret' prints -1.
Now when I change the above function to one with sslmode=allow, the
connection is established and query runs.
I do have (ssl=true) in postgresql.conf and have tested the
certificates and they are working right. I also restart the postmaster
after every change in postgresql.conf and pg_hba.conf.
I would prefer the connections are SSL and hence would like to use the
default "prefer" sslmode.
In response to
pgsql-bugs by date
|Next:||From: vishal saberwal||Date: 2005-08-26 01:30:18|
|Subject: Re: Ref: BUG#1321: SSL error: sslv3 alert handshake failure|
|Previous:||From: Gennadiy.Donchyts||Date: 2005-08-25 23:50:59|
|Subject: Re: BUG #1844: Failed to start service 'PostgreSQL Database Server 8.0'|