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 [...]
- »
Free Web Content Filtering Software for Home Internet | August 10, 2024
We always want to keep safe our home or business internet from unwanted content. There are many internet content filtering softwares those can be used to filter internet content. Among these, OpenDNS is a Free Web Filtering Software used to keep safe home or business internet content. OpenDNS is a DNS based internet content filtering solution. If we use OpenDNS nameservers as DNS, it handles DNS request and filter Malware, Phishing and adult content related websites and denies access. Besides [...]
- »
MikroTik Hotspot Configuration with ECMP Load Balancing | September 4, 2021
MikroTik Hotspot is one of the most popular services in MikroTik RouterOS and day be day the demand of Hotspot service is increasing. MikroTik Hotspot can be used in any Airport, Hotel, Restaurant, Campus, Camp, Office or any ISP network. It is also possible to establish a WiFi Broadband Network with the MikroTik Hotspot service. How to configure MikroTik Hotspot was discussed in one of my previous articles. Although MikroTik Hotspot configuration is not so difficult but sometimes we face [...]
- »
How to Backup and Restore Mozilla Firefox Bookmarks | August 13, 2015
Bookmark is one of the most important and useful features in Mozilla Firefox Browser. If Bookmark is lost, Firefox users become very anxiety to recover it. But Mozilla Firefox also provides a tool to backup and restore Bookmarks so easily. So don’t need to be worried. If you know the proper steps about how to take a backup of your bookmark file and how to restore that bookmark backup file again, it will be very beneficial for you. So, this [...]
- »
Computer Network Topology Outline | September 12, 2017
The first thing that has to study about a network is its physical shape or design layout. It will be extremely important when a wiring scheme and design are selected for a new network installation. Actually Network Topology refers to physical shape or design layout of a network. Network topology determines how different nodes in a network are connected and how these nodes communicate to each other. Types of Computer Network Topology Network really has two shapes or two types [...]
- »
Things to Consider When Developing a Mobile App | February 27, 2022
Building a mobile app is one of the best ways to engage your target market and build an audience. If you want to develop a mobile application that will be truly successful, you need to consider every aspect of the development process. At the same time, there are many things to think about when developing a mobile app. Apps are designed to solve problems for people; if you are thinking about creating an app, you need to think about why [...]
- »
How to Block WiFi Access although Password is Known | April 23, 2024
We usually get internet connection from any ISP and buy any WiFi Router and then configure wireless/AP with password and configure DHCP Server to get connection from own WiFi devices. We use these WiFi Routers/APs at home, office, workspace or any other public places. Usually, we get connected to our WiFi using our provided WiFi password. Initially there will be no problem to keep your network safe using password authentication. But day by day your password will be known by [...]
- »
How to Prevent Simultaneous User Login in MikroTik Hotspot | November 10, 2020
MikroTik Hotspot is a user based internet access system. Most of the user authentication and authorization can be controlled with MikroTik Hotspot. But sometimes some users misuse user based authentication system. Misusing simultaneous login is one of them. Usually we provide one username and password for a user and we expect he/she will use this username and password from only one device at a time. But it is also possible to use same username and password in multiple devices at [...]
More Similar Content
You May Also Like
