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 14 |
%define release 21 |
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 |
|
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 |
39 |
%patch0 -p1 |
%patch0 -p1 |
40 |
%patch1 -p1 |
%patch1 -p1 |
41 |
%patch2 -p1 |
%patch2 -p1 |
42 |
|
%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" \ |
246 |
--file "/sbin/e-smith/systemd/mysql.init" 'attr(0554,root,root)' \ |
--file "/sbin/e-smith/systemd/mysql.init" 'attr(0554,root,root)' \ |
247 |
--dir '/home/e-smith/db/mysql' 'attr(0750,root,root)' \ |
--dir '/home/e-smith/db/mysql' 'attr(0750,root,root)' \ |
248 |
--dir "/var/log/mariadb" 'attr(0750,mysql,mysql)' \ |
--dir "/var/log/mariadb" 'attr(0750,mysql,mysql)' \ |
249 |
|
--dir "/var/log/mysql.init" 'attr(0750,root,root)' \ |
250 |
> %{name}-%{version}-filelist |
> %{name}-%{version}-filelist |
251 |
echo "%doc COPYING" >> %{name}-%{version}-filelist |
echo "%doc COPYING" >> %{name}-%{version}-filelist |
252 |
|
|
357 |
|
|
358 |
|
|
359 |
%changelog |
%changelog |
360 |
|
* Thu Sep 05 2024 Jean-Philippe Pialasse <jpp@koozali.org> 2.7.0-21.sme |
361 |
|
- fix typo for user privileges backup [SME: 12145] |
362 |
|
|
363 |
|
* Sun Sep 01 2024 Jean-Philippe Pialasse <jpp@koozali.org> 2.7.0-19.sme |
364 |
|
- backup user privileges in separate file [SME: 12145] |
365 |
|
this will allow mariadb 10.3 and higher migration |
366 |
|
and is needed to restore to SME 11 |
367 |
|
|
368 |
|
* Thu Nov 23 2023 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-18.sme |
369 |
|
- fix OpenFilesLimit too low preventing backup [SME: 12417] |
370 |
|
- deleting extra folder in /home/e-smith/db/mysql/ for mariadb10* |
371 |
|
|
372 |
|
* Sun Dec 11 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-17.sme |
373 |
|
- fix mariadb overriding skip-networking for other versions [SME: 12262] |
374 |
|
|
375 |
|
* Mon Jul 11 2022 Jean-Philippe Pialasse <tests@pialasse.com> 2.7.0-16.sme |
376 |
|
- use dedicated log file for *mysql.init [SME: 11953] |
377 |
|
|
378 |
|
* Tue Jun 07 2022 John Crisp <jcrisp@safeandsoundit.co.uk> 2.7.0-15.sme |
379 |
|
- Fix init for MariaDB 104+ [SME:11991] |
380 |
|
|
381 |
* 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 |
382 |
- /usr/libexec/mysql-wait-stop not used after mariadb101 [SME: 11936] |
- /usr/libexec/mysql-wait-stop not used after mariadb101 [SME: 11936] |
383 |
|
|