CDR Gets Lost

Home » Asterisk Users » CDR Gets Lost
Asterisk Users 1 Comment

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

——————————–

One thought on - CDR Gets Lost

  • 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@lists.digium.com] On Behalf Of Federico Sent: Tuesday, September 19, 2023 11:36 AM
    To: ‘Asterisk Users Mailing List – Non-Commercial Discussion’

    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

    ——————————–