On Jul 6, 8:33am, Simon Lindsay wrote:
> Subject: (RADIATOR) DataTraffic
> Hi All,
> We're a new Radiator user, and theres only on thing i'm lacking before it
> goes live, we've hacked our own auth module requirements, but we have one
> more need, and i'm wondering if anybody else has already done it ;-)
> Our old system would update the datatraffic table in our mysql database
> upon disconnection of each individual user, whereas with radiator, we'll
> need to ru nthrough once a day, calculate daily usage per user and add it
> into our seperate datatraffic table which is used for billing.
> My request:
> Has anybody written such a beast, preferably in perl, preferably
> connecting to a Mysql database?
> PS. Unless theres a way to 'hook' into the accounting stop request, while
> still processing the original request in the normal manner?
Yes, there are two ways you can do this:
1. Use AcctSQLStatement, which sets an arbitrrary SQL ststement that will be
run for each accounting request ytou received (subject to AccountingStartsOnly
2. Add a PreAuthHook or PostAuthHook that will find the <AuthBy SQL> clause and
then get it to do() your additional SQL statement.
Hope that helps.
Mike McCauley [EMAIL PROTECTED]
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, etc etc on Unix, Win95/8,
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.