[asterisk-users] odbc error - server is gone

[Rizwan Hisham]

Hi list,
yesterday I converted my voicemail.conf to realtime voicemail and also
configured to store the voicemessages in a database using odbc as described
here <http://www.voip-info.org/wiki/view/Asterisk+RealTime+Voicemail> and
here <http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage>.
I am using asterisk 1.4.2 with mysql. I also installed the proper odbc
driver for mysql on the server. I successfully completed the conversion of a
lot of voicemail users into db yesterday. But today on the CLI thsi error
was showing;

[Apr 28 11:40:54] WARNING[24676]: res_odbc.c:147 ast_odbc_smart_execute: SQL
Execute returned an error -1: 08S01: [MySQL][ODBC 3.51
Driver][mysqld-5.0.68-log]MySQL server has gone away (70)
[Apr 28 11:40:54] WARNING[24676]: res_odbc.c:147 ast_odbc_smart_execute: SQL
Execute returned an error -1: 08S01: [MySQL][ODBC 3.51
Driver][mysqld-5.0.68-log]MySQL server has gone away (70)
[Apr 28 11:40:54] WARNING[24676]: app_voicemail.c:2239 inboxcount: SQL
Execute error!
[SELECT COUNT(*) FROM voicemessages WHERE dir =
'/var/spool/asterisk/voicemail/default/1757XXXXXXX/INBOX']

I know that the error is caused due to stale odbc connection with mysql. But
i want to find out if there is a cure for it. Why the connection went stale
in the first place also.

Any ideas?

-- 
Best Ragards
Rizwan Qureshi
VoIP/Asterisk Engineer
Axvoice Inc.

V: +92 (0) 3333 6767 26
E: rizwanhasham at gmail.com
W: www.axvoice.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110428/b584d5b3/attachment.htm>