How to install Chive on CentOS 7

How to install Chive on CentOS 7

Chive is a free and open source database management tool similar to phpmyadmin. It is easy to administer, super fast UI and good web technology. This tutorial covers the installation procedure of Chive on CentOS 7.

Installation procedure

Chive requires the LAMP server for the application to run, so before installing Chive setup the LAMP environment on the target server and then follow the below steps. Now download the package for Chive and execute the wget command.

[root@linuxhelp ~]# wget https://github.com/fusonic/chive/archive/master.zip
--2017-04-18 15:42:07--  https://github.com/fusonic/chive/archive/master.zip
Resolving github.com (github.com)... 192.30.253.113, 192.30.253.112
Connecting to github.com (github.com)|192.30.253.113|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://codeload.github.com/fusonic/chive/zip/master [following]
.
.
.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [application/zip]
Saving to: ‘ master.zip’ 
    [                                                                                                                           < =>               ] 3,879,725   12.4KB/s   in 2m 30s
2017-04-18 15:44:42 (25.2 KB/s) - ‘ master.zip’  saved [3879725]

Next extract the package directly into document root of apache and run the following command.

[root@linuxhelp ~]# unzip master.zip -d /var/www/html/
Archive:  master.zip
657678412e8f4a80f170c5fd12d277e3fb5302b2
   creating: /var/www/html/chive-master/
  inflating: /var/www/html/chive-master/.gitignore 
  inflating: /var/www/html/chive-master/.htaccess 
  inflating: /var/www/html/chive-master/README.md 
  inflating: /var/www/html/chive-master/archiveExport.sh 
   creating: /var/www/html/chive-master/assets/
 extracting: /var/www/html/chive-master/assets/.gitignore 
   creating: /var/www/html/chive-master/css/
  inflating: /var/www/html/chive-master/css/bg.gif 
  inflating: /var/www/html/chive-master/css/form.css 
  inflating: /var/www/html/chive-master/css/layout.css 
  inflating: /var/www/html/chive-master/css/main.css 
  inflating: /var/www/html/chive-master/css/reset.css 
   creating: /var/www/html/chive-master/images/
  inflating: /var/www/html/chive-master/images/blank.gif
.
.
.
master/yii/zii/widgets/jui/CJuiSlider.php 
  inflating: /var/www/html/chive-master/yii/zii/widgets/jui/CJuiSliderInput.php 
  inflating: /var/www/html/chive-master/yii/zii/widgets/jui/CJuiSortable.php 
  inflating: /var/www/html/chive-master/yii/zii/widgets/jui/CJuiTabs.php 
  inflating: /var/www/html/chive-master/yii/zii/widgets/jui/CJuiWidget.php

The package has been successfully extracted. Rename the extracted directory using the mv command as follows.

[root@linuxhelp ~]# mv /var/www/html/chive-master/ /var/www/html/chive

Now set the proper ownership and and file permission for the respective directory.

[root@linuxhelp ~]# chown -R apache:apache /var/www/html/chive
[root@linuxhelp ~]# chown -R 775 /var/www/html/chive

Login to MySQL database to create database and database user for Chive and execute the following commands.

[root@linuxhelp ~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with   or g.
Your MariaDB connection id is 10
Server version: 5.5.52-MariaDB MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type ' help '  or ' h'  for help. Type ' c'  to clear the current input statement.

MariaDB [(none)]>  create database chive 
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]>  CREATE USER ' chive' @' localhost'  IDENTIFIED BY ' 123'  
Query OK, 0 rows affected (0.03 sec)

MariaDB [(none)]>  GRANT ALL ON chive.* TO ' chive' @' localhost'  
Query OK, 0 rows affected (0.02 sec)

MariaDB [(none)]>  flush privileges 
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]>  exit 
Bye

Now open the browser and navigate to following URL http://192.168.7.160/chive. The Chive login page appears.

The application is running successfully. Now the user can use the Chive application to manage the database, schemas and tables.

Wasn' t that an easy installation procedure? Chive is one of the state of the art database tool that made the work of a web engineer very easy.