I was just in the GUI for one of my on-prem customers, looking at CDR reports and their entire system crashed completely, stopped processing calls etc.
I got straight to site within about 30 minutes and have the following error when trying to access the GUI…
Exception
fatal error reading freepbx_settings::
All fwconsole commands fail with the error:
Exception: SQLSTATE[HY000] [2002] Connection refused::SQLSTATE[HY000] [2002] Connection refused in file /var/www/html/admin/libraries/utility.functions.php on line 204
Stack trace:
After further investigation it looks like mysql was corrupted. I have restored a backup of the tables from last night and now get:
SQLSTATE[HY000] [2002] Permission denied::SQLSTATE[HY000] [2002] Permission denied
I have ensured that the freepbxuser account is created, given access to the tables and has the same password as in freepbx.conf
fwconsole chown works fine now but still can’t get into the GUI.