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

Header Data

From: Timothy White <ti***8@gmail.com>
Message Hash: e1645b633e33943101ce79818756ad0d2810f1f3e13f8e0d66ebbee50d0159b8
Message ID: <CAESLx0+fanFJDqUZ4fhqgp4vqcTQ2SYEt-ikCW+7QYoyJGjBMA@mail.gmail.com>
Reply To: <CAJc1nurT=AFS+=VYCq_Hi7fmDBWZdPdJ=B4YZ_oWxY9gT2kFig@mail.gmail.com>
UTC Datetime: 2013-11-28 23:56:32 UTC
Raw Date: Fri, 29 Nov 2013 16:56:32 +1000

Raw message 

Jed

This is great! However, how do we handle radacct being archived each month?
i.e. Giving someone 90 days from first login?

Ideally I want to do something like this, but with a runner script that
updates another table after first login so we always have a reference point.

How do you handle the first login? What does it return?

Tim


On Thu, Nov 28, 2013 at 12:30 PM, Jed Gainer <je***r@gmail.com> wrote:

> 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
>>
>>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> Grase-hotspot mailing list
> Gr***t@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/grase-hotspot
>
>

Thread