2 # Regular cron jobs for the gforge-db-postgresql package
5 INCLUDE_PATH=/etc/gforge:/usr/share/gforge/:/usr/share/gforge/www:/usr/share/gforge/common
7 # Daily reporting process
8 25 7 * * * gforge [ -x /usr/lib/gforge/bin/reporting_cron.php ] && /usr/lib/gforge/bin/reporting_cron.php -d include_path=$INCLUDE_PATH > /dev/null 2>&1
10 # Recalculate user popularity metric
11 25 1 * * * gforge [ -x /usr/lib/gforge/bin/calculate_user_metric.php ] && /usr/lib/gforge/bin/calculate_user_metric.php -d include_path=$INCLUDE_PATH > /dev/null 2>&1
13 # Daily recalculate of the sums under the trove map
14 30 1 * * * gforge [ -x /usr/lib/gforge/bin/db_trove_maint.php ] && /usr/lib/gforge/bin/db_trove_maint.php -d include_path=$INCLUDE_PATH > /dev/null 2>&1
16 # Daily deletion of sessions, closing jobs, etc
17 35 1 * * * gforge [ -x /usr/lib/gforge/bin/project_cleanup.php ] && /usr/lib/gforge/bin/project_cleanup.php -d include_path=$INCLUDE_PATH > /dev/null 2>&1
19 # Daily crunching of survey data and other associated ratings
20 40 1 * * * gforge [ -x /usr/lib/gforge/bin/rating_stats.php ] && /usr/lib/gforge/bin/rating_stats.php -d include_path=$INCLUDE_PATH > /dev/null 2>&1
22 # Daily crunching of project summary data (counts)
23 42 1 * * * gforge [ -x /usr/lib/gforge/bin/db_project_sums.php ] && /usr/lib/gforge/bin/db_project_sums.php -d include_path=$INCLUDE_PATH > /dev/null 2>&1
25 # Daily close pending artifacts
26 43 1 * * * gforge [ -x /usr/lib/gforge/bin/check_stale_tracker_items.php ] && /usr/lib/gforge/bin/check_stale_tracker_items.php -d include_path=$INCLUDE_PATH > /dev/null 2>&1
28 # Weekly project metrics
29 50 1 * * Mon gforge [ -x /usr/lib/gforge/bin/project_weekly_metric.php ] && /usr/lib/gforge/bin/project_weekly_metric.php -d include_path=$INCLUDE_PATH > /dev/null 2>&1
31 # Daily rotation of the activity_log
32 0 0 * * * gforge [ -x /usr/lib/gforge/bin/rotate_activity.php ] && /usr/lib/gforge/bin/rotate_activity.php -d include_path=$INCLUDE_PATH > /dev/null 2>&1
34 # Daily aggregating of the numbers
35 15 0 * * * gforge [ -x /usr/lib/gforge/bin/site_stats.php ] && /usr/lib/gforge/bin/site_stats.php -d include_path=$INCLUDE_PATH > /dev/null 2>&1
37 # Daily sweep of the stats into final tables
38 45 0 * * * gforge [ -x /usr/lib/gforge/bin/db_stats_agg.php ] && /usr/lib/gforge/bin/db_stats_agg.php -d include_path=$INCLUDE_PATH > /dev/null 2>&1
40 # Hourly sending of mass e-mailings
41 48 * * * * root [ -x /usr/lib/gforge/bin/massmail.php ] && /usr/lib/gforge/bin/massmail.php -d include_path=$INCLUDE_PATH > /dev/null 2>&1
44 50 2 * * Mon gforge [ -x /usr/lib/gforge/bin/vacuum.php ] && /usr/lib/gforge/bin/vacuum.php -d include_path=$INCLUDE_PATH > /dev/null 2>&1
46 # Daily sweep of the HTTP log files for project activity
47 15 0 * * * gforge [ -x /usr/lib/gforge/bin/stats_projects_logparse.pl ] && /usr/lib/gforge/bin/stats_projects_logparse.pl > /dev/null 2>&1
49 # Daily mail for not approved news
50 30 17 * * * root [ -x /usr/lib/gforge/bin/get_news_notapproved.pl ] && /usr/lib/gforge/bin/get_news_notapproved.pl > /dev/null 2>&1
52 # Daily incremental backup to /backup
53 # we have to discuss this
54 #15 23 * * * root [ -x /usr/lib/gforge/bin/gforge-db-backup.sh ] && /usr/lib/gforge/bin/gforge-db-backup.sh > /dev/null 2>&1