2013-11-27 - Re: [GRASE-Hotspot] Time Limitations for vouchers

Header Data

From: Jed Gainer <je***r@gmail.com>
Message Hash: df28d903ad8315938786a729c41ea873346ae09bc553ec25ad2e58fca225907c
Message ID: <CAJc1nurT=AFS+=VYCq_Hi7fmDBWZdPdJ=B4YZ_oWxY9gT2kFig@mail.gmail.com>
Reply To: <CAESLx0LAvnMsmBNHGEa5ExMo_aV_n9RWxz0eGsNc=raY9vs1CQ@mail.gmail.com>
UTC Datetime: 2013-11-27 19:30:55 UTC
Raw Date: Wed, 27 Nov 2013 18:30:55 -0800

Raw message 

sqlcounter expire_on_login {
        sql_module_instance = sql

        counter_name = Expire-After-Initial-Login
        check_name = Expire-After
        key = User-Name
        reset = never
        query = "SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) \
                 FROM radacct \
                 WHERE UserName='%{${key}}' \
                 ORDER BY acctstarttime \
                 LIMIT 1;"
}




On Fri, Nov 15, 2013 at 1:02 PM, Timothy White <ti***8@gmail.com> wrote:

> This is a planned feature. It's just not done yet.
>
> Tim
>
>
> On Thu, Nov 14, 2013 at 1:57 AM, <th***o@staedteregion-aachen.de>wrote:
>
>>
>> Hi GRASE-Admins,
>>
>> we would like to create vouchers, that allow users to use the hotspot for
>> a
>> specified time period, let's say one week.
>> This period should start at the day, the user successfully logs in for the
>> first time. This is not necessarily the day, when
>> the user is created. 7 days after the first login, the account must
>> expire,
>> no matter if the user has been online for just a
>> few minutes a day or 7 days around the clock. Can this be achieved? If so,
>> how? Thanks in advance!
>>
>>
>>
>> Mit freundlichen Grüßen
>> Thomas Ginko
>>
>> StädteRegion Aachen
>> A 10.6 Zentrale Dienste
>> Informationstechnik
>> Raum C 040, Zollernstraße 10, 52070 Aachen
>> Tel.: +49(241)51982225
>> Fax: +49(241)519882225
>> Mail: th***o@staedteregion-aachen.de
>>
>> ------------------------------------------------------------------------------
>> DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
>> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
>> Free app hosting. Or install the open source package on any LAMP server.
>> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Grase-hotspot mailing list
>> Gr***t@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/grase-hotspot
>>
>
>
>
> ------------------------------------------------------------------------------
> DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
> Free app hosting. Or install the open source package on any LAMP server.
> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
> _______________________________________________
> Grase-hotspot mailing list
> Gr***t@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/grase-hotspot
>
>

Thread