Douglas Garstang wrote: > I couldn't find one for cdr_mysql.conf. > We're using odbc anyway. MySQL directly might be an option if it works. > Don't think we want to modify the server. > > > ----- Original Message ---- > From: Alex Balashov <[EMAIL PROTECTED]> > To: Asterisk Users Mailing List - Non-Commercial Discussion > <[email protected]> > Sent: Wednesday, May 21, 2008 3:02:07 PM > Subject: Re: [asterisk-users] Asterisk Database Handling > > 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? > > -- > Alex Balashov > Evariste Systems > Web : http://www.evaristesys.com/ > Tel : (+1) (678) 954-0670 > Direct : (+1) (678) 954-0671 > Mobile : (+1) (706) 338-8599 > > _______________________________________________ > -- 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 > > ------------------------------------------------------------------------ > > _______________________________________________ > -- 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 I personally can tell you I've never had a problem with either the PostgreSQL or MySQL cdr apps themselves losing records. However, I can't say personally how well the ODBC method works. I'll just stick to saying that if you're considering using the cdr_mysql addon, I would highly suggest it as I've used it with MUCH success on high load servers.
Sherwood McGowan _______________________________________________ -- 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
