[asterisk-users] odbc error - server is gone

[Sherwood McGowan]

On Thu, Apr 28, 2011 at 11:09 AM, Rizwan Hisham <rizwanhasham at gmail.com>wrote:

> 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
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>               http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>


do you have "sanitysql => select 1" configured in res_odbc.ini?

-- 
Sherwood McGowan
Telecommunications and VOIP Consultant
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110428/08663c72/attachment.htm>