Re: [OpenSIPS-Users] ACC Db Duration
Thanks Daniel :)... You saved the day! Regards, Qasim On Tue, Mar 28, 2017 at 6:36 PM, Daniel Zanutti 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, qasimak...@gmail.com < > qasimak...@gmail.com> 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 > >> *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 >> 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 > > ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] ACC Db Duration
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, qasimak...@gmail.com 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 > *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 > 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] ACC db duration
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:09 AM, qasimak...@gmail.com wrote: > Hi, > > I have enabled acc module in my opensips installation with db, My CDR's > are being written in MySQL backend but for every call the duration remains > 0, I have checked but according to documentation duration is automatically > logged in ACC module. PLease note following debug filtered where query is > made and executed > > ___ > 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
[OpenSIPS-Users] ACC Db Duration
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 , 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 Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] ACC db duration
Hi, I have enabled acc module in my opensips installation with db, My CDR's are being written in MySQL backend but for every call the duration remains 0, I have checked but according to documentation duration is automatically logged in ACC module. PLease note following debug filtered where query is made and executed ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users