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

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

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

[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