[asterisk-users] Asterisk Database Handling

[Douglas Garstang]

Looks like an Asterisk 1.4 option?


----- Original Message ----
From: Tilghman Lesher <tilghman at mail.jeffandtilghman.com>
To: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users at lists.digium.com>
Sent: Wednesday, May 21, 2008 4:39:24 PM
Subject: Re: [asterisk-users] Asterisk Database Handling

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



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20080521/48e80bfc/attachment.htm