On 11/24/2009 10:32 AM, Peter Carlstedt wrote:
The database "radcheck" is for a singeluser if I have understood it
correctly.
I don't know what you mean by single user, but radcheck has all the
users in it. It may have more than one row for a given user if you want
to check more than one attribute for that user.
What I want to do is that through MS Access make a form where I can add
several attributes to the same row in the table.
I don't know what MS Access has to do with this unless you're somehow
using it as a GUI front end to MySQL, but it should be obvious you can't
have more than one attribute per row (because that's the schema).
But since radcheck only seem to work with one attribute per row for one
user I dont really know how to do.
What I mean is that if I have a user called "test-user" and want to have
two attributes for that user, in this case "Cleartext-Password" &
"NAS-Port-Id" I need to have two rows for that user.
Thats right.
The way radcheck works is does a query for all the attributes associated
with a user, if *any* attribute comparison matches (using the operator
for that attribute) then the check succeeds.
Caveat: some attributes are skipped during comparison (e.g. passwords,
auth_type, etc.) because they aren't relevant during authorization.
The table looks like this in Access(when i want to use two or more
attributes):
radcheck:
------------------------------------------------------
_|id|username |attribute |op |value |_
|1 |user-test |Cleartext-Password|== |test-pass |
|2 |user-test |NAS-Port-Id |== |raket |
-------------------------------------------------------
--
John Dennis <[email protected]>
Looking to carve out IT costs?
www.redhat.com/carveoutcosts/
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
