Civimail cronjob not processing messages

[dschafer]

I've seen this issues posted as upgrade related.

However we have 2 installations running 3.2.1. One was an upgrade the other a new install.

In both cases the cron job is setup on the same interval (every 10 mins).

The cron log does not report any errors.
Running the url directly does not generate any errors (just blank page).

But bulk mail jobs never start.

We have a dedicated user account for running the job. It has access CiviCRM adn access CiviMail as its only permissions.

Any ideas

[Donald Lobo]

hey dave:

we introduced bootstrapping Drupal during the cron job (so we can fire hooks etc). If i had to guess, there are certain drupal configs where this fails

unfortunately it does work on our machines/servers, so figuring out why its not working is a wee bit hard

would be great if u can investigate the script and trace it. the lines of code of interest in civimail.cronjob.php is:

Code: [Select]

    // load bootstrap to call hooks                                                                                                                                   
    require_once 'CRM/Utils/System.php';
    CRM_Utils_System::loadBootStrap(  );

lobo

[dschafer]

I'll see what I can find out.

It is definitely due to permissions. I added our mail user to the admin role and bingo, the mail started sending.

[Donald Lobo]

that gives us a big clue

we'll investigate and follow up

lobo

[Donald Lobo]

can you please apply this patch and see if it works for u

https://fisheye2.atlassian.com/rdiff/CiviCRM?csid=29542&u&N

thanx

lobo

[Kiran Jagtap]

Hello dave,

Also it would be great if u apply this patch  https://fisheye2.atlassian.com/browse/CiviCRM/branches/v3.2/CRM/Utils/System/Drupal.php?r1=29542&r2=29546

Make sure to apply first lobo's patch and then apply above patch.

Let us know if it works for you.

Thanks,
Kiran

[mohrahit]

I am facing a similar problem in 3.2.3. I guess the patch above exists in 3.2.3.

civimail.cronjob.php is not processing messages. I am using the following command on the shell:
$wget --post-data='name=name&pass=pass&key=key' http://<path-to-modules>/civicrm/bin/civimail.cronjob.php

• Civimail messages are not processed and no error is reported. The output of the script is blank.
• I tried giving all permissions to the cron user but it leads to the queue being processed but all messages reporting hard bounces.

Any help would be really appreciated. I have no idea how to debug this... there is just no error reported!

-Mohit

[Donald Lobo]

can you check your mailer logs and get more details on the hard bounces? i.e. whats the cause of the hard bounce?

lobo

[mohrahit]

The mailer logs show two bounces (I had 2 IDs in my mailing list) --

• Unknown bounce type
• Not connected

See atttachment for the actual screenshot

-Mohit

[mohrahit]

Moreover, the bounce occurs at sending itself and not after CiviMailProcessor processes it. Thus, it seems a sending issue.

If you need any other logs, do let me know and I will generate those.

thanks and regards
Mohit

[Piotr Szotkowski]

You need to check your mailserver (SMTP) logs, to see what’s the exact reason for the bounces.

[mohrahit]

Hi All,

I debugged the permissions one-by-one. It works when I give the following three permissions to the cron user:

• Access CiviCRM
• Access CiviMail
• Edit All Contacts

I dont know why do we require it to have "Edit All Contacts" permission. Any pointers would help.

-Mohit

[Tony Horrocks]

I hope this helps for Drupal users making cron work in Civi.

1. Make sure you have an anonymous user (user 0)
2. Add this as a file called CrmCron.php to your root directory (the one that already contains cron.php)

<?php
// create a new cURL resource
$ch = curl_init();
// set URL and other appropriate options
curl_setopt($ch, CURLOPT_URL, "http://mysite.com/sites/all/modules/civicrm/bin/civimail.cronjob.php?name=your drupal admin name&pass=your drupal admin password &key=your site key");
curl_setopt($ch, CURLOPT_HEADER, 0);
// grab URL and pass it to the browser
curl_exec($ch);
curl_close($ch);
?>

[grahamgilchrist]

I am having the exact same problem. CiviMail cron was working fine on 3.1.3 but now doesn't work on 3.2.3

We don't have the Login Destination module but do have some custom modules that do stuff with the user object on login. Unfortunately these are business critical modules which we can't disable. Do you think this could be interfering?

I already have a drupal module running the code mentioned by tonyhrx so that it hooks into the drupal cron.

I found the mail processor does run when I comment out the line:
CRM_Utils_System::loadBootStrap(  );
in civimail.cronjob.php

which seems consistent with the things Lobo mentioned above. The user for these mailings has no specific CiviCRM permissions. What exactly does the bulk mailer user need to process these via a http get request to a url like this?
/sites/all/modules/civicrm/bin/civimail.cronjob.php?name=username&pass=password&key=sitekey"


This issue may be related to this:
http://issues.civicrm.org/jira/browse/CRM-6691

[xavier]

If you want to run the cronjob from the cron, I recommend using the php-cli instead of the wrapper as described in the book

http://en.flossmanuals.net/CiviCRM/SystemConfiguration

Easier and more efficient than having a wrapper around a curl call

X+