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

Header Data

From: th***o@staedteregion-aachen.de
Message Hash: fdf722c5fbcb3b376aac0f3a73114882a77028afff8c11d4bea6992dfcd32aba
Message ID: <OF72A68F1D.AF47E8DF-ONC1257C31.00385BFD-C1257C31.0038AE08@kreis-aachen.intern>
Reply To: <CAJc1nurT=AFS+=VYCq_Hi7fmDBWZdPdJ=B4YZ_oWxY9gT2kFig@mail.gmail.com>
UTC Datetime: 2013-11-28 03:19:06 UTC
Raw Date: Thu, 28 Nov 2013 11:19:06 +0100

Raw message 

Jed,

thanks for your reply! I think, I'm going to give this a try.
Well, as soon as I figured out, what this script actually does on our
radius db.
I'm not the sql man, you know.... :-)



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



                                                                                                                                       
  Von:        Jed Gainer <je***r@gmail.com>                                                                                         
                                                                                                                                       
  An:         GRASE Hotspot General Discussions <gr***t@lists.sourceforge.net>,                                                 
                                                                                                                                       
  Datum:      28.11.2013 03:32                                                                                                         
                                                                                                                                       
  Betreff:    Re: [GRASE-Hotspot] Time Limitations for vouchers                                                                        
                                                                                                                                       





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