/[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.10 - (hide annotations) (download)
Tue Nov 26 17:38:54 2019 UTC (4 years, 6 months ago) by jpp
Branch: MAIN
CVS Tags: smeserver-automysqlbackup-3_0_RC6-13_el6_sme
Changes since 1.9: +12 -1 lines 
* Sun Sep 22 2019 Jean-Philipe Pialasse <tests@pialasse.com> 3.0.RC6-13.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]
1 unnilennium 1.1 %define name smeserver-automysqlbackup
2 stephdl 1.2 %define version 3.0.RC6
3 jpp 1.9 %define release 13
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.9 * Sun Sep 22 2019 Jean-Philipe Pialasse <tests@pialasse.com> 3.0.RC6-13.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    
49 jcrisp 1.7 * Mon Nov 26 2018 John Crisp <jcrisp@safeandsoundit.co.uk> 3.0.RC6-11.sme
50     - fix runmysqlscript to allow for change in Backupdir key [SME: 10655]
51    
52 jcrisp 1.6 * Mon Nov 26 2018 John Crisp <jcrisp@safeandsoundit.co.uk> 3.0.RC6-10.sme
53 jcrisp 1.7 - fix runmysqlbackup to allow for new databases [SME: 10654]
54 jcrisp 1.6
55 jcrisp 1.5 * Fri Jul 06 2018 John Crisp <jcrisp@safeandsoundit.co.uk> 3.0.RC6-9.sme
56     - Template configuration files
57     - run automysqlbackup per conf directly from cron rather than runmysqlbackup
58     - Add extra DB keys for mysql53, mysql55, mysql57
59    
60 stephdl 1.4 * Sun Apr 02 2017 stephane de Labrusse <stephdl@de-labrusse.fr> 3.0.RC6-8.sme
61     - Added smeserver-automysqlbackup-AdjustableCronJob.patch
62     - The time to run the Job is adjustable
63    
64 stephdl 1.3 * Wed Sep 16 2015 stephane de Labrusse <stephdl@de-labrusse.fr> 3.0.RC6-6.sme
65     - Added 'epoch: 2'
66    
67 stephdl 1.2 * Sat Aug 22 2015 stephane de Labrusse <stephdl@de-labrusse.fr> 3.0.RC6-5.sme
68     - Initial release to contribs9
69    
70     * Sun Aug 17 2014 Stephane de Labrusse <stephdl@de-labrusse.fr> 3.0.RC6-4
71     - added my own patch against the --events warning
72     --Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
73 unnilennium 1.1
74     * Sun Oct 27 2013 Stephane de Labrusse <stephdl@de-labrusse.fr> 3.0.RC6.3
75     - split the contrib in two versions smeserver-automysqlbackup and automysqlbackup
76     * Mon Apr 22 2013 Stephane de Labrusse <stephdl@de-labrusse.fr>
77     - [3.0.RC6] version Based on automysqlbackup V3.0 RC6
78     * Mon Apr 08 2013 Stephane de Labrusse <stephdl@de-labrusse.fr>
79     - [0.01] Initial version Based on automysqlbackup V3.0 RC6
80    
81     %prep
82     rm -rf $RPM_BUILD_ROOT
83    
84     %setup
85 stephdl 1.4 %patch0 -p1
86 jcrisp 1.5 %patch1 -p1
87 jcrisp 1.6 %patch2 -p1
88 jcrisp 1.7 %patch3 -p1
89 jpp 1.8 %patch4 -p1
90 unnilennium 1.1
91     %build
92 stephdl 1.4 perl createlinks
93 jpp 1.10 find . \( -name .gitinclude -o -name .gitignore \) -print0 | \
94     xargs -0 rm -f
95 unnilennium 1.1
96     %install
97     /bin/rm -rf $RPM_BUILD_ROOT
98 stephdl 1.2 (cd root ;/usr/bin/find . -depth -print | /bin/cpio -dump $RPM_BUILD_ROOT)
99 unnilennium 1.1 /bin/rm -f %{name}-%{version}-filelist
100 stephdl 1.4 /sbin/e-smith/genfilelist $RPM_BUILD_ROOT \
101     --file /sbin/e-smith/runmysqlbackup 'attr(0750,root,root)' \
102 jpp 1.10 --dir /root/backup 'attr(0700,root,root)' \
103     --dir /root/backup/db 'attr(0700,root,root)' \
104     --dir /root/backup/db/daily 'attr(0700,root,root)' \
105     --dir /root/backup/db/fullschema 'attr(0700,root,root)' \
106     --dir /root/backup/db/latest 'attr(0700,root,root)' \
107     --dir /root/backup/db/monthly 'attr(0700,root,root)' \
108     --dir /root/backup/db/status 'attr(0700,root,root)' \
109     --dir /root/backup/db/tmp 'attr(0700,root,root)' \
110     --dir /root/backup/db/weekly 'attr(0700,root,root)' \
111 stephdl 1.4 > %{name}-%{version}-filelist
112 unnilennium 1.1
113    
114     %files -f %{name}-%{version}-filelist
115    
116     %defattr(-,root,root)
117    
118     %clean
119     rm -rf $RPM_BUILD_ROOT
120    
121     %pre
122    
123     %post
124    
125     #protect the backup folder
126 jpp 1.10 chmod -R 700 /root/backup
127 unnilennium 1.1
128     %preun
129     %postun
130     if [ $1 = 0 ] ; then
131     SMEDB=automysqlbackup
132     MYSQLUSER=backupuser
133     echo "======================================================================="
134 jcrisp 1.5 echo " "
135     echo " delete mysql user and revoke all permissions"
136 unnilennium 1.1 # This section deletes backupuser
137     mysql -u root -e "REVOKE ALL PRIVILEGES ON *.* FROM '$MYSQLUSER'@'localhost';"
138     mysql -u root -e "DROP USER $MYSQLUSER@localhost;"
139     echo " "
140 jcrisp 1.5 echo "Do that for each DB - e.g mysq55, mysql57 etc"
141     echo " "
142 unnilennium 1.1 # Delete custom template fragment
143     echo " delete db configuration automysqlbackup"
144 jcrisp 1.5 echo " "
145 unnilennium 1.1 echo "======================================================================="
146    
147     /sbin/e-smith/config delete $SMEDB
148     fi
admin@koozali.org
 ViewVC Help
Powered by ViewVC 1.2.1 RSS 2.0 feed