mikrotik with radius problem

RouterOS General
1

hi guys
i want to use freeradius with mikrotik i setup freeradius and mysql all fine till now , i need help to know how to control mikrotik from mysql and radius i know there’s attributes and i can use them but i need examples plz to begin let’s say add user with username and password and mac address :wink:

c’mon guys let’s see experts talk :stuck_out_tongue: i know this is the hard part in mikrotik but i want to see guys speak and show their knowledge :laughing:
let’s make it :stuck_out_tongue:

2

As you know what attributes are I dont have to explain those. You have to
select the attributes you want to apply to your users, and have those accessible by column in your Mysql database keyed by user.
When you process the radius request from the Microtik, you reference
items in your database such as username, password, bytes left as check attributes, and provide information back to the Microtik from the Mysql
database such as queue attributes, speeds as reply attributes.
Something like
AuthColumnDef 0,Password,check
AuthColumnDef 1,Simultaneous-Use,check
AuthColumnDef 2,Framed-IP-Address,reply
AuthColumnDef 3,Mikrotik-Recv-Limit,reply
AuthColumnDef 4,Mikrotik-Xmit-Limit,reply
etc..

etc.. although this is from Radiator not FreeRadius, but the same principal
applys.

3

You can use dialupadmin, PHP software bundled with freeradius to add/edit users attributes. On the Mikrotik side, you just have to setup authentication over remote radius. Then you can add any attributes you need. You can read Mikrotik supported attributes in the Mikrotik’s documentation. I use freeradius to authenticate my hotspot users and to limit their bandwidth when they login and this work like a charm, no problem.