--- rpms/e-smith-mysql/sme10/e-smith-mysql.spec	2016/07/24 15:20:03	1.14
+++ rpms/e-smith-mysql/sme10/e-smith-mysql.spec	2020/12/08 19:57:09	1.18
@@ -1,10 +1,10 @@
-# $Id: e-smith-mysql.spec,v 1.13 2016/07/23 06:24:27 stephdl Exp $
+# $Id: e-smith-mysql.spec,v 1.17 2020/12/08 03:49:44 jpp Exp $
 
 Summary: e-smith specific mysql configuration and templates.
 %define name e-smith-mysql
 Name: %{name}
 %define version 2.6.0
-%define release 13
+%define release 15
 Version: %{version}
 Release: %{release}%{?dist}
 License: GPL
@@ -16,6 +16,10 @@ Patch2: e-smith-mysql-2.6.0-use_default_
 Patch3: e-smith-mysql-2.6.0-mariadb_forgotten_var.patch
 Patch4: e-smith-mysql-2.6.0.bz9671.RemoveDummyMysqlDatabase.patch 
 Patch5: e-smith-mysql-2.6.0.bz9688.skipredirect.patch
+Patch6: e-smith-mysql-2.6.0-bz11145-updateevent.patch
+Patch7: e-smith-mysql-2.6.0-bz11021-mariadb2systemd.patch
+Patch8: e-smith-mysql-2.6.0-bz11120-mysql.init2systemd.patch
+
 BuildRoot: /var/tmp/%{name}-%{version}-%{release}-buildroot
 BuildArchitectures: noarch
 Requires: mariadb-server
@@ -26,6 +30,17 @@ BuildRequires: e-smith-devtools >= 1.13.
 AutoReqProv: no
 
 %changelog
+* Mon Dec 07 2020 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-15.sme
+- e-smith-update event [SME: 11145]
+- mariadb systemd integration [SME: 11021]
+  move set.password and template
+  create /usr/lib/systemd/system/mariadb.service.d/sme.conf
+  create /sbin/e-smith/systemd/mariadb-initialize + chmod
+  cleanup and remove old /var/service/mariadb
+- mysql.init systemd integration [SME: 11120]
+  create mysql_init.service
+
+
 * Sun Jul 24 2016 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-13.sme
 - systemd skip redirect [SME: 9688]
 
@@ -762,7 +777,6 @@ mysql.
 %patch3 -p1
 %patch4 -p1
 %patch5 -p1
-
 # mysqld renamed to mariadb [SME: 9438]
 # TODO: remove on next tarball creation
 rm -f root/service/mysqld
@@ -773,6 +787,19 @@ rm -f root/etc/rc.d/init.d/supervise/mys
 rm -f root/etc/rc.d/rc7.d/S50mysqld
 
 mkdir -p root/var/log/mariadb.run
+%patch6 -p1
+# move mariadb to systemd
+%patch7 -p1
+rm -rf root/etc/e-smith/templates.metadata/var/service
+rm -rf root/etc/e-smith/templates/var/service/mariadb
+rm -rf root/var/service
+rm -rf root/service
+rm -rf root/etc/rc.d/init.d/supervise
+rm -rf root/var/log
+
+# move mysql.init
+%patch8 -p1
+rm -rf root/etc/rc.d/rc7.d
 
 %build
 perl createlinks
@@ -781,6 +808,7 @@ perl createlinks
 rm -rf $RPM_BUILD_ROOT
 (cd root   ; find . -depth -print | cpio -dump $RPM_BUILD_ROOT)
 /sbin/e-smith/genfilelist $RPM_BUILD_ROOT \
+    --file /sbin/e-smith/systemd/mariadb-initialize 'attr(0554,root,root)' \
     --file /var/service/mariadb/run 'attr(0755,root,root)' \
     --file /var/service/mariadb/control/t 'attr(0750,root,root)' \
     --file /var/service/mariadb/control/d 'attr(0750,root,root)' \
@@ -795,6 +823,16 @@ echo "%doc COPYING"          >> %{name}-
 %clean 
 rm -rf $RPM_BUILD_ROOT
 
+%pre
+if [ $1 -gt 1 ] ; then
+  if [ -e /var/service/mariadb/run ] ; then
+	/usr/bin/sv d mariadb
+	/usr/bin/sv d mariadb/log
+	# also 
+	rm -rf /var/service/mariadb
+  fi
+fi
+
 %post
 
 %postun