--- rpms/smeserver-automysqlbackup/contribs9/smeserver-automysqlbackup.spec 2014/06/17 19:01:17 1.1 +++ rpms/smeserver-automysqlbackup/contribs9/smeserver-automysqlbackup.spec 2017/04/02 16:57:21 1.4 @@ -1,9 +1,9 @@ %define name smeserver-automysqlbackup -%define version 3.0.RC7 -%define release 1 +%define version 3.0.RC6 +%define release 8 %define rpmver 3.0.RC6 - +epoch: 2 Summary: automysqlbackup is a script to backup your msql database on sme8 Name: %{name} Version: %{version} @@ -14,13 +14,13 @@ Source: %{name}-%{version}.t URL: http://sourceforge.net/projects/automysqlbackup/ BuildRoot: /var/tmp/%{name}-%{version}-%{release}-buildroot BuildArchitectures: noarch -Requires: e-smith-base, e-smith-release >= 8 +Requires: e-smith-base, e-smith-release >= 9 Requires: pax Requires: automysqlbackup BuildRequires: e-smith-devtools - +Patch0: smeserver-automysqlbackup-AdjustableCronJob.patch %description -This RPM is an unofficial addon for the SME Server 8.x. +This RPM is an unofficial addon for the SME Server 9.x. The target audience is the Linux/E-smith administrator who wants to backup their mysql databases with an automatic way. This script is based on automysqlbackup V3.0 @@ -28,8 +28,19 @@ This script is based on automysqlbackup %changelog -* Mon Jun 16 2014 JP Pialasse 3.0.RC7-1.sme -- initial import to SME9 contribs +* Sun Apr 02 2017 stephane de Labrusse 3.0.RC6-8.sme +- Added smeserver-automysqlbackup-AdjustableCronJob.patch +- The time to run the Job is adjustable + +* Wed Sep 16 2015 stephane de Labrusse 3.0.RC6-6.sme +- Added 'epoch: 2' + +* Sat Aug 22 2015 stephane de Labrusse 3.0.RC6-5.sme +- Initial release to contribs9 + +* Sun Aug 17 2014 Stephane de Labrusse 3.0.RC6-4 +- added my own patch against the --events warning +--Warning: Skipping the data of table mysql.event. Specify the --events option explicitly. * Sun Oct 27 2013 Stephane de Labrusse 3.0.RC6.3 - split the contrib in two versions smeserver-automysqlbackup and automysqlbackup @@ -42,14 +53,18 @@ This script is based on automysqlbackup rm -rf $RPM_BUILD_ROOT %setup +%patch0 -p1 %build +perl createlinks %install /bin/rm -rf $RPM_BUILD_ROOT -(/usr/bin/find . -depth -print | /bin/cpio -dump $RPM_BUILD_ROOT) +(cd root ;/usr/bin/find . -depth -print | /bin/cpio -dump $RPM_BUILD_ROOT) /bin/rm -f %{name}-%{version}-filelist -/sbin/e-smith/genfilelist $RPM_BUILD_ROOT > %{name}-%{version}-filelist +/sbin/e-smith/genfilelist $RPM_BUILD_ROOT \ +--file /sbin/e-smith/runmysqlbackup 'attr(0750,root,root)' \ +> %{name}-%{version}-filelist %files -f %{name}-%{version}-filelist @@ -66,46 +81,11 @@ SMEDB=automysqlbackup MYSQLUSER=backupuser # Expland template /etc/e-smith/events/actions/initialize-default-databases - -echo "=========================================================================================" -echo " Your Databases are saved in /root/backup/db " -echo " only Root can access to these folders" -echo " a mail is send to Admin for all logs " -echo " " -echo " Configuration file is /etc/automysqlbackup/myserver.conf" -echo " " -echo " For a manual play you can use directly" -echo " automysqlbackup /etc/automysqlbackup/myserver.conf " -echo " else backups are done every night at 04H00 AM with /etc/cron.daily/runmysqlbackup" -echo "=========================================================================================" -echo " RESTORING" -echo " In a root terminal" -echo " cd /root/backup/db/ and choose your backup" -echo " gunzip file-name.sql.gz" -echo " Next you will need to use the mysql client to restore the DB from the sql file." -echo " mysql database < /path/file.sql" -echo " NOTE: Make sure you use < and not > in the above command because you are piping the file.sql" -echo " to mysql and not the other way around" -echo "=========================================================================================" -echo " Some db configuration for handle this contrib" -echo " Mailcontent (stdout/log/files/quiet)" -echo " # What would you like to be mailed to you?" -echo " # - log : send only log file (default)" -echo " # - files : send log file and sql files as attachments (see docs)" -echo " #- stdout : will simply output the log to the screen if run manually." -echo " #- quiet : Only send logs if an error occurs to the MAILADDR." -echo " Sizemail=8000 (bytes)" -echo " Mailto=root (or any other user@domaine.com)" -echo " Backupdir=path to the folder where mysql files are saved" -echo " " -echo " ex: config setprop automysqlbackup Mailcontent files" -echo "=========================================================================================" - - +/sbin/e-smith/expand-template /etc/cron.d/runmysqlbackup #create backupuser and give rights MYSQLPASS=$(/sbin/e-smith/config getprop $SMEDB DbPassword) -mysql -e " GRANT SELECT,LOCK TABLES ON *.* TO $MYSQLUSER@'localhost' " +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