[asterisk-users] Asterisk Database Handling

[Sanjay Rajdev]

I had a similar problem, but in my case we had a custom application that was throwing an segmentation exception which was causing Asterisk to Restart. And in that case It use to miss the log in database. 
You can determine the same by looking at the UNIQUEID being logged for the call. The UNIQUEID actually comprises of 2 things DateTimeString.CallNumber , everytime Asterisk restarts CallNumber will start from 1. So you can check the 2-3 UNIQUEID before you missed entry in CDR table and 2-3 after the missed entry to determine if Asterisk Restarted. 
Other way is you can see the kernel logs to see if Asterisk has thrown any exception. they can be found on Linux at /var/log/messages 


Regards, 
Sanjay Rajdev 

----- Original Message ----- 
From: "Alex Balashov" <abalashov at evaristesys.com> 
To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users at lists.digium.com> 
Sent: Thursday, May 22, 2008 3:32:07 AM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi 
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/20080522/c54626bc/attachment.htm