sql accounting database sample
Most Relevant Content
MikroTik Radius Configuration with FreeRADIUS and MySQL
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 and PHP language. In my previous article, I discussed how to install and configure freeRADIUS on CentOS 7 Linux distribution and how to configure MikroTik Radius to use freeRADIUS as a MikroTik RADIUS server. In this article, I will discuss how to configure freeRADIUS MySQL (freeradius-mysql package) module with MariaDB database. FreeRADIUS with MySQL (MariaDB) Database To work with MySQL database, freeRADIUS provides freeradius-mysql package that contains necessary configuration file and SQL queries. So, we have to install freeradius-mysql package with our freeradius server package. To check whether freeradius-mysql package is installed or not, login to your CentOS server with root user and issue the following command from your command prompt. [root@freeradius ~]# rpm -qa | grep freeradius freeradius-utils-3.0.13-9.el7_5.x86_64 [...]
- »
What Are the 7 Layers of OSI Model and How Do They Work | October 5, 2021
The OSI Model stands for Open Systems Interconnection Model, a conceptualized framework used to describe the seven layers of a telecommunication system or network. It was established as an international standard in the year 1984 by the International Organization for Standardization. This model helps visualize how networks operate and is still used today to figure out and solve network problems, such as by a web development company. In this article, we will talk about the 7 layers of the OSI [...]
- »
MikroTik VPN Configuration with Site-to-Site PPTP | February 19, 2018
VPN (Virtual Private Network) is a technology that provides a secure and encrypted tunnel across a public network and using this VPN tunnel a private network user can send and receive data to any remote private network as if his/her network device was directly connected to that private network. MikroTik PPTP is a popular client-server VPN service that provides a secure and encrypted link across public network. MikroTik PPTP can be applied in two methods. Connecting remote workstation/client: In this [...]
- »
MikroTik RADIUS Server Setup with User Manager – RouterOS7 | August 4, 2022
MikroTik User Manager RADIUS Server is an awesome service for user Authentication, Authorization and Accounting (AAA) for a small or medium business. User Manager RADIUS Server can be used to maintain Hotspot, PPP, DHCP, IPsec, Wireless and System User authentication. In RouterOS 7, User Manager has come with new features and looking, specially, maintaining from Winbox. As User Mange package does not come with the default system package in RouterOS 7, we have to install User Manger package manually before [...]
- »
NGINX Web Server Installation and Configuration in Ubuntu | September 7, 2024
NGINX is a feature rich and high-performance software which is mainly used for Web Server. NGINX can also be used as a proxy server, load balancer, mail proxy and HTTP Cache Server. NGINX is a free and open-source software and can be run on Linux, Windows. macOS and other operating systems. NGINX is a single-thread based application. So, it can handle unlimited client requests using asynchronous technique. NGINX processes highly efficient run loops in a single-thread process called workers. Workers accept [...]
- »
MikroTik Configuration with PPPoE WAN Connection | July 18, 2018
MikroTik Router is a popular routing device to any network administrator because of having a lot of network features availability. MikroTik PPPoE Client is a special feature that is used to connect any PPPoE Server. If your ISP provides PPPoE connection, MikroTik Router is able to connect that PPPoE Server using PPPoE Client. In my previous article, I discussed how to configure MikroTik Router with static WAN connection and in this article I will show how to configure MikroTik Router [...]
- »
Securing MikroTik Router with Port Knocking | March 21, 2021
MikroTik Port Knocking strategy helps to protect MikroTik Router from hackers and unauthorized access as well as enhances MikroTik RouterOS security.
- »
How to Use Old Router as Range Extender to Boost WiFi Signal | October 7, 2019
WiFi is a technology to turn wired internet into WiFi internet and used in every home and office. Wireless internet gives you the freedom to use the internet without sitting in a single place. It is also true that speed performance drop in Wi-fi due to weak signal or interference. Sometimes laying a physical wired connection in every room is not possible. So Wi-Fi range extender setup helps you to boost signal strength. Instead of buying a new range extender [...]
- »
How to Properly Downgrade MikroTik RouterOS and Firmware | October 2, 2019
MikroTik RouterOS is in constant development and new features or bug fixes are frequently available, sometimes even monthly. So, it is always recommend upgrading MikroTik RouterOS to a latest and stable version before beginning any configuration. But sometimes you may face that the upgraded version is not working properly according to your demand or you may upgrade to a new version that you don’t want. In this case, you should come back to your workable RouterOS version and firmware. Upgrading RouterOS [...]
- »
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 [...]
You May Also Like
