Yes I have it there, here the content of the file: i think the code is buggy,
here is a comment from the function which generated the error (ast_odbc_smart_execute in res_odbc.c line 155 ) /* This is a really bad method of trying to correct a dead connection. It * only ever really worked with MySQL. It will not work with any other * database, since most databases prepare their statements on the server, * and if you disconnect, you invalidate the statement handle. Hence, if * you disconnect, you're going to fail anyway, whether you try to execute * a second time or not. */ This function is used all over. On Fri, Apr 29, 2011 at 12:23 AM, Sherwood McGowan < sherwood.mcgo...@gmail.com> wrote: > On Thu, Apr 28, 2011 at 11:09 AM, Rizwan Hisham <rizwanhas...@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: rizwanhas...@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 > > > -- > _____________________________________________________________________ > -- 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 > -- Best Ragards Rizwan Qureshi VoIP/Asterisk Engineer Axvoice Inc. V: +92 (0) 3333 6767 26 E: rizwanhas...@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