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