0

I have a Drupal 7 site.

I have it working fine on localhost and my own test domain, with individual settings folders setup such as:

sites/localhost sites/test.mydomain.co.uk

I am now putting it up onto a site where there is no domain set, but I can access it by visiting: sitename.org/folder1/folder2

i have duplicate settings files in; sites/folder1.folder2 sites/www.upcomingfinaldomainname.com

Have I got these right?

I keep getting the message:

PDOException: SQLSTATE[HY000] [2013] Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in db_table_exists()

I'm using the user and pass I have been provided, and the correct db names. I have also set host as localhost and removed the port number.

Any suggestions?

3
  • Does the MySQL server work well for other sites?
    – mpdonadio
    Jul 23, 2013 at 20:41
  • Yes, no problems. Jul 23, 2013 at 22:18
  • I think you need to enable PDO Extension, ask the hosting provider to enable it
    – Bala
    Jul 24, 2013 at 5:06

2 Answers 2

0

If your connection parameters were incorrect, you would get a different error from MySQL.

I have seen connection problems on Drupal systems for a few different reasons.

  • Overloaded server
  • Low timeout values on a busy server
  • Low value for max_allowed_packet (this normally is a 2006 or 2020, though, in my experience).

Assuming other sites work, then the first two likely aren't the problem. I would check your max_allowed_packet and see if that helps matters. I typically use 32M; large values can help with restoring backups.

0

Looks like a database hosts misconfiguration. Check out the /etc/hosts.allow and set mysqld: ALL. Also, check if it's blacklisted in /etc/hosts.deny.

Also, check if the database server port and host are set correctly. If running on the same server, they should be 127.0.0.1 and port is 3306 (default).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.