<div class="gmail_quote">On Thu, Apr 28, 2011 at 11:09 AM, Rizwan Hisham <span dir="ltr"><<a href="mailto:rizwanhasham@gmail.com">rizwanhasham@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi list,<br>yesterday I converted my voicemail.conf to realtime voicemail and also configured to store the voicemessages in a database using odbc as described <a href="http://www.voip-info.org/wiki/view/Asterisk+RealTime+Voicemail" target="_blank">here</a> and <a href="http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage" target="_blank">here</a>.<br>
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;<br>
<br><div style="margin-left:40px">[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)<br>
[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)<br>[Apr 28 11:40:54] WARNING[24676]: app_voicemail.c:2239 inboxcount: SQL Execute error!<br>
[SELECT COUNT(*) FROM voicemessages WHERE dir = '/var/spool/asterisk/voicemail/default/1757XXXXXXX/INBOX']<br></div><br clear="all">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.<br>
<br>Any ideas?<br><br>-- <br><font color="#888888"><div>Best Ragards</div><div>Rizwan Qureshi</div><div>VoIP/Asterisk Engineer</div><div>Axvoice Inc.<br><br></div>
<div>V: +92 (0) 3333 6767 26</div><div>E: <a href="mailto:rizwanhasham@gmail.com" target="_blank">rizwanhasham@gmail.com</a></div><div>W: <a href="http://www.axvoice.com/" target="_blank">www.axvoice.com</a></div></font><br>
<br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br><br>do you have "sanitysql => select 1" configured in res_odbc.ini?<br clear="all">
<br>-- <br>Sherwood McGowan<br>Telecommunications and VOIP Consultant<br><br>