vicidial.org

by **bobbymc** » Mon Apr 21, 2008 4:48 pm

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.

by **mflorell** » Mon Apr 21, 2008 6:41 pm

what is your mysql timeout set to?

MySQL version?

astGUIclient version?

by **bobbymc** » Mon Apr 21, 2008 6:44 pm

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

by **mflorell** » Mon Apr 21, 2008 6:46 pm

mysqladmin variables

wait_timeout

MySQL version?

astGUIclient version?

How is this a development question?

by **bobbymc** » Mon Apr 21, 2008 6:48 pm

mysql version 5.0.32

# AST_VDauto_dial.pl version 0.12 *DBI-version*

im using a older version 2.0.2 i belive..

by **bobbymc** » Mon Apr 21, 2008 6:49 pm

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

by **bobbymc** » Mon Apr 21, 2008 6:51 pm

| wait_timeout | 28800

by **mflorell** » Mon Apr 21, 2008 10:33 pm

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

by **bobbymc** » Tue Apr 22, 2008 12:38 am

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

by **mflorell** » Tue Apr 22, 2008 2:16 am

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.

by **bobbymc** » Mon Jun 02, 2008 1:04 pm

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

by **mflorell** » Mon Jun 02, 2008 4:07 pm

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.

vicidial.org

AST_VDauto_dial.pl keeps getting dropped by mysql..

AST_VDauto_dial.pl keeps getting dropped by mysql..

Who is online