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 15 |
%define release 18 |
6 |
Version: %{version} |
Version: %{version} |
7 |
Release: %{release}%{?dist} |
Release: %{release}%{?dist} |
8 |
License: GPL |
License: GPL |
11 |
Patch0: smeserver-mysql-2.7.0-bz11899-sclo.patch |
Patch0: smeserver-mysql-2.7.0-bz11899-sclo.patch |
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 |
15 |
|
Patch4: smeserver-mysql-2.7.0-bz12262-skipnetworking.patch |
16 |
|
Patch5:smeserver-mysql-2.7.0-bz12417-OpenFilesLimit.patch |
17 |
|
|
18 |
BuildRoot: /var/tmp/%{name}-%{version}-%{release}-buildroot |
BuildRoot: /var/tmp/%{name}-%{version}-%{release}-buildroot |
19 |
BuildArchitectures: noarch |
BuildArchitectures: noarch |
38 |
%patch0 -p1 |
%patch0 -p1 |
39 |
%patch1 -p1 |
%patch1 -p1 |
40 |
%patch2 -p1 |
%patch2 -p1 |
41 |
|
%patch3 -p1 |
42 |
|
%patch4 -p1 |
43 |
|
%patch5 -p1 |
44 |
|
|
45 |
%build |
%build |
46 |
for ver in 101 102 103 105 |
for ver in 101 102 103 105 |
75 |
mkdir -p root$ver/etc/e-smith/sql/init$ver |
mkdir -p root$ver/etc/e-smith/sql/init$ver |
76 |
mkdir -p root$ver/home/e-smith/db/mariadb$ver |
mkdir -p root$ver/home/e-smith/db/mariadb$ver |
77 |
mkdir -p root$ver/var/log/mariadb$ver |
mkdir -p root$ver/var/log/mariadb$ver |
78 |
mkdir -p root$ver/home/e-smith/db/mysql/mariadb$ver |
#mkdir -p root$ver/home/e-smith/db/mysql/mariadb$ver |
79 |
mkdir -p root$ver/etc/e-smith/events/actions |
mkdir -p root$ver/etc/e-smith/events/actions |
80 |
|
|
81 |
# create configuration db default |
# create configuration db default |
148 |
[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 |
149 |
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 |
150 |
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 |
151 |
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 |
152 |
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 \ |
153 |
-e "s_mariadb_{'mariadb${ver}\-mariadb'}_" \ |
# -e "s_mariadb_{'mariadb${ver}\-mariadb'}_" \ |
154 |
-e "s_^socket.*_socket=${socket}_" |
# -e "s_^socket.*_socket=${socket}_" |
155 |
|
cp rootscl/etc/e-smith/templates/etc/my.conf/_VER_-09socket root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-09socket |
156 |
|
sed -i root$ver/etc/e-smith/templates/etc/my.cnf/${ver}-09socket \ |
157 |
|
-e "s_!!!VER!!!_${ver}_g" \ |
158 |
|
-e "s_!!!PORT!!!_${port}_g" |
159 |
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 |
160 |
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 \ |
161 |
-e "s_!!!VER!!!_${ver}_g" \ |
-e "s_!!!VER!!!_${ver}_g" \ |
244 |
--file "/sbin/e-smith/systemd/mysql.init" 'attr(0554,root,root)' \ |
--file "/sbin/e-smith/systemd/mysql.init" 'attr(0554,root,root)' \ |
245 |
--dir '/home/e-smith/db/mysql' 'attr(0750,root,root)' \ |
--dir '/home/e-smith/db/mysql' 'attr(0750,root,root)' \ |
246 |
--dir "/var/log/mariadb" 'attr(0750,mysql,mysql)' \ |
--dir "/var/log/mariadb" 'attr(0750,mysql,mysql)' \ |
247 |
|
--dir "/var/log/mysql.init" 'attr(0750,root,root)' \ |
248 |
> %{name}-%{version}-filelist |
> %{name}-%{version}-filelist |
249 |
echo "%doc COPYING" >> %{name}-%{version}-filelist |
echo "%doc COPYING" >> %{name}-%{version}-filelist |
250 |
|
|
355 |
|
|
356 |
|
|
357 |
%changelog |
%changelog |
358 |
|
* Thu Nov 23 2023 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-18.sme |
359 |
|
- fix OpenFilesLimit too low preventing backup [SME: 12417] |
360 |
|
- deleting extra folder in /home/e-smith/db/mysql/ for mariadb10* |
361 |
|
|
362 |
|
* Sun Dec 11 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-17.sme |
363 |
|
- fix mariadb overriding skip-networking for other versions [SME: 12262] |
364 |
|
|
365 |
|
* Mon Jul 11 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-16.sme |
366 |
|
- use dedicated log file for *mysql.init [SME: 11953] |
367 |
|
|
368 |
* Tue Jun 07 2022 John Crisp <jcrisp@safeandsoundit.co.uk> 2.7.0-15.sme |
* Tue Jun 07 2022 John Crisp <jcrisp@safeandsoundit.co.uk> 2.7.0-15.sme |
369 |
- Fix init for MariaDB 104+ [SME:11889] |
- Fix init for MariaDB 104+ [SME:11991] |
370 |
|
|
371 |
* Sun Apr 10 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-14.sme |
* Sun Apr 10 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-14.sme |
372 |
- /usr/libexec/mysql-wait-stop not used after mariadb101 [SME: 11936] |
- /usr/libexec/mysql-wait-stop not used after mariadb101 [SME: 11936] |