diff options
Diffstat (limited to 'misc/cron/archive.sh')
-rw-r--r-- | misc/cron/archive.sh | 65 |
1 files changed, 49 insertions, 16 deletions
diff --git a/misc/cron/archive.sh b/misc/cron/archive.sh index 704068864d..9b60016fc7 100644 --- a/misc/cron/archive.sh +++ b/misc/cron/archive.sh @@ -1,7 +1,9 @@ #!/bin/bash -e # Description -# This script automatically fetches the Super User token_auth +# This cron script will automatically run Piwik archiving every hour. + +# It automatically fetches the Super User token_auth # and triggers the archiving for all websites for all periods. # This ensures that all reports are pre-computed and Piwik renders very fast. @@ -10,25 +12,39 @@ # How to setup the crontab job? # Add the following lines in your crontab file, eg. /etc/cron.d/piwik-archive +#---------------START CRON TAB-- #MAILTO="youremail@example.com" -#5 0 * * * www-data /path/to/piwik/misc/cron/archive.sh > /dev/null - -# Other optimization for high traffic websites -# You may want to override the following settings in config/config.ini.php (see documentation in config/config.ini.php) +#5 * * * * www-data /path/to/piwik/misc/cron/archive.sh > /dev/null +#-----------------END CRON TAB-- +# When an error occurs (eg. php memory error, timeout) the error messages +# will be sent to youremail@example.com. +# +# Optimization for high traffic websites +# You may want to override the following settings in config/config.ini.php: +# See documentation of the fields in your piwik/config/config.ini.php +# # [General] # time_before_archive_considered_outdated = 3600 # enable_browser_archiving_triggering = false +# +#=========================================================================== -PHP_BIN=`which php5 2>/dev/null` +for TEST_PHP_BIN in php5 php php-cli php-cgi; do + if which $TEST_PHP_BIN >/dev/null 2>/dev/null; then + PHP_BIN=`which $TEST_PHP_BIN` + break + fi +done if test -z $PHP_BIN; then - PHP_BIN=`which php` + echo "php binary not found. Make sure php5 or php exists in PATH." + exit 1 fi act_path() { - local pathname="$1" - readlink -f "$pathname" 2>/dev/null || \ - realpath "$pathname" 2>/dev/null || \ - type -P "$pathname" 2>/dev/null + local pathname="$1" + readlink -f "$pathname" 2>/dev/null || \ + realpath "$pathname" 2>/dev/null || \ + type -P "$pathname" 2>/dev/null } ARCHIVE=`act_path ${0}` @@ -39,11 +55,28 @@ PIWIK_CONFIG="$PIWIK_CRON_FOLDER"/../../config/config.ini.php PIWIK_SUPERUSER=`sed '/^\[superuser\]/,$!d;/^login[ \t]*=[ \t]*"*/!d;s///;s/"*[ \t]*$//;q' $PIWIK_CONFIG` PIWIK_SUPERUSER_MD5_PASSWORD=`sed '/^\[superuser\]/,$!d;/^password[ \t]*=[ \t]*"*/!d;s///;s/"*[ \t]*$//;q' $PIWIK_CONFIG` -CMD_TOKEN_AUTH="$PHP_BIN $PIWIK_PATH -- module=API&method=UsersManager.getTokenAuth&userLogin=$PIWIK_SUPERUSER&md5Password=$PIWIK_SUPERUSER_MD5_PASSWORD&format=php&serialize=0" +CMD_TOKEN_AUTH="$PHP_BIN -q $PIWIK_PATH -- module=API&method=UsersManager.getTokenAuth&userLogin=$PIWIK_SUPERUSER&md5Password=$PIWIK_SUPERUSER_MD5_PASSWORD&format=php&serialize=0" TOKEN_AUTH=`$CMD_TOKEN_AUTH` -for period in day week year; do - CMD="$PHP_BIN $PIWIK_PATH -- module=API&method=VisitsSummary.getVisits&idSite=all&period=$period&date=last52&format=xml&token_auth=$TOKEN_AUTH"; - $CMD - echo "" +CMD_GET_ID_SITES="$PHP_BIN -q $PIWIK_PATH -- module=API&method=SitesManager.getAllSitesId&token_auth=$TOKEN_AUTH&format=csv&convertToUnicode=0" +ID_SITES=`$CMD_GET_ID_SITES` +echo "Starting Piwik archiving..." +echo "" +for idsite in $ID_SITES; do + TEST_IS_NUMERIC=`echo $idsite | egrep '^[0-9]+$'` + if [ "$TEST_IS_NUMERIC" ] + then + for period in day week year; do + echo "" + echo "Archiving period = $period for idsite = $idsite..." + CMD="$PHP_BIN -q $PIWIK_PATH -- module=API&method=VisitsSummary.getVisits&idSite=$idsite&period=$period&date=last52&format=xml&token_auth=$TOKEN_AUTH"; + $CMD + done + + echo "" + echo "Archiving for idsite = $idsite done!" + fi done + +echo "Piwik archiving finished." + |