Saturday, January 4, 2014

Freepbx database error after power outage

We have freepbx for our phone system and it works great.  The other day there was a power outage and when the freepbx system came back up the webui was complaining about not having a database.  When I sshed into the system and checked, mysql was not running. I tried to start sql and it complained that the socket was already in use.  After some googling it seemed the simplest fix and the first to try was to rename /var/lib/mysql/mysql.sock.  Just to be sure I stopped mysql and then renamed the file.  After starting mysql everything was working again.  Luckily this was an easy one, but if turned out bad I could have fallen back on the backups I created.

Example commands used for red hat based systems:
# service mysqld stop
# mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.old
# service mysqld start

If you're in Waco, Tx G&A Computers can help you with all of your computer repair needs. PC, Mac, all computers repaired.

No comments:

Post a Comment