Author: Rahul

SSL is useful for secure communication between user and web server. Certificate encrypt the data while traveling on public lines, So it will be secure from hackers. Self-signed certificates are free to use but do not use in the production environment where confidential data like a credit card, PayPal information are used. Click here to read more details about Self-signed certificates. This how-to guide will help you to step by step create and install Self Signed Certificate in Apache server on Linux systems. Step 1 – Install mod_ssl Package In order to set up a SSL certificate, make sure mod_ssl…

SAP HANA is an in-memory data platform that is deployable as an on-premise appliance, or in the cloud. It is a revolutionary platform that’s best suited for performing real-time analytics, and developing and deploying real-time applications. Click here to know more about SAP HANA. Use following steps to backup SAP HANA database using command line. Use sql command line backup are recommended in batch mode only Step 1. Login to SAP HANA Server First we need to connect to SAP HANA server using Linux clients (eg: putty) with root user. Step 2. Switch to SAPHANA Admin User Now we need…

Definition at Wikipedia: Caching name servers, also called DNS caches, store DNS query results for a period of time determined in the configuration (time-to-live) of each domain-name record. DNS caches improve the efficiency of the DNS by reducing DNS traffic across the Internet, and by reducing load on authoritative name-servers, particularly root name-servers. Because they can answer questions more quickly, they also increase the performance of end-user applications that use the DNS. Read more This article will help you to setup caching nameserver on your CentOS/RHEL 6 system. Step 1: Install BIND Packages Install bind packages using below command. In…

Elgg is an opensource PHP based application. This is very useful creating social networking site in few minutes. Click here to read more about Elgg. This article will help you to install Elgg on LAMP environment on CentOS, RHEL & Fedora systems. For this tutorial we assume that you already have LAMP setup on your system. If you do not have LAMP setup use this article to setup. Step 1: Download Elgg Archive and Extract Firstly we need to downlaod Elgg archive file and extract it in appropriate directory. # cd /var/www # wget wget http://elgg.org/download/elgg-1.8.17.zip Extract archive in document…

Apache mod_deflate module is used for compressing content before serving to client. You can configure compression only if your hosting provider has enabled the mod_deflate module in Apache. The WHM administrators can enable Gzip globally for all cPanel accounts using WHM control panel. Non cPanel users can enable gzip in Apache web server or Nginx web server using command line. Let’s use the following steps to enable Apache gzip compression using the cPanel web interface. Step 1 – Login to cPanel Account Firstly login to your cPanel account using the web interface. The default cPanel interface is accessible on ports…

Are you having trouble managing and running cron jobs on your Linux server? As a system administrator or engineer, handling cron jobs can be a daily task. Remembering the syntax for setting up a new cron job can be hard, but it’s important for good server management. Cron jobs help automate repetitive tasks on your server. Whether you use CentOS, RHEL, or another Linux version, the crontab command is your main tool for editing and managing these jobs. Creating a cron job might seem easy, but it can get tricky when dealing with multiple users and different server setups. Luckily,…

Apache mod_deflate module is responsible for the DEFLATE output filter that allows output from your server to be compressed before being sent to the client over the network. mod_deflate is the replacement of mod_gzip which was used with older version of Apache. The users with cPanel access only can also enable the Gzip compression. Follow our other article to enable Apache Gzip Compression in cPanel only account. The users with root access can use the WHM panel and enable Apache mod_deflate globally for all cPanel users. Let’s follow the below steps to enable apache Gzip compression (mod_deflate) for all cPanel…

This article is second part of the article Setup Rsyslog with MySQL and LogAnalyzer on CentOS/RHEL systems. In the first part we have integrated Rsyslog with MySQL database server, and all the logs are now saving in database. For recalling below is few configuration details which we used in part-1 to setup it. Rsyslog MySQL Database: Syslog Rsyslog MySQL Username: rsyslog Rsyslog MySQL Password: MYSQLPASSWORD Let’s start the setup of LogAnalyzer on your Linux system with rsyslog database using following steps. Step 1 – Download LogAnalyzer Source Download the LogAnalyzer latest version from its official download site or use the…

PostgreSQL is an advanced database management system used for storing structured or non-structured data. It supports both SQL (relational) and JSON (non-relational) querying, which makes it more advance than other traditional databases. In this beginners tutorial, you will learn about basic PostgreSQL commands and SQL statements. We have tried to include all basic commands, required for beginners to start working with it. Also, I request all our readers to send their valuable suggestions to improve this article. This tutorial doesn’t cover the installation of the PostgreSQL server. You can visit here to install the PostgreSQL server as per your operating…

Rsyslog is an enhanced version of Linux syslog utility. It provides a very efficient way to setup centralized log server in hosting environment. This article will help you to save log files to MySQL database with easy steps. If you have already configured centralized log server, then you can simply setup database on your central log server. This article is created in two parts, In this page you will find setup of Rsyslog integration with MySQL database. In the next article helps you to install and integrate LogAnalyzer with this setup. Step 1: Install MySQL, Apache and PHP First we…