vicidial.org

Hi
I am using VICIBOX 4.0
Asterisk 1.4.4 vici
i am reciving message your session disabled when i tried to login agent.
i check db following tables are crashed


linux-mjyt:~ # mysqlcheck --repair --all-databases

asterisk.live_channels
note : The storage engine for the table doesn't support repair

asterisk.live_sip_channels
note : The storage engine for the table doesn't support repair
asterisk.park_log OK
asterisk.parked_channels
note : The storage engine for the table doesn't support repair

asterisk.server_updater
note : The storage engine for the table doesn't support repair

asterisk.vicidial_auto_calls
note : The storage engine for the table doesn't support repair

asterisk.vicidial_campaign_server_stats
note : The storage engine for the table doesn't support repair

asterisk.vicidial_hopper
note : The storage engine for the table doesn't support repair

asterisk.vicidial_live_agents
Error : Incorrect file format 'vicidial_live_agents'
error : Corrupt

asterisk.vicidial_manager
Error : Incorrect file format 'vicidial_manager'
error : Corrupt

asterisk.web_client_sessions
note : The storage engine for the table doesn't support repair
storage type of these tables is memory when i tried to repair there is message the storage type of these tables does not allow repair.
Then in next installation i changed storage type of these tables to MyISAM but it again crashed .Can anyone guide me why these tables crashed again and again what is precaution for this damage.
After this damage i am unable to login my agent .Please guide me what is the main cause of this db crash how i can recover the crashed db and how i can overcome this problem

this is indicative of a bigger problem. is your hard drive full? did you MD5 check the installation .iso to be sure it was not corrupt? Is your HD dying? Is your memory corrupt?

And on a similar note: You mention vicibox 4.0 ... but is it 4.0.1 or .2 or .3? And asterisk 1.4.4 vici does not exist .. is it 1.4.40-vici? And what about your Vicidial version with build (required!)?

Is this server virtual or physical?

OS Version openSUSE 12.1
VICIBOX Redux version 4.0.1 released
Asterisk version 1.4.44 vici
Server is physical RAM and HDD are working fine but problem is following tables crashed and agent is unable to login
asterisk.live_channels
note : The storage engine for the table doesn't support repair

asterisk.live_sip_channels
note : The storage engine for the table doesn't support repair
asterisk.park_log OK
asterisk.parked_channels
note : The storage engine for the table doesn't support repair

asterisk.server_updater
note : The storage engine for the table doesn't support repair

asterisk.vicidial_auto_calls
note : The storage engine for the table doesn't support repair

asterisk.vicidial_campaign_server_stats
note : The storage engine for the table doesn't support repair

asterisk.vicidial_hopper
note : The storage engine for the table doesn't support repair

asterisk.vicidial_live_agents
Error : Incorrect file format 'vicidial_live_agents'
error : Corrupt

asterisk.vicidial_manager
Error : Incorrect file format 'vicidial_manager'
error : Corrupt

asterisk.web_client_sessions
note : The storage engine for the table doesn't support repair
Kindly guide me about solution of this problem there is 1 TB HDD in system and 4 GB RAM there is no storage space problem.

did you try to repair the database? Specifically those tables? I was expecting that you had already tried this, but if you have not ...:

Code: Select all

mysqlcheck --auto-repair asterisk vicidial_live_agents -p

mysqlcheck --auto-repair asterisk vicidial_manager -p

unable to repair i tried these repair commands how i can save my db from frequent crash

reinstall your system onto a stable hardware base. i have never heard of a DB crashing unless the system was being powered off unexpectedly or had a HD that was dying. Do you reboot this system nightly? And do you do so by pulling out the power cord? LOL

did you tried repairing the whole db using the below command
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

unable to repair i tried these repair commands how i can save my db from frequent crash

> use a good branded server with intel xeon quad core 4 to 8gb ram.
> dont over load the server with more agents ,on a average use 20 to 30 agents in a single server.
> Proper shutdown to be done.
> Use Dual power supporter server and use UPS.
> store the recordings in another FTP server.
> do a daily backup during after office hours.