[OpenSIPS-Users] No acc records after opensips restart

[mayamatakeshi]

Hello Razvan,


On Thu, May 1, 2014 at 4:11 PM, Răzvan Crainea <razvan at opensips.org> wrote:

> Hi, Takeshi!
>
> You are right, CDR_FLAG should only be set on the initial INVITE. DB_FLAG
> should not be set for BYE, because otherwise you will only account that
> method, not the CDR (no duration, setuptime, etc.).
> Have you tried with other Accounting backends (log, events)?
>

Yes. I use both db and log backends and no CDRs are written to opensips.log
in 1.11 after an opensips restart.


> Can you run a test in debugging mode, paste the logs on pastebin[1] and
> send them over (privately if you want)?
>
> [1] http://pastebin.com/


Here it is:
http://pastebin.com/hcdybZL3

Thanks.
Regards,
Takeshi


>
>
> Best regards,
>
> Razvan Crainea
> OpenSIPS Core Developer
> http://www.opensips-solutions.com
>
> On 05/01/2014 09:23 AM, mayamatakeshi wrote:
>
>> Razvan,
>> no, I was only setting the CDR_FLAG on the initial INVITE. This works
>> with 1.10.
>>
>> Then with 1.11, I tested setting the CDR_FLAG when processing BYE
>> requests but it didn't work.
>> Then I set DB_FLAG for BYE and after that, it worked.
>> So this behavior changed.
>> Thanks a lot.
>>
>> Regards,
>> Takeshi.
>>
>>
>> On Wed, Apr 30, 2014 at 11:05 PM, Răzvan Crainea <razvan at opensips.org
>> <mailto:razvan at opensips.org>> wrote:
>>
>>     Hi, Takeshi!
>>
>>     I just tested and there are no issues on my setup. Are you setting
>>     the CDR_FLAG for all the requests? Have you also tried with
>>     different db modes?
>>
>>     Best regards,
>>
>>     Razvan Crainea
>>     OpenSIPS Core Developer
>>     http://www.opensips-solutions.__com <http://www.opensips-
>> solutions.com>
>>
>>
>>
>>     On 04/23/2014 03:05 PM, mayamatakeshi wrote:
>>
>>         Hello,
>>         I am trying to upgrade from opensips 1.10 (commit
>>         bfd86ab25554082053167a82655e66__9ca1c0ea7c)
>>         to 1.11 (latest 313f41ad46921d543980fa9fc71fb0__715d385085).
>>
>>
>>         Almost everything works.
>>         However, in my opensips.cfg I set dialog db_mode to REALTIME.
>>         And I have
>>         acc in CDR mode.
>>         Then after making some calls and confirming the dialogs were
>>         inserted in
>>         the opensips.dialog table, I kill and restart opensips. Then I
>>         terminate
>>         the calls.
>>         In 1.10, this causes proper generation of records in the acc
>> table.
>>         However, in 1.11, no records are written to acc table.
>>         I checked the release notes for 1.11 but could not find any
>>         indication
>>         that this behavior would change:
>>         http://opensips.org/pub/__opensips/1.11.0/src/ChangeLog
>>
>>         <http://opensips.org/pub/opensips/1.11.0/src/ChangeLog>
>>
>>         Before filing a bug ticket i would like to confirm as i might be
>>         overlooking something.
>>
>>         Here is the significant snippets of opensips.cfg:
>>
>>         loadmodule "dialog.so"
>>         modparam("dialog", "default_timeout", 10800)
>>         modparam("dialog", "profiles_with_value", "calls")
>>         modparam("dialog", "db_url",
>>         "mysql://opensips:opensipsrw@__localhost/opensips")
>>
>>         modparam("dialog", "db_mode", 1) # 1=REALTIME, 2=DELAYED,
>> 3=SHUTDOWN
>>         modparam("dialog", "db_update_period", 10)
>>
>>
>>         loadmodule "acc.so"
>>         modparam("acc", "db_flag", "DB_FLAG")
>>         modparam("acc", "log_flag", "LOG_FLAG")
>>         modparam("acc", "log_level", -1)
>>         modparam("acc", "log_facility", "LOG_LOCAL0")
>>         modparam("acc", "db_url",
>>         "mysql://opensips:opensipsrw@__localhost/opensips")
>>
>>         modparam("acc", "failed_transaction_flag",
>>         "FAILED_TRANSACTION_FLAG")
>>         modparam("acc", "db_extra",
>>         "domain=$avp(i:6);direction=$__avp(i:20);from_uname=$fU;to__
>> _uname=$tU;calling_number=$avp(__i:21);destination=$avp(
>> i:22);__anonymous=$avp(i:23);gwid=$__avp(i:24);forward=$avp(i:25)")
>>
>>         modparam("acc", "log_extra",
>>         "domain=$avp(i:6);direction=$__avp(i:20);from_uname=$fU;to__
>> _uname=$tU;calling_number=$avp(__i:21);destination=$avp(
>> i:22);__anonymous=$avp(i:23);gwid=$__avp(i:24);forward=$avp(i:25)")
>>
>>         modparam("acc", "cdr_flag", "CDR_FLAG")
>>
>>         Regards,
>>         Takeshi
>>
>>
>>
>>         _________________________________________________
>>         Users mailing list
>>         Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>         http://lists.opensips.org/cgi-__bin/mailman/listinfo/users
>>         <http://lists.opensips.org/cgi-bin/mailman/listinfo/users>
>>
>>
>>     _________________________________________________
>>     Users mailing list
>>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>     http://lists.opensips.org/cgi-__bin/mailman/listinfo/users
>>
>>     <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
>>
>>
> _______________________________________________
> 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/20140501/c23c8625/attachment.htm>