CDR gets lost
"Federico" <[email protected]> Tue, 19 Sep 2023 11:36:21 -0400
| Newsgroups | gmane.comp.telephony.pbx.asterisk.user |
|---|---|
| Message-ID | <[email protected]> |
This is a multipart message in MIME format.
--===============4727412595992089123==
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_00C4_01D9EAED.8833DFB0"
Content-Language: en-us
This is a multipart message in MIME format.
------=_NextPart_000_00C4_01D9EAED.8833DFB0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
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_00C4_01D9EAED.8833DFB0
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=3D"Content-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-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@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>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_00C4_01D9EAED.8833DFB0--
--===============4727412595992089123==
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=
--===============4727412595992089123==--