2 |
%define name smeserver-mysql |
%define name smeserver-mysql |
3 |
Name: %{name} |
Name: %{name} |
4 |
%define version 2.7.0 |
%define version 2.7.0 |
5 |
%define release 16 |
%define release 19 |
6 |
Version: %{version} |
Version: %{version} |
7 |
Release: %{release}%{?dist} |
Release: %{release}%{?dist} |
8 |
License: GPL |
License: GPL |
12 |
Patch1: smeserver-mysql-2.7.0-bz11922-mysqlinit.patch |
Patch1: smeserver-mysql-2.7.0-bz11922-mysqlinit.patch |
13 |
Patch2: smeserver-mysql-2.7.0-bz11936.patch |
Patch2: smeserver-mysql-2.7.0-bz11936.patch |
14 |
Patch3: smeserver-mysql-2.7.0-bz11953-mysql.init-logging.patch |
Patch3: smeserver-mysql-2.7.0-bz11953-mysql.init-logging.patch |
15 |
|
Patch4: smeserver-mysql-2.7.0-bz12262-skipnetworking.patch |
16 |
|
Patch5: smeserver-mysql-2.7.0-bz12417-OpenFilesLimit.patch |
17 |
|
Patch6: smeserver-mysql-2.7.0-bz12145-backupuserprivileges.patch |
18 |
|
|
19 |
BuildRoot: /var/tmp/%{name}-%{version}-%{release}-buildroot |
BuildRoot: /var/tmp/%{name}-%{version}-%{release}-buildroot |
20 |
BuildArchitectures: noarch |
BuildArchitectures: noarch |
40 |
%patch1 -p1 |
%patch1 -p1 |
41 |
%patch2 -p1 |
%patch2 -p1 |
42 |
%patch3 -p1 |
%patch3 -p1 |
43 |
|
%patch4 -p1 |
44 |
|
%patch5 -p1 |
45 |
|
%patch6 -p1 |
46 |
|
|
47 |
%build |
%build |
48 |
for ver in 101 102 103 105 |
for ver in 101 102 103 105 |
77 |
mkdir -p root$ver/etc/e-smith/sql/init$ver |
mkdir -p root$ver/etc/e-smith/sql/init$ver |
78 |
mkdir -p root$ver/home/e-smith/db/mariadb$ver |
mkdir -p root$ver/home/e-smith/db/mariadb$ver |
79 |
mkdir -p root$ver/var/log/mariadb$ver |
mkdir -p root$ver/var/log/mariadb$ver |
80 |
mkdir -p root$ver/home/e-smith/db/mysql/mariadb$ver |
#mkdir -p root$ver/home/e-smith/db/mysql/mariadb$ver |
81 |
mkdir -p root$ver/etc/e-smith/events/actions |
mkdir -p root$ver/etc/e-smith/events/actions |
82 |
|
|
83 |
# create configuration db default |
# create configuration db default |
150 |
[mariadb-$vers]" > root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-05mariadb |
[mariadb-$vers]" > root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-05mariadb |
151 |
echo "basedir=$basedir" > root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-07basedir |
echo "basedir=$basedir" > root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-07basedir |
152 |
echo "datadir=$datadir" > root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-08datadir |
echo "datadir=$datadir" > root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-08datadir |
153 |
cp -a root/etc/e-smith/templates/etc/my.cnf/009socket root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-09socket |
#cp -a root/etc/e-smith/templates/etc/my.cnf/009socket root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-09socket |
154 |
sed -i root$ver/etc/e-smith/templates/etc/my.cnf/$ver-09socket \ |
#sed -i root$ver/etc/e-smith/templates/etc/my.cnf/$ver-09socket \ |
155 |
-e "s_mariadb_{'mariadb${ver}\-mariadb'}_" \ |
# -e "s_mariadb_{'mariadb${ver}\-mariadb'}_" \ |
156 |
-e "s_^socket.*_socket=${socket}_" |
# -e "s_^socket.*_socket=${socket}_" |
157 |
|
cp rootscl/etc/e-smith/templates/etc/my.conf/_VER_-09socket root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-09socket |
158 |
|
sed -i root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-09socket \ |
159 |
|
-e "s_!!!VER!!!_${ver}_g" \ |
160 |
|
-e "s_!!!PORT!!!_${port}_g" |
161 |
cp rootscl/etc/e-smith/templates/etc/my.conf/_VER_-10port root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-10port |
cp rootscl/etc/e-smith/templates/etc/my.conf/_VER_-10port root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-10port |
162 |
sed -i root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-10port \ |
sed -i root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-10port \ |
163 |
-e "s_!!!VER!!!_${ver}_g" \ |
-e "s_!!!VER!!!_${ver}_g" \ |
357 |
|
|
358 |
|
|
359 |
%changelog |
%changelog |
360 |
|
* Sun Sep 01 2024 Jean-Philippe Pialasse <jpp@koozali.org> 2.7.0-19.sme |
361 |
|
- backup user privileges in separate file [SME: 12145] |
362 |
|
this will allow mariadb 10.3 and higher migration |
363 |
|
and is needed to restore to SME 11 |
364 |
|
|
365 |
|
* Thu Nov 23 2023 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-18.sme |
366 |
|
- fix OpenFilesLimit too low preventing backup [SME: 12417] |
367 |
|
- deleting extra folder in /home/e-smith/db/mysql/ for mariadb10* |
368 |
|
|
369 |
|
* Sun Dec 11 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-17.sme |
370 |
|
- fix mariadb overriding skip-networking for other versions [SME: 12262] |
371 |
|
|
372 |
* Mon Jul 11 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-16.sme |
* Mon Jul 11 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-16.sme |
373 |
- use dedicated log file for *mysql.init [SME: 11953] |
- use dedicated log file for *mysql.init [SME: 11953] |
374 |
|
|