vicidial.org

On my database server in /var/log/syslog i keep getting errors like this

Apr 21 14:40:25 capone mysqld[32735]: 080421 14:40:25 [Warning] Aborted connection 17451963 to db: 'asterisk' user: 'cron' host: 'asterisknode2 (Got an error reading communication packets)


I found out that its caused by this script on all asterisk nodes: /local_home/asterisk/AST_VDauto_dial.pl

This script connects to mysql and goes into a endless loop like its suppose to be. What happens is that after x mount of time mysql times out on it which causes a major issue in the entire system.. Im not sure if its a mysql setting that has to be changed or what but this is a major issue with the system.

what is your mysql timeout set to?

MySQL version?

astGUIclient version?

in my.cnf i dont see any timeout settings so i assume its using the default?

mysqladmin variables

wait_timeout



MySQL version?

astGUIclient version?

How is this a development question?

mysql version 5.0.32

# AST_VDauto_dial.pl version 0.12 *DBI-version*

im using a older version 2.0.2 i belive..

it took me a while to get allot of bugs worked out.. i really dont wanna upgrade as im happy with the version.. the only issue si have is the leave 3way and that the script keeps timing out

| wait_timeout | 28800

I believe that is fixed in a more recent version since as of 2.0.3 that script will check database setting periodically.

can you please find out which version so i can update it from there

I would recommend that up upgrade to at least 2.0.4 or possibly 2.0.4.1rc1 because of all of the bug fixes and new features since 2.0.2.

can you please point me out the major differenced? i been tryignt o devleop ont hsi sicne that version and made a allot of chnages i dont want to loose

There are a few hundred differences between 2.0.2 and 2.0.4.1rc2, most of which were to add new features and new functionality. You would have to do a DIFF of the code to get more information on the exact code changes.