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 [...]
- »
How to Get VMware ESXi Free License | November 5, 2021
You are here that means you are finding how to get ESXi free license because you have installed ESXi 6.7 or ESXi 7 and 60 days trial license has been expired and then all virtual machines have been powered off or you want to use VMware ESXi absolutely free of charge. Whatever your requirement, it is a good news that VMware provides free license with some limitations to use VMware ESXi absolutely free of charge. So, if you have a [...]
- »
Essential Networking Skills for Job Seekers in IT industry | March 18, 2025
The Information Technology (IT) industry is one of the most dynamic and rapidly evolving fields in the modern job market. With continuous advancements in technology, businesses are always on the lookout for skilled IT professionals who can adapt to new trends, troubleshoot complex systems, and enhance cybersecurity measures. However, technical knowledge alone is not enough to secure a job in the IT industry. One of the most critical factors in landing a job and advancing in an IT career is [...]
- »
Managing Disk Partition with the parted Tool in CentOS 7 | March 2, 2019
As a system administrator, sometimes you may require to manage partitions of your CentOS/Red Hat Linux Operating System. Partition management is always a risky task. But there are some useful tools those are so helpful to manage CentOS/Red Hat Linux disk partition easily. In my previous article, I discussed how to manage CentOS/Red Hat 7 HDD partitions with the fdisk utility. The fdisk tool is only eligible to manage MBR partition table. But GPT partition table is now becoming more [...]
- »
MikroTik Backup and Restore Configuration using Winbox | July 31, 2018
Backup and Restore feature in MikroTik Router helps to recover router configuration when running router fails to operation due to hardware failure. If you have a backup copy of your failed router and purchase a new MikroTik Router and then upload and restore that backup file, you will get your running network without any hassle. MikroTik Backup file is also useful when you unfortunately forget your admin privilege user password. You can easily recover your forgotten password with backup file [...]
- »
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 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 [...]
- »
The Importance of Digital Literacy Training in Today’s Tech-Driven World | May 19, 2025
Summary Digital literacy is an essential skill that enables people to participate in contemporary life and work because it influences educational and employment opportunities, communication methods, and civic participation. Basic computer skills and responsibility are joined by critical thinking capabilities, which lead to proper media evaluation techniques as components of digital literacy. Internet access alone does not effectively utilize digital tools since individuals need proper training to harness digital tools effectively. Organizations, including governments, educational institutions, and companies, dedicate funds [...]
- »
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 VPN Configuration with PPTP (Connecting Remote Client) | August 17, 2016
VPN (Virtual Private Network) is a technology that extends private network across a public network. It enables private network users to send and receive data across public network as if their network devices were directly connected to the private network. There are many VPN services in MikroTik RouterOS 7. Among them, MikroTik PPTP is a mostly used VPN service. It is a client-server VPN technology. So, a user can access server, printer, IP phone and any other network devices of [...]
You May Also Like
