I already have the authentication stuff situated however, how do I place more attributes within each table row for a user? I’m slightly confused how the MySQL portion works …
A MySQL dump of a format would be enough for me … if anyone is willing to assist 
thanks
Greetings!
I don’t know if this is the correct forum for FreeRADIUS/MySQL. I use them, and the tables in which you will be interested are the radreply (for individual user return data) and, my favorite, radgroupreply (for user group return data).
I’m sure it isn’t but, being that its related to wifi or at least in my mind … i feel that it is …
This didn’t however answer my question, I am currious how to place like for example bandwidth limitations within the radreply row of the user …
as stated i would love to see how others are doing it as i learn best by example ..
thanks
I use php scripts to modify my SQL database, but you can do it manually.
Log into MySQL, and use this:
insert into radreply (UserName,Attribute,Value) values (‘userX’,‘WISPr-Bandwidth-Max-Up’,‘256000’);
Change ‘userX’ the user you want this to affect. This example will throttle ‘userX’ to 256K upload.
ah, so radius will use the username to identify … kinda scary. but i see that will work well.. thank you!
actually, just attempted this and i still can download at whatever my connection is to the test server which is outside of the mikrotik on a public IP …
Ah! That is because that setting I gave you sets the upload speed. It has nothing to do with the download speed. That would be:
insert into radreply (UserName,Attribute,Value) values (‘userX’,‘WISPr-Bandwidth-Max-Down’,‘512000’);
This will limit download speed to 512K for userX.
BTW, you can keep your SQL radius database smaller by setting these in radgroupreply, then assign your users different groups depending on how much of each of these settings you want them to have.
insert into radgroupreply (GroupName,Attribute,Value) values (‘groupX’,‘WISPr-Bandwidth-Max-Down’,‘512000’);
This will limit download speed for all users in group “groupX”.
ok, i did alittle searching after you had told me how todo the bandwidth limitations, etc.
and tried what you had listed (up/down) … and i was on my switch pppoe’d in and she let me eat the full 100mbit to my test download server (speedtest.net’s mini download test app…)
(http://www.mikrotik.com/documentation/manual_2.9/dictionary)
do appreciate your assistance Tim …
My bad. I thought this was a wireless hotspot connection we were limiting. Well, not all my bad. This is the “wireless networking” forum.
Yes, the MikroTik variables can be used also, but only on MikroTik equipment. I have some APs still that are not MikroTik, and I must use variables that are more generic.
My AP, router are all Mikrotik based. I assumed that the router could handle the PPPoE as it is a Dual Core AMD w/ a gig of ram …
Hmm.. ideas … I don’t really want to setup user profiles (user manager) but if I have to i suppose that’ll be fine?