Hello everyone!
I am sitting here trying to figure out how FreeRadius works towards MySQL.
It is quite hard for me to try to explain what I want to do since Im not good
with MySQL but I will try anyway and hope someone will understand what I mean.
=)
The database "radcheck" is for a singeluser if I have understood it correctly.
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.
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.
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 |
-------------------------------------------------------
The reason I want to make a form is because I want others than me being able to
add new users and have them connected to the correct group which then will have
a separate VLAN and SSID.
So then I thought that if i use the table called "radusergroup" and link the
user to a specific group it should work in a way that all members of this group
may only connect to the network if they try to connect to the correct SSID. It
seems that did not work either. I am at a loss here and dont really know what I
should do. Sorry if my explaination is bad but it is quite hard for me to
explain.
Best regards/ Peter Carlstedt
_________________________________________________________________
Windows Live: Keep your friends up to date with what you do online.
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_1:092010-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html