/[smecontribs]/rpms/smeserver-automysqlbackup/contribs10/smeserver-automysqlbackup.spec
ViewVC logotype

Annotation of /rpms/smeserver-automysqlbackup/contribs10/smeserver-automysqlbackup.spec

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph


Revision 1.2 - (hide annotations) (download)
Sat Apr 17 02:56:42 2021 UTC (3 years, 6 months ago) by jpp
Branch: MAIN
CVS Tags: smeserver-automysqlbackup-3_0_RC6-17_el7_sme
Changes since 1.1: +6 -1 lines
* Fri Apr 16 2021 Jean-Philippe Pialasse <tests@pialasse.com> 3.0.RC6-17.sme
- fix automysql freeze server on reboot after post-upgrade event [SME: 11561]

1 brianr 1.1 %define name smeserver-automysqlbackup
2     %define version 3.0.RC6
3 jpp 1.2 %define release 17
4 brianr 1.1 %define rpmver 3.0.RC6
5    
6     epoch: 2
7     Summary: automysqlbackup is a script to backup your msql database on sme8
8     Name: %{name}
9     Version: %{version}
10     Release: %{release}%{?dist}
11     License: GPL
12     Group: /Web/Application
13     Source: %{name}-%{version}.tar.gz
14     URL: http://sourceforge.net/projects/automysqlbackup/
15     BuildRoot: /var/tmp/%{name}-%{version}-%{release}-buildroot
16     BuildArchitectures: noarch
17     Requires: e-smith-base, e-smith-release >= 9
18     Requires: pax
19     Requires: automysqlbackup
20     BuildRequires: e-smith-devtools
21     Patch0: smeserver-automysqlbackup-AdjustableCronJob.patch
22     Patch1: smeserver-automysqlbackup-enhanced-templates.patch
23     Patch2: smeserver-automysqlbackup-fix-runmysql.patch
24     Patch3: smeserver-automysqlbackup-update-permission-change.patch
25     Patch4: smeserver-automysqlbackup-3.0.RC6-bz10806.errorsAndCreateUsers.patch
26     Patch5: smeserver-automysqlbackup-3.0.RC6-Update-MySQL-Init-for-Mariadb.patch
27 jpp 1.2 Patch6: smeserver-automysqlbackup-3.0.RC6-bz11561.patch
28 brianr 1.1
29     %description
30     This RPM is an unofficial addon for the SME Server 9.x.
31     The target audience is the Linux/E-smith administrator
32     who wants to backup their mysql databases with an automatic way.
33     This script is based on automysqlbackup V3.0
34    
35    
36    
37     %changelog
38 jpp 1.2 * Fri Apr 16 2021 Jean-Philippe Pialasse <tests@pialasse.com> 3.0.RC6-17.sme
39     - fix automysql freeze server on reboot after post-upgrade event [SME: 11561]
40    
41 brianr 1.1 * Mon Oct 19 2020 Brian Read <brianr@bjsystems.co.uk> 3.0-RC6-16.sme
42     - Initial Import to SME10 tree [SME: 11042]
43     - Update-MySQL-Init-for-Mariadb
44    
45     * Sun Sep 22 2019 Jean-Philipe Pialasse <tests@pialasse.com> 3.0.RC6-15.sme
46     - fix multiple cause of error noise and performance [SME: 10806]
47     * avoid parallel run of all backups, cron template rewritten
48     * avoid multiple parallel or repeated chmod and chown
49     * protect from undesired chmod or chown
50     * consistent use of status for cron and conf templates
51     * create backup user for mysql, mysql55 and mysql57 (Maria to do)
52     * update mysql53 use to mysql51 as variable
53     * migrate fragment to remove Mysql55 Mysql57 Mymaria Mysql53 if Mysql53 exist
54     * remove default value in db for Mysql55 Mysql57 Mymaria Mysql53
55     * default as enabled in fragments for all automysql My* properties
56     - create default user in dbs [SME: 10808]
57     - tidy spec file
58    
59     * Mon Nov 26 2018 John Crisp <jcrisp@safeandsoundit.co.uk> 3.0.RC6-11.sme
60     - fix runmysqlscript to allow for change in Backupdir key [SME: 10655]
61    
62     * Mon Nov 26 2018 John Crisp <jcrisp@safeandsoundit.co.uk> 3.0.RC6-10.sme
63     - fix runmysqlbackup to allow for new databases [SME: 10654]
64    
65     * Fri Jul 06 2018 John Crisp <jcrisp@safeandsoundit.co.uk> 3.0.RC6-9.sme
66     - Template configuration files
67     - run automysqlbackup per conf directly from cron rather than runmysqlbackup
68     - Add extra DB keys for mysql53, mysql55, mysql57
69    
70     * Sun Apr 02 2017 stephane de Labrusse <stephdl@de-labrusse.fr> 3.0.RC6-8.sme
71     - Added smeserver-automysqlbackup-AdjustableCronJob.patch
72     - The time to run the Job is adjustable
73    
74     * Wed Sep 16 2015 stephane de Labrusse <stephdl@de-labrusse.fr> 3.0.RC6-6.sme
75     - Added 'epoch: 2'
76    
77     * Sat Aug 22 2015 stephane de Labrusse <stephdl@de-labrusse.fr> 3.0.RC6-5.sme
78     - Initial release to contribs9
79    
80     * Sun Aug 17 2014 Stephane de Labrusse <stephdl@de-labrusse.fr> 3.0.RC6-4
81     - added my own patch against the --events warning
82     --Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
83    
84     * Sun Oct 27 2013 Stephane de Labrusse <stephdl@de-labrusse.fr> 3.0.RC6.3
85     - split the contrib in two versions smeserver-automysqlbackup and automysqlbackup
86     * Mon Apr 22 2013 Stephane de Labrusse <stephdl@de-labrusse.fr>
87     - [3.0.RC6] version Based on automysqlbackup V3.0 RC6
88     * Mon Apr 08 2013 Stephane de Labrusse <stephdl@de-labrusse.fr>
89     - [0.01] Initial version Based on automysqlbackup V3.0 RC6
90    
91     %prep
92     rm -rf $RPM_BUILD_ROOT
93    
94     %setup
95     %patch0 -p1
96     %patch1 -p1
97     %patch2 -p1
98     %patch3 -p1
99     %patch4 -p1
100     %patch5 -p1
101 jpp 1.2 %patch6 -p1
102 brianr 1.1
103     %build
104     perl createlinks
105     find . \( -name .gitinclude -o -name .gitignore \) -print0 | \
106     xargs -0 rm -f
107    
108     %install
109     /bin/rm -rf $RPM_BUILD_ROOT
110     (cd root ;/usr/bin/find . -depth -print | /bin/cpio -dump $RPM_BUILD_ROOT)
111     /bin/rm -f %{name}-%{version}-filelist
112     /sbin/e-smith/genfilelist $RPM_BUILD_ROOT \
113     --file /sbin/e-smith/runmysqlbackup 'attr(0750,root,root)' \
114     --dir /root/backup 'attr(0700,root,root)' \
115     --dir /root/backup/db 'attr(0700,root,root)' \
116     --dir /root/backup/db/daily 'attr(0700,root,root)' \
117     --dir /root/backup/db/fullschema 'attr(0700,root,root)' \
118     --dir /root/backup/db/latest 'attr(0700,root,root)' \
119     --dir /root/backup/db/monthly 'attr(0700,root,root)' \
120     --dir /root/backup/db/status 'attr(0700,root,root)' \
121     --dir /root/backup/db/tmp 'attr(0700,root,root)' \
122     --dir /root/backup/db/weekly 'attr(0700,root,root)' \
123     > %{name}-%{version}-filelist
124    
125    
126     %files -f %{name}-%{version}-filelist
127    
128     %defattr(-,root,root)
129    
130     %clean
131     rm -rf $RPM_BUILD_ROOT
132    
133     %pre
134    
135     %post
136    
137     #protect the backup folder
138     chmod -R 700 /root/backup
139    
140     %preun
141     %postun
142     if [ $1 = 0 ] ; then
143     SMEDB=automysqlbackup
144     MYSQLUSER=backupuser
145     echo "======================================================================="
146     echo " "
147     echo " delete mysql user and revoke all permissions"
148     # This section deletes backupuser
149     mysql -u root -e "REVOKE ALL PRIVILEGES ON *.* FROM '$MYSQLUSER'@'localhost';"
150     mysql -u root -e "DROP USER $MYSQLUSER@localhost;"
151     echo " "
152     echo "Do that for each DB - e.g mysq55, mysql57 etc"
153     echo " "
154     # Delete custom template fragment
155     echo " delete db configuration automysqlbackup"
156     echo " "
157     echo "======================================================================="
158    
159     /sbin/e-smith/config delete $SMEDB
160     fi

admin@koozali.org
ViewVC Help
Powered by ViewVC 1.2.1 RSS 2.0 feed