--- rpms/smeserver-mysql/sme10/smeserver-mysql.spec	2022/04/09 18:22:07	1.26
+++ rpms/smeserver-mysql/sme10/smeserver-mysql.spec	2023/11/24 04:16:21	1.34
@@ -2,7 +2,7 @@ Summary: Koozali SME Server specific mys
 %define name smeserver-mysql
 Name: %{name}
 %define version 2.7.0
-%define release 13
+%define release 18
 Version: %{version}
 Release: %{release}%{?dist}
 License: GPL
@@ -11,6 +11,9 @@ 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
 
 BuildRoot: /var/tmp/%{name}-%{version}-%{release}-buildroot
 BuildArchitectures: noarch
@@ -35,6 +38,9 @@ mysql.
 %patch0 -p1
 %patch1 -p1
 %patch2 -p1
+%patch3 -p1
+%patch4 -p1
+%patch5 -p1
 
 %build
 for ver in  101 102 103 105
@@ -69,7 +75,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 +148,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" \
@@ -192,7 +202,8 @@ sed -i root$ver/usr/lib/systemd/system/m
 if [ $ver -ge  102 ]
 then
   sed -i root$ver/usr/lib/systemd/system/mariadb${ver}-mariadb.service \
-	-e "s/_safe//";
+	-e "s/_safe//" \
+	-e "s/^ExecStopPost.*//";
 fi
 if [ $ver -ge  104 ]
 then
@@ -233,6 +244,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
 
@@ -343,6 +355,22 @@ Koozali SME Server configuration package
 
 
 %changelog
+* 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]
+
+* Sun Apr 10 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-14.sme
+- /usr/libexec/mysql-wait-stop not used after mariadb101 [SME: 11936]
+
 * Sat Apr 09 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-13.sme
 - fix few typos [SME: 11936]