Hugh,
Config and logs attached.
And the application crashed when testing Simultaneous-Use for both
configurations below.
In my AuthBy config:
"DefaultSimultaneousUse 1" With "AuthAttrDef
Simultaneous-Use,Simultaneous-Use,check"
Or
In my Handler:
MaxSessions 1
On Fri, 2 Nov 2012 07:19:09 +1100
Hugh Irvine <[email protected]> wrote:
>
>Hello Rohan -
>
>We will need to see the configuration file (no secrets) together with a trace
>4 debug showing what is happening.
>
>regards
>
>Hugh
>
>
>On 2 Nov 2012, at 05:53, <[email protected]> wrote:
>
>> Hello,
>>
>> Why doesn't the following work?
>>
>>
>> Identifier SQLAccounting
>> DBSource dbi:mysql:inetdb_test
>> DBUsername inet
>> DBAuth inet@inetdb
>> #Disable SQL authentication
>> AuthSelect
>> HandleAcctStatusTypes Start,Stop
>> AccountingTable ARCH_ACCOUNTING
>> AcctColumnDef USER_NAME,User-Name
>> AcctColumnDef ACCT_START_TIME,Timestamp,integer
>> AcctColumnDef ACCT_STOP_TIME,Timestamp,integer
>> AcctColumnDef ACCT_STATUS_TYPE,Acct-Status-Type,integer
>> AcctColumnDef ACCT_DELAY_TIME,Acct-Delay-Time,integer
>> AcctColumnDef ACCT_INPUT_OCTETS,Acct-Input-Octets,integer
>> AcctColumnDef ACCT_OUTPUT_OCTETS,Acct-Output-Octets,integer
>> AcctColumnDef ACCT_SESSION_ID,Acct-Session-Id
>> AcctColumnDef ACCT_SESSION_TIME,Acct-Session-Time,integer
>> AcctColumnDef ACCT_TERMINATE_CAUSE,Acct-Terminate-Cause,integer
>> AcctColumnDef FRAMED_IP_ADDRESS,Framed-IP-Address
>> AcctColumnDef NAS_IDENTIFIER,NAS-Identifier
>> AcctColumnDef NAS_PORT,NAS-Port,integer
>> AcctColumnDef CALLED_STATION_ID,Called-Station-Id
>> AcctColumnDef CALLING_STATION_ID,Calling-Station-Id
>> SQLRecoveryFile %L/sqlaccounting.sql
>>
>>
>> Specifying the following in my Handler does not work. I don't even see any
>> trace in my logs set at level 4 or 5.
>> AuthBy SQLAccounting
>>
>> However my sessions database work with the following.
>> SessionDatabase SQLSDB
>>
>> Thanks much.
>>
>> Regards,
>> Rohan
>> _______________________________________________
>> radiator mailing list
>> [email protected]
>> http://www.open.com.au/mailman/listinfo/radiator
>
>
>--
>
>Hugh Irvine
>[email protected]
>
>Radiator: the most portable, flexible and configurable RADIUS server
>anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
>Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS,
>TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
>DIAMETER etc.
>Full source on Unix, Windows, MacOSX, Solaris, VMS, NetWare etc.
>
Rohan Henry
Server Administrator
LIME
Phone (876) 936-4819
Mobile (876) 997-0729
Thu Nov 1 15:54:20 2012: DEBUG: Packet dump:
*** Received from 208.138.43.125 port 50000 ....
Packet length = 275
01 30 01 13 0d be 33 79 1a c8 7e 15 4b 7f 71 ee
2a e1 0e 6d 02 12 99 65 62 a0 7c 20 4b 79 ed e0
ee 67 94 69 7c d8 01 09 6d 63 61 74 72 61 31 2c
38 65 72 78 20 54 65 6e 47 69 67 61 62 69 74 45
74 68 65 72 6e 65 74 20 33 2f 30 2f 30 2e 39 34
31 30 30 35 3a 39 34 2d 31 30 30 35 3a 31 38 33
30 38 32 30 39 33 30 06 06 00 00 00 02 07 06 00
00 00 01 1a 1f 00 00 13 0a 18 19 70 70 70 6f 65
20 30 30 3a 39 30 3a 64 30 3a 33 30 3a 33 65 3a
37 63 1f 36 23 4a 75 6e 69 70 65 72 5f 45 33 32
30 5f 32 23 4c 69 6e 6b 20 54 6f 20 43 61 72 6c
2d 4d 50 4c 53 5f 50 45 2d 4e 6f 64 65 2d 35 2f
32 2f 32 23 31 30 30 35 3d 06 00 00 00 0f 05 06
30 00 03 ed 57 29 54 65 6e 47 69 67 61 62 69 74
45 74 68 65 72 6e 65 74 20 33 2f 30 2f 30 2e 39
34 31 30 30 35 3a 39 34 2d 31 30 30 35 04 06 d0
8a 2b 7d 20 10 4a 75 6e 69 70 65 72 5f 45 33 32
30 5f 32
Code: Access-Request
Identifier: 48
Authentic: <13><190>3y<26><200>~<21>K<127>q<238>*<225><14>m
Attributes:
User-Password = <153>eb<160>| Ky<237><224><238>g<148>i|<216>
User-Name = "mcatra1"
Acct-Session-Id = "erx TenGigabitEthernet
3/0/0.941005:94-1005:1830820930"
Service-Type = Framed-User
Framed-Protocol = PPP
Unisphere-Pppoe-Description = "pppoe 00:90:d0:30:3e:7c"
Calling-Station-Id = "#Juniper_E320_2#Link To
Carl-MPLS_PE-Node-5/2/2#1005"
NAS-Port-Type = Ethernet
NAS-Port = 805307373
NAS-Port-Id = "TenGigabitEthernet 3/0/0.941005:94-1005"
NAS-IP-Address = 208.138.43.125
NAS-Identifier = "Juniper_E320_2"
Thu Nov 1 15:54:20 2012: DEBUG: Handling request with Handler
'NAS-Identifier="Juniper_E320_2"'
Thu Nov 1 15:54:20 2012: DEBUG: SQLSDB Deleting session for mcatra1,
208.138.43.125, 805307373
Thu Nov 1 15:54:20 2012: DEBUG: do query is: 'delete from ACTIVE_SESSIONS
where USER_NAME='mcatra1' and NAS_IP_ADDRESS='208.138.43.125' and
NAS_PORT_ID='TenGigabitEthernet 3/0/0.941005:94-1005'':
Thu Nov 1 15:54:20 2012: DEBUG: Query is: 'select
NAS_IP_ADDRESS='208.138.43.125',NAS_PORT_ID='TenGigabitEthernet
3/0/0.941005:94-1005',ACCT_SESSION_ID='erx TenGigabitEthernet
3/0/0.941005:94-1005:1830820930' from ACTIVE_SESSIONS where
USER_NAME='mcatra1'':
Thu Nov 1 15:54:20 2012: DEBUG: Handling with Radius::AuthLDAP2: xDSL
Thu Nov 1 15:54:20 2012: INFO: Connecting to olympias1 socrates:389
Thu Nov 1 15:54:20 2012: INFO: Attempting to bind to LDAP server olympias1
socrates:389
Thu Nov 1 15:54:20 2012: DEBUG: LDAP got result for
uid=mcatra1,ou=IPCustomers,o=domain.com
Thu Nov 1 15:54:20 2012: DEBUG: LDAP got userPassword: ******
Thu Nov 1 15:54:20 2012: DEBUG: LDAP got servicestatus: ACTIVE
Thu Nov 1 15:54:20 2012: DEBUG: Radius::AuthLDAP2 looks for match with mcatra1
[mcatra1]
Thu Nov 1 15:54:20 2012: DEBUG: Radius::AuthLDAP2 ACCEPT: : mcatra1 [mcatra1]
Thu Nov 1 15:54:20 2012: DEBUG: AuthBy LDAP2 result: ACCEPT,
Thu Nov 1 15:54:20 2012: DEBUG: Access accepted for mcatra1
Thu Nov 1 15:54:20 2012: DEBUG: Packet dump:
*** Sending to 208.138.43.125 port 50000 ....
Packet length = 29
02 30 00 1d a3 5f c2 db 36 90 a5 c7 94 55 3e 4b
21 0c e2 37 19 09 6d 63 61 74 72 61 31
Code: Access-Accept
Identifier: 48
Authentic: <163>_<194><219>6<144><165><199><148>U>K!<12><226>7
Attributes:
Class = "mcatra1"
Thu Nov 1 15:54:20 2012: DEBUG: Packet dump:
*** Received from 208.138.43.125 port 50125 ....
Packet length = 308
04 63 01 34 d0 c0 04 de be e6 48 5f ba c2 df fe
58 f8 aa df 28 06 00 00 00 01 01 09 6d 63 61 74
72 61 31 37 06 50 92 97 99 29 06 00 00 00 00 20
10 4a 75 6e 69 70 65 72 5f 45 33 32 30 5f 32 2c
38 65 72 78 20 54 65 6e 47 69 67 61 62 69 74 45
74 68 65 72 6e 65 74 20 33 2f 30 2f 30 2e 39 34
31 30 30 35 3a 39 34 2d 31 30 30 35 3a 31 38 33
30 38 32 30 39 33 30 04 06 d0 8a 2b 7d 19 09 6d
63 61 74 72 61 31 06 06 00 00 00 02 07 06 00 00
00 01 0d 06 00 00 00 00 1a 1f 00 00 13 0a 18 19
70 70 70 6f 65 20 30 30 3a 39 30 3a 64 30 3a 33
30 3a 33 65 3a 37 63 08 06 d0 83 aa b5 09 06 ff
ff ff ff 1f 36 23 4a 75 6e 69 70 65 72 5f 45 33
32 30 5f 32 23 4c 69 6e 6b 20 54 6f 20 43 61 72
6c 2d 4d 50 4c 53 5f 50 45 2d 4e 6f 64 65 2d 35
2f 32 2f 32 23 31 30 30 35 3d 06 00 00 00 0f 05
06 30 00 03 ed 57 29 54 65 6e 47 69 67 61 62 69
74 45 74 68 65 72 6e 65 74 20 33 2f 30 2f 30 2e
39 34 31 30 30 35 3a 39 34 2d 31 30 30 35 2d 06
00 00 00 01
Code: Accounting-Request
Identifier: 99
Authentic: <208><192><4><222><190><230>H_<186><194><223><254>X<248><170><223>
Attributes:
Acct-Status-Type = Start
User-Name = "mcatra1"
Event-Timestamp = 1351784345
Acct-Delay-Time = 0
NAS-Identifier = "Juniper_E320_2"
Acct-Session-Id = "erx TenGigabitEthernet
3/0/0.941005:94-1005:1830820930"
NAS-IP-Address = 208.138.43.125
Class = "mcatra1"
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-Compression = None
Unisphere-Pppoe-Description = "pppoe 00:90:d0:30:3e:7c"
Framed-IP-Address = 208.131.170.181
Framed-IP-Netmask = 255.255.255.255
Calling-Station-Id = "#Juniper_E320_2#Link To
Carl-MPLS_PE-Node-5/2/2#1005"
NAS-Port-Type = Ethernet
NAS-Port = 805307373
NAS-Port-Id = "TenGigabitEthernet 3/0/0.941005:94-1005"
Acct-Authentic = RADIUS
Thu Nov 1 15:54:20 2012: DEBUG: Handling request with Handler
'NAS-Identifier="Juniper_E320_2"'
Thu Nov 1 15:54:20 2012: DEBUG: SQLSDB Adding session for mcatra1,
208.138.43.125, 805307373
Thu Nov 1 15:54:20 2012: DEBUG: do query is: 'delete from ACTIVE_SESSIONS
where USER_NAME='mcatra1' and NAS_IP_ADDRESS='208.138.43.125' and
NAS_PORT_ID='TenGigabitEthernet 3/0/0.941005:94-1005'':
Thu Nov 1 15:54:20 2012: DEBUG: do query is: 'insert into ACTIVE_SESSIONS
(USER_NAME,NAS_IP_ADDRESS,NAS_PORT,NAS_PORT_ID,ACCT_SESSION_ID,ACCT_START_TIME,FRAMED_IP_ADDRESS,
NAS_PORT_TYPE,SERVICE_TYPE) values
('mcatra1','208.138.43.125','805307373','TenGigabitEthernet
3/0/0.941005:94-1005','erx TenGigabitEthernet
3/0/0.941005:94-1005:1830820930','1351784345',
'208.131.170.181','Ethernet','Framed-User')':
Thu Nov 1 15:54:20 2012: DEBUG: Handling with Radius::AuthLDAP2: xDSL
Thu Nov 1 15:54:20 2012: DEBUG: AuthBy LDAP2 result: ACCEPT,
Thu Nov 1 15:54:20 2012: DEBUG: Accounting accepted
Thu Nov 1 15:54:20 2012: DEBUG: Packet dump:
*** Sending to 208.138.43.125 port 50125 ....
Packet length = 20
05 63 00 14 27 ba 05 f4 0a 38 b9 81 c6 62 d9 77
87 3e 5e c6
Code: Accounting-Response
Identifier: 99
Authentic: '<186><5><244><10>8<185><129><198>b<217>w<135>>^<198>
Attributes:
Thu Nov 1 15:54:27 2012: DEBUG: Packet dump:
*** Received from 208.138.43.125 port 50125 ....
Packet length = 380
04 64 01 7c c7 ad 75 b5 b2 4c 3c 82 c3 f6 21 7d
a3 99 2a fd 28 06 00 00 00 02 01 09 6d 63 61 74
72 61 31 37 06 50 92 97 a0 29 06 00 00 00 00 20
10 4a 75 6e 69 70 65 72 5f 45 33 32 30 5f 32 2c
38 65 72 78 20 54 65 6e 47 69 67 61 62 69 74 45
74 68 65 72 6e 65 74 20 33 2f 30 2f 30 2e 39 34
31 30 30 35 3a 39 34 2d 31 30 30 35 3a 31 38 33
30 38 32 30 39 33 30 04 06 d0 8a 2b 7d 19 09 6d
63 61 74 72 61 31 06 06 00 00 00 02 07 06 00 00
00 01 0d 06 00 00 00 00 1a 1f 00 00 13 0a 18 19
70 70 70 6f 65 20 30 30 3a 39 30 3a 64 30 3a 33
30 3a 33 65 3a 37 63 08 06 d0 83 aa b5 09 06 ff
ff ff ff 1f 36 23 4a 75 6e 69 70 65 72 5f 45 33
32 30 5f 32 23 4c 69 6e 6b 20 54 6f 20 43 61 72
6c 2d 4d 50 4c 53 5f 50 45 2d 4e 6f 64 65 2d 35
2f 32 2f 32 23 31 30 30 35 34 06 00 00 00 00 2a
06 00 00 15 d8 35 06 00 00 00 00 2b 06 00 00 46
a6 1a 0c 00 00 13 0a 2a 06 00 00 00 00 2f 06 00
00 00 51 1a 0c 00 00 13 0a 2b 06 00 00 00 00 30
06 00 00 00 40 3d 06 00 00 00 0f 05 06 30 00 03
ed 57 29 54 65 6e 47 69 67 61 62 69 74 45 74 68
65 72 6e 65 74 20 33 2f 30 2f 30 2e 39 34 31 30
30 35 3a 39 34 2d 31 30 30 35 2d 06 00 00 00 01
2e 06 00 00 00 07 31 06 00 00 00 01
Code: Accounting-Request
Identifier: 100
Authentic: <199><173>u<181><178>L<<130><195><246>!}<163><153>*<253>
Attributes:
Acct-Status-Type = Stop
User-Name = "mcatra1"
Event-Timestamp = 1351784352
Acct-Delay-Time = 0
NAS-Identifier = "Juniper_E320_2"
Acct-Session-Id = "erx TenGigabitEthernet
3/0/0.941005:94-1005:1830820930"
NAS-IP-Address = 208.138.43.125
Class = "mcatra1"
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-Compression = None
Unisphere-Pppoe-Description = "pppoe 00:90:d0:30:3e:7c"
Framed-IP-Address = 208.131.170.181
Framed-IP-Netmask = 255.255.255.255
Calling-Station-Id = "#Juniper_E320_2#Link To
Carl-MPLS_PE-Node-5/2/2#1005"
Acct-Input-Gigawords = 0
Acct-Input-Octets = 5592
Acct-Output-Gigawords = 0
Acct-Output-Octets = 18086
Unisphere-Input-Gigapkts = 0
Acct-Input-Packets = 81
Unisphere-Ouput-Gigapkts = 0
Acct-Output-Packets = 64
NAS-Port-Type = Ethernet
NAS-Port = 805307373
NAS-Port-Id = "TenGigabitEthernet 3/0/0.941005:94-1005"
Acct-Authentic = RADIUS
Acct-Session-Time = 7
Acct-Terminate-Cause = User-Request
Thu Nov 1 15:54:27 2012: DEBUG: Handling request with Handler
'NAS-Identifier="Juniper_E320_2"'
Thu Nov 1 15:54:27 2012: DEBUG: SQLSDB Deleting session for mcatra1,
208.138.43.125, 805307373
Thu Nov 1 15:54:27 2012: DEBUG: do query is: 'delete from ACTIVE_SESSIONS
where USER_NAME='mcatra1' and NAS_IP_ADDRESS='208.138.43.125' and
NAS_PORT_ID='TenGigabitEthernet 3/0/0.941005:94-1005'':
Thu Nov 1 15:54:27 2012: DEBUG: Handling with Radius::AuthLDAP2: xDSL
Thu Nov 1 15:54:27 2012: DEBUG: AuthBy LDAP2 result: ACCEPT,
Thu Nov 1 15:54:27 2012: DEBUG: Accounting accepted
Thu Nov 1 15:54:27 2012: DEBUG: Packet dump:
*** Sending to 208.138.43.125 port 50125 ....
Packet length = 20
05 64 00 14 2c 25 a3 9b e4 1a 40 69 42 6b be 66
84 99 d8 40
Code: Accounting-Response
Identifier: 100
Authentic: ,%<163><155><228><26>@iBk<190>f<132><153><216>@
Attributes:# radius.cfg
#
# Example Radiator configuration file.
# This very simple file will allow you to get started with
# a simple system. You can then add and change features.
# We suggest you start simple, prove to yourself that it
# works and then develop a more complicated configuration as required.
#
# This example will authenticate from a standard users file in
# DbDir/users and log accounting to LogDir/detail.
#
# It will accept requests from any client and try to handle request
# for any realm.
#
# You should consider this file to be a starting point only
# $Id: linux-radius.cfg,v 1.3 2002/03/24 23:07:49 mikem Exp $
#Foreground
#LogStdout
LogDir /var/log/radius
DbDir /etc/radiator
# Use a low trace level in production systems. Increase
# it to 4 or 5 for debugging, or use the -trace flag to radiusd
Trace 5
AuthPort 1645,1812
AcctPort 1646,1813
# You will probably want to add other Clients to suit your site,
# one for each NAS you want to work with
#<Client DEFAULT>
# Secret ******
# DupInterval 0
#</Client>
<Client localhost>
Secret ******
DupInterval 0
</Client>
<Client *.*.*.*>
Secret *****
DupInterval 0
</Client>
<Client *.*.*.*>
Secret ******
DupInterval 0
</Client>
#<Realm DEFAULT>
# <AuthBy FILE>
# Filename %D/users
# </AuthBy>
# # Log accounting to a detail file
# AcctLogFileName %L/detail
#</Realm>
<AuthLog FILE>
Identifier myauthlogger
Filename %L/authlog
LogSuccess 3
LogFailure 3
</AuthLog>
#<AuthBy INTERNAL>
# Identifier InvalidUsers
# AuthResult ACCEPT
# AcctResult ACCEPT
#</AuthBy>
#Authenticates broadband users
<AuthBy LDAP2>
Identifier xDSL
Host ******
AuthDN cn=directory manager
AuthPassword ******
BaseDN %0=%1,ou=IPCustomers,o=domain.com
Scope onelevel
UsernameAttr uid
PasswordAttr userPassword
SearchFilter (|(packagename=Wireless*)(packagename=ADSL*))
# DefaultSimultaneousUse 1
AuthAttrDef servicestatus,SERVICESTATUS,check
# AuthAttrDef packagename,PACKAGENAME,request
# AuthAttrDef ipaddress,ipaddress,reply
# AuthAttrDef Simultaneous-Use,Simultaneous-Use,check
# AuthAttrDef NAS-Port-Type,NAS-Port-Type,check
# AuthAttrDef Calling-Station-Id,Calling-Station-Id,check
# AuthAttrDef Called-Station-Id,Called-Station-Id,check
# AuthAttrDef NAS-IP-Address,NAS-IP-Address,check
# AuthAttrDef Framed-Address,Framed-Address,reply
# AuthAttrDef Session-Timeout,Session-Timeout,reply
# AuthAttrDef Port-Limit,Port-Limit,reply
# AuthAttrDef Framed-Pool,Framed-Pool,reply
# AuthAttrDef Framed-Route,Framed-Route,reply
Debug 255
#ServerChecksPassword
NoDefault
AddToReply Class = %{User-Name}
</AuthBy>
#Authenticates DIALUP users
<AuthBy LDAP2>
Identifier DIALUP
Host olympias1 socrates
AuthDN cn=directory manager
AuthPassword Ld@pm@n@g3r
BaseDN %0=%1,ou=IPCustomers,ou=Jamaica,ou=Customers,o=time4lime.com
# SearchFilter (%0=%1)
Scope onelevel
UsernameAttr uid
PasswordAttr userPassword
SearchFilter (packagename=Voyageur*)
AuthAttrDef servicestatus,SERVICESTATUS,check
# AuthAttrDef packagename,PACKAGENAME,request
# AuthAttrDef ipaddress,ipaddress,reply
# AuthAttrDef Simultaneous-Use,Simultaneous-Use,check
# AuthAttrDef NAS-Port-Type,NAS-Port-Type,check
# AuthAttrDef Calling-Station-Id,Calling-Station-Id,check
# AuthAttrDef Called-Station-Id,Called-Station-Id,check
# AuthAttrDef NAS-IP-Address,NAS-IP-Address,check
# AuthAttrDef Framed-Address,Framed-Address,reply
# AuthAttrDef Session-Timeout,Session-Timeout,reply
# AuthAttrDef Port-Limit,Port-Limit,reply
# AuthAttrDef Framed-Pool,Framed-Pool,reply
# AuthAttrDef Framed-Route,Framed-Route,reply
Debug 255
#ServerChecksPassword
NoDefault
# AddToReply Class = %{User-Name}
</AuthBy>
<SessionDatabase SQL>
Identifier SQLSDB
DBSource dbi:mysql:inetdb_test
DBUsername ******
DBAuth ******
AddQuery insert into ACTIVE_SESSIONS \
(USER_NAME,NAS_IP_ADDRESS,NAS_PORT,NAS_PORT_ID,ACCT_SESSION_ID,ACCT_START_TIME,FRAMED_IP_ADDRESS,
\
NAS_PORT_TYPE,SERVICE_TYPE) \
values \
('%U','%{NAS-IP-Address}','%{NAS-Port}','%{NAS-Port-Id}','%{Acct-Session-Id}','%{Event-Timestamp}',
\
'%{Framed-IP-Address}','%{NAS-Port-Type}','%{Service-Type}')
DeleteQuery delete from ACTIVE_SESSIONS where USER_NAME='%U' and
NAS_IP_ADDRESS='%{NAS-IP-Address}' and NAS_PORT_ID='%{NAS-Port-Id}'
CountQuery select
NAS_IP_ADDRESS='%{NAS-IP-Address}',NAS_PORT_ID='%{NAS-Port-Id}',ACCT_SESSION_ID='%{Acct-Session-Id}'
from ACTIVE_SESSIONS where USER_NAME='%U'
</SessionDatabase>
<AuthBy SQL>
Identifier SQLAccounting
DBSource dbi:mysql:inetdb_test
DBUsername ******
DBAuth ******
#Disable SQL authentication
#AuthSelect
HandleAcctStatusTypes Start,Stop
AccountingTable ARCH_ACCOUNTING
AcctColumnDef USER_NAME,User-Name
AcctColumnDef ACCT_START_TIME,Timestamp,integer
AcctColumnDef ACCT_STOP_TIME,Timestamp,integer
AcctColumnDef ACCT_STATUS_TYPE,Acct-Status-Type,integer
AcctColumnDef ACCT_DELAY_TIME,Acct-Delay-Time,integer
AcctColumnDef ACCT_INPUT_OCTETS,Acct-Input-Octets,integer
AcctColumnDef ACCT_OUTPUT_OCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCT_SESSION_ID,Acct-Session-Id
AcctColumnDef ACCT_SESSION_TIME,Acct-Session-Time,integer
AcctColumnDef ACCT_TERMINATE_CAUSE,Acct-Terminate-Cause,integer
AcctColumnDef FRAMED_IP_ADDRESS,Framed-IP-Address
AcctColumnDef NAS_IDENTIFIER,NAS-Identifier
AcctColumnDef NAS_PORT,NAS-Port,integer
AcctColumnDef CALLED_STATION_ID,Called-Station-Id
AcctColumnDef CALLING_STATION_ID,Calling-Station-Id
SQLRecoveryFile %L/sqlaccounting.sql
</AuthBy>
<Handler NAS-Identifier="Juniper_E320_2">
AddToRequest SERVICESTATUS = ACTIVE
AuthBy xDSL
# AuthBy DIALUP
# AuthBy InvalidUsers
SessionDatabase SQLSDB
# MaxSessions 1
RejectHasReason
AuthBy SQLAccounting
# Log authentication success and failure to the a file
AuthLog myauthlogger
# Log accounting to a detail file
AcctLogFileName %L/detail
# PostSearchHook sub {print "PostSearchHook @_\n";\
# my $attr = $_[3]->get('packagename');\
# print "get attribute $attr\n";}
</Handler>
<Handler NAS-Identifier="Juniper_E320_1">
AddToRequest SERVICESTATUS = ACTIVE
# AuthBy DIALUP
AuthBy xDSL
SessionDatabase SQLSDB
# MaxSessions 1
AuthBy SQLAccounting
RejectHasReason
# Log authentication success and failure to the a file
AuthLog myauthlogger
# Log accounting to a detail file
AcctLogFileName %L/detail
# PostSearchHook sub {print "PostSearchHook @_\n";\
# my $attr = $_[3]->get('packagename');\
# print "get attribute $attr\n";}
</Handler>_______________________________________________
radiator mailing list
[email protected]
http://www.open.com.au/mailman/listinfo/radiator
