<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>Hi Razvan.</p>
<p>I will check the log and let you know.</p>
<p>To run dlg_list have I to use MI or is there an way of running it via the OpenSIPS config file?</p>
<p>Thanks.</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 Răzvan Crainea <razvan@opensips.org><br>
<b>Enviado:</b> quinta-feira, 17 de setembro de 2015 09:32<br>
<b>Para:</b> users@lists.opensips.org<br>
<b>Assunto:</b> Re: [OpenSIPS-Users] Table dialog remains empty even after calls. Some error in my config file? Others tables are good.</font>
<div> </div>
</div>
<div><tt>Hi, Rodrigo!<br>
<br>
Are you seeing any errors in your logs related to sqlite not being able to insert dialogs in your database?<br>
Can you run a dlg_list while a call is on?<br>
<br>
Best regards,<br>
</tt>
<pre class="moz-signature" cols="72">Răzvan Crainea
OpenSIPS Solutions
<a class="moz-txt-link-abbreviated" href="http://www.opensips-solutions.com">www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 09/17/2015 03:26 PM, Rodrigo Pimenta Carvalho wrote:<br>
</div>
<blockquote type="cite">
<div id="divtagdefaultwrapper" style="font-size:12pt; color:#000000; background-color:#FFFFFF; font-family:Calibri,Arial,Helvetica,sans-serif">
<p><br>
</p>
<p><br>
</p>
<p>Hi.</p>
<p><br>
</p>
<p>Some days ago I got a help in this discussion list.</p>
<p>According to that help, the table that has information about dialled calls is acc.</p>
<p>So, I will read today about ACC and Dialog. I suspect that CDR information uses tables acc and dialog, due to the present fields (columns) in such tables.</p>
<p><br>
</p>
<p>Hopefully, I will see how to use such tables, making OpenSIPS record data there. Let's see...</p>
<p><br>
</p>
<p>Best regards.<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>
<a class="moz-txt-link-abbreviated" href="mailto:sisc-request@listas.inatel.br">sisc-request@listas.inatel.br</a>
<a class="moz-txt-link-rfc2396E" href="mailto:sisc-request@listas.inatel.br"><sisc-request@listas.inatel.br></a> em nome de Rodrigo Pimenta Carvalho
<a class="moz-txt-link-rfc2396E" href="mailto:pimenta@inatel.br"><pimenta@inatel.br></a><br>
<b>Enviado:</b> quarta-feira, 16 de setembro de 2015 17:34<br>
<b>Para:</b> OpenSIPS users mailling list<br>
<b>Assunto:</b> [sisc] Table dialog remains empty even after calls. Some error in my config file? Others tables are good.</font>
<div> </div>
</div>
<div>
<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>I'm using OpenSIPS 2.2 with SQLite, from <span dir="ltr"><font face="Calibri,Arial,Helvetica,sans-serif" color="black" size="3"><span style="font-size:12pt; background-color:white">commit 97ea216790a20e150d09314aeea360aa48a37b36.</span></font></span></p>
<p><br>
</p>
<p>I have noticed that my OpenSIPS is recording data only into the following tables:</p>
<p>- subscriber</p>
<p>- location</p>
<p>- missed_calls</p>
<p>-acc<br>
</p>
<p><br>
</p>
<p>I need make my OpenSIPS record data into table dialog too, as I need present the list of dialled calls in the GUI of my application. I intend to read dialled calls information from table dialog.</p>
<p>So, I suspect that maybe some configuration is wrong in my OpenSIPS environment.</p>
<p><br>
</p>
<p>In my opensips_residential.cfg file I have:</p>
<p><br>
</p>
<p><br>
</p>
<p>--------------------------------------------------------------------------------</p>
<p>#### DIALOG module<br>
loadmodule "dialog.so"<br>
modparam("dialog", "dlg_match_mode", 1)<br>
modparam("dialog", "db_mode", 1)<br>
modparam("dialog", "db_url", "sqlite:///usr/local/opensips_proxy/sqlite") <br>
modparam("dialog", "default_timeout", 540)</p>
<p>---------------------------------------------------------------------------------------</p>
<p><br>
</p>
<p>####### Routing Logic ########</p>
<p><br>
</p>
<p>.</p>
<p>.</p>
<p>.</p>
<p><br>
</p>
<p> # account only INVITEs<br>
if (is_method("INVITE")) {<br>
<br>
# create dialog with timeout<br>
if ( !create_dialog("B") ) {<br>
send_reply("500","Internal Server Error");<br>
exit;<br>
}<br>
<br>
setflag(ACC_DO); # do accounting<br>
}</p>
<p>.</p>
<p>.</p>
<p>.<br>
</p>
<p><br>
</p>
<p>-----------------------------------------------------------------------------------------</p>
<p><br>
</p>
<p>Is there some error in my configuration?</p>
<p>What should I investigate to eliminate the issue?</p>
<p><br>
</p>
<p>Any hint will be very helpful!</p>
<p><br>
</p>
<p>Thanks alot.</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>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset> <br>
<pre>_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</div>
</div>
</body>
</html>