Skip site navigation (1) Skip section navigation (2)

PQconnectdb SSL (sslmode)

From: vishal saberwal <vishalsaberwal(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, tjtoocool(at)phreaker(dot)net
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: PQconnectdb SSL (sslmode)
Date: 2005-08-26 01:20:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
I am not sure if this is a bug.

local all all trust
host all all trust
host all all trust
hostssl dbm all md5

int ret=PQconnectdb("hostaddr= 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 saberwalDate: 2005-08-26 01:30:18
Subject: Re: Ref: BUG#1321: SSL error: sslv3 alert handshake failure
Previous:From: Gennadiy.DonchytsDate: 2005-08-25 23:50:59
Subject: Re: BUG #1844: Failed to start service 'PostgreSQL Database Server 8.0'

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group