Campaign mails sent more than once

**russgalleywood** · 2006-10-11, 10:12 AM

I have no idea if this is anything to do with sugar but if someone can help I would appreciate it.

We sent a Campaing on the 6th of October to 333 recipients from a single Target List. It had a Start Date of the 5th and an End Date of the 6th. It says it is now 'Compete' and was of Type 'Email'
However, this morning we got back hundreds of bounce emails, far more than we sent in fact. When I now look at the Camapign Status it shows as having sent 1012! These are often to the same recipients and some customers go these up to 10 times!
There are also no messages in either 'Bounced Messages' Subpanels.

I realise this could be to do with our Mail Server but if the mailserver isd sending them multiple times, would the Sugar Server, a totally seperate pysical machine on the same Subnet know about this?

I have our Email Settings set to use SMTP and point at our Mail Server IP address, it appears to be relaying them on otherwise the Customers wouldn't be receiving 10 emails!

I tested this thoroughly last week by sending Campaign emails to my own home email address (outside our Company mail system) and to other user home email, they all got them ONCE only but this was with a small Target List. Other staff also tried to send these out and were also successful so why is this just happeninjg with big Target Lists?

Would using sendmail help here do you think?

Sugar Server - Sugar 4.5c, PHP 5.0.5, MySQL 4.0.12, Apache 2.0.52, CentOS 4.4

Mailserver - SME 7 Server

Any help much appreciated

**czei** · 2006-10-30, 08:00 PM

The same thing happened to me. The test emails embedded in the list got 3-4 copies of the mailing. I opened a case on this problem a couple of weeks ago and never heard back.

**kpit** · 2006-10-30, 08:41 PM

Sendmail will definately help. I have a sendmail server running on SugarCRM that relays to the real email server. SugarCRM using SMTP can not handle delays well especially with high volume emails. By using sendmail which is better at handling email server delays. Not to mention SugarCRM can dump the emails to sendmail to queue up for delivery if email servers are slow and will handle delevery in the background without much overhead.

**russgalleywood** · 2006-10-31, 08:22 AM

Unfortunately it's too late!

After we sent another Campaign and some customers got the message over 100 times, we have dropped Sugar.

A very embarrassing episode for me, to see all the smug faces when I announced that we were going back to Act. £5000 down the drain as far as I am concerned.

So thanks Guys for your attempt to help but Sugar was doomed from the start. Working in a company of 'Linuxists' it was always going to be an uphill battle.

It seemed we could forgive Act it's quirks (which we paid good money for), but anything even vaguely related to Linux is shot down in flames for the slightest error.

I will continue to plough my lonely Open-Source furrow alone and retire to my Cave to lick my wounds!

Bye to everyone on the Sugar Forums!

**pdeschen** · 2006-10-31, 06:20 PM

In the Email Setting of the Admin Panal, there is a choice of either using sendmail or SMTP as the transfer agent. What exactly is the difference between those 2 mechanisms?

I have a sendmail server running on SugarCRM that relays to the real email server. SugarCRM using SMTP can not handle delays well especially with high volume emails.

Dhe? In the end, this "real email server" could either be on the sub network or remote but there should be no relation with this "delays" thing. Whatever the mail agent, such problem should not occur.

This is a bit annoying to me and would need investigation.

russgalleywood:

Did you try to send a test campaign to "bouncable emails" (invalid ones and such) as well as valid emails and see how it reacts?

Looking forward to some investigation...

**jhamill** · 2006-10-31, 08:21 PM

It sounds like the sugar sending of the mail process is going multiple times.

we've had this happen a few times in the early days when went to sugarcrm.

It was extremely embarassing to have the same mails go multiple times to the customers. we had set the scheduler to send the mail to a very small interval, and it didn't actually finish one batch before it went and started the same batch again
again. therefore the same customers ended up getting the mail repeated. It looked like sugarcrm wasn't updating the email send record after each email but at the end of the batch. Don't know if this is still an issue.

we reduced our batch sizes and increased the schedule interval to ensure it doesn't happen again. We also moved to sendmail on the same box so that the batch went almost straight from sugarcrm to sendmail for queueing.

john

ps. we are running pretty much the same OS settings as you.

I changed our cron settings to a single file in cron.hourly as below

[root@chifley1 cron.hourly]# cat sugarrun
#!/bin/sh
cd /var/www/html/crm
php -f cron.php >> /var/log/sugarccron.log

Originally Posted by russgalleywood

I have no idea if this is anything to do with sugar but if someone can help I would appreciate it.

We sent a Campaing on the 6th of October to 333 recipients from a single Target List. It had a Start Date of the 5th and an End Date of the 6th. It says it is now 'Compete' and was of Type 'Email'
However, this morning we got back hundreds of bounce emails, far more than we sent in fact. When I now look at the Camapign Status it shows as having sent 1012! These are often to the same recipients and some customers go these up to 10 times!
There are also no messages in either 'Bounced Messages' Subpanels.

I realise this could be to do with our Mail Server but if the mailserver isd sending them multiple times, would the Sugar Server, a totally seperate pysical machine on the same Subnet know about this?

I have our Email Settings set to use SMTP and point at our Mail Server IP address, it appears to be relaying them on otherwise the Customers wouldn't be receiving 10 emails!

I tested this thoroughly last week by sending Campaign emails to my own home email address (outside our Company mail system) and to other user home email, they all got them ONCE only but this was with a small Target List. Other staff also tried to send these out and were also successful so why is this just happeninjg with big Target Lists?

Would using sendmail help here do you think?

Sugar Server - Sugar 4.5c, PHP 5.0.5, MySQL 4.0.12, Apache 2.0.52, CentOS 4.4

Mailserver - SME 7 Server

Any help much appreciated

**russgalleywood** · 2006-11-01, 10:47 AM

Thanks for trying to help Guys but as I say, it's too late!

Don't get me wrong, I love Sugar and have lamented it's passing at our company but we have spent the money on Act 2007 now so there is no going back.

I tried both SMTP to my SMTP Mailserver and also Sendmail with Sugar 4.5b but it was actually worse with Sendmail! 17000 mails went to 300 customers this way!

It seems very likely something to do with the Scheduler but can't be sure. (I was on CentOS 4.4 Linux)

Anyway, Good Luck with the solution.