How To Backup MariaDB Or MySQL Using Bash Script

The article explains how to backup all databases MySQL or MariaDB using bash script on CentOS. The script will backup all databases and will display the size of the backup file and also displays the backup time of a database. The script using bzip2 compression so if we don’t have the package, install it using the command: Continue reading

How To Install And Configure NTP On CentOS 7

NTP stands for Network Time Protocol, an Internet standard protocol originally developed by Professor David L. Mills at the University of Delaware and it is used to synchronize the clocks of computers for some time reference. NTP uses UDP port 123 and uses a hierarchical, semi-layered system of time sources. Each level of this hierarchy is termed a stratum and is assigned a number starting with zero for the reference clock at the top. A server synchronized to a stratum n server runs at stratum n + 1. The number represents the distance from the reference clock and is used to prevent cyclical dependencies in the hierarchy. Please see picture below: Continue reading

Basics of Expect Programming Language

Expect programming language is a program to automate interactions between the program and the user that expose a text terminal interface such as telnet, FTP, fsck, rlogin, ssh, and others. It is written by Don Libes in 1990 as a Tcl extension and can be installed on almost any Unix type distribution. This article will explain how to install expect on CentOS any version and how to use it.
Continue reading

How to Install Adminer On CentOS 7

In the previous article we explained how to install phpmyadmin on CentOS, but unfortunately, the application only manages MySQL or MariaDB. There is an application can manage MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB via browser is called Adminer. Adminer is an open source application written in PHP. It is built by Jakub Vrána who started to develop this tool as a light-weight alternative to phpMyAdmin, in July 2007. This article will explain how to install Adminer on CentOS 7 and as of this writing, version of Adminer is 4.6.1.
Continue reading

How To Install PhpMyAdmin On CentOS

phpMyadmin is an open source application to manage the administration of MySQL and MariaDB over the web. Using this application, we can easier to manage and handle the databases than via command line. This article explains how to install phpmyadmin on CentOS 7 and CentOS 6 using web server apache and assume that we installed database like MySQL or MariaDB on the server.
Continue reading

Install NagioSQL On CentOS 7

We already install NConf application to configure Nagios hosts, but there is another application to configure hosts in Nagios called NagioSQL application. NagiosQL is a professional, web-based configuration tool for Nagios based monitoring tools and any Nagios functionalities are supported. It is designed for large enterprise requirements as well as small environments, support for every Nagios object definition option and for template definitions (host, services, contacts), and et cetera. As of the writing, the latest version of Nagios is 3.3.0 and we will install it on CentOS 7.
Continue reading

How To Configure Only PING Service For The Host in NConf

In the previous article, we installed NConf application to manage the hosts in Nagios. But sometimes we just want to monitor the host whether the host is on or not and we need not monitor other services on the host. In short, we only want PING service only and do not require other services for the host. By default, NConf application does not provide as we want and we must configure it so we can monitor the host whether the host is on or off.
Continue reading

How to Install ownCloud on CentOS 7

OwnCloud is open source application for file sharing similar to Dropbox. Using this application we can store and access our data across all of your devices and share your files with others as well. Frank Karlitschek made the application and release its initial release in 2010. OwnCloud has 2 licenses: community and enterprise licenses and this article will explain how to install community version of ownCloud on CentOS 7.
Continue reading