odbc psql link ssl cert error

From: Michel Cevzar <michel(dot)cevzar(at)5element(dot)si>
To: pgsql-odbc(at)postgresql(dot)org
Subject: odbc psql link ssl cert error
Date: 2020-12-30 13:56:42
Message-ID: c8903a3c-3bab-a80f-6ca2-8344d969dc0a@5element.si
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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?

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Ian Harding 2020-12-30 20:29:25 ODBC Log from SSIS (Visual Studio 2019)
Previous Message Першин Юрий Петрович 2020-12-23 00:44:03 BUG: copyConnAttributes should decode_or_remove_braces for user name too