--- rpms/smeserver-automysqlbackup/contribs9/smeserver-automysqlbackup.spec	2015/09/16 20:50:45	1.3
+++ rpms/smeserver-automysqlbackup/contribs9/smeserver-automysqlbackup.spec	2017/04/02 16:57:21	1.4
@@ -1,6 +1,6 @@
 %define name smeserver-automysqlbackup
 %define version 3.0.RC6
-%define release 6
+%define release 8
 %define rpmver   3.0.RC6
 
 epoch: 2
@@ -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,6 +28,10 @@ This script is based on automysqlbackup
 
 
 %changelog
+* Sun Apr 02 2017 stephane de Labrusse <stephdl@de-labrusse.fr> 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 <stephdl@de-labrusse.fr> 3.0.RC6-6.sme
 - Added 'epoch: 2'
 
@@ -49,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
 (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
@@ -73,42 +81,7 @@ 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)