--- rpms/smeserver-mysql/sme10/smeserver-mysql.spec	2022/06/07 12:39:31	1.29
+++ rpms/smeserver-mysql/sme10/smeserver-mysql.spec	2024/09/05 14:09:41	1.37
@@ -2,7 +2,7 @@ Summary: Koozali SME Server specific mys
 %define name smeserver-mysql
 Name: %{name}
 %define version 2.7.0
-%define release 15
+%define release 21
 Version: %{version}
 Release: %{release}%{?dist}
 License: GPL
@@ -11,6 +11,10 @@ Source: %{name}-%{version}.tar.xz
 Patch0: smeserver-mysql-2.7.0-bz11899-sclo.patch
 Patch1: smeserver-mysql-2.7.0-bz11922-mysqlinit.patch
 Patch2: smeserver-mysql-2.7.0-bz11936.patch
+Patch3: smeserver-mysql-2.7.0-bz11953-mysql.init-logging.patch
+Patch4: smeserver-mysql-2.7.0-bz12262-skipnetworking.patch
+Patch5: smeserver-mysql-2.7.0-bz12417-OpenFilesLimit.patch
+Patch6: smeserver-mysql-2.7.0-bz12145-backupuserprivileges.patch
 
 BuildRoot: /var/tmp/%{name}-%{version}-%{release}-buildroot
 BuildArchitectures: noarch
@@ -35,6 +39,10 @@ mysql.
 %patch0 -p1
 %patch1 -p1
 %patch2 -p1
+%patch3 -p1
+%patch4 -p1
+%patch5 -p1
+%patch6 -p1
 
 %build
 for ver in  101 102 103 105
@@ -69,7 +77,7 @@ port="${ports[$ver]}"
 mkdir -p root$ver/etc/e-smith/sql/init$ver
 mkdir -p root$ver/home/e-smith/db/mariadb$ver
 mkdir -p root$ver/var/log/mariadb$ver
-mkdir -p root$ver/home/e-smith/db/mysql/mariadb$ver
+#mkdir -p root$ver/home/e-smith/db/mysql/mariadb$ver
 mkdir -p root$ver/etc/e-smith/events/actions
 
 # create configuration db default
@@ -142,10 +150,14 @@ echo "
 [mariadb-$vers]" >  root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-05mariadb
 echo "basedir=$basedir" >  root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-07basedir
 echo "datadir=$datadir" > root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-08datadir
-cp -a root/etc/e-smith/templates/etc/my.cnf/009socket root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-09socket
-sed -i root$ver/etc/e-smith/templates/etc/my.cnf/$ver-09socket \
-	-e "s_mariadb_{'mariadb${ver}\-mariadb'}_" \
-	-e "s_^socket.*_socket=${socket}_"
+#cp -a root/etc/e-smith/templates/etc/my.cnf/009socket root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-09socket
+#sed -i root$ver/etc/e-smith/templates/etc/my.cnf/$ver-09socket \
+#	-e "s_mariadb_{'mariadb${ver}\-mariadb'}_" \
+#	-e "s_^socket.*_socket=${socket}_"
+cp rootscl/etc/e-smith/templates/etc/my.conf/_VER_-09socket root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-09socket
+sed -i root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-09socket \
+        -e "s_!!!VER!!!_${ver}_g" \
+        -e "s_!!!PORT!!!_${port}_g"
 cp rootscl/etc/e-smith/templates/etc/my.conf/_VER_-10port root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-10port
 sed -i root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-10port \
 	-e "s_!!!VER!!!_${ver}_g" \
@@ -234,6 +246,7 @@ rm -rf $RPM_BUILD_ROOT
     --file "/sbin/e-smith/systemd/mysql.init" 'attr(0554,root,root)' \
     --dir '/home/e-smith/db/mysql' 'attr(0750,root,root)' \
     --dir "/var/log/mariadb" 'attr(0750,mysql,mysql)' \
+    --dir "/var/log/mysql.init" 'attr(0750,root,root)' \
     > %{name}-%{version}-filelist
 echo "%doc COPYING"          >> %{name}-%{version}-filelist
 
@@ -344,6 +357,24 @@ Koozali SME Server configuration package
 
 
 %changelog
+* Thu Sep 05 2024 Jean-Philippe Pialasse <jpp@koozali.org> 2.7.0-21.sme
+- fix typo for user privileges backup [SME: 12145]
+
+* Sun Sep 01 2024 Jean-Philippe Pialasse <jpp@koozali.org> 2.7.0-19.sme
+- backup user privileges in separate file [SME: 12145]
+  this will allow mariadb 10.3 and higher migration 
+  and is needed to restore to SME 11
+
+* Thu Nov 23 2023 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-18.sme
+- fix OpenFilesLimit too low preventing backup [SME: 12417]
+- deleting extra folder in /home/e-smith/db/mysql/ for mariadb10*
+
+* Sun Dec 11 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-17.sme
+- fix mariadb overriding skip-networking for other versions  [SME: 12262]
+
+* Mon Jul 11 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-16.sme
+- use dedicated log file for *mysql.init [SME: 11953]
+
 * Tue Jun 07 2022 John Crisp <jcrisp@safeandsoundit.co.uk> 2.7.0-15.sme
 - Fix init for MariaDB 104+ [SME:11991]