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

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

2015-09-21 Thread 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-boun...@lists.opensips.org <users-boun...@lists.opensips.org> em nome 
de Razvan Crainea <raz...@opensips.org>
Enviado: quinta-feira, 17 de setembro de 2015 09:32
Para: users@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-requ...@listas.inatel.br<mailto:sisc-requ...@listas.inatel.br> 
<sisc-requ...@listas.inatel.br><mailto:sisc-requ...@listas.inatel.br> em nome 
de Rodrigo Pimenta Carvalho <pime...@inatel.br><mailto:pime...@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@lists.opensips.org<mailto:Users@lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

2015-09-17 Thread Rodrigo Pimenta Carvalho



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-requ...@listas.inatel.br  em nome de 
Rodrigo Pimenta Carvalho 
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@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

2015-09-17 Thread 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-requ...@listas.inatel.br  em 
nome de Rodrigo Pimenta Carvalho 

*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@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

2015-09-17 Thread Rodrigo Pimenta Carvalho

Hi Razvan.

I will check the log and let you know.

To run dlg_list have I to use MI or is there an way of running it via the 
OpenSIPS config file?

Thanks.


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



De: users-boun...@lists.opensips.org <users-boun...@lists.opensips.org> em nome 
de Razvan Crainea <raz...@opensips.org>
Enviado: quinta-feira, 17 de setembro de 2015 09:32
Para: users@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-requ...@listas.inatel.br<mailto:sisc-requ...@listas.inatel.br> 
<sisc-requ...@listas.inatel.br><mailto:sisc-requ...@listas.inatel.br> em nome 
de Rodrigo Pimenta Carvalho <pime...@inatel.br><mailto:pime...@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@lists.opensips.org<mailto:Users@lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

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

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

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

4 matches

Site Navigation

Mail list logo

Footer information