<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,<div><br></div><div>I have managed to get values for duration, setup time, created fields. Now I would like to see the from/to party URI as well as how can I see these records in the CP?</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 style="margin: 0px; font-size: 11px; font-family: Menlo;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br></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 01-Jul-2014, at 6:36 pm, Maqbul Khan - Reform InfoTech <<a href="mailto:maqbul@reforminfotech.com">maqbul@reforminfotech.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><meta http-equiv="Content-Type" content="text/html charset=windows-1252"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Hi Miha,<div><br></div><div>Yes, path is correct, in fact MI commands are working fine from CLI only on portal it does not show. My major goal is to make CDR working, while reading manuals, i came to know dialog should be working and I checked on CLI everything is working fine.</div><div><br></div><div>In fact, ACC table is also getting records for each call, but CDR table does not update. CDR table was not there all these time, I recently created through script available in tools folder for CP.</div><div><br></div><div>Here are ACC table records:</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;">| 1695 | BYE | yWL6.hcBbHQuiCKVmdVZ6GhAZ7w44XVx | PmLWoZFFV1UdYTUw505Pb4yrEJ0r7M8i | mOk1S34qlptLGZdEOpnKJSVFJlTtonmt | 200 | OK | 2014-07-01 07:57:46 | 0 | 0 | 0 | NULL |</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">| 1694 | INVITE | yWL6.hcBbHQuiCKVmdVZ6GhAZ7w44XVx | PmLWoZFFV1UdYTUw505Pb4yrEJ0r7M8i | mOk1S34qlptLGZdEOpnKJSVFJlTtonmt | 200 | OK | 2014-07-01 07:57:25 | 0 | 0 | 0 | NULL |</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">| 1693 | BYE | Ci0RTq8YuHLqMrAXv6EZV2zUTDVvdAI2 | CTIzYMvWKN6.9g71x5qPUY3VUkYnmuxf | b1Dph4-FuxwaAWHyL-FaAPvB9uyNVdvg | 200 | OK | 2014-07-01 07:57:00 | 0 | 0 | 0 | NULL |</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">| 1692 | INVITE | Ci0RTq8YuHLqMrAXv6EZV2zUTDVvdAI2 | CTIzYMvWKN6.9g71x5qPUY3VUkYnmuxf | b1Dph4-FuxwaAWHyL-FaAPvB9uyNVdvg | 200 | OK | 2014-07-01 07:56:45 | 0 | 0 | 0 | NULL |</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">| 1691 | BYE </div></div><div><br></div><div>cdr_id, duration, setuptime & created all of them are 0 or null. Any thoughts?</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><div>On 30-Jun-2014, at 6:22 pm, Miha <<a href="mailto:miha@softnet.si">miha@softnet.si</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">
did you check if the path is right?<br>
<br>
<br>
miha<br>
<br>
<div class="moz-cite-prefix">Dne 6/30/2014 2:49 PM, piše Maqbul Khan
- Reform InfoTech:<br>
</div>
<blockquote cite="mid:28D6A1DA-D2EB-4F6C-9FD5-8F02C8638DEE@reforminfotech.com" type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
Hello,
<div><br>
</div>
<div>I have setup opensips in a normal way, but when I check
Dialog in OpenSIPS Control Panel, it says <span style="background-color: rgb(233, 236, 239); font-family:
Verdana, Arial, Helvetica, sans-serif; text-align:
-webkit-center;">Array ( [0] => sorry -- cannot open write
fifo )</span></div>
<div><br>
</div>
<div>Also, when I try to do tail /tmp/opensips_fifo it does not
show anything. Can anyone help with this? My main goal is to
make CDRs working. I can see CDR fetch query is done fine on
the admin portal, but as far as I have read, dialog module
should be working for this.</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>Reform InfoTech</div>
<div>
<div><br>
</div>
</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><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/devel">http://lists.opensips.org/cgi-bin/mailman/listinfo/devel</a><br></blockquote></div><br></div></div></blockquote></div><br></div></body></html>