Where to find sql counter module ?

[YvesDM]

On 2/24/07, Graham Beneke <graham_bulk at apolix.co.za> wrote:
>
>
> In the current version of FR (1.1.4) the sqlcounter module is no longer
> experimental - comes as in the default collection of modules.
>
> There is also a wiki article on using sqlcounter:
> http://wiki.freeradius.org/Rlm_sqlcounter
>
> Its not complete but I am working on it.
>
> --
> Graham Beneke


Interesting, tnx for your work!
I'm struggling with the sqlcounter module too for the moment.
Try to define the reply-name (FR1.1.4), but it gives me errors

If I specify this in sqlcounter.conf:
 sqlcounter volumelimit {
                counter-name = Octets-Total
                check-name = Max-Octets
                reply-name = ChilliSpot-Max-Total-Octets
                sqlmod-inst = sql
                key = User-Name
                reset = monthly

                # This query will calculate the total volume used


it results in:

freeradius -X | grep sqlcounter
<snip>
 sqlcounter: counter-name = "Octets-Total"
 sqlcounter: check-name = "Max-Octets"
 sqlcounter: reply-name = "ChilliSpot-Max-Total-Octets"
 sqlcounter: key = "User-Name"
 sqlcounter: sqlmod-inst = "sql"
 sqlcounter: query = "SELECT (SUM(AcctInputOctets) +SUM(AcctInputGigawords *
4294967295) +SUM(AcctOutputOctets) +SUM(AcctOutputGigawords * 4294967295)) /
1048576 FROM radacct WHERE UserName = '%{%k}' AND AcctStartTime >
FROM_UNIXTIME('%b')"
 sqlcounter: reset = "monthly"
 sqlcounter: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
rlm_sqlcounter: No such attribute ChilliSpot-Max-Total-Octets
obelix:/etc/freeradius#
 sqlcounter: counter-name = "Octets-Total"
 sqlcounter: check-name = "Max-Octets"
 sqlcounter: reply-name = "ChilliSpot-Max-Total-Octets"
 sqlcounter: key = "User-Name"
 sqlcounter: sqlmod-inst = "sql"
 sqlcounter: query = "SELECT (SUM(AcctInputOctets) +SUM(AcctInputGigawords *
4294967295) +SUM(AcctOutputOctets) +SUM(AcctOutputGigawords * 4294967295)) /
1048576 FROM radacct WHERE UserName = '%{%k}' AND AcctStartTime >
FROM_UNIXTIME('%b')"
 sqlcounter: reset = "monthly"
 sqlcounter: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
rlm_sqlcounter: No such attribute ChilliSpot-Max-Total-Octets
obelix:/etc/freeradius#



Strange...
But I'm not in a rush, I'll find out what's wrong :-)

Kind regards,
Yves
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070224/74119b54/attachment.html>