--- rpms/smeserver-mysql/sme10/smeserver-mysql.spec	2022/12/11 05:23:03	1.31
+++ rpms/smeserver-mysql/sme10/smeserver-mysql.spec	2024/09/01 04:21:50	1.35
@@ -2,7 +2,7 @@ Summary: Koozali SME Server specific mys
 %define name smeserver-mysql
 Name: %{name}
 %define version 2.7.0
-%define release 17
+%define release 19
 Version: %{version}
 Release: %{release}%{?dist}
 License: GPL
@@ -13,6 +13,8 @@ Patch1: smeserver-mysql-2.7.0-bz11922-my
 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
@@ -39,6 +41,8 @@ mysql.
 %patch2 -p1
 %patch3 -p1
 %patch4 -p1
+%patch5 -p1
+%patch6 -p1
 
 %build
 for ver in  101 102 103 105
@@ -73,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
@@ -150,7 +154,7 @@ echo "datadir=$datadir" > root$ver/etc/e
 #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
+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"
@@ -353,6 +357,15 @@ Koozali SME Server configuration package
 
 
 %changelog
+* 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]