radius with mysql user profile management
Most Relevant Content
FreeRADIUS User Profile Configuration for MikroTik Router
FreeRADIUS is a high performance RADIUS application that accepts a large number of network devices as RADIUS Client including MikroTik Router. FreeRADIUS MySQL module helps to get user authentication and authorization information from database server and to store user accounting information in database server. Configuring MySQL user group and profile properly, freeRADIUS user restriction can easily be maintained. How to configure user group to apply user limitation was discussed in my previous article. In this article, I will discuss how to configure freeRADIUS user profile to apply user limitation with more efficiently. FreeRADIUS User Profile Configuration A user profile is nothing but a user who has no entry in radcheck and radreply table but is a member of one or more groups to hold reply attributes. Assigning group to a profile is done with radusergroup table. User-Profile internal AVP is used to assign a profile to a user with radcheck table. So, a complete profile configuration is done by the following steps. Creating user limitations with group management Assigning group to a profile holder user Assigning created profile to users In this article, we will create the following three profiles for MikroTik PPPoE users according to the above steps. Profile [...]
- »
FreeRADIUS MySQL Database GUI with phpMyAdmin on CentOS 7 | January 30, 2019
FreeRADIUS is a high performance RADIUS Server that accepts a large number of networking devices as RADIUS Client including MikroTik Router. MySQL is one of the best user sources for freeRADIUS server. In my previous article, I discussed how to install freeRADIUS server on CentOS 7 and how to integrate MySQL module with freeRADIUS server. I also discussed how to create user group and profile in MySQL database server and authenticate MikroTik PPPoE client with MySQL database user. I used [...]
- »
FreeRADIUS User Group Management with MySQL | January 3, 2019
FreeRADIUS is a high performance RADIUS Server. A number of network devices can be used with freeRADIUS Server as a RADIUS Client including MikroTik Router. As a modular RADIUS suite, freeRADIUS accepts MySQL module to query user authentication and authorization and to store accounting data. In my previous article, I discussed how to install and configure FreeRADIUS MySQL module. I also discussed how to authenticate MikroTik Login with freeRADIUS MySQL user. In this article, we will talk about how to [...]
- »
7 Best WiFi Router Brands For Home Or Apartment | September 18, 2021
So, you are deciding to buy a WiFi Router for your home or apartment and finding which brand will be the best WiFi Router for your home. A lot of brands which manufacture WiFi Router for home usage are available nowadays in the market but all brands are not renowned and don’t provide best performance for home usage. So, before going to buy a WiFi Router, you should have better understanding about Best WiFi Router Brand that provides best WiFi [...]
- »
How to Buy a Good WiFi Router for Home or Office | October 12, 2021
You are here because you want to buy a WiFi Router and want to know how to buy a good WiFi Router for your home or office or business. A lot of wireless routers are nowadays available in the market. But before buying a WiFi Router, you should know which one is a good WiFi Router for your need based on some features and specifications of the router. We will now see some key points those should have well understand [...]
- »
VMware ESXi 7.0 Installation and Basic Configuration | December 1, 2020
VMware vSphere is the pioneer in virtualization world. No other virtualization software is as feature rich as VMware vSphere. More than 500,000 enterprise data center are now using VMware vSphere. It is expected that most of the data center will be turned into virtualization in near future. As VMware vSphere provides more feature than any other virtualization software, it is also expected that demand of VMware vSphere will increase day by day. VMware ESXi is the foundation of VMware vSphere [...]
- »
PPPoE Server Configuration in MikroTik RouterOS 7 | December 2, 2023
MikroTik PPPoE is a client-server protocol and mostly used at the end ISP configuration where MikroTik RouterOS acts as a PPPoE Server and user’s WiFi Router acts as PPPoE client. MikroTik PPPoE Server can be used with MikroTik simple queue management. So, it helps to manage user’s bandwidth easily. People who are trying to do internet business should learn MikroTik PPPoE Server. Configuring PPPoE Server in MikroTik RouterOS 7 is so easy. If you have knowledge on basic RouterOS 7 [...]
- »
FreeRADIUS Installation and Basic Configuration on CentOS 7 | November 28, 2018
FreeRADIUS is a modular, high performance and highly customizable open source RADIUS server. Anyone can use FreeRADIUS without any charge and can customize his RADIUS server according to his organizational requirements. In my previous article, I discussed how to install and configure user manager RADIUS server developed by MikroTik. The main disadvantage of user manager RADIUS server is ‘it is not customizable and not suitable for medium or large organization’. On the other hand, FreeRADIUS is giving facility to customize [...]
- »
How to Block VPN Access with MikroTik Router | May 14, 2019
Sometimes system administrators create firewall rule to block unwanted websites. But VPN apps break these firewall rules and allow access to unwanted websites. For example, if Facebook is blocked with MikroTik Firewall and any expert user installs and enables VPN apps (such as OpenVPN, Hotspot Shield, ProtonVPN, NordVPN, PureVPN etc.), he can easily get access to Facebook. So, system administrators should also block popular VPN apps so that user cannot use those VPN servers. Blocking VPN apps is not so [...]
- »
MikroTik WiFi MAC Authentication with UserMan RADIUS Server | December 23, 2019
MikroTik Wireless Router is popularly used as WiFi AP. MikroTik WiFi AP has a lot of features to tune WiFi network as your requirements. MAC authentication is one the amazing and useful features in MikroTik WiFi. MAC authentication enables filtering MAC address that means no MAC can be able to connect to WiFi AP without authentication. MAC authentication can be done either local database or RADIUS Server. MAC authentication with RADIUS Server provides facility to manage multiple APs from centralized [...]
More Similar Content
You May Also Like
