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

  • »

    How to Create Gmail Account Successfully |   August 17, 2015

    Email is the heart of any business communication today. Not only enterprise companies but also our personal life’s activities are mostly depended on email. So, every person should have an email account today. There are many online companies (such as Gmail, Yahoo and Hotmail) who are providing free email services for any online users. Among these online companies, Gmail is the most popular free email service by Google with 15 GB free storage facility. Gmail has huge features to maintain [...]

    READ MORE »

  • »

    MikroTik User Manager RADIUS Installation on RouterOS 7 |   July 5, 2022

    The User Manager is a MikroTik provided RADIUS Server packages. It can be used to manage users for small or medium level business. User Manger is not a default RouterOS packages. So, we have to install user manager as an extra package in RouterOS 7. RouterOS 7 has brought a massive change on User Manager package. The most important change is managing User Manager from Winbox while in RouterOS 6 the User Manager package can only be managed from Web [...]

    READ MORE »

  • »

    MikroTik DHCP Server Configuration with Radius Server |   January 24, 2018

    The Dynamic Host Configuration Protocol (DHCP) is a client-server protocol that is used to assign an IP address and other network configuration parameters dynamically to each device on a network so that they can communicate with other IP networks. DHCP Server is popularly used in an Enterprise Office Network because in an office network various types of IP devices such as Laptop, Desktop, Tablet, Smartphone, IP Phone and so on are maintained and almost all IP devices support DHCP. An ISP Network can also be [...]

    READ MORE »

  • »

    MikroTik Site to Site VPN with L2TP/IPsec |   March 3, 2018

    VPN (Virtual Private Network) is a technology that provides a secure and encrypted tunnel across a public network. A private network user can send and receive data to any remote private network using this VPN Tunnel as if his/her network device was directly connected to that private network. MikroTik L2TP server is one of the most popular VPN services. It provides a secure and encrypted tunnel across public network for transporting IP traffic using PPP. L2TP/IPsec is more secure than [...]

    READ MORE »

  • »

    Why ISPs Should Embrace TR-069 ACS to Stay Ahead of Competitors |   May 22, 2023

    As the telecommunications industry becomes more competitive, local ISPs need to find ways to stay ahead of larger telcos and offer services that meet the changing demands of their customers. One of the solutions to this challenge is to implement TR-069 ACS server to help streamline network management, reduce costs, and increase efficiency. In this article, we’ll explore why the TR-069 ACS server is essential for medium-sized ISPs to stay competitive in today’s market. We’ll examine the challenges these ISPs [...]

    READ MORE »

  • »

    Free Internet Speed Test Online |   August 31, 2015

    You are here because you want to check your broadband internet speed. Don’t worry, I will show you how to check your internet speed from online absolutely free and fastest way. I will show you top 4 websites link from which your broadband internet speed can be checked so easily. I will also show you how to check bandwidth usage continuously with windows operating system’s utility and a third party software utility. So, keep reading this article and find how [...]

    READ MORE »

  • »

    Setting Google as Default Search Engine |   September 30, 2015

    Google is one of the most popular search engines to any online user. It is said that no online user cannot go a single day without Google search engine. Google search statistics shows that over 40,000 search queries are processed every second by Google. If you have any query about any subject, just type in Google search box and Google will show you billion of results related to your search query within less than a second. So, usually you will want [...]

    READ MORE »