<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>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>
<p style="font-family: Calibri, Arial, Helvetica, sans-serif;"><br>
</p>
<p style="font-family: Calibri, Arial, Helvetica, sans-serif;"><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>
</div>
</body>
</html>