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

[Rodrigo Pimenta Carvalho]

Hi Razvan.


I have just checked the case and there is no issue in fact. I was misunderstanding the situation.

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.


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.


I will study about ACC and Dialog. Let's see.


Thanks!


RODRIGO PIMENTA CARVALHO
Inatel Competence Center
Software
Ph: +55 35 3471 9200 RAMAL 979


________________________________
De: users-bounces at lists.opensips.org <users-bounces at lists.opensips.org> em nome de Razvan Crainea <razvan at opensips.org>
Enviado: quinta-feira, 17 de setembro de 2015 09:32
Para: users at lists.opensips.org
Assunto: Re: [OpenSIPS-Users] Table dialog remains empty even after calls. Some error in my config file? Others tables are good.

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,

Razvan Crainea
OpenSIPS Solutions
www.opensips-solutions.com<http://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<mailto:sisc-request at listas.inatel.br> <sisc-request at listas.inatel.br><mailto:sisc-request at listas.inatel.br> em nome de Rodrigo Pimenta Carvalho <pimenta at inatel.br><mailto: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<mailto: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/20150921/3ebcf615/attachment.htm>