Re: [OpenSER-Users] OpenSER+freeradius+billing problem

17 Aug 2007

      Your problem is that the RADIUS server and the RADIUS client are using
different dictionaries.
See what happens when they both use the same dictionary.
Regards,
Norm
ram wrote:
...
On 8/18/07, *Norman Brandinger* <norm@goes.com mailto:norm@goes.com>
wrote:
If you can't find some other RADIUS dictionary with the attribute
defined, then you will have to define it yourself or remove it
from your
OpenSER configuration.

A quick "egrep -R" search on my systems produced the following:

dictionary.sip:ATTRIBUTE        Sip-User-Realm          111     string

Hi
thanks i have remove Attribiute and run the openser working
I have made test call and talk for 10seconds hangup the call
in database i see the below records
+-----------+----------------------------------+------------------+----------+-------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+------------------------------+------------------------------+--------------------+---------------+----------------+-----------------+----------------+---------------+
| RadAcctId | AcctSessionId                    | AcctUniqueId     |
UserName | Realm | NASIPAddress | NASPortId | NASPortType |
AcctStartTime       | AcctStopTime        | AcctSessionTime |
AcctAuthentic | ConnectInfo_start | ConnectInfo_stop | AcctInputOctets
| AcctOutputOctets | CalledStationId              |
CallingStationId             | AcctTerminateCause | ServiceType   |
FramedProtocol | FramedIPAddress | AcctStartDelay | AcctStopDelay |
+-----------+----------------------------------+------------------+----------+-------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+------------------------------+------------------------------+--------------------+---------------+----------------+-----------------+----------------+---------------+
|         1 | 813b4501b92f1425@c291dGhlcm4tYzJ
mailto:813b4501b92f1425@c291dGhlcm4tYzJ | 2e5817b61b8f83d3
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 13:01:45 | 2007-08-16 13:01:45
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|         2 | 537a78508d427b5c@c291dGhlcm4tYzJ
mailto:537a78508d427b5c@c291dGhlcm4tYzJ | 44d8e47ed26d3e7b
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 14:23:09 | 0000-00-00 00:00:00
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|         3 | 537a78508d427b5c@c291dGhlcm4tYzJ
mailto:537a78508d427b5c@c291dGhlcm4tYzJ | 44d8e47ed26d3e7b
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 14:23:20 | 2007-08-16 14:23:20
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|         4 | 537a78508d427b5c@c291dGhlcm4tYzJ
mailto:537a78508d427b5c@c291dGhlcm4tYzJ | 44d8e47ed26d3e7b
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 14:23:20 | 2007-08-16 14:23:20
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|         5 | 537a78508d427b5c@c291dGhlcm4tYzJ
mailto:537a78508d427b5c@c291dGhlcm4tYzJ | 44d8e47ed26d3e7b
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 14:23:20 | 2007-08-16 14:23:20
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|         6 | 537a78508d427b5c@c291dGhlcm4tYzJ
mailto:537a78508d427b5c@c291dGhlcm4tYzJ | 44d8e47ed26d3e7b
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 14:23:20 | 2007-08-16 14:23:20
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|         7 | 537a78508d427b5c@c291dGhlcm4tYzJ
mailto:537a78508d427b5c@c291dGhlcm4tYzJ | 44d8e47ed26d3e7b
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 14:23:21 | 2007-08-16 14:23:21
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|         8 | 537a78508d427b5c@c291dGhlcm4tYzJ
mailto:537a78508d427b5c@c291dGhlcm4tYzJ | 44d8e47ed26d3e7b
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 14:23:21 | 2007-08-16 14:23:21
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|         9 | a86473214956cc44@c291dGhlcm4tYzJ
mailto:a86473214956cc44@c291dGhlcm4tYzJ | 190b69a53cae5f33
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 14:44:54 | 0000-00-00 00:00:00
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        10 | a86473214956cc44@c291dGhlcm4tYzJ
mailto:a86473214956cc44@c291dGhlcm4tYzJ | 190b69a53cae5f33
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 14:44:54 | 0000-00-00 00:00:00
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        11 | 7a3c594386522c1f@c291dGhlcm4tYzJ
mailto:7a3c594386522c1f@c291dGhlcm4tYzJ | 5a9422a16bc2acbf
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 14:49:40 | 0000-00-00 00:00:00
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        12 | 7a3c594386522c1f@c291dGhlcm4tYzJ
mailto:7a3c594386522c1f@c291dGhlcm4tYzJ | 5a9422a16bc2acbf
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 14:49:55 | 2007-08-16 14:49:55
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        13 | 0554504fd134d470@c291dGhlcm4tYzJ
mailto:0554504fd134d470@c291dGhlcm4tYzJ | f6432ce5eab2eda2
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 15:01:50 | 0000-00-00 00:00:00
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        14 | 0554504fd134d470@c291dGhlcm4tYzJ
mailto:0554504fd134d470@c291dGhlcm4tYzJ | f6432ce5eab2eda2
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 15:01:50 | 0000-00-00 00:00:00
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        15 | 0554504fd134d470@c291dGhlcm4tYzJ
mailto:0554504fd134d470@c291dGhlcm4tYzJ | f6432ce5eab2eda2
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 15:01:58 | 0000-00-00 00:00:00
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        16 | 0554504fd134d470@c291dGhlcm4tYzJ
mailto:0554504fd134d470@c291dGhlcm4tYzJ | f6432ce5eab2eda2
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 15:02:17 | 2007-08-16 15:02:17
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        17 | 0554504fd134d470@c291dGhlcm4tYzJ
mailto:0554504fd134d470@c291dGhlcm4tYzJ | f6432ce5eab2eda2
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 15:02:17 | 2007-08-16 15:02:17
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        18 | 235b5e52a955e35c@c291dGhlcm4tYzJ
mailto:235b5e52a955e35c@c291dGhlcm4tYzJ | c103c92194dae078
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 16:46:54 | 0000-00-00 00:00:00
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        19 | 235b5e52a955e35c@c291dGhlcm4tYzJ
mailto:235b5e52a955e35c@c291dGhlcm4tYzJ | c103c92194dae078
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 16:46:54 | 0000-00-00 00:00:00
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        20 | 62210477326ab30b@c291dGhlcm4tYzJ
mailto:62210477326ab30b@c291dGhlcm4tYzJ | 81e223864b22d27d
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 16:47:50 | 0000-00-00 00:00:00
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        21 | 62210477326ab30b@c291dGhlcm4tYzJ
mailto:62210477326ab30b@c291dGhlcm4tYzJ | 81e223864b22d27d
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 16:47:50 | 0000-00-00 00:00:00
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        22 | 62210477326ab30b@c291dGhlcm4tYzJ
mailto:62210477326ab30b@c291dGhlcm4tYzJ | 81e223864b22d27d
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 16:47:56 | 0000-00-00 00:00:00
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        23 | 62210477326ab30b@c291dGhlcm4tYzJ
mailto:62210477326ab30b@c291dGhlcm4tYzJ | 81e223864b22d27d
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 16:48:16 | 2007-08-16 16:48:16
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        24 | 62210477326ab30b@c291dGhlcm4tYzJ
mailto:62210477326ab30b@c291dGhlcm4tYzJ | 81e223864b22d27d
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-16 16:48:17 | 2007-08-16 16:48:17
|               0 |               |                  
|                  |               0 |                0
|                              |                             
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        25 | ad372005d8558a52@c291dGhlcm4tYzJ
mailto:ad372005d8558a52@c291dGhlcm4tYzJ | 393421034322fbe9
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-17 18:56:03 | 0000-00-00 00:00:00
|               0 |               |                  
|                  |               0 |                0 |
sip:17325824631@X.X.X.10 mailto:sip:17325824631@X.X.X.10 |
sip:12345@X.X.X.10 mailto:sip:12345@X.X.X.10      
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        26 | ad372005d8558a52@c291dGhlcm4tYzJ
mailto:ad372005d8558a52@c291dGhlcm4tYzJ | f692e52a8b35d782 |
12345    |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-17 18:56:03 | 0000-00-00 00:00:00
|               0 |               |                  
|                  |               0 |                0 |
sip:17325824631@X.X.X.10 mailto:sip:17325824631@X.X.X.10 |
sip:12345@X.X.X.10 mailto:sip:12345@X.X.X.10      
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        27 | ad372005d8558a52@c291dGhlcm4tYzJ
mailto:ad372005d8558a52@c291dGhlcm4tYzJ | f692e52a8b35d782 |
12345    |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-17 18:56:11 | 0000-00-00 00:00:00
|               0 |               |                  
|                  |               0 |                0 |
sip:17325824631@X.X.X.10 mailto:sip:17325824631@X.X.X.10 |
sip:12345@X.X.X.10 mailto:sip:12345@X.X.X.10      
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        28 | ad372005d8558a52@c291dGhlcm4tYzJ
mailto:ad372005d8558a52@c291dGhlcm4tYzJ | 393421034322fbe9
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-17 18:56:22 | 2007-08-17 18:56:22
|               0 |               |                  
|                  |               0 |                0 |
sip:12345@X.X.X.10 mailto:sip:12345@X.X.X.10       |
sip:17325824631@X.X.X.10 mailto:sip:17325824631@X.X.X.10
|                    | IAPP-Register |               
|                 |              0 |             0 |
|        29 | ad372005d8558a52@c291dGhlcm4tYzJ
mailto:ad372005d8558a52@c291dGhlcm4tYzJ | 393421034322fbe9
|          |       | 127.0.0.1 http://127.0.0.1    | 5060     
|             | 2007-08-17 18:56:22 | 2007-08-17 18:56:22
|               0 |               |                  
|                  |               0 |                0 |
sip:12345@X.X.X.10 mailto:sip:12345@X.X.X.10       |
sip:17325824631@X.X.X.10 mailto:sip:17325824631@X.X.X.10
|                    | IAPP-Register |               
|                 |              0 |             0 |
+-----------+----------------------------------+------------------+----------+-------+--------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+------------------------------+------------------------------+--------------------+---------------+----------------+-----------------+----------------+---------------+
more /usr/local/var/log/radius/radacct/127.0.0.1/detail-20070817
Fri Aug 17 18:56:03 2007
        Acct-Status-Type = Start
        Service-Type = IAPP-Register
        Attr-102 = 0x000000c8
        Error-Cause = 1
        Event-Timestamp = "Aug 17 2007 18:56:03 IST"
        Attr-105 = 0x3363306161633665
        Acct-Session-Id = "ad372005d8558a52@c291dGhlcm4tYzJkOWVh
mailto:ad372005d8558a52@c291dGhlcm4tYzJkOWVh"
        Called-Station-Id = "sip:17325824631@X.X.X.10
mailto:sip:17325824631@X.X.X.10"
        Calling-Station-Id = "sip:12345@X.X.X.10
mailto:sip:12345@X.X.X.10 "
        X-Ascend-IPX-Peer-Mode =
0x7369703a3137333235383234363331403230322e36332e39362e3130
        X-Ascend-Send-Secret = 0x3230322e36332e39362e39
        X-Ascend-Receive-Secret = 0x36393138
        X-Ascend-FR-Direct-DLCI =
0x223132333435223c7369703a3132333435403230322e36332e39362e31303e3b7461673d3363306161633665
    X-Ascend-Handle-IPX =

0x6579654265616d2072656c6561736520333031306e207374616d70203139303339
        X-Ascend-Netware-timeout =
0x3c7369703a3132333435403139322e3136382e312e3130313a363931383e
        NAS-Port = 5060
        Acct-Delay-Time = 0
        NAS-IP-Address = 127.0.0.1 http://127.0.0.1
        Client-IP-Address = 127.0.0.1 http://127.0.0.1
        Acct-Unique-Session-Id = "393421034322fbe9"
        Timestamp = 1187357163
Fri Aug 17 18:56:03 2007
        Acct-Status-Type = Start
        Service-Type = IAPP-Register
        Attr-102 = 0x000000c8
        Error-Cause = 1
        Event-Timestamp = "Aug 17 2007 18:56:03 IST"
        Attr-105 = 0x3363306161633665
        Acct-Session-Id = "ad372005d8558a52@c291dGhlcm4tYzJkOWVh
mailto:ad372005d8558a52@c291dGhlcm4tYzJkOWVh"
        Called-Station-Id = " sip:17325824631@X.X.X.10
mailto:sip:17325824631@X.X.X.10"
        Calling-Station-Id = "sip:12345@X.X.X.10
mailto:sip:12345@X.X.X.10"
        X-Ascend-IPX-Peer-Mode =
0x7369703a3137333235383234363331403230322e36332e39362e3130
        User-Name = "12345"
        X-Ascend-Send-Secret = 0x3230322e36332e39362e39
        X-Ascend-Receive-Secret = 0x36393138
        X-Ascend-FR-Direct-DLCI =
0x223132333435223c7369703a3132333435403230322e36332e39362e31303e3b7461673d3363306161633665
    X-Ascend-Handle-IPX =

0x6579654265616d2072656c6561736520333031306e207374616d70203139303339
        X-Ascend-Netware-timeout =
0x3c7369703a3132333435403139322e3136382e312e3130313a363931383e
        NAS-Port = 5060
        Acct-Delay-Time = 0
        NAS-IP-Address = 127.0.0.1 http://127.0.0.1
        Client-IP-Address = 127.0.0.1 http://127.0.0.1
        Acct-Unique-Session-Id = "f692e52a8b35d782"
        Timestamp = 1187357163
Fri Aug 17 18:56:11 2007
        Acct-Status-Type = Start
        Service-Type = IAPP-Register
        Attr-102 = 0x000000c8
        Error-Cause = 1
        Event-Timestamp = "Aug 17 2007 18:56:11 IST"
        Attr-105 = 0x3363306161633665
        Attr-104 = 0x61733739376434633964
        Acct-Session-Id = "ad372005d8558a52@c291dGhlcm4tYzJkOWVh
mailto:ad372005d8558a52@c291dGhlcm4tYzJkOWVh"
        Called-Station-Id = "sip:17325824631@X.X.X.10
mailto:sip:17325824631@X.X.X.10"
        Calling-Station-Id = "sip:12345@X.X.X.10
mailto:sip:12345@X.X.X.10"
        X-Ascend-IPX-Peer-Mode =
0x7369703a3137333235383234363331403230322e36332e39362e3130
        User-Name = "12345"
        X-Ascend-Send-Secret = 0x3230322e36332e39362e39
        X-Ascend-Receive-Secret = 0x36393138
        X-Ascend-FR-Direct-DLCI =
0x223132333435223c7369703a3132333435403230322e36332e39362e31303e3b7461673d3363306161633665
        X-Ascend-Handle-IPX =
0x6579654265616d2072656c6561736520333031306e207374616d70203139303339
        X-Ascend-Netware-timeout =
0x3c7369703a3132333435403139322e3136382e312e3130313a363931383e
        NAS-Port = 5060
        Acct-Delay-Time = 0
        NAS-IP-Address = 127.0.0.1 http://127.0.0.1
        Client-IP-Address = 127.0.0.1 http://127.0.0.1
        Acct-Unique-Session-Id = "f692e52a8b35d782"
        Timestamp = 1187357171
Fri Aug 17 18:56:22 2007
        Acct-Status-Type = Stop
        Service-Type = IAPP-Register
        Attr-102 = 0x000000c8
        Error-Cause = 8
        Event-Timestamp = "Aug 17 2007 18:56:22 IST"
        Attr-105 = 0x61733739376434633964
        Attr-104 = 0x3363306161633665
        Acct-Session-Id = "ad372005d8558a52@c291dGhlcm4tYzJkOWVh
mailto:ad372005d8558a52@c291dGhlcm4tYzJkOWVh"
        Called-Station-Id = "sip:12345@X.X.X.10
mailto:sip:12345@X.X.X.10"
        Calling-Station-Id = "sip:17325824631@X.X.X.10
mailto:sip:17325824631@X.X.X.10"
        X-Ascend-IPX-Peer-Mode =
0x7369703a3132333435403230322e36332e39362e3130
        X-Ascend-Send-Secret = 0x3230322e36332e39362e313933
        X-Ascend-Receive-Secret = 0x35303630
        X-Ascend-FR-Direct-DLCI =
0x3c7369703a3137333235383234363331403230322e36332e39362e31303e3b7461673d61733739376434633964
    X-Ascend-Handle-IPX = 0x417374657269736b20504258
    NAS-Port = 5060
    Acct-Delay-Time = 0
    NAS-IP-Address = 127.0.0.1 <http://127.0.0.1>
    Client-IP-Address = 127.0.0.1 <http://127.0.0.1>
    Acct-Unique-Session-Id = "393421034322fbe9"
    Timestamp = 1187357182

Fri Aug 17 18:56:22 2007
        Acct-Status-Type = Stop
        Service-Type = IAPP-Register
        Attr-102 = 0x000000c8
        Error-Cause = 8
        Event-Timestamp = "Aug 17 2007 18:56:22 IST"
        Attr-105 = 0x61733739376434633964
        Attr-104 = 0x3363306161633665
        Acct-Session-Id = "ad372005d8558a52@c291dGhlcm4tYzJkOWVh
mailto:ad372005d8558a52@c291dGhlcm4tYzJkOWVh"
        Called-Station-Id = "sip:12345@X.X.X.10
mailto:sip:12345@X.X.X.10"
        Calling-Station-Id = "sip:17325824631@X.X.X.10
mailto:sip:17325824631@X.X.X.10"
        X-Ascend-IPX-Peer-Mode =
0x7369703a3132333435403230322e36332e39362e3130
        X-Ascend-Send-Secret = 0x3230322e36332e39362e313933
        X-Ascend-Receive-Secret = 0x35303630
        X-Ascend-FR-Direct-DLCI =
0x3c7369703a3137333235383234363331403230322e36332e39362e31303e3b7461673d61733739376434633964
    X-Ascend-Handle-IPX = 0x417374657269736b20504258
    NAS-Port = 5060
    Acct-Delay-Time = 0
    NAS-IP-Address = 127.0.0.1 <http://127.0.0.1>
    Client-IP-Address = 127.0.0.1 <http://127.0.0.1>
    Acct-Unique-Session-Id = "393421034322fbe9"
    Timestamp = 1187357182

i see some 00000
how can i account them ?
ram

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

Re: [OpenSER-Users] OpenSER+freeradius+billing problem