Author Topic: Upgraded to 3.2.4 and now can't send/receive e-mails. Get timeout on Outbound (Read 1069 times)

backdrifting · November 04, 2010, 06:57:35 pm

Ok so I have successfully upgraded from 2.2.7 on a Drupal 6.19 site to CiviCRM 3.2.4. Everything checks out except for sending e-mails. We're able to register for our events but the confirmation e-mail is no longer being sent.

My Outbound Mail settings (via /civicrm/admin/setting/smtp&reset=1) is set to SMTP as it was with 2.2.7. I have SMTP authentication with the correct e-mail address and password listed.

If I try to save and send an e-mail (test e-mail) from this config screen the site just hangs for about 10 seconds and then dumps out a huge slew of MySQL errors starting with:

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:85:\"MySQL server has gone away\nquery: SELECT * FROM system WHERE type = 'theme'\";s:5:\"%file\";s:45:\"/home/public_html/includes/theme.inc\";s:5:\"%line\";i:471;}', 3, '', '/civicrm/admin/setting/smtp', '/civicrm/admin/setting/smtp?reset=1', '76.106.37.121', 1288921711) in /home/public_html/includes/database.mysql.inc on line 128

Then if I try changing the protocol to the mail() which I successfully use on other CiviCRM sites, it also times out and shows the MySQL errors.

Again everything else seems to be working fine post upgrade. What is causing this?

-Trevor

backdrifting · November 04, 2010, 07:34:26 pm

Here's the backtrace from the debug on the configuration timeout:

backTrace

/home//public_html/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 143
, handle,
/home//public_html/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931
/home//public_html/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 968
/home//public_html/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564
/home//public_html/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/home//public_html/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/home//public_html/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 308
/home//public_html/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/home//public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2411
/home//public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 442
/home//public_html/sites/all/modules/civicrm/CRM/Admin/Form/Setting/Smtp.php, find, 167
/home//public_html/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 250
/home//public_html/sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 167
/home//public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 64
/home//public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home//public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home//public_html/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 279
/home//public_html/sites/all/modules/civicrm/CRM/Utils/Wrapper.php, run, 115
/home//public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 191
/home//public_html/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 351
, civicrm_invoke,
/home//public_html/includes/menu.inc, call_user_func_array, 348
/home//public_html/index.php, menu_execute_active_handler, 18

rjlang · November 05, 2010, 03:41:22 pm

Hi, I can add a bit more to what backdrifting posted about this. The problem affects all emails sent by CiviCRM: registration confirmation emails, membership confirmation emails, and CiviMail mailings. Attempting to send a test mailing (step 4 of a CiviMail mailing) generates an error that simply says: "Sorry. A nonrecoverable error has occurred." The Error Details/Additional Details shown on this error page are:

Array(
...
[message] => Authentication failed.
[mode] => 16
[debug_info] =>
[type] => PEAR_error
...

As backdrifting said, the SMTP information is correct and is the same as what worked under 2.2.7.

Any ideas from anyone?

Robert

xavier · November 06, 2010, 08:54:48 am

Hi,

The upgrade has uncover previous problems on your configuration.

A chapter in our book "Understanding CiviCRM" is available online http://en.flossmanuals.net/CiviCRM/SystemConfiguration is available and describes how to fix that.

(not sure where it comes from, check the outbound mail configuration and your mailbox configuration).

X+

backdrifting · November 06, 2010, 04:16:21 pm

Not sure if I totally agree with this. The e-mails work without issue in 2.2.7. So I don't think we have any issues with our previous configuration. In fact I've restored to our 2.2.7 db and the e-mails are sending again without issue. So this definitely seems to be only an issue with the upgrade to 3.2.4.

=Trevor

CiviCRM Community Forums (archive)

News:

Author Topic: Upgraded to 3.2.4 and now can't send/receive e-mails. Get timeout on Outbound (Read 1069 times)

backdrifting

Upgraded to 3.2.4 and now can't send/receive e-mails. Get timeout on Outbound

backdrifting

Re: Upgraded to 3.2.4 and now can't send/receive e-mails. Get timeout on Outbound

rjlang

Re: Upgraded to 3.2.4 and now can't send/receive e-mails. Get timeout on Outbound

xavier

Re: Upgraded to 3.2.4 and now can't send/receive e-mails. Get timeout on Outbound

backdrifting

Re: Upgraded to 3.2.4 and now can't send/receive e-mails. Get timeout on Outbound