[asterisk-users] Asterisk Database Handling

[Douglas Garstang]

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 <abalashov at evaristesys.com>
To: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users at lists.digium.com>
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



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