We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 38878
    • 255 Posts
    I am getting some pretty squirrely behavior on one of my sites. It is itermittent, and appears to be a connectivity issue with the MYSQL server. The site runs with the occasional error:
    [2013-01-28 12:35:01] (ERROR in xPDOConnection::connect @ /data/14/1/64/123/1064123/user/1097640/counter/core/xpdo/xpdo.class.php : 2999) SQLSTATE[HY000] [2003] Can't connect to MySQL server on '205.178.146.109' (4)
    [2013-01-28 12:35:03] (ERROR in xPDOConnection::connect @ /data/14/1/64/123/1064123/user/1097640/counter/core/xpdo/xpdo.class.php : 2999) SQLSTATE[HY000] [2003] Can't connect to MySQL server on '205.178.146.109' (4)
    [2013-01-28 12:35:04] (ERROR @ /connectors/browser/directory.php) Error preparing statement for query: SELECT modAccessContext.id, modAccessContext.target, modAccessContext.principal, modAccessContext.authority, modAccessContext.policy, Policy.data FROM `hcev_access_context` AS `modAccessContext` LEFT JOIN `hcev_access_policies` `Policy` ON `modAccessContext`.`policy` =  `Policy`.`id` WHERE  ( `modAccessContext`.`principal_class` = ? AND `modAccessContext`.`target` = ? )  ORDER BY modAccessContext.target,modAccessContext.principal,modAccessContext.authority,modAccessContext.policy ASC  - 
    [2013-01-28 12:35:09] (FATAL) The requested resource has no valid content type specified.
    [2013-01-28 12:35:11] (ERROR in xPDOConnection::connect @ /data/14/1/64/123/1064123/user/1097640/counter/core/xpdo/xpdo.class.php : 2999) SQLSTATE[HY000] [2003] Can't connect to MySQL server on '205.178.146.109' (4)
    [2013-01-28 12:35:12] (ERROR in xPDOConnection::connect @ /data/14/1/64/123/1064123/user/1097640/counter/core/xpdo/xpdo.class.php : 2999) SQLSTATE[HY000] [2003] Can't connect to MySQL server on '205.178.146.109' (4)
    [2013-01-28 12:35:12] (ERROR @ /connectors/browser/directory.php) Error preparing statement for query: SELECT modAccessContext.id, modAccessContext.target, modAccessContext.principal, modAccessContext.authority, modAccessContext.policy, Policy.data FROM `hcev_access_context` AS `modAccessContext` LEFT JOIN `hcev_access_policies` `Policy` ON `modAccessContext`.`policy` =  `Policy`.`id` WHERE  ( `modAccessContext`.`principal_class` = ? AND `modAccessContext`.`target` = ? )  ORDER BY modAccessContext.target,modAccessContext.principal,modAccessContext.authority,modAccessContext.policy ASC  - 


    Anyone else seeing this? I did a reinstall and cleaned everything. Not sure why I would have a periodic inability to connect to the MYSQL server. Any advice would be great.
      • 28042 ☆ A M B ☆
      • 24,524 Posts
      Usually that means the server is overloaded. Is this on shared hosting?
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org
        • 38878
        • 255 Posts
        Yes. Network Solutions. Dab dabbit. Nothing I can fix myself. Will end up costing me duckets. Any suggestions on a good/cheap/fast provider for MODX? I can't have this silliness.
          • 38878
          • 255 Posts
          Well I broke down and called support. The issue it appears is in using the IP address for the MYSQL server isn't "desireable". I used it b/c the hostname was unqualified (w/o the domain) and not publicly resolvable in DNS. The said to use just the hostname. I guess they have a bunch of WAMP servers running WINS. How 2002!! <<.<< >>.>>. J/K. Anyway that was the fix so far. Just wanted to close the loop. Maybe someone else w/ NWS has the same issue.

          Lesson: Intermittent xPDO issues are probably not.