Re: CDR gets lost
TTT <[email protected]> Tue, 19 Sep 2023 15:51:56 +0000
| Newsgroups | gmane.comp.telephony.pbx.asterisk.user |
|---|---|
| Message-ID | <0100018aae241d1d-33d8a0ad-d44e-452e-8b3e-6e53ffd42cc4-000000@email.amazonses.com> |
This is a multipart message in MIME format. --===============3980744110442683683== Content-Type: multipart/alternative; boundary="----=_NextPart_000_07B5_01D9EAEF.B0A75560" Content-Language: en-us This is a multipart message in MIME format. ------=_NextPart_000_07B5_01D9EAEF.B0A75560 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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:[email protected]] On Behalf Of Federico Sent: Tuesday, September 19, 2023 11:36 AM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' <[email protected]> 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 ------=_NextPart_000_07B5_01D9EAEF.B0A75560 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <html xmlns:v=3D"urn:schemas-microsoft-com:vml" = xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" = xmlns=3D"http://www.w3.org/TR/REC-html40"><head><meta = http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"><meta name=3DGenerator content=3D"Microsoft Word 15 = (filtered medium)"><style><!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif;} a:link, span.MsoHyperlink {mso-style-priority:99; color:#0563C1; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:#954F72; text-decoration:underline;} span.EmailStyle17 {mso-style-type:personal; font-family:"Calibri",sans-serif; color:windowtext;} span.EmailStyle18 {mso-style-type:personal-reply; font-family:"Calibri",sans-serif; color:#1F497D;} .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;} div.WordSection1 {page:WordSection1;} --></style><!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--></head><body lang=3DEN-US = link=3D"#0563C1" vlink=3D"#954F72"><div class=3DWordSection1><p = class=3DMsoNormal><span style=3D'color:#1F497D'>Yes – update your = my.conf to increase the timeouts by a large amount, then restart mysql = daemon. Here’s some details:<o:p></o:p></span></p><p = class=3DMsoNormal><span = style=3D'color:#1F497D'><o:p> </o:p></span></p><p = class=3DMsoNormal><span style=3D'color:#1F497D'><a = href=3D"https://telium.io/en/topic/mysql-server-has-gone-away/">https://t= elium.io/en/topic/mysql-server-has-gone-away/</a><o:p></o:p></span></p><p= class=3DMsoNormal><span = style=3D'color:#1F497D'><o:p> </o:p></span></p><p = class=3DMsoNormal><span = style=3D'color:#1F497D'><o:p> </o:p></span></p><div><div = style=3D'border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in = 0in 0in'><p class=3DMsoNormal><b>From:</b> asterisk-users = [mailto:[email protected]] <b>On Behalf Of = </b>Federico<br><b>Sent:</b> Tuesday, September 19, 2023 11:36 = AM<br><b>To:</b> 'Asterisk Users Mailing List - Non-Commercial = Discussion' <[email protected]><br><b>Subject:</b> = [asterisk-users] CDR gets lost<o:p></o:p></p></div></div><p = class=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal>I noticed = that of Asterisk is idle many hours, then the CDR (with = batch=3Dyes) does not get written to the MySQL database anymore. Is = there a keepalive command for ODBC? <o:p></o:p></p><p = class=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal>cdr show = status<o:p></o:p></p><p class=3DMsoNormal><o:p> </o:p></p><p = class=3DMsoNormal>Call Detail Record (CDR) settings<o:p></o:p></p><p = class=3DMsoNormal>----------------------------------<o:p></o:p></p><p = class=3DMsoNormal> = Logging:  = ; = Enabled<o:p></o:p></p><p class=3DMsoNormal> = Mode: &n= bsp; = Simple<o:p></o:p></p><p class=3DMsoNormal> Log calls by = default: Yes<o:p></o:p></p><p = class=3DMsoNormal> Log unanswered = calls: Yes<o:p></o:p></p><p = class=3DMsoNormal> Log = congestion: &n= bsp; Yes<o:p></o:p></p><p = class=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal> = Ignore bridging changes: No<o:p></o:p></p><p = class=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal> = Ignore dial state changes: No<o:p></o:p></p><p = class=3DMsoNormal><o:p> </o:p></p><p class=3DMsoNormal>* Registered = Backends<o:p></o:p></p><p class=3DMsoNormal> = -------------------<o:p></o:p></p><p = class=3DMsoNormal> Adaptive ODBC<o:p></o:p></p><p = class=3DMsoNormal> cdr_manager (suspended) = <o:p></o:p></p><p = class=3DMsoNormal> cdr-custom<o:p></o:p></p><p = class=3DMsoNormal> csv = <o:p></o:p></p></div></body></html> ------=_NextPart_000_07B5_01D9EAEF.B0A75560-- --===============3980744110442683683== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: inline LS0gCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fXwotLSBCYW5kd2lkdGggYW5kIENvbG9jYXRpb24gUHJvdmlkZWQgYnkg aHR0cDovL3d3dy5hcGktZGlnaXRhbC5jb20gLS0KCkNoZWNrIG91dCB0aGUgbmV3IEFzdGVyaXNr IGNvbW11bml0eSBmb3J1bSBhdDogaHR0cHM6Ly9jb21tdW5pdHkuYXN0ZXJpc2sub3JnLwoKTmV3 IHRvIEFzdGVyaXNrPyBTdGFydCBoZXJlOgogICAgICBodHRwczovL3dpa2kuYXN0ZXJpc2sub3Jn L3dpa2kvZGlzcGxheS9BU1QvR2V0dGluZytTdGFydGVkCgphc3Rlcmlzay11c2VycyBtYWlsaW5n IGxpc3QKVG8gVU5TVUJTQ1JJQkUgb3IgdXBkYXRlIG9wdGlvbnMgdmlzaXQ6CiAgIGh0dHA6Ly9s aXN0cy5kaWdpdW0uY29tL21haWxtYW4vbGlzdGluZm8vYXN0ZXJpc2stdXNlcnM= --===============3980744110442683683==--