(RADIATOR) radmin and RADIATOR

[Hugh Irvine]

Hello Lloyd -

You should get the USERID in the authentication query and send it to the NAS 
in a Class attribute in the Access-Accept. Then you would simply store the 
Class attribute in the appropriate field when the accounting packets come in.

Something like this:

# define AuthBy SQL

<AuthBy SQL>
	Identifier CheckUser
	.....
	AuthSelect select PASSWORD, CHECKATTR, REPLYATTR, USERID \
		from SUBSCRIBERS where USERNAME = '%n'
	AuthCloumnDef 0, Password, check
	AuthColumnDef 1, GENERIC, check
	AuthColumnDef 2, GENERIC, reply
	AuthColumnDef 3, Class, reply

	AccountingTable RADUSAGE
	AcctColumnDef USERNAME, User-Name
	......
	AcctColumnDef USERID, Class
</AuthBy>

You will also need to modify the RADUSAGE and the SUBSCRIBERS tables to 
contain the USERID field.

hth

Hugh


On Tuesday 18 September 2001 15:05, lloyd dagoc wrote:
> hello,
> does anyone know who or what perl radius package updates the RADUSAGE
> table..what i want to do is before radiator updates acounting table in
> RADUSAGE, i want it first to query a field in a seperate table...say
> USERID....now i want to insert USERID data to my accounting table RADUSAGE
> whenever a usage entry is inserted in my table...how do i do this?
>
> thanks = )
> lloyd
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.

-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.