CiviCRM Community Forums (archive)

I'm trying to set up cron jobs for Mailings Scheduler (process_mailings) and Bounces Fetcher (fetch_bounces) I am following the CLI instructions at:

http://wiki.civicrm.org/confluence/display/CRMDOC42/CiviMail+Installation [nofollow]

I'm running CiviCRM 4.1 with Drupal 6.26

My settings file is:

/sites/default/civicrm.settings.php

CiviCRM installation:

/sites/all/modules/civicrm

The first error I encountered was the following:

Could not find valid configuration dir, best guess:  /path/to/website/root/sites/all/modules/civicrm/../../..<br/><br/>
If this is a standalone installation (i.e. not a Drupal or Joomla module) and you'd like to re-initialize it, <a href="../install/index.php?mode=standalone">click here</a>

I thought that I could solve this using the settings_location.php file method however now I'm getting the following error:

Error: Could not create directory: /path/to/website/root/sites/default/files/civicrm/templates_c/en_US/.<p>If you have moved an existing CiviCRM installation from one location or server to another there are several steps you will need to follow. They are detailed on this CiviCRM wiki page - <a href="http://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location [nofollow]"  target="_blank" title="Opens documentation in a new window.">Moving an Existing Installation to a New Server or Location</a>. A fix for the specific problem that caused this error message to be displayed is to set the value of the config_backend column in the civicrm_domain table to NULL. However we strongly recommend that you review and follow all the steps in that document.</p>

Is this simply a permissions issue? I can not change the permission on my template_c directory because the server requires the ability to write to it.

Cron is running as root.

Do I need to change the permission of a script runs when the cron job executes?

Hi,

I get the same error when running, as root, from the command line and the error report from cron.

The crontab is edited while as root thus I assume that it runs as root unless I'm mistaken.

Running as root from the command line:

The permissions on files/civicrm are 777 recursively.

path: /sites/all/modules/civicrm
command: php bin/cli.php -j -u username -p password -e Job -a process_mailing

The above username and password being a user in my Drupal system with 'view all contacts', 'access CiviCRM' and 'access CiviMail' permission.

Output:

Error: Could not create directory: /path/to/webroot/sites/default/files/civicrm/templates_c/en_US/.<p>If you have moved an existing CiviCRM installation from one location or server to another there are several steps you will need to follow. They are detailed on this CiviCRM wiki page - <a href="http://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location"  target="_blank" title="Opens documentation in a new window.">Moving an Existing Installation to a New Server or Location</a>. A fix for the specific problem that caused this error message to be displayed is to set the value of the config_backend column in the civicrm_domain table to NULL. However we strongly recommend that you review and follow all the steps in that document.</p>

I assume that when running the above command as root that the cli has root permission.

Is there something wrong about what I'm doing?

Thanks again.

Hi Xavier thank you for the idea. However based on what I understood from your reply this is the result.

First, yes this is the proper path:
/path/to/webroot/sites/default/files/civicrm/templates_c/en_US/

I looked in /etc/cron.d/ and should I see a file with the username I'm trying to run cron as i.e. root? Anyway I don't.

Based on what I understood your recommendation was, I edited my crontab and it looks like this:

CIVI_ROOT=/path/to/webroot/sites/all/modules/civicrm/
PHP=nice -n19 /usr/bin/php
PARAMS= -j -s example.com -u username -p password -e Job -a process_mailing
*/5 * * * * apache cd $CIVI_ROOT; $PHP bin/cli.php $PARAMS

My new error is this:

/bin/sh: apache: command not found
Could not open input file: bin/cli.php

It appears to me that it thinks that what I want to use as the USERNAME (apache) is the command.

This is how I understand I should add the USERNAME to the job. Am I making a mistake?

su root

crontab -e