--- On Wed, 4/7/10, Alan DeKok <[email protected]> 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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
