Hi Guys, This tutorial will help to for installing MySQL 5.6 on CentOS/RHEL system. I am using CentOS 6, 32 bit version. For other OS version you can download files from here. Also change the rpm names in all given commands in this tutorial. Step 1: Download RPMs from MySQL Download required rpm files from MySQL cdn network using following download links. # cd /opt/ # wget http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-server-5.6.15-1.el6.i686.rpm # wget http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-client-5.6.15-1.el6.i686.rpm # wget http://cdn.mysql.com/Downloads/MySQL-5.6/MySQL-shared-5.6.15-1.el6.i686.rpm Step 2: Install MysQL RPMs Install downloaded rpms using rpm command line tool. # rpm -ivh MySQL-server-5.6.15-1.el6.i686.rpm # rpm -ivh MySQL-client-5.6.15-1.el6.i686.rpm # rpm -ivh MySQL-shared-5.6.15-1.el6.i686.rpm Step…
Author: Rahul
Email authentication has become an integral part of today’s digital world. It’s a crucial process that verifies the legitimacy of an email sender. Among the many methods of email authentication, SPF (Sender Policy Framework) is a prominent technique that aids in verifying that the emails are sent from an authorized server and helps in reducing email spam. To bolster the security and reputation of your server, it’s recommended to implement SPF records on your cPanel server. This article will guide you through the process of adding SPF records for all accounts on a cPanel server. Understanding SPF Before we dive…
The dd is a command which stands for “data duplicator”. This command is used for copying and converting data. The dd command simply copies standard input to standard output, read in 512-byte blocks. You can use the dd command to back up the entire hard disk or partition. Using the dd command you can also backup the MBR. Go through this tutorial and understand the uses of dd command. #1 – Create Backup of Existing Partition The following command will create a backup of the entire partition /dev/sdb1 and write to /backup/sdb1.img file. dd if=/dev/sdb1 of=/backup/sdb1.img Sample Output 16064937+0 records…
SQLite is a lightweight SQL database that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. Except some of the commands, SQLite uses similar command syntax as used by MySQL, Oracle. This article will help to How to use SQLite database using the command line. 1. Create SQLite Database SQLite provides a simple command to create database. Use following command to create an sqlite database. sqlite3 tecadmin.db Basically SQLite database is a file that gets created in your currect working directory. ls -l tecadmin.db -rw-r–r–. 1 root root 3072 May 11 14:32 tecadmin.db 2. Create Tables in SQLite Database After…
Until today I was using the basic HAProxy settings, Today i found a task about selection of backend server basis of url request. While working on this task, I learned about HAProxy ACLs. Task: I have wordpress installed as http://domainname.com/blog . This domain is running from 2 back-end server and balanced by HAProxy, The task is to redirect all /blog request to only single server. Network Scenario for this setup HAProxy Server: 192.168.1.90 WEB1 : 192.168.1.103 WEB2 : 192.168.1.105 Domain: tecadmin.net The below example includes ACL for url_beg. url_beg matches the string used in url submitted. Using the url all…
Git is a free and open source distributed version control system designed to handle everything from small to very large projects with speed and efficiency. Git is easy to learn and has a tiny footprint with lightning fast performance. It outclasses SCM tools like Subversion, CVS, Perforce, and ClearCase with features like cheap local branching, convenient staging areas, and multiple workflows. This how to guide will help you to upgrade git version on your CentOS/RHEL 6 system. Step 1: Install rpmforge Repository Download and install rpmforge repository rpm using following commands. RHEL/CentOS 6 – 64bit # rpm -i ‘http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm’ #…
The DNS ( Domain Name System ) is a distributed system, used for transalate domain names to IP and vice a versa. This article will help you to How to Setup Master Slave DNS Server on CentOS 6 and RHEL Systems. Network Scenario for this Setup Master DNS Server IP: 192.168.1.90 ( ns1.tecadmin.net ) Slave DNS Server IP: 192.168.1.91 ( ns2.tecadmin.net ) Domain Name : demotecadmin.net ( For Testing Purpose ) Domain IP : 192.168.1.100 ( For Testing Purpose ) Step 1: Install Required RPMS ( at Master and Slave Both ) Install bind packages at both Master and Slave…
cPanel/WHM is a web-based control panel to manage complete Linux operating system. All the cPanel accounts are created using one primary domain. This article will help you to change documentroot for the primary domain of cPanel user. You must have root shell access for changing the main/primary domain document root in cPanel, Use following steps to change document root of your primary domain in cPanel account. Prerequisites You must have SSH access to root user to cPanel server. Step 1 – Update Document Root in cPanel Use SSH to get shell access for your server as root account, using your…
Introduction The LEMP stack, consisting of Linux, Nginx, MariaDB, and PHP-FPM, is a powerful combination for hosting dynamic websites and applications. CentOS/RHEL, known for its stability and security, is an ideal choice for setting up such an environment. This guide will provide detailed instructions on installing and configuring Nginx, MariaDB, and PHP-FPM, with an emphasis on a specific PHP version to meet the requirements of various applications. 1. Preliminary System Update Update your system packages: sudo dnf update sudo dnf upgrade Enable the EPEL repository: sudo dnf install epel-release 2. Installing Nginx Install Nginx: sudo dnf install nginx Start and…
Network monitoring is an essential aspect of system administration, especially for large enterprise networks. The ability to monitor network performance helps to ensure that the network is functioning optimally and proactively identify potential problems. One of the most widely used network monitoring tools is Cacti. This open-source tool provides a comprehensive and intuitive web-based interface for monitoring network performance. In this article, we will guide you through the process of installing Cacti on CentOS and RHEL-based systems. We will also explain how to configure and use Cacti to monitor network performance. Prerequisites A system running CentOS or RHEL-based distribution Root…