Skip to content

cdr_mysql.c:580 my_load_module: Unable to query table description

In Elastix, Sometimes (usually after unexpected shutdown) all of your extensions will unregister and you can’t see your extensions list.

The first step to solve the problem is to reload Asterisk service.

Login with root account to your CentOS via SSH (PuTTY is an easy tool)

To reload Asterisk service:
asterisk -r

See the result. If there is no error, so the problem is resolved. Just refresh your Elastix configuration page and you’ll see your extensions.

Finally, turn your phones off and on.

You may see a red error on asterisk -r result

If you see below error in asterisk -r result:

cdr_mysql.c:580 my_load_module: Unable to query table description

The problem is from your MYSQL database. But don’t worry. You don’t have to install Elastix again.
Here is the solution:

1- stop asterisk service with

/etc/init.d/asterisk stop

2- login to your MYSQL

mysql -u root -p

Then enter your MYSQL password.

3- repair your corrupted table

repair table asteriskcdrdb.cdr;

4- Exit MySQL


5- Start Asterisk service.
/etc/init.d/asterisk start

That’s all. Now you can call the Marshal 😉

Published inLinuxTroubleshootingVOIP

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Skip to toolbar