Re: [OpenSIPS-Users] ACC Db Duration

[qasimak...@gmail.com]

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

[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, 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

[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: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

[qasimak...@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 , 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

[qasimak...@gmail.com]

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