• SolvedFixed
  • remote mysql server -> how to prepare ssl client?

Hey everyone,

actually i'm preparing another system where i will need to connect to a remote percona xtraDB cluster with ProxySQL as middleware. This clusters uses "SSL only" and i just want to ask how/where i can configure the mysql client to use a client certificate.

In a generic debian 12 i'm placing the client cert most of the time within /etc/mysql and doing the configuration in /etc/mysql/conf.d/ssl.cnf with.

[client]
ssl-ca=/etc/mysql/ca.pem
ssl-cert=/etc/mysql/client-cert.pem
ssl-key=/etc/mysql/client-key.pem

How/Where can i place and configure it before running the setup where i will define the connection details for the remote connection?

Best regards

6 months later

I played around with certificate generation on Oct 30 2024, and it did not seem successful. Only today did I revisit the topic when seeing a duplicate forum post. Lo and behold, things turned out to work this time after adding more openssl command line parameters or something. So stand by while I add support to Gromox…

5 days later

© 2020-2024 grommunio GmbH. All rights reserved. | https://grommunio.com | Data Protection | Legal notice