Campaign emails not sending automatically

[kevinp]

I have been struggling for weeks with campaign emails. It seems to work with small campaigns but I am trying to send out to about 28000 contacts and targets. Most of the emails are "stuck" in the queue and only get sent out in small batches when I manually click the "Send Queued Campaign Emails" button under "Manage Email Queue". It sends out as many emails at a time as set in "Campaign Email Settings". The scheduler is set to run every minute and cron.php is also scheduled to execute every minute. I have read many threads and followed the ideas given but I am having no success at all.

My setup is as follows
Windows XP SP 3
Sugar Community Edition 5.0.0.g
MS IIS V5.1
PHP V5
MS SQL Express

So if anyone can shed any light on the above...

Thanks

[roblaus]

What are you using - sendmail or smtp? I guess the latter because you are on Windows. Did you try with another smtp provider? Sometimes the guys block larger batches. Does the scheduler really run? Do you see an execution every minute?
These are stupid questions maybe but a remote diagnosis is very hard.

rgds

[kevinp]

Thanks for responding.
Yes, I am using SMTP because as you say Sendmail + Windows does not work.
I have tried more than 1 SMTP provider.
I see the cron.php execute every minute so I assume the scheduler is really running.
What helps confuse me is that the mails don't go out automatically but in dribs and drabs when I click the button to manually send them.

There's no such thing as a stupid question - I hope!

[abeucher]

Hello,
I have the same problem... My campaign works properly when I send batch manually, but when i configure the scheduler (each hour) + crontab (each hour) : nothing.
I test the server : The file cron.php properly runs each hour. It's ok.

I don't find any response in sugarcrmforum. The only element I found is : scheduler don't work on the communauty version ... Is-it right ?

My configuration
Sugarcrm 5.0 communauty version
linux server - php 5 - mysql4/5


thanks for your help too !

[kuske]

Seems to be a timing problem...

Others had the same problem.
IN the last campaign I set the sendmail to 15 mails per batch and run every minute and it worked fine.
But for 28000 contacs this takes a long time...

[abeucher]

To test, I set the sendmail to 1 mails per batch. with a schedule and a cron each hour.
nothing at all !


ps : the timing between the scheduler and the crontab shoud be the same ?

[clint]

Hello,
I have the same problem... My campaign works properly when I send batch manually, but when i configure the scheduler (each hour) + crontab (each hour) : nothing.
I test the server : The file cron.php properly runs each hour. It's ok.

I don't find any response in sugarcrmforum. The only element I found is : scheduler don't work on the communauty version ... Is-it right ?

My configuration
Sugarcrm 5.0 communauty version
linux server - php 5 - mysql4/5


thanks for your help too !

The scheduler code in Sugar Community Edition is the exact same as the scheduler code in Sugar Professional.

I think I know what you are running into. cron.php needs to write a lock file to the cache when it runs. If it can't run that file, it will write an error to sugarcrm.log and complete without executing your schedulers.

Check your sugarcrm.log file. Do you see an error "Scheduler cannot write PID file. Please check permissions on cache/modules/Schedulers"?

If so, then you have a file permissions issue and cron.php won't run. You need to change permissions so that the user your web server is running under can create that directory and write files to that directory.