“tlsv1 alert iso-8859-1 ca” with PQconnectdb - Mailing list pgsql-general

From M Tarkeshwar Rao
Subject “tlsv1 alert iso-8859-1 ca” with PQconnectdb
Date
Msg-id AM8PR07MB8229AFC37537B83FE085784CAEF19@AM8PR07MB8229.eurprd07.prod.outlook.com
Whole thread Raw
Responses Re: “tlsv1 alert iso-8859-1 ca” with PQconnectdb
List pgsql-general

Hi all,

 

I made following changes in my Postgres server which means I am enabling one way authentication: (Disabled Mutual authentication. Only client will authenticate server.)

hostssl all             myuser          0.0.0.0/0               md5 clientcert=0

 

I am trying psql with following options where I am providing client certificates also. It is connected perfectly.

psql "host= 10.10.11.18 sslmode=verify-ca sslrootcert=em-ca-crt.pem sslcert=em-client-crt.pem sslkey=em-client-key.pem port=5433 user=postgres dbname=postgres"

 

Same when we used with C api (PQconnectdb((const char *)str);) it is failing with following error message.

 

“tlsv1 alert unknown ca”

 

Also we tried with Java test program. It is connecting properly. Can you please suggest what could be the reason?

 

Regards

Tarkeshwar

 

 

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: pg_restore (fromuser -> touser)
Next
From: Tom Lane
Date:
Subject: Re: “tlsv1 alert iso-8859-1 ca” with PQconnectdb