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…
Author: Rahul
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…
This is an copy of Star Wars totally created with ASCII characters. It can be easily watch using any computer supports telnet in command line and having internet connection. For Windows Users: Go to Start >> Run >> Type “cmd” and Press Enter It will open command prompt, now type below command and press enter and watch it. telnet towel.blinkenlights.nl For Linux Users: Open Terminal and type following command and watch it. telnet towel.blinkenlights.nl How to Enable Telnet in Windows 7, 8 Follow below steps to enable telnet client in windows 7.8. Goto Control Panel >> Programs >> Turn Windows…
Do you ever have a situation where you need to replace a word or sentence in many files? You could copy and paste it, or perhaps there’s an existing script that can do the job. But how about if you just need to replace it with another word or sentence somewhere else? You could use find, but that would be too generic and require writing a script for this task. And what if you don’t even know what word or sentence you must find and replace? How about using sed then? If you are not familiar with the Unix command…
phpPgAdmin is web-based client written in php for accessing and managing PostgreSQL databases. It provides very efficient way to work with databases on PostgreSQL like, create database, table, alter database, export/import database etc. This article will help you to install phpPgAdmin on CentOS and RedHat Systems. Before installing it make sure you have Apache and PostgreSQL installed on server. If you do not have them read our tutorials to how to install them. Installing PostgreSQL on CentOS, RHEL and Fedora Installing Apache MySQL PHP on CentOS and RHEL Step 1: Add PostgreSQL Repository First step is to install postgres repository…