[asterisk-users] Asterisk Database Handling

[Jay R. Ashworth]

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                      jra at baylink.com
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)