[asterisk-users] CDR gets lost

[TTT]

Yes - update your my.conf to increase the timeouts by a large amount, then
restart mysql daemon.  Here's some details:

 

https://telium.io/en/topic/mysql-server-has-gone-away/

 

 

From: asterisk-users [mailto:asterisk-users-bounces at lists.digium.com] On
Behalf Of Federico
Sent: Tuesday, September 19, 2023 11:36 AM
To: 'Asterisk Users Mailing List - Non-Commercial Discussion'
<asterisk-users at lists.digium.com>
Subject: [asterisk-users] CDR gets lost

 

I noticed that of Asterisk is idle many hours, then the CDR (with
batch=yes) does not get written to the MySQL database anymore. Is there a
keepalive command for ODBC? 

 

cdr show status

 

Call Detail Record (CDR) settings

----------------------------------

  Logging:                    Enabled

  Mode:                       Simple

  Log calls by default:       Yes

  Log unanswered calls:       Yes

  Log congestion:             Yes

 

  Ignore bridging changes:    No

 

  Ignore dial state changes:  No

 

* Registered Backends

  -------------------

    Adaptive ODBC

    cdr_manager (suspended) 

    cdr-custom

    csv 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20230919/bea261ce/attachment.html>