Hi Hugh,
Thanks for your help.
I have a table that looks like (below) now.
USERNAME ACCTSTYPE TIME
NAS-IDENTIFIER FRAMED-IP-ADDRESS TIMESTAMP
[EMAIL PROTECTED] Start Jan
21, 2003 07:02 viruse1 80.247.158.69
1043136137
[EMAIL PROTECTED] Stop Jan 21,
2003 08:51 viruse1 80.247.158.69
1043142670
[EMAIL PROTECTED] Start Jan 16,
2003 22:58 viruse1 80.247.158.68
1042761506
[EMAIL PROTECTED] Stop Jan 16, 2003
23:12 viruse1 80.247.158.68
1042762372
Now, is there a way I can generate accounting records that show how long the
particular IPASS user was logged on? I guess such a
record would have to be logged when the accounting stop packet is sent to
radiator. So that I have a table such as:
USERNAME ACCTSTYPE TIME
NAS-IDENTIFIER FRAMED-IP-ADDRESS
[EMAIL PROTECTED] Stop 30:00
viruse1 80.247.158.69
[EMAIL PROTECTED] Stop 15:00
viruse1 80.247.158.69
[EMAIL PROTECTED] Stop 17:23
viruse1 80.247.158.68
[EMAIL PROTECTED] Stop 1:12:02
viruse1 80.247.158.68
where the "TIME" column is the length of time the user spemt online. (I
don't really need the ACCTSTYPE column)
My config at the moment is as below:
<AuthBy SQL>
Identifier IPASSSQLAccounting
DBSource dbi:Oracle:radius00
DBUsername radiusgold
DBAuth radiusgold
HandleAcctStatusTypes Start, Stop
AuthSelect
AccountingTable IPASSACCOUNTING
AcctColumnDef USERNAME, User-Name
AcctColumnDef ACCTSTATUSTYPE, Acct-Status-Type
AcctColumnDef TIME, Timestamp, integer-date
AcctColumnDef NASIDENTIFIER, NAS-Identifier
AcctColumnDef FRAMEDIPADDRESS, Framed-IP-Address
AcctColumnDef TIMESTAMP, Timestamp
</AuthBy>
<AuthBy DYNADDRESS>
Identifier myIPADDRESSauth
Allocator mySQLallocator
PoolHint %{Client:Identifier}
MapAttribute yiaddr, Framed-IP-Address
MapAttribute subnetmask, Framed-IP-Netmask
StripFromReply PoolHint
AddToReply MS-MPPE-Encryption-Policy = 1, MS-MPPE-Encryption-Types
= 6
AddToReply MS-MPPE-Send-Key, MS-MPPE-Recv-Key
DefaultSimultaneousUse 1
</AuthBy>
<AuthBy DYNADDRESS>
Identifier noIPADDRESSauth
Allocator mySQLallocator
MapAttribute yiaddr, Framed-IP-Address
MapAttribute subnetmask, Framed-IP-Netmask
StripFromReply PoolHint
AddToReply MS-MPPE-Encryption-Policy = 1, MS-MPPE-Encryption-Types
= 6
AddToReply MS-MPPE-Send-Key, MS-MPPE-Recv-Key
DefaultSimultaneousUse 1
</AuthBy>
<AuthBy DYNADDRESS>
Identifier pattonIPADDRESSauth
Allocator mySQLallocator
MapAttribute yiaddr, Framed-IP-Address
MapAttribute subnetmask, Framed-IP-Netmask
StripFromReply PoolHint
DefaultSimultaneousUse 1
</AuthBy>
###### proxy radius for IPASS
<AuthBy RADIUS>
Identifier ipassNetserver
Host 63.10.24.21
Secret
AuthPort 11812
AcctPort 11813
AddToRequest Called-Station-Id=%{Called-Station-Id},
NAS-IP-Address=%N
DefaultSimultaneousUse 1
</AuthBy>
#=================== HANDLERs ================================
<Handler Realm=myipass>
RewriteUsername
s/^IPASS\/([^#]+)\#([^@]+)\@myipass$/IPASS\/$1\@$2/
AuthByPolicy ContinueAlways
AuthBy IPASSSQLAccounting
AuthBy ipassNetserver
</Handler>
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
