<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:Courier New,courier,monaco,monospace,sans-serif;font-size:10pt"><div style="font-family: Courier New,courier,monaco,monospace,sans-serif; font-size: 10pt;">I couldn't find one for cdr_mysql.conf.<br>We're using odbc anyway. MySQL directly might be an option if it works.<br>Don't think we want to modify the server.<br><br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Alex Balashov <abalashov@evaristesys.com><br>To: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users@lists.digium.com><br>Sent: Wednesday, May 21, 2008 3:02:07 PM<br>Subject: Re: [asterisk-users] Asterisk Database Handling<br><br>Douglas Garstang wrote:<br><br>> We are sending CDR's to MySQL via odbc. It seems that Asterisk is <br>> sometimes dropping CDR's, and they aren't
being sent to the database <br>> (they ARE in the Master.csv file though). We suspect that when the MySQL <br>> socket is idle, it gets disconnected, either by the MySQL server or by <br>> our firewall, and when Asterisk goes to send the next CDR over the <br>> socket, does not re-open the database, and drops that CDR. Possibly on <br>> the next call, it connects ok and sends the next CDR.<br><br>Isn't there a keepalive option somewhere for cdr_mysql.conf, or failing <br>that, a keepalive mechanism that can be enabled for TCP connections on <br>the server side?<br><br>-- <br>Alex Balashov<br>Evariste Systems<br>Web : <a href="http://www.evaristesys.com/" target="_blank">http://www.evaristesys.com/</a><br>Tel : (+1) (678) 954-0670<br>Direct : (+1) (678) 954-0671<br>Mobile : (+1) (706) 338-8599<br><br>_______________________________________________<br>-- Bandwidth and Colocation Provided by <a
href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></div></div></div><br>
</body></html>