[OpenSIPS-Users] No acc records after opensips restart

[Răzvan Crainea]

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)?
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/

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
>