Site Down: Upgrade from 5.3.14 to 6.x Fails

[stevewest15]

Hi,

 

We've tried upgrading WHMCS and now any page gives the following error:

 

Critical Error
SQLSTATE[HY000] [2002] No such file or directory

 

Apache logs & php logs doesn't show any errors. We've opened a support ticket but they're very slow lately (Ticket #PFV-479740). Appreciate any help you can offer!

 

Thx,

 

SW

[brian!]

are the custom paths in the configuration.php file correct?

[stevewest15]

Hi,

 

Yes, the custom paths are valid.

 

Thx,

 

SW

[rkatz0]

Did you upgrade mysql and/or PHP? The above error indicates there could be a problem connecting to the mysqld sock, so you may want to try locating it, and / or recreating the link.

 

- - - Updated - - -

 

Also could be PDO for PHP, this thread might help you solve it: http://stackoverflow.com/questions/2412009/starting-with-zend-tutorial-zend-db-adapter-throws-exception-sqlstatehy000

[stevewest15]

Hi,

 

We didn't change anything on the server nor WHMCS other then following the instructions to perform an upgrade.

 

It looks like w/ WHMCS 6.x, it doesn't like having the following in configuration.php:

 

$db_host = 'localhost';

 

The fix for us was to change the above to an IP address instead of localhost (even though localhost works for other apps installed on the server (WP, etc):

 

$db_host = '127.0.0.1';

 

Thx,

 

SW