ACC Db Duration

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

ACC Db Duration

qasimakhan@gmail.com
Hi,

Sorry for the spam last email i miss-clicked on send amidst writing the email.

Anyways the problem i am facing is that my ACC module is configured with MySQL DB backend and the CDR's are being written. However the problem i am facing is that it is not logging duration into DB or syslog. Here are debug logs where query is being prepared and inserted

  • db_mysql_do_prepared_query: new query=|insert into acc(method,from_tag,to_tag,callid,sip_code,sip_reason,time,caller_id,callee_id,serverid,info,billResponse,balance ) values (?,?,?,?,?,?,?,?,?,?,?,?,?)|
  • DBG:db_mysql:re_init_statement:  query  is <insert into acc (method,from_tag,to_tag,callid,sip_code,sip_reason,time,caller_id,callee_id,serverid,info,billResponse,balance ) values(?,?,?,?,?,?,?,?,?,?,?,?,?)>, ptr=(nil)

The problem is that i dont see duration in this query. Am i missing some flag or something that needs to be set for duration to be logged in DB?

P.S. I am using opensips 1.11

Regards,

Qasim


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: ACC Db Duration

Daniel Zanutti
Hi

Did you check "cdr_flag" on Acc module?

Otherwise it will generate 2 registers, 1 for INVITE and 1 for BYE.

Regards

On Tue, Mar 28, 2017 at 10:29 AM, [hidden email] <[hidden email]> wrote:
Hi,

Sorry for the spam last email i miss-clicked on send amidst writing the email.

Anyways the problem i am facing is that my ACC module is configured with MySQL DB backend and the CDR's are being written. However the problem i am facing is that it is not logging duration into DB or syslog. Here are debug logs where query is being prepared and inserted

  • db_mysql_do_prepared_query: new query=|insert into acc(method,from_tag,to_tag,callid,sip_code,sip_reason,time,caller_id,callee_id,serverid,info,billResponse,balance ) values (?,?,?,?,?,?,?,?,?,?,?,?,?)|
  • DBG:db_mysql:re_init_statement:  query  is <insert into acc (method,from_tag,to_tag,callid,sip_code,sip_reason,time,caller_id,callee_id,serverid,info,billResponse,balance ) values(?,?,?,?,?,?,?,?,?,?,?,?,?)>, ptr=(nil)

The problem is that i dont see duration in this query. Am i missing some flag or something that needs to be set for duration to be logged in DB?

P.S. I am using opensips 1.11

Regards,

Qasim


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: ACC Db Duration

qasimakhan@gmail.com
Thanks Daniel :)... You saved the day!

Regards,
Qasim

On Tue, Mar 28, 2017 at 6:36 PM, Daniel Zanutti <[hidden email]> wrote:
Hi

Did you check "cdr_flag" on Acc module?

Otherwise it will generate 2 registers, 1 for INVITE and 1 for BYE.

Regards

On Tue, Mar 28, 2017 at 10:29 AM, [hidden email] <[hidden email]> wrote:
Hi,

Sorry for the spam last email i miss-clicked on send amidst writing the email.

Anyways the problem i am facing is that my ACC module is configured with MySQL DB backend and the CDR's are being written. However the problem i am facing is that it is not logging duration into DB or syslog. Here are debug logs where query is being prepared and inserted

  • db_mysql_do_prepared_query: new query=|insert into acc(method,from_tag,to_tag,callid,sip_code,sip_reason,time,caller_id,callee_id,serverid,info,billResponse,balance ) values (?,?,?,?,?,?,?,?,?,?,?,?,?)|
  • DBG:db_mysql:re_init_statement:  query  is <insert into acc (method,from_tag,to_tag,callid,sip_code,sip_reason,time,caller_id,callee_id,serverid,info,billResponse,balance ) values(?,?,?,?,?,?,?,?,?,?,?,?,?)>, ptr=(nil)

The problem is that i dont see duration in this query. Am i missing some flag or something that needs to be set for duration to be logged in DB?

P.S. I am using opensips 1.11

Regards,

Qasim


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users