[Asterisk-Users] CDR MySQL

[Jozeph Brasil]

Hi Steve,

Thank you for reply! :) Do you know if anyone have been patched to solve this?

Quoting Steve Davies <davies147 at gmail.com>:

> I do not know for sure, but in my experience, the most common cause of
> this error is an application which assumes a database connection will
> stay open forever.
>
> Some MySQL installs have a timeout on idle connections. It should be
> possible to set this to a very-long or infinite timeout.
>
> Hope that helps,
> Steve
>
> On 10/5/05, Jozeph Brasil <jozeph at globalmedia.com.br> wrote:
>>
>>
>>
>> Hi Asteriskers!
>>
>>
>>
>> I've enable CDR to store data on a remote machine using MySQL. But I have a
>> problem. Analyzing the log, I see some ERROR messages as:
>>
>>
>>
>>     -- SIP/21-3787 is ringing
>>
>>   == Spawn extension (default, 21, 1) exited non-zero on 'SIP/21-ce14'
>>
>> Oct  5 13:22:54 ERROR[8576]: cdr_addon_mysql.c:161 mysql_log: cdr_mysql:
>> Unknown connection error: (2013) Lost connection to MySQL server during
>> query
>>
>>
>>
>> This occurs every time that extension hangs up the call. Anyone know why
>> asterisk lost connection during query?
>> _______________________________________________
>> --Bandwidth and Colocation sponsored by Easynews.com --
>>
>> Asterisk-Users mailing list
>> Asterisk-Users at lists.digium.com
>> http://lists.digium.com/mailman/listinfo/asterisk-users
>> To UNSUBSCRIBE or update options visit:
>>
>> http://lists.digium.com/mailman/listinfo/asterisk-users
>>
>>
> _______________________________________________
> --Bandwidth and Colocation sponsored by Easynews.com --
>
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>