[MDEV-16219] mariadb ssl_rsa_setup maintenance tool with galera option would accelerate tls deployment on galera cluster Created: 2018-05-18  Updated: 2023-12-22

Status: Open
Project: MariaDB Server
Component/s: Galera, Scripts & Clients, SSL
Fix Version/s: None

Type: New Feature Priority: Major
Reporter: Zdravelina Sokolovska (Inactive) Assignee: Seppo Jaakola
Resolution: Unresolved Votes: 0
Labels: Papercut, beginner-friendly

Issue Links:
Relates
relates to MDEV-15568 SST + SSL/TLS broken due to socat CN ... Closed

 Description   

mariadb ssl_rsa_setup maintenance tool with galera option would accelerate tls deployment on galera cluster

mariadb is supporting tls encryption in client - server channels
as well in mariadb galera cluster.
Deployment of ssl however requires more steps and it would be useful to have
mariadb_ssl_rsa_setup tool to accelerate it and avoid miss configuration errors.

tool may generate client and server certification files and keys
export them optionally to the server or cluster nodes /etc/mysql/certification dir(s)
with appropriate ownership and permissions
and prepare optionally server or cluster nodes configuration files .

[root@t4w5 ~]# ls -l /etc/ | grep mysql
drwxr-xr-x   3 mysql mysql      16 May 11 13:51 mysql
[root@t4w5 ~]# ls /etc/mysql/cc
client.crt  client.key  client.pem  server.crt  server.key  server.pem
 

galera node server.cnf

[mysqld]
 
#ssl-ca=/etc/mysql/cc/server.crt
#ssl-key=/etc/mysql/cc/server.key
#ssl-cert=/etc/mysql/cc/server.pem
 
 
 
[client]
 
#ssl-ca=/etc/mysql/cc/client.crt
#ssl-key=/etc/mysql/cc/client.key
#ssl-cert=/etc/mysql/cc/client.pem
 
 
 

[mysqld]
 
ssl-ca=/etc/mysql/cc/server.crt
ssl-key=/etc/mysql/cc/server.key
ssl-cert=/etc/mysql/cc/server.pem
 
 
 
[client]
 
ssl-ca=/etc/mysql/cc/client.crt
ssl-key=/etc/mysql/cc/client.key
ssl-cert=/etc/mysql/cc/client.pem
 
 
 



 Comments   
Comment by Jan Lindström (Inactive) [ 2019-12-12 ]

This sounds like a feature request.

Generated at Thu Feb 08 08:27:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.