freeradius mysql group configuration

Most Relevant Content

  • FreeRADIUS User Group Management with MySQL

    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 configure user group in MySQL module to categorize freeRADIUS user’s reply attributes. FreeRADIUS User Group Group is used to categorize some attributes those will be applied on some users. In freeRADIUS, these attribute are referred to as AVP. So, before going to configure user group, we should have clear concept on freeRADIUS AVP. Attribute Value Pair (AVP) AVP is the workhorse of the RADIUS Protocol. Communication between a RADIUS Server and RADIUS Client is done based on AVPs. AVP can be categorized either check or reply attributes. Check attributes are sent from the client to the server. Reply attributes are sent from the server to the client. Attributes serve as carriers of information between the RADIUS Client and Server. The [...]

    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 Profile Configuration for MikroTik Router |   January 10, 2019

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

    READ MORE »

  • »

    MikroTik Radius Configuration with FreeRADIUS and MySQL |   December 18, 2018

    FreeRADIUS is a modular RADIUS suite. A lot of modules such as Perl, python, MySQL etc. can be integrated with freeRADIUS to enrich freeRADIUS features. MySQL is one of the best user and client sources in freeRADIUS server. One of the important advantages of MySQL with freeRADIUS server is that MySQL can easily be controlled with a lot of programming languages including PHP. So, freeRADIUS users and their authentication, authorization and accounting can easily be controlled graphically using MySQL database [...]

    READ MORE »

  • »

    MikroTik Radius Configuration with FreeRADIUS |   December 7, 2018

    FreeRADIUS is a high performance RADIUS suite that provides authentication, authorization and accounting facility for a large number of network devices including MikroTik Router. Although MikroTik has user manager RADIUS service to provide authentication, authorization and accounting facility but it is not free for customization and not suitable for medium to large organization. On the other hand, freeRADIUS is free for customization according to your organization requirements. But freeRADIUS has to be customized by you. In my previous article, I [...]

    READ MORE »

  • You May Also Like

  • »

    Apache2 Web Server HTTPS Configuration on Ubuntu Server |   August 15, 2021

    Data transmission between web server and web client over port 80 (HTTP) is not encrypted. So, any middle man between web server and web client can view transmitted data and can steal secret information. To overcome this limitation, HTTPS Protocol over port 443 has been introduced. HTTPS is a secure web server that is configured with SSL/TLS certificate. TLS (Transport Layer Security) and its predecessor SSL (Secure Sockets Layer) are web protocols used to wrap normal traffic in a protected, [...]

    READ MORE »

  • »

    MikroTik OpenVPN Configuration on TCP Port 443 with Windows OS |   April 6, 2020

    MikroTik OpenVPN is an amazing VPN solution. IT provides a secure and encrypted VPN tunnel across public network. Unlike PPTP and L2TP VPN Services which are poorly designed and can easily be blocked, OpenVPN can highly be customized and even can be run on so popular TCP Port 443. So, OpenVPN cannot easily be blocked. OpenVPN uses SSL/TLS Certificates. So, OpenVPN Tunnel is a trusted tunnel to send and receive data across public network. OpenVPN is a site to site [...]

    READ MORE »

  • »

    Ubuntu Server 20.04 Installation with LVM |   May 28, 2021

    Linux is a free and open source operating system developed by Linus Torvalds on September 17, 1991. It is mainly used as server environment. A lot of Linux distributions are present today. Among them, Ubuntu is one of the best stable Linux distributions. Ubuntu has both Desktop and Server distribution. Ubuntu Server is a high performance and stable enterprise Linux distribution and it can be easily used in production. Ubuntu Server has both community-support and well documentation. So, IT guys can use Ubuntu [...]

    READ MORE »

  • »

    MikroTik Winbox 4: New, Fast and Simple RouterOS GUI |   September 16, 2024

    MikroTik Winbox 4 is a new era of MikroTik network management. Winbox 4 is a new, fast and simple RouterOS GUI. Winbox 4 has a modern and intuitive Graphical User Interface which is preferred and loved by the MikroTik network engineer to manage RouterOS. MikroTik Winbox 4 is now available for download and can be download for Windows, Linux and macOS. Winbox 4 has new features which was absent in previous Winbox version. In this article, we will see how [...]

    READ MORE »

  • »

    NGINX and PHP-FPM: A High-Performance Web Hosting Duo |   September 26, 2024

    When it comes to hosting high-performance websites or web applications, Nginx and PHP-FPM are often paired together due to their complementary capabilities. NGINX is a highly efficient web server which works seamlessly with PHP-FPM. PHP-FPM is a FastCGI Process Manager for PHP that is used to deliver fast, reliable, and scalable solutions for dynamic content. What is Nginx? Nginx (pronounced as “engine-ex”) is a lightweight, high-performance web server that is widely used for serving static content, load balancing and reverse [...]

    READ MORE »