Proxysql SSL ca cert RDS

How to connect to RDS with ssl in AWS from Proxysql?
Only have the CA-cert root certificate from aws to connect to RDS.
I can connect directly from the server that has proxysql installed.
mysql -udlewis -p -h rds.instance.rds.amazonaws.com -P3306 --ssl-ca /etc/ssl/certs/rds-ca-2019-root.pem
I can not connect with ssl from proxysql
mysql -udlewis -p -h 127.0.0.1 -P3306 --ssl-ca /home/dlewis/rds-ca-2019-root.pem
or
mysql -udlewis -p -h 127.0.0.1 -P3306

variables:
| mysql-have_ssl | true |
| mysql-ssl_p2s_ca | /etc/mysql/ssl/rds-ca-2019-root.pem |
| mysql-ssl_p2s_cert | |
| mysql-ssl_p2s_key | |
| mysql-ssl_p2s_cipher | |

Hi, there seems to be a few configs missing. Please check SSL Encryption at ProxySQL Part 1 - ProxySQL
for instructions

1 Like