Hi All,

Its been a while....

YFi Hotspot Manager Beta-1 (the new incarnation of Hotcakes Hotspot Manager) is now available for public consumption.

A total rewrite which uses the latest buzzword technologies.

Now you can.....
1.) Create Vouchers and export them to PDF or CSV.
2.) Vouchers has an expiry date, only start to count-down upon first log in.
3.) Batch voucher creation
4.) Realm creation - Access providers gets assigned to one or more realms.
5.) Permanent users who you can supply extra caps (Data or Time)
6.) Notify them about events EG Maintain work on the Week-end
7.) Notify them on their usage.
8.) Permanent users has their own log-in page to view their usage.
9.) Geared for large or small deployments

and GPL as before

You can grab Beta-1 here:

http://sourceforge.net/projects/hotcakes/

Cheers

Hi Paul

You can try this:

Be sure to define a 'Check Attribute' of 'Session-Timeout' when you make use of rlm_sqlcounter.
EG
Session-Timeout     :=    1200

you can then define a counter like this in the modules:

sqlcounter noresetcounter {
                counter-name = Session-Timeout
                check-name = Session-Timeout
                reply-name = Session-Timeout
                sqlmod-inst = sql
                key = User-Name
                reset = never
                query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{%k}'"

}

Include it in the 'authorize {      }' section
EG 'noresetcounter'

rlm_sqlcounter will then take the check value defined and subtract the value of the SQL statement's result.

The newer versions of rlm_sqlcounter also lets you define the reply attribute, which can be handy to give users a data 'cap'.
It did prove to be buggy though on large values.

If you are lazy you could just grab a copy of Hotcakes, It already has these counters pre-defined and works 'out of the box'