Greetings,
Here's my problem. I hope someone can help, I'm beating my head on the
table. I apologize for the length, but I want to be as clear and complete
as possible to make it easier to answer.
I'm using freeradius 0.4 and the freeradius-mysql and the
radiud-freeradius-mysql packages download from Debian Woody. This addon
allows the setup of tables for your database. This has been working great
for the last 4-5 months, so I assume that things are okay with the
database, tables, etc. I have added users to the radcheck and they
authenticate correctly.
What I want to do now is create a group of users who can only login from
8:00am till 6:00pm. I added a row to the usergroup table containing the
user's name to the "UserName" column and put "daytime" in the GroupName
column. This creates a relationship between a user's name and a group
they belong to...correct??? I can log in with this account correctly...no
problem.
Now, I go to the radgroupcheck table (which I believe gets checked next
after the person's name links it to that group, and tests the
attribute/value pairs in it). I think that I can add a GroupName,
"Login-Time" and some value (string) for that group. For example, if a
row in the table "usergroup" with columns named: "id" type int (10),
"UserName" type varchar (30),
"GroupName" type varchar (30)
has the values "any integer", "bob", "daytime" , that means that bob is
part of a group name daytime...correct??
Then, if the table radgroupcheck with columns named:
"id type int (10),
"GroupName" type varchar (30)
"Attribute type varchar (40)
"Value" type varchar (40)
has values of "any integer", "daytime", "Login-Time", "0800-1800", that
means that anyone part of group "daytime" will be allowed to login between
8:00am and 6:00pm....correct???
Well, when I add these entries from the example above to the radgroupcheck
table, the authentication always fails, no matter what value I enter for
"Value".
I read the notes on this on the frontios site, and there was a mention of
the need to add field "op" type varchar(2) to the radcheck and
radgroupcheck tables, for version 0.5 and newer, but I'm only running
0.4.
Does anyone have any ideas or do I need to supply more information? Any
help is very much appreciated.
Sincerely,
Rodney Fluharty
[EMAIL PROTECTED]
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
