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 [...]

    READ MORE »

  • More Similar Content

  • »

    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 [...]

    READ MORE »

  • »

    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 [...]

    READ MORE »

  • You May Also Like

  • »

    MikroTik Router Integration and Configuration on GNS3 |   September 19, 2018

    GNS3 is a network simulator software used by hundreds of thousands of network engineers worldwide to emulate, configure, test and troubleshoot virtual and real networks. GNS3 can talk a large number of network vendors including MikroTik. MikroTik introduces Cloud Hosted Router (a RouterOS version) that is used to run as virtual machine and a virtual machine can easily be integrated with GNS3. So, network administrators who are fond of MikroTik Router can now configure, test and troubleshoot their MikroTik network [...]

    READ MORE »

  • »

    How to Clear Google Chrome History |   August 20, 2015

    Google Chrome is one of the most popular web browsers to online users. It provides a lot of features which help to use this browser smoothly and securely. Google Chrome history is one of the useful features in Google Chrome which helpfully caches or remembers a lot of browsing information specially username and password or login credential of your important web account when you visit various websites in internet. If you are the only user of your desktop or laptop, [...]

    READ MORE »

  • »

    Ubuntu RADIUS Server Configuration with freeRADIUS |   September 3, 2022

    Ubuntu Server is one of most popular open-source Linux Server distribution. It is stable and reliable than other Linux distributions. So, enterprise level application can be hosted on Ubuntu Server. Ubuntu RADIUS Server is popularly used for remote authentication and mostly used with the freeRADIUS open source RAIDUS application. freeRADIUS is one of the most popular and powerful AAA (Authorization, Authentication and Accounting) application. Any enterprise (specially ISP company) can use freeRADIUS for AAA solution and can develop billing system. [...]

    READ MORE »

  • »

    WiFi Station Setup in MikroTik Wireless Router |   November 27, 2019

    MikroTik Wireless Router is capable of working as a WiFi Client.  So, if any ISP provides WiFi connection for their clients, MikroTik Wireless Router can be used to connect to that ISP SSID by configuring wireless station mode. MikroTik WiFi station mode finds available SSID and connects with permitted SSID.  This wireless connection can be used as wireless WAN connection and configuring LAN, multiple devices can get internet over this wireless WAN connection. In my previous article, I discussed how [...]

    READ MORE »

  • »

    MikroTik Hotspot with Bandwidth Limitation and Prepaid Billing System |   January 14, 2018

    Say, you are a network administrator and want to establish a network that will have user bandwidth package management facility with prepaid billing system as well as partner advertisement facility. Then, MikroTik Hotspot Server Configuration with MikroTik User Manager Radius Server will be a wise decision. Because, MikroTik User Manager Radius Server is a user authentication, authorization and accounting application that will give facility to manage user bandwidth package with prepaid billing system. On the other hand, you can easily [...]

    READ MORE »

  • »

    How to Install Discord on Ubuntu 24.04 |   July 28, 2024

    Discord is a popular communication platform designed for creating communities and bringing people together through text, voice, and video chat. Originally created for gamers, Discord has expanded to encompass a wide range of communities beyond gaming, including hobbyists, professionals, study groups, and more. There are several methods of installing Discord on Ubuntu 24.04. We will be covering the easiest method for demonstration which is from the snap store. Following are the step-by-step commands to install Discord on Ubuntu 24.04. Install [...]

    READ MORE »

  • »

    How to Block Tor Browser with MikroTik Router |   June 12, 2019

    Tor Browser is an alternative to VPN and Web Proxy that breaks blocking firewall rule. If any user installs and uses Tor Browser, he/she can hide the public IP address of router and can unblock blocked websites applied on a network. So, administrators should block Tor Nodes along with other blocking firewall rule. In my previous article, I discussed how to block VPN and Proxy access with MikroTik Router and in this article I will discuss how to block Tor [...]

    READ MORE »