Proxysql startup failed due to issues in reading password protected SSL certificate

I need to enable SSL with my own certificate for the connection between client and proxysql.
How can I feed the password of pem files during start-up?

Proxysql startup failed with below error

Starting ProxySQL: 2021-03-26 14:05:17 [INFO] Using config file /home/proxysql/etc/proxysql.cnf
2021-03-26 14:05:17 [INFO] Using OpenSSL version: OpenSSL 1.1.1d 10 Sep 2019
2021-03-26 14:05:17 [INFO] SSL keys/certificates found in datadir (/home/sas/proxysql/data): loading them.
2021-03-26 14:05:17 main.cpp:425:rsa_key_read(): [ERROR] Error on PEM_read_bio_RSAPrivateKey for /home/proxysql/data/proxysql-key.pem.

1 Like

Hello @preethi11 ,
You can’t. Your key needs to not have an encrypted passphrase. I suggest filing a feature request on proxysql’s github for this.

1 Like