No leads in hopper

[ilovevici]

My main server broke. I took the hard drive out of the broken server and put it in a spare server (exact same model #, same specs, same everything).

I ran the IP update script, rebooted, then went into the Admin area to change the IP in the System Settings and Servers pages to the new ip. I then tried to login to a campaign as an agent, and it said no leads in hopper.

I've checked filter settings, and made sure 24 hour access is permitted, there are dialable leads, but for some reason whenever I reset the hopper, it doesn't load the leads into the hopper (the config was working when the HD was in the broken server, so the settings didn't change so it should work for this identical server).

I've ran the "/usr/share/astguiclient/AST_VDhopper.pl --debug", and this is what I get - was hoping someone had encountered this and/or might know what to suggest:

----- DEBUG -----

TIME DEBUG: -5.00|-4|1| GMT: 01:33
SELECT list_id FROM vicidial_lists where ( (active='N') or ( (active='Y') and (expiration_date < "2014-10-07") ) );Inactive Lists: 0
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2014-10-07 21:33:49' and status='ACTIVE';|
hopper DNC count: 0
---------------Auto Trim Hopper Enabled For 9000---------------------
Leads in Hopper for this Campaign = 0
Hopper Level for this Campaign = 20

---------------Auto Trim Hopper Enabled For 9002---------------------
Leads in Hopper for this Campaign = 0
Hopper Level for this Campaign = 20

DBD::mysql::st execute failed: Incorrect file format 'vicidial_live_agents' at /usr/share/astguiclient/AST_VDhopper.pl line 963.
executing: SELECT COUNT(*) FROM vicidial_live_agents WHERE campaign_id='9003' and status IN ('READY','QUEUE','INCALL','CLOSER') and last_update_time >= '1969-12-31 16:33:34' Incorrect file format 'vicidial_live_agents' at /usr/share/astguiclient/AST_VDhopper.pl line 963.
You have new mail in /var/mail/root

[striker]

try to repair the mysql using the below command and then check...

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

[ilovevici]

Thanks - I did the command in ssh and this was what came back:

Error: mysqlcheck doesn't support multiple contradicting commands.
You have new mail in /var/mail/root

[ilovevici]

I also ran the following: "mysqlcheck -u root -p --auto-repair --check --all-databases", and I ended up getting this:

Repairing tables
asterisk.vicidial_live_agents
Error : Incorrect file format 'vicidial_live_agents'
error : Corrupt
asterisk.vicidial_manager
Error : Incorrect file format 'vicidial_manager'
error : Corrupt

Is there anything further I can to do attempt to get these tables back, or maybe some way to reinstall these tables only? I'm trying whatever I can to avoid having to do a complete reinstall.

[boybawang]

you will need to do a lowlevel repair, heres what you have to do:

Step 1: shutdown mysql
Step 2: cd /var/lib/mysql/asterisk/
Step 3: run: myisamchk -o *.MYI

[boybawang]

or myisamchk -r *.MYI when your under /var/lib/mysql/asterisk/

[ilovevici]

Thanks - I tried running both. When I looked in the detailed log regarding what it did to the two corrupt tables in question it said this:
---------
myisamchk: error: 'vicidial_live_agents.MYI' is not a MyISAM-table
---------
myisamchk: error: 'vicidial_manager.MYI' is not a MyISAM-table

Hopefully there's somethign else I can try out before having to do a complete reinstall

[boybawang]

did you shutdown mysql first? also here are some repair options of myisamchk feel free to try all of them

http://dev.mysql.com/doc/refman/5.1/en/ ... tions.html