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-boun...@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@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
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users