[asterisk-dev] Lost Query with MySQL

[Kaloyan Kovachev]

do you ping the connection (if it is allready established) to MySQL before the
next query is executed?

interactive_timeout and wait_timeout in my.cnf may also help to keep the
connection up longer, but you should definately check if the connection is
gone and resetup it.

On Thu, 22 Mar 2007 19:56:43 -0500, C. Savinovich wrote
> Hello everyone, I am writing a C module that uses a SELECT query to a 
> mysql server upon starting a phone call...  somehow the query works the 
> first time or two, afterwards, it doen't, although connection is still 
> on...  any hints or guesses will be appreciated
> 
> CS
> 
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
> 
> asterisk-dev mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-dev