Hello Jamie -
>
> >I am currently authenticating users via AuthRODOPI which works great ...
>>what I would like to do is log the accounting details (date, time, IP,
>>start, stop) to an external database (i.e. Access or MySQL) ...
>>
>>I am going to code a small ASP/PHP utility for tracking abusers as we get
>>alot of reports of user on XXX IP at XXX time and it takes a long time to
>>untar all the detail archies and search through them ... a database would
>be
>>much easier ...
>>
>>Is this possible? ... if so does anyone have any sample cfg's I could looks
> >at?
>>
Very simple:
# configuration for second SQL database
<AuthBy RODOPI>
Identifier CheckRODOPI
DBSource ....
DBUsername ....
DBAuth ....
....
</AuthBy>
<AuthBy SQL>
Identifer SQLAccounting
DBSource ....
DBUsername ....
DBAuth ....
AuthSelect
AccountingTable ....
AcctColumnDef ....
AcctSQLStatement ....
</AuthBy>
# Realms or Handlers
<Realm ....>
AuthByPolicy ContinueAlways
AuthBy SQLAccounting
AuthBy CheckRODOPI
</Realm>
There are also lots of examples on the archive site:
http://www.starport.net/~radiator
hth
Hugh
--
NB: I am travelling this week, so there may be delays in our correspondence.
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.
