1 |
# $Id: e-smith-mysql.spec,v 1.3 2016/03/18 11:11:54 unnilennium Exp $ |
# $Id: e-smith-mysql.spec,v 1.23 2021/03/04 20:17:44 jpp Exp $ |
2 |
|
|
3 |
Summary: e-smith specific mysql configuration and templates. |
Summary: e-smith specific mysql configuration and templates. |
4 |
%define name e-smith-mysql |
%define name e-smith-mysql |
5 |
Name: %{name} |
Name: %{name} |
6 |
%define version 2.6.0 |
%define version 2.6.0 |
7 |
%define release 3 |
%define release 20 |
8 |
Version: %{version} |
Version: %{version} |
9 |
Release: %{release}%{?dist} |
Release: %{release}%{?dist} |
10 |
License: GPL |
License: GPL |
11 |
Group: Networking/Daemons |
Group: Networking/Daemons |
12 |
Source: %{name}-%{version}.tar.xz |
Source: %{name}-%{version}.tar.xz |
13 |
Patch0: e-smith-mysql-2.6.0-mariadb1.patch |
Patch0: e-smith-mysql-2.6.0-mariadb1.patch |
14 |
|
Patch1: e-smith-mysql-2.6.0-mysqld2mariadb.patch |
15 |
|
Patch2: e-smith-mysql-2.6.0-use_default_innodb_settings.patch |
16 |
|
Patch3: e-smith-mysql-2.6.0-mariadb_forgotten_var.patch |
17 |
|
Patch4: e-smith-mysql-2.6.0.bz9671.RemoveDummyMysqlDatabase.patch |
18 |
|
Patch5: e-smith-mysql-2.6.0.bz9688.skipredirect.patch |
19 |
|
Patch6: e-smith-mysql-2.6.0-bz11145-updateevent.patch |
20 |
|
Patch7: e-smith-mysql-2.6.0-bz11021-mariadb2systemd.patch |
21 |
|
Patch8: e-smith-mysql-2.6.0-bz11120-mysql.init2systemd.patch |
22 |
|
Patch9: e-smith-mysql-2.6.0-bz7827-dumpfailure.patch |
23 |
|
Patch10: e-smith-mysql-2.6.0-bz455-bz4606-bz11404-bz11425.patch |
24 |
|
Patch11: e-smith-mysql-2.6.0.bz11453-sme9restoreerror.patch |
25 |
|
|
26 |
BuildRoot: /var/tmp/%{name}-%{version}-%{release}-buildroot |
BuildRoot: /var/tmp/%{name}-%{version}-%{release}-buildroot |
27 |
BuildArchitectures: noarch |
BuildArchitectures: noarch |
28 |
Requires: mariadb-server |
Requires: mariadb-server |
33 |
AutoReqProv: no |
AutoReqProv: no |
34 |
|
|
35 |
%changelog |
%changelog |
36 |
* Thu Mar 31 2016 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-3.sme |
* Sat Mar 14 2021 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-20.sme |
37 |
|
- fix restore of sme9 backup fails to start mysql.init [SME: 11453] |
38 |
|
|
39 |
|
* Thu Mar 04 2021 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-19.sme |
40 |
|
- add property to enable mysqld slow queries log [SME: 455] |
41 |
|
simply use SlowQueries as the amount of second and it is enabled |
42 |
|
remove property to stop logging |
43 |
|
- more mysqld/mariadb parameter available with properties /templates [SME: 4606] |
44 |
|
- ease 4 databit characters with innodb [SME: 11404] |
45 |
|
- redirect mariadb log from systemd to file [SME: 11425] |
46 |
|
|
47 |
|
* Wed Jan 27 2021 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-18.sme |
48 |
|
- fix backup fails in pre-backup in mysqldump [SME: 7827] |
49 |
|
|
50 |
|
* Sun Dec 13 2020 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-17.sme |
51 |
|
- expand 10mysql_upgrade and restart mysql.init on e-smith-mysql-update [SME: 11120] |
52 |
|
this to make sure mariadb upgrade fully and prevent residual 10mysql_upgrade stay in the way |
53 |
|
|
54 |
|
* Wed Dec 09 2020 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-16.sme |
55 |
|
- fix issue with 10mysql_upgrade crashing mariadb [SME: 11120] |
56 |
|
also removed noise from spec file |
57 |
|
|
58 |
|
* Mon Dec 07 2020 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-15.sme |
59 |
|
- e-smith-update event [SME: 11145] |
60 |
|
- mariadb systemd integration [SME: 11021] |
61 |
|
move set.password and template |
62 |
|
create /usr/lib/systemd/system/mariadb.service.d/sme.conf |
63 |
|
create /sbin/e-smith/systemd/mariadb-initialize + chmod |
64 |
|
cleanup and remove old /var/service/mariadb |
65 |
|
- mysql.init systemd integration [SME: 11120] |
66 |
|
create mysql_init.service |
67 |
|
|
68 |
|
|
69 |
|
* Sun Jul 24 2016 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-13.sme |
70 |
|
- systemd skip redirect [SME: 9688] |
71 |
|
|
72 |
|
* Sat Jul 23 2016 stephane de Labrusse <stephdl@de-labrusse.fr> 2.6.0-12.sme |
73 |
|
- Corrected a typo in e-smith-mysql-2.6.0.bz9671.RemoveDummyMysqlDatabase.patch |
74 |
|
- [SME: 9671] |
75 |
|
|
76 |
|
* Thu Jul 21 2016 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-11.sme |
77 |
|
- fix broken link /etc/init.d/supervise/mariadb [SME: 9686] |
78 |
|
|
79 |
|
* Mon Jul 18 2016 stephane de Labrusse <stephdl@de-labrusse.fr> 2.6.0-10.sme |
80 |
|
- Remove Dummy database from backup and restoration [SME: 9671] |
81 |
|
- Added e-smith-mysql-2.6.0.bz9671.RemoveDummyMysqlDatabase.patch |
82 |
|
|
83 |
|
* Mon Jul 18 2016 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-8.sme |
84 |
|
- fix forgotten mysqld variables in various scripts [SME: 9438] |
85 |
|
- e-smith-mysql-2.6.0-mariadb_forgotten_var.patch |
86 |
|
|
87 |
|
* Mon Apr 11 2016 Daniel Berteaud <daniel@firewall-services.com> 2.6.0-7.sme |
88 |
|
- Use default InnoDB settings [SME: 9439] |
89 |
|
|
90 |
|
* Mon Apr 11 2016 Daniel Berteaud <daniel@firewall-services.com> 2.6.0-6.sme |
91 |
|
- Rename mysqld to mariadb [SME: 9438] |
92 |
|
|
93 |
|
* Mon Apr 11 2016 Daniel Berteaud <daniel@firewall-services.com> 2.6.0-5.sme |
94 |
|
- Remove uneeded scriplets %post and %postun [SME: 9422] |
95 |
|
|
96 |
|
* Thu Mar 31 2016 Jean-Philipe Pialasse <tests@pialasse.com> 2.6.0-4.sme |
97 |
- new path for pid file with mariadb [SME: 9407] |
- new path for pid file with mariadb [SME: 9407] |
98 |
- my.cnf : Innodb needs to be active for mariadb [SME: 9406] |
- my.cnf : Innodb needs to be active for mariadb [SME: 9406] |
99 |
|
|
797 |
%prep |
%prep |
798 |
%setup |
%setup |
799 |
%patch0 -p1 |
%patch0 -p1 |
800 |
|
%patch1 -p1 |
801 |
|
%patch2 -p1 |
802 |
|
%patch3 -p1 |
803 |
|
%patch4 -p1 |
804 |
|
%patch5 -p1 |
805 |
|
# mysqld renamed to mariadb [SME: 9438] |
806 |
|
# TODO: remove on next tarball creation |
807 |
|
rm -f root/service/mysqld |
808 |
|
rm -rf root/var/service/mysqld |
809 |
|
rm -rf root/var/run/ |
810 |
|
rm -rf root/var/log/mysqld |
811 |
|
rm -f root/etc/rc.d/init.d/supervise/mysqld |
812 |
|
rm -f root/etc/rc.d/rc7.d/S50mysqld |
813 |
|
mkdir -p root/var/log/mariadb.run |
814 |
|
%patch6 -p1 |
815 |
|
# move mariadb to systemd |
816 |
|
%patch7 -p1 |
817 |
|
rm -rf root/etc/e-smith/templates.metadata/var/service |
818 |
|
rm -rf root/etc/e-smith/templates/var/service/mariadb |
819 |
|
rm -rf root/var/service |
820 |
|
rm -rf root/service |
821 |
|
rm -rf root/etc/rc.d/init.d/supervise |
822 |
|
rm -rf root/var/log |
823 |
|
# move mysql.init |
824 |
|
%patch8 -p1 |
825 |
|
rm -rf root/etc/rc.d/rc7.d |
826 |
|
%patch9 -p1 |
827 |
|
%patch10 -p1 |
828 |
|
%patch11 -p1 |
829 |
|
|
830 |
%build |
%build |
831 |
perl createlinks |
perl createlinks |
834 |
rm -rf $RPM_BUILD_ROOT |
rm -rf $RPM_BUILD_ROOT |
835 |
(cd root ; find . -depth -print | cpio -dump $RPM_BUILD_ROOT) |
(cd root ; find . -depth -print | cpio -dump $RPM_BUILD_ROOT) |
836 |
/sbin/e-smith/genfilelist $RPM_BUILD_ROOT \ |
/sbin/e-smith/genfilelist $RPM_BUILD_ROOT \ |
837 |
--dir /var/run/mysqld 'attr(0755,mysql,mysql)' \ |
--file /sbin/e-smith/systemd/mariadb-initialize 'attr(0554,root,root)' \ |
838 |
--file /var/service/mysqld/run 'attr(0755,root,root)' \ |
--dir '/var/log/mariadb.run' 'attr(2750,smelog,smelog)' \ |
|
--file /var/service/mysqld/control/t 'attr(0750,root,root)' \ |
|
|
--file /var/service/mysqld/control/d 'attr(0750,root,root)' \ |
|
|
--file /var/service/mysqld/control/i 'attr(0750,root,root)' \ |
|
|
--file /var/service/mysqld/control/q 'attr(0750,root,root)' \ |
|
|
--file /var/service/mysqld/log/run 'attr(0755,root,root)' \ |
|
|
--dir '/var/log/mysqld' 'attr(2750,smelog,smelog)' \ |
|
839 |
--dir '/home/e-smith/db/mysql' 'attr(0750,root,root)' \ |
--dir '/home/e-smith/db/mysql' 'attr(0750,root,root)' \ |
840 |
> %{name}-%{version}-filelist |
> %{name}-%{version}-filelist |
841 |
echo "%doc COPYING" >> %{name}-%{version}-filelist |
echo "%doc COPYING" >> %{name}-%{version}-filelist |
843 |
%clean |
%clean |
844 |
rm -rf $RPM_BUILD_ROOT |
rm -rf $RPM_BUILD_ROOT |
845 |
|
|
846 |
%post |
%pre |
847 |
# mysql.com compatibility |
if [ $1 -gt 1 ] ; then |
848 |
[ -e /etc/rc.d/init.d/mysqld ] || ln -s ./mysql /etc/rc.d/init.d/mysqld |
if [ -e /var/service/mariadb/run ] ; then |
849 |
# We remove this because the template has been renamed |
/usr/bin/sv d mariadb |
850 |
/bin/rm -f /etc/e-smith/events/bootstrap-console-save/templates2expand/etc/e-smith/sql/init/10fix_privilege_tables |
/usr/bin/sv d mariadb/log |
851 |
|
fi |
852 |
|
fi |
853 |
|
|
854 |
|
%post |
855 |
|
|
856 |
%postun |
%postun |
|
if [ "$1" == 0 ]; then |
|
|
[ -L /etc/rc.d/init.d/mysqld ] && rm /etc/rc.d/init.d/mysqld || : |
|
|
fi |
|
857 |
|
|
858 |
%files -f %{name}-%{version}-filelist |
%files -f %{name}-%{version}-filelist |
859 |
%defattr(-,root,root) |
%defattr(-,root,root) |