[pgpool-general: 4121] Pgpool SSL connection help need

[AI Rumman]

Hi All,

I am trying to setup Pgpool II SSL connection from* client to PGPOOL*,
where PGPOOL to backend DB is non-ssl.
Database backend is 9.4 and Pgpool version is "pgpool-II version 3.4.3"

I followed this doc:
http://www.pgpool.net/mediawiki/index.php/FAQ
And configured ssl parameters as below:

enable_pool_hba = on
> pool_passwd = 'pool_passwd'
> authentication_timeout = 60
> ssl = on
> ssl_key = '/opt/msp/pkg/postgres/pgpool/key/server.key'
> ssl_cert = '/opt/msp/pkg/postgres/pgpool/key/server.crt'



pool_hba.conf:

hostssl all         all           0.0.0.0/0           trust



Now, when I am trying to connect from client:

psql -h 10.0.0.13 -p 9999 sslmode=require
> Password:
> psql: server does not support SSL, but SSL was required



Am I missing any step here?

Please advice.



Thanks & Regards.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20151016/eb9a12cd/attachment.html>