Author Topic: Asterisk Problems  (Read 1118 times)

thatcrazyperson123

  • Newbie
  • *
  • Posts: 8
    • View Profile
Asterisk Problems
« on: September 23, 2009, 08:53:44 pm »
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?

posde

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 2984
  • Wastes Life On LinuxMCE Since 2007
    • View Profile
    • My Home
Re: Asterisk Problems
« Reply #1 on: September 23, 2009, 08:57:19 pm »
This sounds like a broken mysql database. Try searching for information on how to fix broken mysql databases.

Zaerc

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 2256
  • Department of Redundancy Department.
    • View Profile
Re: Asterisk Problems
« Reply #2 on: September 23, 2009, 11:50:15 pm »
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.
"Change is inevitable. Progress is optional."
-- Anonymous


thatcrazyperson123

  • Newbie
  • *
  • Posts: 8
    • View Profile
Re: Asterisk Problems
« Reply #3 on: November 07, 2009, 05:04:26 pm »
Thanks, did the trick :)