Lepus(天兔)数据库监控系统基于lnmp环境安装部署-工具盒子

Lepus(天兔)数据库监控系统是是一款专业、强大的数据库监控管理系统，通过Lepus可以监控数据库的实时健康和各项性能指标，目前已支持MySQL、Oracle、MongoDB、Redis数据库的全面监控，Lepus能够查看各种实时性能状态指标，并且对监控、性能数据进行统计分析。

Lepus(天兔)数据库监控系统最新版本还停留在16年发布的v3.8-beta，官方提供的文档不够详细，并且有些地址已失效，我这里以Centos7.x系统，lnmp环境为例，重新写一篇Lepus(天兔)监控系统安装配置教程。

Lepus官方地址；http://www.lepus.cc/ http://www.dbarun.com/docs/lepus/

提前需要了解的是nginx需要配置一个rewrite规则，并且php版本不支持7.x，本文是以whsir一键包为例进行lnmp基础环境的安装。

1、安装lnmp基础环境
yum remove mariadb* yum install epel-release rpm -ivh http://mirrors.whsir.com/centos/whsir-release-centos.noarch.rpm yum install wnginx wphp56 wmysql55 gcc gcc-c++ python-pip python-devel echo 'export PATH=$PATH:/usr/local/nginx/sbin/:/usr/local/php/bin/:/usr/local/mysql/bin/' >> /etc/profile source /etc/profile

|-------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | 1 2 3 4 5 6 | yum remove mariadb* yum install epel-release rpm -ivh http://mirrors.whsir.com/centos/whsir-release-centos.noarch.rpm yum install wnginx wphp56 wmysql55 gcc gcc-c++ python-pip python-devel echo 'export PATH=$PATH:/usr/local/nginx/sbin/:/usr/local/php/bin/:/usr/local/mysql/bin/' >> /etc/profile source /etc/profile |

2、安装python基础环境

我这里使用Centos7默认的python就好（Python版本要求为Python2.6以上,不支持Python3），MySQL-python必须安装
pip install MySQL-python==1.2.5

|---|---------------------------------| | 1 | pip install MySQL-python==1.2.5 |

如果需要监控Redis，则安装（可选）
pip install redis==3.2.1

|---|--------------------------| | 1 | pip install redis==3.2.1 |

如果需要监控Mongodb，则安装（可选）
pip install pymongo==3.8.0

|---|----------------------------| | 1 | pip install pymongo==3.8.0 |

3、下载Lepus(天兔)包
cd /usr/local/src/ wget https://down.whsir.com/downloads/Lepus_v3.8_beta.tar.gz tar xf Lepus_v3.8_beta.tar.gz

|-------|---------------------------------------------------------------------------------------------------------------| | 1 2 3 | cd /usr/local/src/ wget https://down.whsir.com/downloads/Lepus_v3.8_beta.tar.gz tar xf Lepus_v3.8_beta.tar.gz |

4、创建监控数据库并授权

默认root密码为空，我这里将mysql初始化后，修改root默认密码为whsir
/etc/init.d/mysql start echo -e "\nn\ny\ny\ny\ny" | mysql_secure_installation

|-----|-------------------------------------------------------------------------------------| | 1 2 | /etc/init.d/mysql start echo -e "\nn\ny\ny\ny\ny" | mysql_secure_installation |

mysql -uroot -p mysql> set password = password('whsir'); mysql> create database lepus default character set utf8; mysql> grant select,insert,update,delete,create on lepus.* to 'lepus_user'@'localhost' identified by 'blog.whsir.com'; mysql> flush privileges; mysql> quit

|-------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | 1 2 3 4 5 6 | mysql -uroot -p mysql> set password = password('whsir'); mysql> create database lepus default character set utf8; mysql> grant select,insert,update,delete,create on lepus.* to 'lepus_user'@'localhost' identified by 'blog.whsir.com'; mysql> flush privileges; mysql> quit |

5、导入sql
cd /usr/local/src/Lepus_v3.8_beta mysql -uroot -pwhsir lepus < sql/lepus_table.sql mysql -uroot -pwhsir lepus < sql/lepus_data.sql

|-------|--------------------------------------------------------------------------------------------------------------------------------------| | 1 2 3 | cd /usr/local/src/Lepus_v3.8_beta mysql -uroot -pwhsir lepus < sql/lepus_table.sql mysql -uroot -pwhsir lepus < sql/lepus_data.sql |

6、安装Lpeus(天兔)程序
cd /usr/local/src/Lepus_v3.8_beta/python chmod +x install.sh

|-----|--------------------------------------------------------------| | 1 2 | cd /usr/local/src/Lepus_v3.8_beta/python chmod +x install.sh |

./install.sh [note] lepus will be install on basedir: /usr/local/lepus [note] /usr/local/lepus directory does not exist,will be created. [note] /usr/local/lepus directory created success. [note] wait copy files....... [note] change script permission. [note] create links. [note] install complete.

|-----------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | 1 2 3 4 5 6 7 8 | ./install.sh [note] lepus will be install on basedir: /usr/local/lepus [note] /usr/local/lepus directory does not exist,will be created. [note] /usr/local/lepus directory created success. [note] wait copy files....... [note] change script permission. [note] create links. [note] install complete. |

7、修改lepus配置文件
vi /usr/local/lepus/etc/config.ini

|---|------------------------------------| | 1 | vi /usr/local/lepus/etc/config.ini |

[monitor_server] host="127.0.0.1" port=3306 user="lepus_user" passwd="blog.whsir.com" dbname="lepus"

|-------------|--------------------------------------------------------------------------------------------------------| | 1 2 3 4 5 6 | [monitor_server] host="127.0.0.1" port=3306 user="lepus_user" passwd="blog.whsir.com" dbname="lepus" |

8、启动Lepus

启动前设置一个软连接，不然会报错，如果启动报错请查看/usr/local/lepus/logs/lepus.log
ln -sv /usr/local/mysql/lib/libmysqlclient.so.18 /usr/lib64/libmysqlclient.so.18 lepus start

|-----|----------------------------------------------------------------------------------------------| | 1 2 | ln -sv /usr/local/mysql/lib/libmysqlclient.so.18 /usr/lib64/libmysqlclient.so.18 lepus start |

9、配置天兔web管理台
cd /usr/local/src/Lepus_v3.8_beta/ mkdir /data/www cp -rf php/* /data/www cd /data/www/application/config

|---------|------------------------------------------------------------------------------------------------------------| | 1 2 3 4 | cd /usr/local/src/Lepus_v3.8_beta/ mkdir /data/www cp -rf php/* /data/www cd /data/www/application/config |

10、修改web数据库配置
vi /data/www/application/config/database.php

|---|----------------------------------------------| | 1 | vi /data/www/application/config/database.php |

$db['default']['username'] = 'lepus_user'; $db['default']['password'] = 'blog.whsir.com';

|-----|---------------------------------------------------------------------------------------------------| | 1 2 | $db['default']['username'] = 'lepus_user'; $db['default']['password'] = 'blog.whsir.com'; |

11、配置nginx

注意rewrite，如果不配置的话，web控制台是进不去的，会提示404
vi /usr/local/nginx/conf/vhost/demo.conf

|---|------------------------------------------| | 1 | vi /usr/local/nginx/conf/vhost/demo.conf |

server { listen 80 default_server; server_name _; index index.html index.htm index.php; root /data/www; error_page 500 502 503 504 /50x.html; if (!-e $request_filename) { rewrite ^(.*)$ /index.php?s=$1 break; } include enable-php56.conf; #include enable-php70.conf; #include enable-php71.conf; #include enable-php72.conf; #include enable-php73.conf; location ~ .*\.(gif|jpg|jpeg|png|bmp|swf)$ { expires 30d; } location ~ .*\.(js|css)?$ { expires 12h; } access_log /data/logs/nginx/demo_access.log; error_log /data/logs/nginx/demo_error.log; }

|-------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 | server { listen 80 default_server; server_name _; index index.html index.htm index.php; root /data/www; error_page 500 502 503 504 /50x.html; if (!-e $request_filename) { rewrite ^(.*)$ /index.php?s=$1 break; } include enable-php56.conf; #include enable-php70.conf; #include enable-php71.conf; #include enable-php72.conf; #include enable-php73.conf; location ~ .*\.(gif|jpg|jpeg|png|bmp|swf)$ { expires 30d; } location ~ .*\.(js|css)?$ { expires 12h; } access_log /data/logs/nginx/demo_access.log; error_log /data/logs/nginx/demo_error.log; } |

12、启动nginx和php
/etc/init.d/nginx start /etc/init.d/php-fpm56 start

|-----|-----------------------------------------------------| | 1 2 | /etc/init.d/nginx start /etc/init.d/php-fpm56 start |

打开浏览器输入IP地址打开天兔数据库监控系统，默认账号密码为admin/Lepusadmin