CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • CiviMail installation and configuration (Moderator: Donald Lobo) »
  • Hints for debugging civimail cron job
Pages: [1]

Author Topic: Hints for debugging civimail cron job  (Read 1881 times)

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Hints for debugging civimail cron job
May 31, 2011, 03:13:38 pm
I'm having a frustrating time getting the civimail cron job to process the mail queue. I'm looking for some assistance in debugging.

I am able to get the mail to to process by using the trigger http://[mydomain]/index.php?q=civicrm/mailing/queue&reset=1 [^] but cannot get the cronjob script to work from the command line nor from cron.

php cli is installed so I want to run it according to the instructions Xavier put in the Floss manual.

I have turned on CiviCRM debugging and added the debug directive to civimail.settings.php but can't see anything in the log that gives me a clue as to what the problem is. All I can see is a dump of the SQL query but no other messages. I have also looked at tcpdump output and don't see any attempted traffic to civismtp.uas.coop. Drupal watchdog logs don't reveal any clues.

I am on CiviCRM 3.2.3. Upgrading is not feasible at this time.
« Last Edit: May 31, 2011, 03:16:24 pm by Ozyank »

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Hints for debugging civimail cron job
June 01, 2011, 04:21:36 am
If the http method works so just use the cron wget method.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Hints for debugging civimail cron job
June 01, 2011, 06:10:58 am
Quote from: Ozyank on May 31, 2011, 03:13:38 pm
I'm having a frustrating time getting the civimail cron job to process the mail queue. I'm looking for some assistance in debugging.

php cli is installed so I want to run it according to the instructions Xavier put in the Floss manual.


what does it do when you run the command from the cli ?

cd /wherever/is/your/civicrm
nice -19 php bin/civimail.cronjob.php -syourorg.org -uyouruser -pyourpassword

Does it write some error message ?
-syourorg.org or -sdefault, depends on how you have installed drupal (single or multisite)

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Re: Hints for debugging civimail cron job
June 01, 2011, 03:28:46 pm
The job is running. The problem seems to be with the scheduling. I am submitting the job to be processed immediately (I am in Australia). The server time is CDT in the USA so the queue doesn't get picked up until the server catches up. This behaviour is different than our current production system, I believe.

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Hints for debugging civimail cron job
June 03, 2011, 03:29:14 am
What is the timezone setting in php ?  CDT or Australia?

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Dennis Gray

  • Ask me questions
  • ****
  • Posts: 472
  • Karma: 1
  • CiviCRM version: Various. See post.
  • CMS version: Drupal, Wordpress and Joomla. See post.
  • MySQL version: TBA
  • PHP version: TBA
Re: Hints for debugging civimail cron job
July 05, 2011, 04:51:43 pm
I've started another post on this topic but just thought I'd note there that our admins are all over the world, as you probably know from discussions with Jason in Paris. We need the time to be sent relative to the user's local time.

GingerFeet

  • I post occasionally
  • **
  • Posts: 78
  • Karma: 4
  • CiviCRM version: 3.4.6 / 3.4.7
  • CMS version: Drupal 6.22
  • MySQL version: 5.1
  • PHP version: 5.3.6
Re: Hints for debugging civimail cron job
July 15, 2011, 03:10:13 pm
Hi,

Please try my solution.
http://forum.civicrm.org/index.php/topic,20739.0.html

If it works, please reply to the thread:
http://forum.civicrm.org/index.php/topic,20739.0.html

Thanks,
GF
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • CiviMail installation and configuration (Moderator: Donald Lobo) »
  • Hints for debugging civimail cron job

This forum was archived on 2017-11-26.