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

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

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

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