[asterisk-users] Asterisk Database Handling

[Tilghman Lesher]

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