Fix Asterisk Fatal Error Connecting to MySql

Posted: December 27, 2013 by gngtech in Uncategorized
Tags:

Our lives have become these complicated webs of dependencies, most of which is on electricity. So when the electrical grid starts acting up its like getting a punch right to the gut. You’re dazed, possibly confused a bit, and surely bent over in pain. Okay, so maybe this is a bit of a dramatic analogy, but my point is we need electricity to make all our gizmos work. Until someone can invent some way of running Asterisk without any juice it falls victim to the same whims.

Needless to say we had a power outage. It was one of those nasty brown outs where the electricity sort of works and is probably doing its damnedest to destroy your precious electronics. Once it was over our * server started up and the phones all could not connect. I hopped on to the server and found a fatal error page once again from the FreePBX web page. This time the error indicated it was from not being able to connect to MySQL. Fare enough, worse things have happened.

1) SSH to you * box.
2) Run “mysql”.
3) Observe the error about not being able to connect to mysql.sock.
4) Stop the mysql server.

Image
5) Rename the sock file.

Image
6) Start the mysql server.

Image
7) Start the asterisk server if it isn’t already running.

Image

Hopefully now when you visit the FreePBX web page it will be full of rainbows and unicorns. Oh, and your phones should now be working.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s