On Wed, May 21, 2008 at 06:02:07PM -0400, Alex Balashov wrote: > Douglas Garstang wrote: > > We are sending CDR's to MySQL via odbc. It seems that Asterisk is > > sometimes dropping CDR's, and they aren't being sent to the database > > (they ARE in the Master.csv file though). We suspect that when the MySQL > > socket is idle, it gets disconnected, either by the MySQL server or by > > our firewall, and when Asterisk goes to send the next CDR over the > > socket, does not re-open the database, and drops that CDR. Possibly on > > the next call, it connects ok and sends the next CDR. > > Isn't there a keepalive option somewhere for cdr_mysql.conf, or failing > that, a keepalive mechanism that can be enabled for TCP connections on > the server side?
In some recent mysql update, the behaviour with which it times out connections changed, and it bit some other project I follow as well; MythTV, I think. You might check their mailing list, Doug, for details. Cheers, -- jra -- Jay R. Ashworth Baylink [EMAIL PROTECTED] Designer The Things I Think RFC 2100 Ashworth & Associates http://baylink.pitas.com '87 e24 St Petersburg FL USA http://photo.imageinc.us +1 727 647 1274 Those who cast the vote decide nothing. Those who count the vote decide everything. -- (Joseph Stalin) _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users