Dear Kostas & freeradius users,
because I have more that 10 different groups day, night, test,... with different
login-times and different Max-Session-Times ...
for example the sql tables are as below:
usergroup:
+----+----------+-----------+
| id | UserName | GroupName |
+----+----------+-----------+
| 2 | mehdi | night |
| 4 | hadi | test |
+----+----------+-----------+
radgroupcheck:
+----+-----------+------------------+--------------+------+
| id | GroupName | Attribute | Value | op |
+----+-----------+------------------+--------------+------+
| 3 | night | Login-Time | Any1400-2348 | := |
| 4 | test | Max-Session-Time | 200 | := |
| 5 | test | Login-Time | Any1700-2000 | := |
+----+-----------+------------------+--------------+------+
is it possible to define groups login-time and max-session-time in users file and
define the users in sql simultaniously ?
I mean to delete the rows no. 3,4,5 from radgroupcheck and define some thing like the
following in the users file but the usergroup table be intact :
day Current-Time == "Any1400-0200", Max-Monthly-Session := 90000
Fall-Through = 1
day Current-Time == "Any0200-0700", Max-Monthly-Session := 270000
Fall-Through = 1
day Current-Time == "Any0700-1400", Max-Monthly-Session := 180000
Fall-Through = 1
test Current-Time == "Any1400-0200", Max-Monthly-Session := 190000
Fall-Through = 1
test Current-Time == "Any0200-0700", Max-Monthly-Session := 70000
Fall-Through = 1
Regards,
Mehdi Roomi,
>It's a little hard and i don't see a reason why you should prefer sql instead of
>the users file. SQL is used to define per user profile, the users file can be
>used to define profiles for all users based on checks on the incoming packets.
>> I want to define following group definition from USERS file into SQL server tables :
>>
>> DEFAULT Current-Time == "Any1400-0200", Max-Monthly-Session := 90000
>> Fall-Through = 1
>> DEFAULT Current-Time == "Any0200-0700", Max-Monthly-Session := 270000
>> Fall-Through = 1
>> DEFAULT Current-Time == "Any0700-1400", Max-Monthly-Session := 180000
>> Fall-Through = 1
>>
>> Any idea about the content of radgroup, radreply,radgroupreply &
>> radgroupcheck tables as the mentioned tables accept only one entry for a
>> specific Attribute per GroupName?
_____________________________________________________________
Promote your group and strengthen ties to your members with [EMAIL PROTECTED] by
Everyone.net http://www.everyone.net/?btn=tag
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
