[asterisk-users] odbc error - server is gone

Sun May 1 01:40:23 CDT 2011

isql?

On Sat, Apr 30, 2011 at 6:18 PM, Pezhman Lali <lopl at lopl.net> wrote:

> check your odbc connection with isql
>
> best
>
>
>
> On Fri, Apr 29, 2011 at 9:33 PM, Warren Selby <wcselby at selbytech.com>wrote:
>
>> 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.
>>
>> Thanks,
>> --Warren Selby, dCAP
>>
>> On Apr 29, 2011, at 7:32 AM, Rizwan Hisham <rizwanhasham at gmail.com>
>> wrote:
>>
>> 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.mcgowan at gmail.com>
>> sherwood.mcgowan at gmail.com> wrote:
>>
>>> On Thu, Apr 28, 2011 at 11:09 AM, Rizwan Hisham <<rizwanhasham at gmail.com>
>>> 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>rizwanhasham at gmail.com
>>>> W: <http://www.axvoice.com/>www.axvoice.com
>>>>
>>>>
>>>> --
>>>> _____________________________________________________________________
>>>> -- Bandwidth and Colocation Provided by <http://www.api-digital.com>
>>>> http://www.api-digital.com --
>>>> New to Asterisk? Join us for a live introductory webinar every Thurs:
>>>>               <http://www.asterisk.org/hello>
>>>> http://www.asterisk.org/hello
>>>>
>>>> asterisk-users mailing list
>>>> To UNSUBSCRIBE or update options visit:
>>>>   <http://lists.digium.com/mailman/listinfo/asterisk-users>
>>>> 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>
>>> http://www.api-digital.com --
>>> New to Asterisk? Join us for a live introductory webinar every Thurs:
>>>               <http://www.asterisk.org/hello>
>>> http://www.asterisk.org/hello
>>>
>>> asterisk-users mailing list
>>> To UNSUBSCRIBE or update options visit:
>>>   <http://lists.digium.com/mailman/listinfo/asterisk-users>
>>> http://lists.digium.com/mailman/listinfo/asterisk-users
>>>
>>
>>
>>
>> --
>> Best Ragards
>> Rizwan Qureshi
>> VoIP/Asterisk Engineer
>> Axvoice Inc.
>>
>> V: +92 (0) 3333 6767 26
>> E: <rizwanhasham at gmail.com>rizwanhasham at gmail.com
>> W: <http://www.axvoice.com/>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>
>> http://www.asterisk.org/hello
>>
>> asterisk-users mailing list
>> To UNSUBSCRIBE or update options visit:
>>    <http://lists.digium.com/mailman/listinfo/asterisk-users>
>> http://lists.digium.com/mailman/listinfo/asterisk-users
>>
>>
>> --
>> _____________________________________________________________________
>> -- 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
>>
>
>
> --
> _____________________________________________________________________
> -- 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: rizwanhasham at gmail.com
W: www.axvoice.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110501/9b155371/attachment.htm>