1 files changed, 22 insertions, 0 deletions

diff --git a/src/mariadb-copy-cert.mk b/src/mariadb-copy-cert.mk
new file mode 100755
index 0000000..d810f30
--- /dev/null
+++ b/src/mariadb-copy-cert.mk
@@ -0,0 +1,22 @@
+#!/usr/bin/env -S make -f
+domain != hostname --fqdn
+source_dir = /etc/apache2/md/domains/$(domain)
+target_dir = /etc/mysql
+user = mysql
+group = mysql
+source_basenames = privkey.pem pubcert.pem
+target_basenames = server-key.pem server-cert.pem cacert.pem
+source_files = $(addprefix $(source_dir)/,$(source_basenames))
+target_files = $(addprefix $(target_dir)/,$(target_basenames))
+
+INSTALL = install -o $(user) -g $(group)
+
+all: $(target_files)
+$(target_files): $(source_files) | $(target_dir)
+
+$(target_dir):
+        mkdir -p $@
+$(target_dir)/server-key.pem:
+        $(INSTALL) -m 0440 $(source_dir)/privkey.pem -T $@
+$(target_dir)/server-cert.pem $(target_dir)/cacert.pem:
+        $(INSTALL) -m 0444 $(source_dir)/pubcert.pem -T $@