2014-07-10 - Re: [GRASE-Hotspot] 3 Simultaneous + limit from first login

Header Data

From: Ali Sen <al***n@gmail.com>
Message Hash: 8fc9f6e415d0dc1e3d0addc1c400b3ada31aeafd263676731af4b6ac3762b36a
Message ID: <CAP4d4+VRMPisny3kNzzbmbGXAS6DVbOdTL=mgKZvL61ApW7AcQ@mail.gmail.com>
Reply To: <CAP4d4+V0oyr=EY8Rx=co5mh6hKdeHeqVbN7HcVQsWpkYFAWVzg@mail.gmail.com>
UTC Datetime: 2014-07-10 01:24:06 UTC
Raw Date: Thu, 10 Jul 2014 11:24:06 +0300

Raw message 

i forgot sorry. you need to insert or update mysql tables for accessperiod
attribute also.
for group settings insert to radgroupcheck or for single user insert to
radcheck.
example for user test; 2 day account after first login
username test attiribute Access-Period  op :=  value  86400





-------

Ali Sen




2014-07-10 11:14 GMT+03:00 Ali Sen <al***n@gmail.com>:

> 1 - Yes it is possible but not with radmin interface. grase radmin only
> supports 1 simultaneous use.
>
> If you are familiar to mysql you can insert or change attiributes
> manually.
> for group settings you can change or insert "Simultaneous-Use" Value=3 to
> radgroupcheck table from radius database or for a single user you can
> insert "Simultaneous-Use" attiribute to  radcheck table.
>
> 2 - second question is also possible via sql counters.
> you need to edit /etc/freeradius/sql/mysql/counter.conf and add suitable
> sql parameters. (below, i will give sample counter)  and activate it by
> editing /etc/freeradius/sites-enabled/default  -->authorize --> sql section
> by adding countername. (add "accessperiod" for my sample counter)
>
>
>
> Sample Counter.  name accessperiod
> ###########
>
>         sqlcounter accessperiod {
>                 counter-name = Max-Access-Period-Never
>                 check-name = Access-Period
>                 sqlmod-inst = sql
>                 key = User-Name
>                 reset = never
>                 query = "SELECT IF(COUNT(radacctid>=1),(UNIX_TIMESTAMP() -
> IFNULL(UNIX_TIMESTAMP(AcctStartTime),0)),0) FROM radacct WHERE UserName =
> '%{%k}' AND AcctSessionTime >= 1 ORDER BY AcctStartTime LIMIT 1"
>         }
>
> ####
>
>
>
>
>
>
>
>
>
> -------
>
> Ali Sen
>
>
>
>
> 2014-07-07 8:44 GMT+03:00 Edward Allen <yb***j@gmail.com>:
>
> I want to enable simultaneous users with a limit. Is that possible?
>>
>>
>> Eg. I want to create a user and allow it to be able to signin on upto (3)
>> three devices simultaneously.
>>
>>
>> Is there a way to set time limits effective from first login?
>> Eg. i create 2day user on sunday, that user first login on wednesday
>> therefore expires on friday.
>>
>> --
>> This mailing list is for the Grase Hotspot Project
>> http://grasehotspot.org
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "Grase Hotspot" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to gr***e@grasehotspot.org.
>> To post to this group, send email to gr***t@grasehotspot.org.
>> Visit this group at
>> http://groups.google.com/a/grasehotspot.org/group/grase-hotspot/.
>> To view this discussion on the web visit
>> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/3d3b8a21-74f8-40b8-ac9b-45646d571232%40grasehotspot.org
>> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/3d3b8a21-74f8-40b8-ac9b-45646d571232%40grasehotspot.org?utm_medium=email&utm_source=footer>
>> .
>>
>
>

Thread