<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Hi Vlad,<div><br></div><div>I’m using 1.9 of OpenSIPS. I’m not sure what I’m using. By default there was no CDR table in the database, and all CDRs used to even now in ACC table only. Later on i tried to create CDR table and import store procedure, but still it is not working. How can I check what is in use? How can I check if OpenSIPS is using single entry per call?</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><div>On 07-Jul-2014, at 3:26 pm, Vlad Paiu <<a href="mailto:vladpaiu@opensips.org">vladpaiu@opensips.org</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">
<meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type">
<div 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="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="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="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="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>
</div>
_______________________________________________<br>Devel mailing list<br><a href="mailto:Devel@lists.opensips.org">Devel@lists.opensips.org</a><br>http://lists.opensips.org/cgi-bin/mailman/listinfo/devel<br></blockquote></div><br></div></body></html>