[OpenSIPS-Users] ACC Db Duration

[qasimakhan at gmail.com]

Thanks Daniel :)... You saved the day!

Regards,
Qasim

On Tue, Mar 28, 2017 at 6:36 PM, Daniel Zanutti <daniel.zanutti at gmail.com>
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, qasimakhan at gmail.com <
> qasimakhan at 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 <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
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
> _______________________________________________
> Users mailing list
> 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/20170328/d4eb51f6/attachment.html>