Hello Ferhat -
On Wed, 15 Dec 1999, Ferhat DILMAN wrote:
>
> Hi,
>
> Is it possible to run seperate AcctSQLstatement per START and STOP
> accounting requests?
>
> I would like to run a specific SQL statement when Acct START request
> received and STOP request received.
>
Sure - set up separate Handlers for each one:
....
<Handler Acct-Status-Type = Start>
<AuthBy SQL>
DBSource ...
DBAuth ...
DBUsername ...
AuthSelsect
AccountingTable ....
AcctSQLStatement ....
</AuthBy>
</Handler>
<Handler Acct-Status-Type = Stop>
<AuthBy SQL>
DBSource ...
DBAuth ...
DBUsername ...
AuthSelsect
AccountingTable ....
AcctSQLStatement ....
</AuthBy>
</Handler>
....
The usual caveats apply regarding Realms and Handlers - change all Realms (if
used) to Handlers: <Realm foo.bar> becomes <Handler Realm = foo.bar> and make
sure to order your Handlers appropriately (more restrictive before more
general).
regards
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
