Hello Aaron -
On Tue, 26 Sep 2000, [EMAIL PROTECTED] wrote:
> I am using a MwSQL DB to authenticate and log accounting requests. I would
> like to only get starts and stops and no alives because they clutter up my
> DB. How can I configure that?? I currently have one realm for DEFAULT and
> and AuthBySQL clause in it. Any assitance would be appreciated.
>
Here is one way to do it:
# configuration to log accounting starts and accounting stops only
# first AuthBy does accounting only (note empty AuthSelect)
# second AuthBy does authentication only (note empty AccountingTable)
# second AuthBy will also acknowledge accounting alives
<AuthBy SQL>
Identifier SQLAccounting
DBSource ....
DBUsername ....
DBAuth .....
AuthSelect
AccountingTable ACCOUNTING
AcctColumnDef .....
.......
</AuthBy>
<AuthBy SQL>
Identifier SQLAuthentication
DBSource ....
DBUsername ....
DBAuth .....
AuthSelect select .......
AuthColumnDef .....
.......
AccountingTable
</AuthBy>
# configure first Handler for accounting
# second Handler for authentication
<Handler Acct-Status-Type = /Start|Stop/>
AuthBy SQLAccounting
</Handler>
<Handler>
AuthBy SQLAuthentication
</AuthBy>
If you have any questions please ask.
regards
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
