How to use SSL option

[swarno]

Is there an example for the following settings ? Is the cacertfile used for server validation?
##auth.pgsql.ssl_opts.keyfile =
##auth.pgsql.ssl_opts.certfile =
##auth.pgsql.ssl_opts.cacertfile =

How to set the sslmode for connection to postgres.
sslmode=require/verifyCA/verify-full etc.

[swarno]

Can I get any update of mutual verification of certificates over SSL?

[aravindranathan]

Environment

• OS: Ubuntu 14.04
• Erlang/OTP: (erlang/otp version installed as a part of http://emqtt.io/downloads/stable/ubuntu14_04-deb)
• EMQ: emqttd-2.2.0

Description

The emq-auth_psql plugin seems to be successful in a making a TLS connection to the DB. The SSL certficate used is signed by a private CA and this CA has not been imported and added to the auth.pgsql.ssl_opts.cacertfile

[ashtonian]

an example of a valid config for the file paths would be great so its explicit if the paths are relative or absolute, would make debugging connectivity issues easier.