[Asterisk-Users] CDR MySQL

[Steve Davies]

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
>
>