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

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

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

Revision 1.6 by jcrisp, Mon Nov 26 13:50:22 2018 UTC Revision 1.9 by jpp, Tue Nov 26 17:18:49 2019 UTC
# Line 1  Line 1 
1  %define name smeserver-automysqlbackup  %define name smeserver-automysqlbackup
2  %define version 3.0.RC6  %define version 3.0.RC6
3  %define release 10  %define release 13
4  %define rpmver   3.0.RC6  %define rpmver   3.0.RC6
5    
6  epoch: 2  epoch: 2
# Line 21  BuildRequires:      e-smith-devtools Line 21  BuildRequires:      e-smith-devtools
21  Patch0: smeserver-automysqlbackup-AdjustableCronJob.patch  Patch0: smeserver-automysqlbackup-AdjustableCronJob.patch
22  Patch1: smeserver-automysqlbackup-enhanced-templates.patch  Patch1: smeserver-automysqlbackup-enhanced-templates.patch
23  Patch2: smeserver-automysqlbackup-fix-runmysql.patch  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    
27  %description  %description
28  This RPM is an unofficial addon for the SME Server 9.x.    This RPM is an unofficial addon for the SME Server 9.x.  
# Line 31  This script is based on automysqlbackup Line 33  This script is based on automysqlbackup
33    
34    
35  %changelog  %changelog
36    * Sun Sep 22 2019 Jean-Philipe Pialasse <tests@pialasse.com> 3.0.RC6-13.sme
37    - 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    * 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  * Mon Nov 26 2018 John Crisp <jcrisp@safeandsoundit.co.uk> 3.0.RC6-10.sme  * Mon Nov 26 2018 John Crisp <jcrisp@safeandsoundit.co.uk> 3.0.RC6-10.sme
53  - fix runmysqlbackup to allow for new databases [SME:10654]  - fix runmysqlbackup to allow for new databases [SME: 10654]
54    
55  * Fri Jul 06 2018 John Crisp <jcrisp@safeandsoundit.co.uk> 3.0.RC6-9.sme  * Fri Jul 06 2018 John Crisp <jcrisp@safeandsoundit.co.uk> 3.0.RC6-9.sme
56  - Template configuration files  - Template configuration files
# Line 67  rm -rf $RPM_BUILD_ROOT Line 85  rm -rf $RPM_BUILD_ROOT
85  %patch0 -p1  %patch0 -p1
86  %patch1 -p1  %patch1 -p1
87  %patch2 -p1  %patch2 -p1
88    %patch3 -p1
89    %patch4 -p1
90    
91  %build  %build
92  perl createlinks  perl createlinks
# Line 90  rm -rf $RPM_BUILD_ROOT Line 110  rm -rf $RPM_BUILD_ROOT
110  %pre  %pre
111    
112  %post  %post
 SMEDB=automysqlbackup  
 MYSQLUSER=backupuser  
 # Expland template  
 /etc/e-smith/events/actions/initialize-default-databases  
 /sbin/e-smith/expand-template /etc/cron.d/runmysqlbackup  
   
 echo "***********************************************************************"  
 echo "  "  
 echo "Creating backup user for default mysql53 database"  
 #create backupuser and give rights  
 MYSQLPASS=$(/sbin/e-smith/config getprop $SMEDB DbPassword)  
 mysql -e " GRANT EVENT,SELECT,LOCK TABLES ON *.* TO $MYSQLUSER@'localhost' "  
 mysql -u root -e "SET PASSWORD FOR $MYSQLUSER@localhost = PASSWORD( '$MYSQLPASS' ) "  
 mysqladmin flush-privileges  
 /etc/rc.d/init.d/mysql.init start  
 echo "done"  
 echo "*** If you add mysql55/mysql57 you must add a backup user ***"  
 echo "You can use the password from config show automysqlbackup"  
 echo "e.g.: "  
 echo "mysql55 -e \" GRANT EVENT,SELECT,LOCK TABLES ON *.* TO $MYSQLUSER@\'localhost\' \" "  
 echo "mysql55 -u root -e \"SET PASSWORD FOR $MYSQLUSER@localhost = PASSWORD( \'$MYSQLPASS\' ) \" "  
 echo "  "  
 echo "***********************************************************************"  
113    
114  #protect the backup folder  #protect the backup folder
115  chmod -R 700 /root/backup/db  chmod -R 700 /root/backup/db

Legend:
Removed lines/characters  
Changed lines/characters
  Added lines/characters
admin@koozali.org
 ViewVC Help
Powered by ViewVC 1.2.1 RSS 2.0 feed