--- On Wed, 4/7/10, Alan DeKok <aland@deployingradius.com> wrote:
a) store traffic data in the DB when an accounting packet is received
Accounting to DB is already working.
b) check that on loging
You shouldn't need to use sqlcounter. Just a plain SELECT will do it.
Thank you for clarifying that.
Write the logic in Perl first, then convert it to the server config.
That is where it is getting though for me because I am new to Perl and SQL. Maybe some with more brains could provide some insight how to solve it. Here is my SQL select statement: SELECT (SUM(AcctInputOctets + AcctOutputOctets)) FROM radacct WHERE UserName='test' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'; +-------------------------------------------+ | (SUM(AcctInputOctets + AcctOutputOctets)) | +-------------------------------------------+ | 12965354 | +-------------------------------------------+ What I would like to do is compare the returned value with another one which represents my traffic quota in bytes: SELECT Value from radcheck WHERE UserName = 'test' AND Attribute = 'Max-Octets'; +-----------+ | Value | +-----------+ | 200000000 | +-----------+ If the value of Max-Octets is exceeded, login shall be denied. Cheers, Alexander