odbc psql link ssl cert error

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

odbc psql link ssl cert error

michel_cevzar
Dear Sir,


I  am having problems with odbc psql link on cent os8 and with postgres-odbc version 10.3(this one was the default one in the repository)

I have defined my ssl cert files as such

pqopt={sslrootcert=/etc/ssl/certs/db_ssl_cert/client.crt \
sslcert=/etc/ssl/certs/db_ssl_cert/postgresql_client.crt
sslkey=/etc/ssl/certs/db_ssl_cert/postgresql_client.key}


But I keep getting error(when using isql), even though I can connect using psql

[08001][unixODBC]libpq connection parameter error:invalid connection option "{sslrootcert"

I get this error no matter what I put in front of the first "=" sign.


Should the certificates be in ~/.postgresql/ directory?

What is the problem? On my windows machine I input parameters as above and no problems with the driver version 11.0, should I simply update the driver to the latest version?



Reply | Threaded
Open this post in threaded view
|

Re: odbc psql link ssl cert error

Clemens Ladisch
Michel Cevzar wrote:
> I have defined my ssl cert files as such
>
> pqopt={sslrootcert=...

Where exactly did you write this setting?

> [08001][unixODBC]libpq connection parameter error:invalid connection option "{sslrootcert"

Apparently, you are not allowed to use {} at that place.


Regards,
Clemens