[OpenSER-Users] OpenSER+freeradius+billing problem
ram
talk2ram at gmail.com
Fri Aug 17 22:46:26 CEST 2007
On 8/18/07, Norman Brandinger <norm at 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 at c291dGhlcm4tYzJ | 2e5817b61b8f83d3 |
| | 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 at c291dGhlcm4tYzJ | 44d8e47ed26d3e7b |
| | 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 at c291dGhlcm4tYzJ | 44d8e47ed26d3e7b |
| | 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 at c291dGhlcm4tYzJ | 44d8e47ed26d3e7b |
| | 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 at c291dGhlcm4tYzJ | 44d8e47ed26d3e7b |
| | 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 at c291dGhlcm4tYzJ | 44d8e47ed26d3e7b |
| | 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 at c291dGhlcm4tYzJ | 44d8e47ed26d3e7b |
| | 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 at c291dGhlcm4tYzJ | 44d8e47ed26d3e7b |
| | 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 at c291dGhlcm4tYzJ | 190b69a53cae5f33 |
| | 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 at c291dGhlcm4tYzJ | 190b69a53cae5f33 |
| | 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 at c291dGhlcm4tYzJ | 5a9422a16bc2acbf |
| | 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 at c291dGhlcm4tYzJ | 5a9422a16bc2acbf |
| | 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 at c291dGhlcm4tYzJ | f6432ce5eab2eda2 |
| | 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 at c291dGhlcm4tYzJ | f6432ce5eab2eda2 |
| | 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 at c291dGhlcm4tYzJ | f6432ce5eab2eda2 |
| | 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 at c291dGhlcm4tYzJ | f6432ce5eab2eda2 |
| | 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 at c291dGhlcm4tYzJ | f6432ce5eab2eda2 |
| | 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 at c291dGhlcm4tYzJ | c103c92194dae078 |
| | 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 at c291dGhlcm4tYzJ | c103c92194dae078 |
| | 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 at c291dGhlcm4tYzJ | 81e223864b22d27d |
| | 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 at c291dGhlcm4tYzJ | 81e223864b22d27d |
| | 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 at c291dGhlcm4tYzJ | 81e223864b22d27d |
| | 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 at c291dGhlcm4tYzJ | 81e223864b22d27d |
| | 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 at c291dGhlcm4tYzJ | 81e223864b22d27d |
| | 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 at c291dGhlcm4tYzJ | 393421034322fbe9 |
| | 127.0.0.1 | 5060 | | 2007-08-17 18:56:03 |
0000-00-00 00:00:00 | 0 | |
| | 0 | 0 |
sip:17325824631 at X.X.X.10 | sip:12345 at X.X.X.10 | |
IAPP-Register | | | 0
| 0 |
| 26 | ad372005d8558a52 at c291dGhlcm4tYzJ | f692e52a8b35d782 | 12345
| | 127.0.0.1 | 5060 | | 2007-08-17 18:56:03 |
0000-00-00 00:00:00 | 0 | |
| | 0 | 0 |
sip:17325824631 at X.X.X.10 | sip:12345 at X.X.X.10 | |
IAPP-Register | | | 0
| 0 |
| 27 | ad372005d8558a52 at c291dGhlcm4tYzJ | f692e52a8b35d782 | 12345
| | 127.0.0.1 | 5060 | | 2007-08-17 18:56:11 |
0000-00-00 00:00:00 | 0 | |
| | 0 | 0 |
sip:17325824631 at X.X.X.10 | sip:12345 at X.X.X.10 | |
IAPP-Register | | | 0
| 0 |
| 28 | ad372005d8558a52 at c291dGhlcm4tYzJ | 393421034322fbe9 |
| | 127.0.0.1 | 5060 | | 2007-08-17 18:56:22 |
2007-08-17 18:56:22 | 0 | |
| | 0 | 0 |
sip:12345 at X.X.X.10
| sip:17325824631 at X.X.X.10 | | IAPP-Register
| | | 0 | 0 |
| 29 | ad372005d8558a52 at c291dGhlcm4tYzJ | 393421034322fbe9 |
| | 127.0.0.1 | 5060 | | 2007-08-17 18:56:22 |
2007-08-17 18:56:22 | 0 | |
| | 0 | 0 |
sip:12345 at X.X.X.10
| sip:17325824631 at 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 at c291dGhlcm4tYzJkOWVh"
Called-Station-Id = "sip:17325824631 at X.X.X.10"
Calling-Station-Id = "sip:12345 at 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
Client-IP-Address = 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 at c291dGhlcm4tYzJkOWVh"
Called-Station-Id = "sip:17325824631 at X.X.X.10"
Calling-Station-Id = "sip:12345 at 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
Client-IP-Address = 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 at c291dGhlcm4tYzJkOWVh"
Called-Station-Id = "sip:17325824631 at X.X.X.10"
Calling-Station-Id = "sip:12345 at 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
Client-IP-Address = 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 at c291dGhlcm4tYzJkOWVh"
Called-Station-Id = "sip:12345 at X.X.X.10"
Calling-Station-Id = "sip:17325824631 at 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
Client-IP-Address = 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 at c291dGhlcm4tYzJkOWVh"
Called-Station-Id = "sip:12345 at X.X.X.10"
Calling-Station-Id = "sip:17325824631 at 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
Client-IP-Address = 127.0.0.1
Acct-Unique-Session-Id = "393421034322fbe9"
Timestamp = 1187357182
i see some 00000
how can i account them ?
ram
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20070818/60ea4b25/attachment.htm>
More information about the sr-users
mailing list