<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hello,<br>
<br>
What OpenSIPS version are you using ?<br>
<br>
Are you using the CDR account within OpenSIPS ( which generates a
single CDR entry per call ), or the old type of accounting ( which
uses a MySQL stored procedure to merge the two INVITE & BYE
entries per call ) ?<br>
<br>
I see the 1704 entry is a full CDR, with duration, setuptime and
created fields populated.<br>
<br>
Best Regards,<br>
<pre class="moz-signature" cols="72">Vlad Paiu
OpenSIPS Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a> </pre>
On 04.07.2014 13:48, Maqbul Khan - Reform InfoTech wrote:<br>
</div>
<blockquote
cite="mid:E1E9A071-DA40-4174-828A-04010A5D821C@reforminfotech.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
Hello,
<div><br>
</div>
<div>I am having issue with OpenSIPS does not populate any CDRs in
CDR table. I could see records with limited fields in ACC
table. Here is an example of ACC table. Can anyone help me
make CDR table working please?</div>
<div><br>
</div>
<div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">mysql>
select * from acc order by Id desc limit 0,10;</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">+------+--------+----------------------------------+----------------------------------+----------------------------------+----------+------------+---------------------+--------+----------+-----------+---------------------+</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">|
id | method | from_tag | to_tag
| callid |
sip_code | sip_reason | time | cdr_id |
duration | setuptime | created |</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">+------+--------+----------------------------------+----------------------------------+----------------------------------+----------+------------+---------------------+--------+----------+-----------+---------------------+</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">|
1705 | BYE | caAP1nQWLr69ppVbHAOzQB3N7tUg6LFe | 9726134b
| NTw0aWGotkTFiWkbnRVAgWBLpLoHQco6 |
200 | OK | 2014-07-01 09:15:33 | 0 |
0 | 0 | NULL |</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">|
1704 | INVITE | caAP1nQWLr69ppVbHAOzQB3N7tUg6LFe | 9726134b
| NTw0aWGotkTFiWkbnRVAgWBLpLoHQco6 |
200 | OK | 2014-07-01 09:15:16 | 0 |
16 | 3 | 2014-07-01 09:15:13 |</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">|
1703 | BYE |</div>
</div>
<div><br>
<div apple-content-edited="true">
<div style="color: rgb(0, 0, 0); letter-spacing: normal;
orphans: auto; text-align: start; text-indent: 0px;
text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
word-wrap: break-word; -webkit-nbsp-mode: space;
-webkit-line-break: after-white-space;">
<div style="color: rgb(0, 0, 0); font-family: Helvetica;
font-style: normal; font-variant: normal; font-weight:
normal; letter-spacing: normal; line-height: normal;
orphans: 2; text-align: -webkit-auto; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
word-wrap: break-word; -webkit-nbsp-mode: space;
-webkit-line-break: after-white-space;">
<div style="color: rgb(0, 0, 0); font-family: Helvetica;
font-style: normal; font-variant: normal; font-weight:
normal; letter-spacing: normal; line-height: normal;
orphans: 2; text-align: -webkit-auto; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
word-wrap: break-word; -webkit-nbsp-mode: space;
-webkit-line-break: after-white-space;">
<div style="color: rgb(0, 0, 0); font-family: Helvetica;
font-style: normal; font-variant: normal; font-weight:
normal; letter-spacing: normal; line-height: normal;
orphans: 2; text-align: -webkit-auto; text-indent:
0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; word-wrap: break-word;
-webkit-nbsp-mode: space; -webkit-line-break:
after-white-space;">
<div>Maqbul A Khan</div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Devel@lists.opensips.org">Devel@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/devel">http://lists.opensips.org/cgi-bin/mailman/listinfo/devel</a>
</pre>
</blockquote>
<br>
</body>
</html>