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