[asterisk-users] Asterisk Database Handling

[Al Baker]

OK - but when * goes to "insert" the CDR Record, if the MYSQL connection 
has "timed-out"
shouldn't the Interace (I guess the ODBC) return an ERROR condition, 
indicating that the
SQL command FAILED ?  Shouldn't * recognize that and either RETRY 
several times or LOG an Error ???

Jay R. Ashworth wrote:
> 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
>