Nothing on CLI

Support forum for the ViciBox ISO Server Install and ISO LiveCD Demo

Moderators: enjay, williamconley, Staydog, mflorell, MJCoate, mcargile, Kumba

Nothing on CLI

Postby joylovebasu » Thu Jul 16, 2009 12:30 pm

I have 10 agent logged in.

It was working perfectly.

All of sudden its NOT.

Manual calls going perfectly

When agents on dialer, nothing on CLI.

When booting it show an error :

etc/wanpipe/wanpipe.1 not found

What could be the problem ?

9 agents logged in on all servers
System Load Average: 0.08
joylovebasu
 
Posts: 127
Joined: Tue Jun 09, 2009 11:13 am

Postby joylovebasu » Thu Jul 16, 2009 12:45 pm

Error
SQL query:

SHOW INDEX FROM `call_log` ;


MySQL said:

#145 - Table './asterisk/call_log' is marked as crashed and should be repaired
joylovebasu
 
Posts: 127
Joined: Tue Jun 09, 2009 11:13 am

Postby williamconley » Sat Jul 18, 2009 3:49 pm

solution for now:
mysqlcheck --auto-repair --all-databases -p
may need to run more than once or perform other repairs as needed

solution for future:
is your hard drive full? delete everything in /var/log/astguiclient
did your system crash (power failure? "off" button?)
Uninterruptible Power Supply and put TAPE over the off button. ONLY use the console to issue a command to shut down so your sql tables won't be corrupted by an interrupted write.

Background:
Vicidial (like standard mysql) uses NORMAL sql tables which are NOT transaction safe. They can't be rolled back. An interrupted write will cause a crashed table, plain and simple. Easy to fix ... but annoying. ;)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 50 guests