On Thu, Apr 28, 2011 at 11:09 AM, Rizwan Hisham <[email protected]>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: [email protected] > 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
-- _____________________________________________________________________ -- 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
