(RADIATOR) To Delete Temporary Userids in the Oracle Database

[Hugh Irvine]

Hello Jaafar -

Yes you can do this quite easily.

For point 1 below, you would look up the unique number when processing 
the access request and include it in a Class attribute in the access 
accept.

For point 2, you would either use Handlers or a PostAuthHook.

# define AuthBy clauses

<AuthBy SQL>
	Identifier CheckPasswordAndUniqueNumber
	....
	AuthSelect select PASSWORD, UNIQUENUMBER from SUBSCRIBERS \
		where USERNAME eq %0
	AuthColumnDef 0, Password, check
	AuthColumnDef 1, Class, reply
	.....
</AuthBy>

<AuthBy SQL>
	Identifier ProcessAccountingStop
	.....
	AuthSelect
	AccountingTable ACCOUNTING
	AcctSQLStatement delete from SUBSCRIBERS \
		where UNIQUENUMBER = %{Class}
	.....
</AuthBy>

# define Handlers

<Handler Acct-Status-Type = Stop>
	AuthByPolicy ContinueAlways
	AuthBy ProcessAccountingStop
	.....
</Handler>

<Handler ....>
	.....
</Handler>


If you have any further questions, please don't hesitate to ask.

regards

Hugh


>
> Hello
>
> We have this scenario:
>
> - temporary userids are provisioned in the Oracle Database.
> - each userids are tied to a unique number.
>
> 1.  we want this unique number to be included in the accounting STOP
>     packets.
> 2.  when user logout, we want the userids to be deleted from the 
> Database.
>
> Can these 2 be achieved in Radiator ?
>
>
> Pls advise.
>
> Thank you.
>
>
>
> Best Regards
> Jaafar Sarim
> SingNet
>
> -------------------------------------------------------
>
> --
> Mike McCauley                               mikem at open.com.au
> Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
> 24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
> Phone +61 3 9598-0985                       Fax   +61 3 9598-0955
>
> 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 etc etc
> on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X etc etc
>
> ===
> 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.