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 »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Losing DB connection on mail cron
Pages: 1 [2]

Author Topic: Losing DB connection on mail cron  (Read 4993 times)

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Losing DB connection on mail cron
May 20, 2008, 02:25:55 pm

1. these errors just started in the past few days? the system was working fine for the prior few months, i assume

2. any more details on the cpanel <-> mysql issues and the status of your mysql db?

seems like this is a db issue at this stage. can u transfer the db locally and run some tests?

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Matt2000

  • I post frequently
  • ***
  • Posts: 288
  • Karma: 27
    • http://www.ninjitsuweb.com
Re: Losing DB connection on mail cron
May 20, 2008, 03:10:05 pm
1. These problems appears after moving form a previous server to a new, cpanel based server.

2. I seem to be passed the 'lost connection' type errors. I don't believe there are active errors in the database, except possibly the one mailing that returns the "more than one live job" issue.

I decided to test sending a message via the 'Send mail to Contact' feature, and I received a SMTP error. So I am working with my host to find out if the server is blocking third party SMTP connections. (cPanel includes a security 'feature' to disallow this, but I believe I have the feature disabled.)

Drupal/CiviCRM micro-blogging http://twitter.com/matt2000

Ninjitsu Web Development http://www.NinjitsuWeb.com/

Matt2000

  • I post frequently
  • ***
  • Posts: 288
  • Karma: 27
    • http://www.ninjitsuweb.com
Re: Losing DB connection on mail cron
May 21, 2008, 10:47:45 pm
OK, with the help of Shane @ UAS / CiviSMTP, we narrowed down the final issue to the a network problem in the CiviSMTP data center.

So, the bottom line for future generations is to know that the MySQL issue WAS resolved by the cPanel provided fix. So be aware of this potential requirement.
Drupal/CiviCRM micro-blogging http://twitter.com/matt2000

Ninjitsu Web Development http://www.NinjitsuWeb.com/
Pages: 1 [2]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Losing DB connection on mail cron

This forum was archived on 2017-11-26.