about radius server and mikrotik

RouterOS General
1

hello,

i have radius server and mikrotik, in hotspot working, I would like to use radius dhcp and add firewall address-list something for example: Name test, address 192.168.0.5.

If anyone know how to do add from radius server mysql.

please help.

thanks

2

I am not certain that I am parsing your question correctly. I may be answering the wrong question.

Here is a sample of the RADIUS attributes I set to put DHCP users into address lists. I use the address lists for mangle and queue trees, but it will work with firewall filter rules also.

FreeRADIUS / MySQL

This is a very standard FreeRADIUS table configuration.

username is mac address in the radcheck table. usernames are tied to groupnames in the radusergroup table.

mysql> select * from radgroupreply where groupname like "%Customers" order by groupname;
+-----+----------------+-----------------------+----+----------------+
| id  | groupname      | attribute             | op | value          |
+-----+----------------+-----------------------+----+----------------+
|  67 | 1MbCustomers   | Mikrotik-Address-List | =  | 1MbCustomers   |
|  66 | 1MbCustomers   | Framed-Pool           | =  | CustPub        |
| 107 | 1MbCustomers   | Session-Timeout       | =  | 3600           |
| 108 | 2MbCustomers   | Session-Timeout       | =  | 3600           |
|  68 | 2MbCustomers   | Mikrotik-Address-List | =  | 2MbCustomers   |
|  69 | 2MbCustomers   | Framed-Pool           | =  | CustPub        |
| 109 | 3MbCustomers   | Session-Timeout       | =  | 3600           |
|  71 | 3MbCustomers   | Framed-Pool           | =  | CustPub        |
|  70 | 3MbCustomers   | Mikrotik-Address-List | =  | 3MbCustomers   |
3

Thanks for the reply,

can you help? how to make sql script for mikrotik dhcp from radius + mysql.

we can contact in skype or mail?
if we can please send mail: nika.khmaladze11@gmail.com

thanks.