[OpenSIPS-Users] Table dialog remains empty even after calls. Some error in my config file? Others tables are good.

[Răzvan Crainea]

Hi, Rodrigo!

Are you seeing any errors in your logs related to sqlite not being able 
to insert dialogs in your database?
Can you run a dlg_list while a call is on?

Best regards,

Răzvan Crainea
OpenSIPS Solutions
www.opensips-solutions.com

On 09/17/2015 03:26 PM, Rodrigo Pimenta Carvalho wrote:
>
>
>
> Hi.
>
>
> Some days ago I got a help in this discussion list.
>
> According to that help, the table that has information about dialled 
> calls is acc.
>
> 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.
>
>
> Hopefully, I will see how to use such tables, making OpenSIPS record 
> data there. Let's see...
>
>
> Best regards.
>
>
> RODRIGO PIMENTA CARVALHO
> Inatel Competence Center
> Software
> Ph: +55 35 3471 9200 RAMAL 979
>
>
> ------------------------------------------------------------------------
> *De:* sisc-request at listas.inatel.br <sisc-request at listas.inatel.br> em 
> nome de Rodrigo Pimenta Carvalho <pimenta at inatel.br>
> *Enviado:* quarta-feira, 16 de setembro de 2015 17:34
> *Para:* OpenSIPS users mailling list
> *Assunto:* [sisc] Table dialog remains empty even after calls. Some 
> error in my config file? Others tables are good.
>
> Dear OpenSIPS-Users,
>
>
> I'm using OpenSIPS 2.2 with SQLite, from commit 
> 97ea216790a20e150d09314aeea360aa48a37b36.
>
>
> I have noticed that my OpenSIPS is recording data only into the 
> following tables:
>
> - subscriber
>
> - location
>
> - missed_calls
>
> -acc
>
>
> 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.
>
> So, I suspect that maybe some configuration is wrong in my OpenSIPS 
> environment.
>
>
> In my opensips_residential.cfg file I have:
>
>
>
> --------------------------------------------------------------------------------
>
> #### DIALOG module
> loadmodule "dialog.so"
> modparam("dialog", "dlg_match_mode", 1)
> modparam("dialog", "db_mode", 1)
> modparam("dialog", "db_url", "sqlite:///usr/local/opensips_proxy/sqlite")
> modparam("dialog", "default_timeout", 540)
>
> ---------------------------------------------------------------------------------------
>
>
> ####### Routing Logic ########
>
>
> .
>
> .
>
> .
>
>
>     # account only INVITEs
>     if (is_method("INVITE")) {
>
>         # create dialog with timeout
>         if ( !create_dialog("B") ) {
>             send_reply("500","Internal Server Error");
>             exit;
>         }
>
>         setflag(ACC_DO); # do accounting
>     }
>
> .
>
> .
>
> .
>
>
> -----------------------------------------------------------------------------------------
>
>
> Is there some error in my configuration?
>
> What should I investigate to eliminate the issue?
>
>
> Any hint will be very helpful!
>
>
> Thanks alot.
>
>
>
> RODRIGO PIMENTA CARVALHO
> Inatel Competence Center
> Software
> Ph: +55 35 3471 9200 RAMAL 979
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150917/7f6bd3a7/attachment.htm>