<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><br>
</p>
<p>Hi Răzvan.</p>
<p><br>
</p>
<p>I have just checked the case and there is no issue in fact. I was misunderstanding the situation.</p>
<p>When the call ends, the OpenSIPS removes the record of the respective dialogue. That is why I was thinking that OpenSIPS wasn't saving data in the dialog table, as I was checking such table always after ending the call.</p>
<p><br>
</p>
<p>Now, I have to see whether there is a way of keeping records in the dialog table for some time, even after ending the calls. Because the information from dialog table will be useful for my application in moments after ending the calls.</p>
<p><br>
</p>
<p>I will study about ACC and Dialog. Let's see.</p>
<p><br>
</p>
<p>Thanks!</p>
<p></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 style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><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 id="LPlnk22505" 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 style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><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>