<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Ok Faheem.</p>
<p><br>
</p>
<p>Thank you very much. I will take a look at those documentations.</p>
<p><br>
</p>
<p>Regards.</p>
<p><br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">RODRIGO PIMENTA CARVALHO<br>
Inatel Competence Center<br>
Software<br>
Ph: +55 35 3471 9200 RAMAL 979<br>
</div>
</font></div>
</div>
</div>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>De:</b> users-bounces@lists.opensips.org <users-bounces@lists.opensips.org> em nome de Faheem Muhammad <faheem2084@gmail.com><br>
<b>Enviado:</b> segunda-feira, 14 de setembro de 2015 15:40<br>
<b>Para:</b> OpenSIPS users mailling list<br>
<b>Assunto:</b> Re: [OpenSIPS-Users] What information about calls are kept by OpenSIPS and how to handle it?</font>
<div> </div>
</div>
<div>
<div dir="ltr">You can use acc module for #1 and 2
<div><a href="http://www.opensips.org/html/docs/modules/1.6.x/acc">http://www.opensips.org/html/docs/modules/1.6.x/acc</a></div>
<div>It does all type of call logs. you can find the details in the documentation.<br>
<div><br>
</div>
</div>
<div>Regarding #3, you can filter out different soft phone using predefined $ua (useragent field), but this UAC defined field can be manipulated by any intelligent subscriber. </div>
<div><br>
</div>
<div>Regarding #4, I think this is not possible using MI interface, you can write any external script to connect to db and use MI commands. </div>
<div><br>
</div>
<div><br>
</div>
<div>Regards,</div>
<div>Muhammad Faheem</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Mon, Sep 14, 2015 at 11:03 PM, Rodrigo Pimenta Carvalho
<span dir="ltr"><<a href="mailto:pimenta@inatel.br" target="_blank">pimenta@inatel.br</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
<div dir="ltr">
<div style="font-size:12pt; color:#000000; background-color:#ffffff; font-family:Calibri,Arial,Helvetica,sans-serif">
<p>Dear OpenSIPS-Users,</p>
<p><br>
</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">I have some doubts about recording calls information on the OpenSIPs database:</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif"><br>
</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">1. Letīs suppose OpenSIPS is version 2.2 and it is using SQLite. After receiving a SIP INVITE, or SIP OK, or SIP CANCEL, etc, does OpenSIPS record information about the call? For example: who has called,
when the call was originated, who was called, missed calls, answered calls, dialed calls, dialed numbers? The software we are building must list the record of past calls. So the needing of keeping and retrieving such kind of information.</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif"><br>
</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">2 What are the tables in the OpenSIPS SQLite DB that keep such information? I have analyzed some tables in my OpenSIPS and I have noticed that some of it still remain empty even after some calls. </p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif"><br>
</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">3. In my project there are 3 kinds of SIP clients (softphones for door bells, for ordinary users, for special users). Only calls originated from a specific set of softphones must have information recorded
in the database. How to configure OpenSIPS to record only calls from such softphoes?</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif"><br>
</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">I will start today studying about MI interface.</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">4. Does such interface provide some way to read data from the OpenSIPS SQLite Database, so that I can use it in a external script? </p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif"><br>
</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">Any hint will be very helpful!</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">Best regards.</p>
<span class="HOEnZb"><font color="#888888">
<p style="font-family:Calibri,Arial,Helvetica,sans-serif"><br>
</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif"><br>
</p>
<div>
<div name="divtagdefaultwrapper">
<div><font size="2">
<div>RODRIGO PIMENTA CARVALHO<br>
Inatel Competence Center<br>
Software<br>
Ph: <a href="tel:%2B55%2035%203471%209200" value="+553534719200" target="_blank">
+55 35 3471 9200</a> RAMAL 979<br>
</div>
</font></div>
</div>
</div>
</font></span></div>
</div>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</body>
</html>