Asterisk Problems

[thatcrazyperson123]

Hi, I have Linux MCE 7.10 (I like to steer clear of alpha's) running on a system that is just a core, not a core hybrid, 2 NICs, etc.   When I go to add a phone line from the online configuration, it gives me an error.

Fatal error: mysql error: [145: Table './asterisk/sip' is marked as crashed and should be repaired] in EXECUTE(" SELECT sip.id,sip.data,sips.data AS sdata, sipp.data AS pdata,siph.data AS hdata FROM sip INNER JOIN sip sips ON (sips.id=sip.id) AND (sips.keyword='secret') INNER JOIN sip sipp ON (sipp.id=sip.id) AND (sipp.keyword='username') INNER JOIN sip siph ON (siph.id=sip.id) AND (siph.keyword='host') WHERE (sip.keyword='account') AND (sip.data='sipgate' OR sip.data='inphonex' OR sip.data='broadvoice' OR sip.data='voiceeclipse' OR sip.data='sipgradwell' OR sip.data='xs4all' OR sip.data='viatalk_us-central' OR sip.data='1und1' OR sip.data='sipgate_de')") in /var/www/pluto-admin/include/adodb/adodb-errorhandler.inc.php on line 77

Is there anything I can do without reinstalling LMCE?

[Marie.O]

This sounds like a broken mysql database. Try searching for information on how to fix broken mysql databases.

[Zaerc]

You probably need to open a terminal and do something like this:

sudo su -
mysql asterisk

then on the mysql> prompt:

mysql> CHECK TABLE sip;
+--------------+-------+----------+----------+
| Table        | Op    | Msg_type | Msg_text |
+--------------+-------+----------+----------+
| asterisk.sip | check | status   | OK       |
+--------------+-------+----------+----------+
1 row in set (0.00 sec)
mysql> REPAIR TABLE sip;
+--------------+--------+----------+----------+
| Table        | Op     | Msg_type | Msg_text |
+--------------+--------+----------+----------+
| asterisk.sip | repair | status   | OK       |
+--------------+--------+----------+----------+
1 row in set (0.03 sec)

mysql> quit
Bye


And it works on other tables/databases too, good luck.

[thatcrazyperson123]

Thanks, did the trick