On Wednesday 21 May 2008 19:03:25 Douglas Garstang wrote: > On Wednesday, May 21, 2008 4:39:24 PM, Tilghman Lesher wrote: > > On Wednesday 21 May 2008 17:02:07 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? > > > > Please check the 'idlecheck' option in res_odbc.conf. > > Looks like an Asterisk 1.4 option?
Correct; it's actually a workaround for a bug in the MySQL drivers. It was discovered long after 1.2 was end-of-lifed. -- Tilghman _______________________________________________ -- 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
