[pgpool-general: 8127] Re: Connection to Aurora with rds.force_ssl set to 1 fails

[Bo Peng]

Hello,

> psql: error:
> FATAL:  no pg_hba.conf entry for host "x.x.x.x", user "administrator",
> database "eittestshared", SSL off

As the error shows no pg_hba.conf entry for ... SSL off.
Pgpool-II couldn't connect to PostgreSQL without SSL.
You need to enable "ssl" in Pgpool-II.

https://www.pgpool.net/docs/latest/en/html/runtime-ssl.html#RUNTIME-SSL-SETTINGS

> I've set up an ec2 instance running pgpool (pgpool-II-4.3.1) and I am
> struggling to understand how to enable SSL connections through to an Aurora
> Postgres Instance.
> 
> When I set my rds.force_ssl to 0 it works without issue.  Otherwise when I
> set rds.force_ssl to 1 I get the error :
> 
> psql: error:
> FATAL:  no pg_hba.conf entry for host "x.x.x.x", user "administrator",
> database "eittestshared", SSL off
> 
> Unfortunately our standard is to have the rds.force_ssl parameter set to 1.
> 
> Thanks so much in advance
> Regards
> 
> -- 
> 
> *Lorraine Anderson* | Senior Consultant | m: +64 2718002193 <+642718002193>
>  | p: +64 9 918 0580 <+64099180580>
> Level 22, Crombie Lockwood Tower, 191 Queen St, Auckland,1010, New Zealand


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
http://www.sraoss.co.jp/