<div dir="ltr">Isql is a process by which you can test your ODBC connection without calling to asterisk. Just one line command to test the ODBC connectivity.<br><br><pre class="screen" id="I_programlisting12_tt1456"><font size="2"><strong style="font-family: verdana,sans-serif;" class="userinput"><code></code></strong><font size="4"><span style="font-family: verdana,sans-serif;">echo "select 1" | isql -v <b>asterisk-connector</b></span></font></font><br>
</pre> here<font size="2"><font size="4"><span style="font-family: verdana,sans-serif;"> asterisk-connector</span></font></font>
is your OBDC connection name.<br><br><br><div class="gmail_quote">On Sun, May 1, 2011 at 12:10 PM, Rizwan Hisham <span dir="ltr"><<a href="mailto:rizwanhasham@gmail.com">rizwanhasham@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">isql?<div><div></div><div class="h5"><br><br><div class="gmail_quote">On Sat, Apr 30, 2011 at 6:18 PM, Pezhman Lali <span dir="ltr"><<a href="mailto:lopl@lopl.net" target="_blank">lopl@lopl.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
check your odbc connection with isql<div><br></div><div>best<div><div></div><div><br><div><br><br><div class="gmail_quote">On Fri, Apr 29, 2011 at 9:33 PM, Warren Selby <span dir="ltr"><<a href="mailto:wcselby@selbytech.com" target="_blank">wcselby@selbytech.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div bgcolor="#FFFFFF"><div>You're using 1.4.2. Why not try upgrading to a more recent release of 1.4 (I believe 1.4.41 is current) and see if your issue has been resolved. </div>
<div><br>Thanks,<div>--Warren Selby, dCAP</div></div><div><div></div><div><div><br>On Apr 29, 2011, at 7:32 AM, Rizwan Hisham <<a href="mailto:rizwanhasham@gmail.com" target="_blank">rizwanhasham@gmail.com</a>> wrote:<br>
<br></div><div></div><blockquote type="cite"><div>Yes I have it there, here the content of the file:<br><br>i think the code is buggy,<br><br>here is a comment from the function which generated the error (ast_odbc_smart_execute in res_odbc.c line 155 )<br>
<br>/* This is a really bad method of trying to correct a dead connection. It<br>
* only ever really worked with MySQL. It will not work with any other<br> * database, since most databases prepare their statements on the server,<br> * and if you disconnect, you invalidate the statement handle. Hence, if<br>
* you disconnect, you're going to fail anyway, whether you try to execute<br> * a second time or not.<br> */<br><br>This function is used all over.<br><br><div class="gmail_quote">On Fri, Apr 29, 2011 at 12:23 AM, Sherwood McGowan <span dir="ltr"><<a href="mailto:sherwood.mcgowan@gmail.com" target="_blank"></a><a href="mailto:sherwood.mcgowan@gmail.com" target="_blank">sherwood.mcgowan@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="gmail_quote"><div><div></div><div>On Thu, Apr 28, 2011 at 11:09 AM, Rizwan Hisham <span dir="ltr"><<a href="mailto:rizwanhasham@gmail.com" target="_blank"></a><a href="mailto:rizwanhasham@gmail.com" target="_blank">rizwanhasham@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div>
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: <a href="tel:%2B92%20%280%29%203333%206767%2026" value="+923333676726" target="_blank">+92 (0) 3333 6767 26</a></div><div>E: <a href="mailto:rizwanhasham@gmail.com" target="_blank"></a><a href="mailto:rizwanhasham@gmail.com" target="_blank">rizwanhasham@gmail.com</a></div>
<div>W: <a href="http://www.axvoice.com/" target="_blank"></a><a href="http://www.axvoice.com" target="_blank">www.axvoice.com</a></div></font><br>
<br></div></div>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank"></a><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"></a><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"></a><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">
<font color="#888888">
<br>-- <br>Sherwood McGowan<br>Telecommunications and VOIP Consultant<br><br>
</font><br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank"></a><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"></a><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"></a><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 clear="all"><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: <a href="tel:%2B92%20%280%29%203333%206767%2026" value="+923333676726" target="_blank">+92 (0) 3333 6767 26</a></div><div>E: <a href="mailto:rizwanhasham@gmail.com" target="_blank"></a><a href="mailto:rizwanhasham@gmail.com" target="_blank">rizwanhasham@gmail.com</a></div>
<div>W: <a href="http://www.axvoice.com/" target="_blank"></a><a href="http://www.axvoice.com" target="_blank">www.axvoice.com</a></div>
</font><br>
</div></blockquote><blockquote type="cite"><div><span>--</span><br><span>_____________________________________________________________________</span><br><span>-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --</span><br>
<span>New to Asterisk? Join us for a live introductory webinar every Thurs:</span><br><span> <a href="http://www.asterisk.org/hello" target="_blank"></a><a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a></span><br>
<span></span><br><span>asterisk-users mailing list</span><br><span>To UNSUBSCRIBE or update options visit:</span><br><span> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank"></a><a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a></span></div>
</blockquote></div></div></div><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></div></div></div></div>
<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 clear="all"><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>
</div></div><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 clear="all"><br>-- <br><div dir="ltr"><br><br>
<br>-----<br>Thanks and regards<br><br> Virendra Bhati<br>+91-9172341457<br></div><br>
</div>