Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

FreePBX System Administration
,
1

After a power cut I am getting the following error

Unable to create lock file: Read-only file system
Failed to start up concurrent users module!
Exception: SQLSTATE[HY000] [2002] Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)::SQLSTATE[HY000] [2002] Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111) in file /var/www/html/admin/libraries/utility.functions.php on line 204
Stack trace:

  1. Exception->() /var/www/html/admin/libraries/utility.functions.php:204
  2. die_freepbx() /var/www/html/admin/libraries/BMO/Database.class.php:131
  3. PDOException->() /var/www/html/admin/libraries/BMO/Database.class.php:128
  4. PDO->__construct() /var/www/html/admin/libraries/BMO/Database.class.php:128
  5. FreePBX\Database->__construct() /var/www/html/admin/libraries/BMO/FreePBX.class.php:72
  6. FreePBX->__construct() /var/www/html/admin/bootstrap.php:141
  7. require_once() /etc/freepbx.conf:9
  8. include_once() /var/lib/asterisk/bin/fwconsole:12
    Unable to create lock file: Read-only file system
    Failed to start up concurrent users module!
    Exception: SQLSTATE[HY000] [2002] Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)::SQLSTATE[HY000] [2002] Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111) in file /var/www/html/admin/libraries/utility.functions.php on line 204
    Stack trace:
  9. Exception->() /var/www/html/admin/libraries/utility.functions.php:204
  10. die_freepbx() /var/www/html/admin/libraries/BMO/Database.class.php:131
  11. PDOException->() /var/www/html/admin/libraries/BMO/Database.class.php:128
  12. PDO->__construct() /var/www/html/admin/libraries/BMO/Database.class.php:128
  13. FreePBX\Database->__construct() /var/www/html/admin/libraries/BMO/FreePBX.class.php:72
  14. FreePBX->__construct() /var/www/html/admin/bootstrap.php:141
  15. require_once() /etc/freepbx.conf:9
  16. include_once() /var/lib/asterisk/bin/fwconsole:12

Any ideas? I have tried the below:-
fsck /dev/sdax

chown mysql:mysql /var/run/mysqld
service mysqld start

fwconsole database repair

none of the above work?

2

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.