HELP!!! Outgoing SMTP campaign emails not being sent in SugarCRM OSS 4.2.0d

[jpeckham]

Please Help - no SMTP emails are being sent in SugarCRM - either using the Send Test feature or via the scheduler.

*****
Please can a very kind SugarCRM member help with investigating this problem as I'm quite close to abandoning even though I've put in quite a lot of time to get it running so far. It's dead in the water for me at the moment.
*****

I'm using:
SugarCRM version 4.2.0d
MAC OS X ..... 10.4.6
PHP 5.1.4-5
Apache 1.3.33
MySQL 5.0.21

After sending campaign emails, if I go to the outgoing email queue (Admin -> Outbound Email Queue Management) emails are listed there with these values:

Send Attempts = 1
In Process = Checked

Also if I force the outgoing email queue using "Send Queued Campaign Emails", the email status changes from:
Send Attempts = 0
In Process = 0

to:

Send Attempts = 1
In Process = Checked

I'm not sure what "Checked" means.

There is no information in the debug log relating to outgoing mail either.


When I check the target email account there has been no email sent - I have double & triple checked the SMTP settings and they are correct for my account. I've tried and tried many times to get the email sent - but nothing is coming out.

I've set the same SMTP information everywhere (SugarCRM login account, system-wide and in the group that is used by the inbound mailbox). I've also tried using IP address everywhere of my mail host rather than the domain name.

But SugarCRM absolutely refuses to send any outgoing SMTP mail.


The debug output from running emailmandelivery.php (with mail in the outgoing queue) is:

Sun Jun 11 21:36:42 2006,167 [1949] INFO SugarCRM - Query:SELECT category, name, value FROM config
Sun Jun 11 21:36:42 2006,169 [1949] INFO SugarCRM - Connect:Resource id #158
Sun Jun 11 21:36:42 2006,172 [1949] INFO SugarCRM - Query Execution Time:0.00103
Sun Jun 11 21:36:42 2006,189 [1949] DEBUG SugarCRM - Array
(
[0] => SELECT * FROM emailman WHERE send_date_time <= DATE_FORMAT('2006-06-11 20:36:42', '%Y-%m-%d %H:%i:%s') AND (in_queue ='0' OR ( in_queue ='1' AND in_queue_date <= DATE_FORMAT('2006-06-10 20:36:42', '%Y-%m-%d %H:%i:%s'))) ORDER BY campaign_id,user_id, list_id
[1] => 0
[2] => 500
)

Sun Jun 11 21:36:42 2006,192 [1949] DEBUG SugarCRM - Limit Query: SELECT * FROM emailman WHERE send_date_time <= DATE_FORMAT('2006-06-11 20:36:42', '%Y-%m-%d %H:%i:%s') AND (in_queue ='0' OR ( in_queue ='1' AND in_queue_date <= DATE_FORMAT('2006-06-10 20:36:42', '%Y-%m-%d %H:%i:%s'))) ORDER BY campaign_id,user_id, list_id Start: 0 count: 500
Sun Jun 11 21:36:42 2006,195 [1949] INFO SugarCRM - Query: SELECT * FROM emailman WHERE send_date_time <= DATE_FORMAT('2006-06-11 20:36:42', '%Y-%m-%d %H:%i:%s') AND (in_queue ='0' OR ( in_queue ='1' AND in_queue_date <= DATE_FORMAT('2006-06-10 20:36:42', '%Y-%m-%d %H:%i:%s'))) ORDER BY campaign_id,user_id, list_id LIMIT 0,500
Sun Jun 11 21:36:42 2006,198 [1949] INFO SugarCRM - Query Execution Time:0.001273

I've checked the "emailman" table in the database and there is a row in there.


If there are any kind souls out there - please help!!!

Thanks a lot
John

[y2chuck]

update your log4php file to "info" as well. You might get some more info.

I guess your talking about sending through a campaign right? If so, make sure the target list is actually categorized as "seed" list or something. I've had instances where I just left a target list to "default" and Sugar wouldn't send out the messages.