I am new to Postgre. Migrating from MySQL. I am trying to connect via SSL to a PostgreSQL using FireDac in Delphi. I have followed the instructions at the following site: https://www.howtoforge.com/postgresql-ssl-certificates to create my self-certified certificates and configure the config files. I have coped the specified files to the client machine and installed the root.crt certificate. Via FireDAC's connection params I have specified the following: Params.values[SSL_ca']:=sslCertsPath+'root.crt'; Params.values['SSL_cert']:=sslCertsPath+'postgresql.crt.'; Params.values['SSL_key']:=sslCertsPath+'postgresql.key'; I am getting a connection error re invalid client certificate. I have used OpenSSL to verify against the root.crt and postgresql.crt and this confirms the certificate is ok. Mark __ |
