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
——————————–
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
——————————–