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) »
  • Scheduled mail 'running' but never sends
Pages: [1]

Author Topic: Scheduled mail 'running' but never sends  (Read 3191 times)

leemako

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.0
  • CMS version: Drupal 7
  • MySQL version: 5.0.92
  • PHP version: 5.2.17
Scheduled mail 'running' but never sends
June 08, 2011, 04:27:45 pm
Drupal 7.2 with CiviCRM 4.0 (will be upgrading to 4.0.2 this weekend). Using the default mail option and have gone through the relevant set up in Civi interface. Can send individual emails to users, have created two Cron jobs, have set up return path. Sending a test mailing to a group works fine also. When I schedule a mailing and choose 'send immediately' it sits on scheduled for a while and when cron kicks in goes from scheduled to running but never completes. I am unsure where to look for any possible error logs on this if there are any.

Another strange thing and possibly related, when I went to create a site Key there was already one in the settings file (is this supposed to auto generate in 4.0 ?). The cron jobs appear to run (at least changing from scheduled to running) so I guess this is ok right?

Ive spent a very long time reading documentation on all this to get the set up just right but maybe there is something i have missed, any light you could shed would be much appreciated.
« Last Edit: June 08, 2011, 04:41:06 pm by leemako »

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Scheduled mail 'running' but never sends
June 09, 2011, 01:00:33 am
What's on the report ? How many mails are scheduled/sent ?

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

leemako

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.0
  • CMS version: Drupal 7
  • MySQL version: 5.0.92
  • PHP version: 5.2.17
Re: Scheduled mail 'running' but never sends
June 09, 2011, 02:13:18 am
Thanks for the reply xavier, the report is as follows

Intended Recipients   2
Successful Deliveries   0 (0.00%)
Tracked Opens   0
Click-throughs   0
Forwards   0
Replies   0
Bounces   0 (0.00%)
Unsubscribe Requests   0 (0.00%)
Scheduled Date   8th June , 2011 11:15 PM
Status   Running
Start Date   8th June , 2011 11:20 PM
End Date   

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Scheduled mail 'running' but never sends
June 09, 2011, 02:22:30 am
Ah,

Can disable the cron for a while, create a new mailing and run the command you run on the cron manually?

It hopefully is going to display a message about what's the issue.

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

leemako

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.0
  • CMS version: Drupal 7
  • MySQL version: 5.0.92
  • PHP version: 5.2.17
Re: Scheduled mail 'running' but never sends
June 09, 2011, 06:21:13 am
I tried running it manually from the browser but sent me to a blank page with no errors. I stumbled across another thread which sounded similar to my issue, turns out was permissions based all along. http://forum.civicrm.org/index.php?topic=15472.0
I added the civimail drupal account i made to adminstrator group and the tests went immediatley. Now I just need to change the permissions for that civimail role. Thanks for your assistance xavier

FatherShawn

  • Ask me questions
  • ****
  • Posts: 372
  • Karma: 25
    • C3 Design
  • CiviCRM version: 4.2.11
  • CMS version: Drupal 7.23
  • MySQL version: 5.5.32
  • PHP version: 5.3.10
Re: Scheduled mail 'running' but never sends
July 29, 2011, 06:49:14 pm
So I upgraded a 3.1 install today to 3.4.4 for a client.  CiviMail jobs are staying stuck on "running"  SMTP settings are fine - test mail sends properly. Both cli and curl based calls to civimail.cronjob.php run without complaint

Turns out that the user that I created for this job always had 'access CiviCRM' and 'access CiviMail' permissions in Drupal.  Following the post referenced above, I added 'edit all contacts' permission and the jobs now send. Is this expected behavior?
Lead Developer, C3 Design.
Twitter: @FatherShawn

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Scheduled mail 'running' but never sends
July 30, 2011, 12:45:46 am
Hi,

It's expected ( it needs to put on hold potentially any contact)

Wondering if we shouldn't bypass the access rights altogether when running the cron.

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

FatherShawn

  • Ask me questions
  • ****
  • Posts: 372
  • Karma: 25
    • C3 Design
  • CiviCRM version: 4.2.11
  • CMS version: Drupal 7.23
  • MySQL version: 5.5.32
  • PHP version: 5.3.10
Re: Scheduled mail 'running' but never sends
July 30, 2011, 04:58:38 am
No, I like restricting the privileges of the automated user.  We just need to update the documentation to match the operation. What a really don't get is that another site that I upgraded not too long ago to 3.4.4 the civimail automated user role also did not have "edit all users" but it has been functioning fine, including putting people on hold. 
« Last Edit: July 30, 2011, 05:03:55 am by FatherShawn »
Lead Developer, C3 Design.
Twitter: @FatherShawn

paulsmithx

  • I’m new here
  • *
  • Posts: 12
  • Karma: 0
Re: Scheduled mail 'running' but never sends
September 04, 2011, 11:06:42 pm
Not so happy for me. I'm on Drupal 7 and Civicrm 4.0.5.

I've created a user with admin privileges, and worked with the isp to add the cron job. When the cron starts it just sits there doing nothing and never completes, so we get multiple cron jobs backing up on each other.

I am sending out 2500 email via an external smtp, one at a time. Is this expected behaviour, or should the cron job just send a start to the database and then return, not sure how this should work?

As an aside I've also got a mailing showing 100% but still running. Che strano!
Thanks
Paul

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Scheduled mail 'running' but never sends
September 04, 2011, 11:43:51 pm
Try running manually the script used in the cronjob, see if you get more info

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

paulsmithx

  • I’m new here
  • *
  • Posts: 12
  • Karma: 0
Re: Scheduled mail 'running' but never sends
September 05, 2011, 01:05:15 am
Thanks Xavier,
I did as you suggested, and it returns to the command prompt directlly but I can't see any evidence of the job having started.

If, for example, a previous manually started send job has stalled, the running of the cron job doesn't restart it. Also the drupal watchdog table doesn't log any details of the job having starting.
Thanks
Paul

FatherShawn

  • Ask me questions
  • ****
  • Posts: 372
  • Karma: 25
    • C3 Design
  • CiviCRM version: 4.2.11
  • CMS version: Drupal 7.23
  • MySQL version: 5.5.32
  • PHP version: 5.3.10
Re: Scheduled mail 'running' but never sends
September 14, 2011, 06:49:51 pm
Quote from: paulsmithx on September 05, 2011, 01:05:15 am
Also the drupal watchdog table doesn't log any details of the job having starting.

That sounds like key info - you should see a session open for the user the command uses to login...
Lead Developer, C3 Design.
Twitter: @FatherShawn

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • CiviMail installation and configuration (Moderator: Donald Lobo) »
  • Scheduled mail 'running' but never sends

This forum was archived on 2017-11-26.