call_log_export.pl error

[tgalan]

Hello guys

System:
Vicibox 6.0.3 Cluster
1xDB/Web Server: Intel(R) Xeon(R) CPU E5-1620 0 @ 3.60GHz. 64GB Ram 678 GB HDD: 2x Asterisk Server: Intel(R) Xeon(R) CPU E5-1620 0 @ 3.60GHz. 16GB 128GB HDD.

Trying to Run the AST_call_log_export.pl I'm having the bellow errors. I checked the max_connections variable for Msql: 768 and the wait_timeout is set to 28800.

I tried also commented those 2 lines on the scripts but at the end, the same result, the file doesn't get any information.

Checked permissions on the /srv/www/htdocs/vicidial/server_reports/ and set it to 777.

Any advice on what to do??

-- AST_call_log_export.pl --

This program is designed to gather all outbound calls and post them to a file.

Campaign: TESTCAMP vicidial_log.campaign_id NOT IN('')
Output Format: ndcad14csv


----- SQL CONVERT_TZ: -5:00|-5:00 '-5:00','-5:00' -----

DBD::mysql::db do failed: MySQL server has gone away at /usr/share/astguiclient/AST_call_log_export.pl line 495.
DBD::mysql::db do failed: MySQL server has gone away at /usr/share/astguiclient/AST_call_log_export.pl line 501.
CALLS EXPORT FOR 2015-07-31: calls20150730.csv
TOTAL CALLS: 8205284
script execution time in seconds: 222 minutes: 3.7

[mflorell]

Not really sure what the problem could be. I just tested it on a newer vicibox install and I did not receive any errors.

Have you tried running it with the --debugX flag?

[tgalan]

this is the error on the debugX

DBD::mysql::st execute failed: MySQL server has gone away at /usr/share/astguiclient/AST_call_log_export.pl line 458.
executing: select CONVERT_TZ(event_time,'-5:00','-5:00'),vicidial_list.phone_number,vendor_lead_code,vicidial_agent_log.status,vicidial_agent_log.user,first_name,last_name,vicidial_list.lead_id,vicidial_list.list_id,campaign_id,talk_sec,vicidial_list.source_id,dead_sec,agent_log_id from vicidial_list,vicidial_agent_log where vicidial_agent_log.campaign_id NOT IN('') and processed='N' and vicidial_agent_log.lead_id=vicidial_list.lead_id and vicidial_agent_log.status NOT IN('DROP','XDROP','NA','AA','AM','AL','AB','ADC','PU','PM','SVYEXT','SVYVM','SVYHU','SVYREC','HXFER','HOLDTO','QVMAIL','RQXFER','CPDATB','CPDB','CPDNA','CPDREJ','CPDINV','CPDSUA','CPDSI','CPDSNC','CPDSR','CPDSUK','CPDSV','CPDUK','CPDERR','TIMEOT','AFTHRS','NANQUE','INCALL','','QUEUE','MAXCAL') order by event_time; MySQL server has gone away at /usr/share/astguiclient/AST_call_log_export.pl line 458.

[mflorell]

I haven't had that problem before,

Here are some reasons why you might be getting that error:

https://dev.mysql.com/doc/refman/5.0/en/gone-away.html

[tgalan]

Thanks, let me see if I can follow a couple of this. Will reply back....

[williamconley]

How did you install your vicidial? Which .iso? How did you cluster?

Is the DB Server a Vicibox install or a "generic" DB? (Dangerous ... always use Kumba's iso's to install all parts of Vicidial! LOL)

[tgalan]

I used Vicibox v6.03 Install for all of them...

[williamconley]

Are the servers sharing a private network (without a router in the way)?