/** * Parse crontab line into Job object * * @param $jobLine * * @return Job * @throws \InvalidArgumentException */ static function parse($jobLine) { // split the line $parts = preg_split('@ @', $jobLine, NULL, PREG_SPLIT_NO_EMPTY); // check the number of part if (count($parts) < 5) { throw new \InvalidArgumentException('Wrong job number of arguments.'); } // analyse command $command = implode(' ', array_slice($parts, 5)); // prepare variables $lastRunTime = $logFile = $logSize = $errorFile = $errorSize = $comments = null; // extract comment if (strpos($command, '#')) { list($command, $comment) = explode('#', $command); $comments = trim($comment); } // extract error file if (strpos($command, '2>>')) { list($command, $errorFile) = explode('2>>', $command); $errorFile = trim($errorFile); } // extract log file if (strpos($command, '>>')) { list($command, $logPart) = explode('>>', $command); $logPart = explode(' ', trim($logPart)); $logFile = trim($logPart[0]); } // compute last run time, and file size if (isset($logFile) && file_exists($logFile)) { $lastRunTime = filemtime($logFile); $logSize = filesize($logFile); } if (isset($errorFile) && file_exists($errorFile)) { $lastRunTime = max($lastRunTime ?: 0, filemtime($errorFile)); $errorSize = filesize($errorFile); } $command = trim($command); // compute status $status = 'error'; if ($logSize === null && $errorSize === null) { $status = 'unknown'; } else { if ($errorSize === null || $errorSize == 0) { $status = 'success'; } } // set the Job object $job = new Job(); $job->setMinute($parts[0])->setHour($parts[1])->setDayOfMonth($parts[2])->setMonth($parts[3])->setDayOfWeek($parts[4])->setCommand($command)->setErrorFile($errorFile)->setErrorSize($errorSize)->setLogFile($logFile)->setLogSize($logSize)->setComments($comments)->setLastRunTime($lastRunTime)->setStatus($status); return $job; }
require_once $newscoopDir . 'vendor/yzalis/crontab/src/Crontab/CrontabFileHandler.php'; require_once $newscoopDir . 'vendor/symfony/symfony/src/Symfony/Component/Process/Process.php'; require_once $newscoopDir . 'vendor/symfony/symfony/src/Symfony/Component/Process/ProcessPipes.php'; use Crontab\Crontab; use Crontab\Job; $crontab = new Crontab(); $newscoopRealPath = realpath($newscoopDir); $newscoopJobs = array($newscoopRealPath . '/application/console user:garbage', $newscoopRealPath . '/bin/newscoop-autopublish', $newscoopRealPath . '/bin/newscoop-indexer', $newscoopRealPath . '/bin/subscription-notifier', $newscoopRealPath . '/bin/events-notifier', $newscoopRealPath . '/bin/newscoop-statistics', $newscoopRealPath . '/bin/newscoop-stats', $newscoopRealPath . '/scripts/newscoop.php', $newscoopRealPath . '/application/console log:maintenance'); $connection = mysqli_connect($Campsite['db']['host'], $Campsite['db']['user'], $Campsite['db']['pass'], $Campsite['db']['name']); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } foreach ($crontab->getJobs() as $key => $job) { foreach ($newscoopJobs as $key => $value) { if (strpos($job->getCommand(), $value) !== false) { $crontab->removeJob($job); } } } $job = new Job(); $job->setMinute('*')->setHour('*')->setDayOfMonth('*')->setMonth('*')->setDayOfWeek('*')->setCommand('php ' . $newscoopRealPath . '/application/console scheduler:run'); $crontab->addJob($job); mysqli_query($connection, "INSERT INTO `cron_jobs`(`name`, `command`, `schedule`, `is_active`, `created_at`, `sendMail`) VALUES ('Remove obsolete pending users data','" . $newscoopRealPath . "/application/console user:garbage','30 0 * * *', 1, NOW(), 0)"); mysqli_query($connection, "INSERT INTO `cron_jobs`(`name`, `command`, `schedule`, `is_active`, `created_at`, `sendMail`) VALUES ('Autopublish pending issues and articles','" . $newscoopRealPath . "/bin/newscoop-autopublish','* * * * *', 1, NOW(), 0)"); mysqli_query($connection, "INSERT INTO `cron_jobs`(`name`, `command`, `schedule`, `is_active`, `created_at`, `sendMail`) VALUES ('Runs Newscoop Indexer - articles indexing','" . $newscoopRealPath . "/bin/newscoop-indexer','0 */4 * * *', 1, NOW(), 0)"); mysqli_query($connection, "INSERT INTO `cron_jobs`(`name`, `command`, `schedule`, `is_active`, `created_at`, `sendMail`) VALUES ('Send Newscoop subscriptions notifications','" . $newscoopRealPath . "/bin/subscription-notifier','0 */8 * * *', 1, NOW(), 0)"); mysqli_query($connection, "INSERT INTO `cron_jobs`(`name`, `command`, `schedule`, `is_active`, `created_at`, `sendMail`) VALUES ('Send Newscoop events notifications','" . $newscoopRealPath . "/bin/events-notifier','*/2 * * * *', 1, NOW(), 0)"); mysqli_query($connection, "INSERT INTO `cron_jobs`(`name`, `command`, `schedule`, `is_active`, `created_at`, `sendMail`) VALUES ('Remove old statistics from Newscoop database','" . $newscoopRealPath . "/bin/newscoop-statistics','0 */4 * * *', 1, NOW(), 0)"); mysqli_query($connection, "INSERT INTO `cron_jobs`(`name`, `command`, `schedule`, `is_active`, `created_at`, `sendMail`) VALUES ('Send Newscoop stats to Sourcefabric','" . $newscoopRealPath . "/bin/newscoop-stats','0 5 * * *', 1, NOW(), 0)"); mysqli_query($connection, "INSERT INTO `cron_jobs`(`name`, `command`, `schedule`, `is_active`, `created_at`, `sendMail`, `detailsUrl`) VALUES ('Display the last 7 days logged actions when going to Configure -> Logs. All the rest are stored in newscoop-audit.log.','" . $newscoopRealPath . "/application/console log:maintenance','30 1 * * *', 0, NOW(), 0, 'http://sourcefabric.booktype.pro/newscoop-42-for-journalists-and-editors/log-file-maintenance/')"); $crontab->write();
/** * Save newscoop cronjobs in user cronjob file * * @param SchedulerService $scheduler Cron job scheduler service * @return bolean */ public function saveCronjobs(SchedulerServiceInterface $scheduler) { $binDirectory = realpath($this->newscoopDir . '/bin'); $appDirectory = realpath($this->newscoopDir . '/application/console'); $scheduler->registerJob("Autopublish pending issues and articles", array('command' => $binDirectory . '/newscoop-autopublish', 'schedule' => '* * * * *')); $scheduler->registerJob("Runs Newscoop Indexer - articles indexing", array('command' => $binDirectory . '/newscoop-indexer --silent', 'schedule' => '0 */4 * * *')); $scheduler->registerJob("Send Newscoop subscriptions notifications", array('command' => $binDirectory . '/subscription-notifier', 'schedule' => '0 */8 * * *')); $scheduler->registerJob("Send Newscoop events notifications", array('command' => $binDirectory . '/events-notifier', 'schedule' => '*/2 * * * *')); $scheduler->registerJob("Remove old statistics from Newscoop database", array('command' => $binDirectory . '/newscoop-statistics', 'schedule' => '0 */4 * * *')); $scheduler->registerJob("Send Newscoop stats to Sourcefabric", array('command' => $binDirectory . '/newscoop-stats', 'schedule' => '0 5 * * *')); $scheduler->registerJob("Remove obsolete pending users data", array('command' => $appDirectory . ' user:garbage', 'schedule' => '30 0 * * *')); $scheduler->registerJob("Display the last 7 days logged actions when going to Configure -> Logs. All the rest are stored in newscoop-audit.log.", array('command' => $appDirectory . ' log:maintenance', 'schedule' => '30 1 * * *', 'enabled' => false, 'detailsUrl' => 'http://sourcefabric.booktype.pro/newscoop-42-for-journalists-and-editors/log-file-maintenance/')); $crontab = new Crontab(); $job = new Job(); $job->setMinute('*')->setHour('*')->setDayOfMonth('*')->setMonth('*')->setDayOfWeek('*')->setCommand('php ' . $appDirectory . ' scheduler:run'); $crontab->addJob($job); $crontab->write(); return true; }