# mysqlISP/docs $Id: crontab.txt,v 1.3 2004/07/02 17:02:53 ggw Exp $
#
#This is ust a simple setup example.
#Must be checked further.
#

##Sync onboard clock: Keep all ISP servers sync'd
36 3 * * * /usr/sbin/ntpdate tock.usno.navy.mil > /dev/null

#
#GNU/Linux GPL mysqlISP system: Turn this server into 
#open source managed network server appliance: Main server in this cluster is dega.
#Questions: support @ openisp . net
#

#
#mysqlISP
#mysqlISP mysql root passwd must be set in tConfiguration
#
#*/5 * * * * /cgi-bin/mysqlBind.cgi ProcessJobQueue >>~openisp/logs/mysqlISP.log 2>&1
#
#Backup
#30 4 * * * export ISMROOT=~openisp;/cgi-bin/mysqlISP.cgi Backup > /dev/null
#
#Monthly readonly compressed tInvoice and related table data archiving.
#Only on the first of new month with last months name (Ex. Jul 2004) and year as arguments
#Wrap around year tool lastmonth is in mysqlRadacct.tar.gz
#3 3 1 * * /cgi-bin/mysqlISP.cgi ArchiveInvoice `/bin/lastmonth` /var/lib/mysql/mysqlisp >>~openisp/logs/mysqlISP.log 2>&1


#
#mysqlISP mysql root passwd must be set in tConfiguration
#This extra security measure will be done for all mysqlX subsystem soon.
#mysqlApache already does.
#
*/5 * * * * /cgi-bin/mysqlBind.cgi ProcessJobQueue >>~openisp/logs/mysqlISP.log 2>&1
#Backup
30 4 * * * export ISMROOT=~openisp;/cgi-bin/mysqlISP.cgi Backup > /dev/null


#
#mysqlRadius. Independent -not backup- mysqlRadius server for national pops (MegaPop).
#
* * * * * /cgi-bin/mysqlRadius.cgi ProcessExtJobQueue dega >> ~openisp/logs/mysqlRadiusExt.log 2>&1;/bin/sleep 1; ~openisp/cgi-bin/mysqlRadius.cgi ProcessJobQueue dega >> ~openisp/logs/mysqlRadius.log 2>&1
##daily backup local data
20 3 * * * ISMROOT=~openisp;export ISMROOT;/cgi-bin/mysqlRadius.cgi Backup wsxedc > /dev/null

#
#mysqlBind slave named server off of dega .17
#
* * * * * /cgi-bin/mysqlBind.cgi jobqueue slave ns2.isp.net 192.168.0.17 >> ~openisp/logs/mysqlBind.log 2>&1
#Extra backup of dega data only even days
20 3 * * */2 /usr/local/mysql/bin/mysqldump -e -h 192.168.0.17 -u mysqlbind -pwsxedc --all mysqlbind > ~openisp/mysqlBind/data/dumpall.txt

#
#mysqlSendmail slave mx2 (esmtp) sendmail server off of dega
#
* * * * * /cgi-bin/mysqlSendmail.cgi ProcessESMTPJobQueue dega >> ~openisp/logs/mysqlSendmail.log 2>&1
#Extra backup of mercury data only even days, using mysqldump 
20 3 * * */2 /usr/local/mysql/bin/mysqldump -e -h 192.168.0.17 -u mysqlsendmail -pwsxedc --all mysqlsendmail > ~openisp/mysqlSendmail/data/dumpall.txt