Need opensips only send accounting requests at BYE to aaa radius

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Need opensips only send accounting requests at BYE to aaa radius

Ahmed Shabana

Dears , I am facing a strange issue and spending so many hours on it .

We have two environment Development and staging ,

opensips use Radius as accounting backend

, opensips.cfg generated from template that should only apply each environment IPs and VAR  

Vimdiff show that files identical except in params of each environment  .

We use do_accounting(“aaa”, “cdr”) at initial INVITE as below

 

@ Initial INVITE

13         $acc_extra(extra_au) = $au ;

12         $acc_extra(extra_ru) = $ru;

11         $acc_extra(extra_rpid) = $avp(rpid);

10         $acc_extra(extra_si) = $si;

  9         $acc_extra(extra_username) = $au;

  8         $acc_extra(extra_ar) = $ar;

  7         $acc_extra(extra_rd) = $rd;

  6         $acc_extra(extra_fU) = $fU;

  5         $acc_extra(extra_rU) = $rU+"@"+$rd;

  1           xlog("---- current Dialog.Status is :$DLG_status " ) ; # the output of this log $DLG_Status = 1 as expected

  2         do_accounting("aaa","cdr");

 

 

 

@ is_method(“BYE”)

  do_accounting("aaa", "cdr|failed|missed");

 

 

The problem now is :

When apply radsniff at Development , it behaves exactly as we plan

Send Accounting request only at Acct-Status-Type Stop with all params

-----------------------------------------------------------

Access-Request Id 230   192.168.13.1:35549 -> 192.168.13.11:1812        +0.000

        User-Name = "restcomm.test@192.168.1.100"

        Digest-Attributes = 0x0a0f72657374636f6d6d2e74657374

        Digest-Attributes = 0x010f3139322e3136382e312e313030

        Digest-Attributes = 0x0232356133343233643730303030303038383464323865663661373330393464386362656566303664333862373964326537

        Digest-Attributes = 0x04217369703a2b393636353633373032323638403139322e3136382e312e313030

        Digest-Attributes = 0x0308494e56495445

        Digest-Response = "4bfc6f0ecee7b25d81cf4e68f52243db"

        Service-Type = IAPP-Register

        Sip-Uri-User = "1234"

        Acct-Session-Id = "d6cd5b2bec619771f02e050c3c92ca7e@172.19.0.2"

        NAS-Port = 5060

        NAS-IP-Address = 192.168.13.1

 

Access-Accept Id 230    192.168.13.11:1812 -> 192.168.13.1:35549        +0.001

 

Accounting-Request Id 231       192.168.13.1:32887 -> 192.168.13.11:1813        +0.048

        Acct-Status-Type = Stop

        Service-Type = IAPP-Register

        Sip-Response-Code = 200

        Sip-Method = Invite

        Event-Timestamp = "Dec 15 2017 19:34:17 UTC"

        Sip-From-Tag = "81019376_9b1d9904_57a5b08a_ef03d73c"

        Sip-To-Tag = "as2ae5edf5"

        Acct-Session-Id = "d6cd5b2bec619771f02e050c3c92ca7e@172.19.0.2"

        Sip-Call-Duration = 0

        Sip-Call-MSDuration = 367

        Sip-Call-Setuptime = Route-IP-No

        Sip-Translated-Request-URI = "sip:+966563702268@192.168.13.12:5060"

        Sip-Src-IP = "\002"

        User-Name = "rxt.test"

        SIP-AVP = "192.168.13.12"

        Calling-Station-Id = "1234"

        Called-Station-Id = "966563702268@192.168.13.12"

        Sip-Group = "ACae6e420f425248d6a26948c17a9e2acf"

        NAS-Port = 5060

        Acct-Delay-Time = 0

        NAS-IP-Address = 192.168.13.1

 

 

 

At Staging environment ,

It Send Accounting-Request for both Acct-Status-Type Start and Stop !!!

 

Access-Request Id 199    192.168.104.109:43417 -> 192.168.105.241:1812               +1901.364

                User-Name = "restcomm.test@192.168.104.109"

                Digest-Attributes = 0x0a0f72657374636f6d6d2e74657374

                Digest-Attributes = 0x01113139322e3136382e3130342e313039

                Digest-Attributes = 0x0232356133343161366630303030303030313563633834333862343365306633386439303764313230303564373230633334

                Digest-Attributes = 0x04237369703a2b323031313135353433363236403139322e3136382e3130342e313039

                Digest-Attributes = 0x0308494e56495445

                Digest-Response = "3d8cccd86495bddedbdae41999820898"

                Service-Type = Sip-Session

                Sip-Uri-User = "2979666"

                Acct-Session-Id = "68d55cd505be7b9f3ad4adae150a693e@192.168.104.207"

                NAS-Port = 5060

                NAS-IP-Address = 192.168.104.109

 

Access-Accept Id 199      192.168.105.241:1812 -> 192.168.104.109:43417               +1901.371

 

 

 

 

 

Accounting-Request Id 200           192.168.104.109:41734 -> 192.168.105.241:1813               +1911.726

                Acct-Status-Type = Start

                Service-Type = Sip-Session

                Sip-Response-Code = 200

                Sip-Method = INVITE

                Event-Timestamp = "Dec 15 2017 18:54:19 UTC"

                Sip-From-Tag = "74898207_03603651_57a5b08a_059b89a0"

                Sip-To-Tag = "23712318_6772d868_bd252ab2-7f19-4b4b-9d64-8543b3e60525"

                Acct-Session-Id = "68d55cd505be7b9f3ad4adae150a693e@192.168.104.207"

                Digest-Attributes = 0x0a0f72657374636f6d6d2e74657374

                Sip-Translated-Request-URI = "sip:[hidden email]"

                Sip-Src-IP = "\317h\250\300[\0324Z"

                User-Name = "rxt.test"

                Attr-111 = 0x3139322e3136382e3130342e313039

                SIP-AVP = "ceq.pstn.ie1.twilio.com"

                Calling-Station-Id = "2979666"

                Called-Station-Id = "[hidden email]"

                Sip-Group = "ACae6e420f425248d6a26948c17a9e2acf"

                NAS-Port = 5060

                Acct-Delay-Time = 0

                NAS-IP-Address = 192.168.104.109

 

Accounting-Response Id 200        192.168.105.241:1813 -> 192.168.104.109:41734               +1911.727

 

Access-Request Id 201    192.168.104.109:34342 -> 192.168.105.241:1812               +2545.558

                User-Name = "restcomm.test@192.168.104.109"

                Digest-Attributes = 0x0a0f72657374636f6d6d2e74657374

                Digest-Attributes = 0x01113139322e3136382e3130342e313039

                Digest-Attributes = 0x0232356133343163663330303030303030306534383762636339316161333161616532643938666336623535313831346235

                Digest-Attributes = 0x04237369703a2b323031313135353433363236403139322e3136382e3130342e313039

                Digest-Attributes = 0x0308494e56495445

                Digest-Response = "aa768ad30a7ec76ba70c2a1507920ff6"

                Service-Type = Sip-Session

                Sip-Uri-User = "2979666"

                Acct-Session-Id = "bf121b81b4413a8f5ccf5a3f703d89cc@192.168.104.207"

                NAS-Port = 5060

                NAS-IP-Address = 192.168.104.109

 

Access-Accept Id 201      192.168.105.241:1812 -> 192.168.104.109:34342               +2545.560

 

 

 

Which make the custom SQL statement we build at /etc/freeradius/sql/mysql/dialup.conf not function , which only handle accounting_stop_query

 

Your support is so much appreciated

 


Best regards ,

Shabana

 


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users