/[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.8 by jpp, Tue Nov 26 03:40:46 2019 UTC Revision 1.10 by jpp, Tue Nov 26 17:38:54 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 12  %define release 13
4  %define rpmver   3.0.RC6  %define rpmver   3.0.RC6
5    
6  epoch: 2  epoch: 2
# Line 33  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-12.sme  * 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]  - fix multiple cause of error noise and performance [SME: 10806]
38    * avoid parallel run of all backups, cron template rewritten    * avoid parallel run of all backups, cron template rewritten
39    * avoid multiple parallel or repeated chmod and chown    * avoid multiple parallel or repeated chmod and chown
# Line 90  rm -rf $RPM_BUILD_ROOT Line 90  rm -rf $RPM_BUILD_ROOT
90    
91  %build  %build
92  perl createlinks  perl createlinks
93    find . \( -name .gitinclude -o -name .gitignore \) -print0 | \
94                                                                    xargs -0 rm -f
95    
96  %install  %install
97  /bin/rm -rf $RPM_BUILD_ROOT  /bin/rm -rf $RPM_BUILD_ROOT
# Line 97  perl createlinks Line 99  perl createlinks
99  /bin/rm -f %{name}-%{version}-filelist  /bin/rm -f %{name}-%{version}-filelist
100  /sbin/e-smith/genfilelist $RPM_BUILD_ROOT \  /sbin/e-smith/genfilelist $RPM_BUILD_ROOT \
101  --file /sbin/e-smith/runmysqlbackup 'attr(0750,root,root)' \  --file /sbin/e-smith/runmysqlbackup 'attr(0750,root,root)' \
102    --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  > %{name}-%{version}-filelist  > %{name}-%{version}-filelist
112    
113    
# Line 110  rm -rf $RPM_BUILD_ROOT Line 121  rm -rf $RPM_BUILD_ROOT
121  %pre  %pre
122    
123  %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 "***********************************************************************"  
124    
125  #protect the backup folder  #protect the backup folder
126  chmod -R 700 /root/backup/db  chmod -R 700 /root/backup
127                                                            
128  %preun  %preun
129  %postun  %postun

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