Zabbix6.0下部署开源的Zabbix报表系统ZbxTable

发布时间 2023-10-31 23:48:16作者: 呼长喜

一、环境准备
1.新建zbxtable文件夹,将三件套下载到本地存放
mkdir ~/zbxtable

ZbxTable: https://dl.cactifans.com/zbxtable/zbxtable-2.1.0.tar.gz
ZbxTable-Web: https://dl.cactifans.com/zbxtable/web.tar.gz
MS-Agent: https://dl.cactifans.com/zbxtable/ms-agent-1.0.4.tar.gz

2.创建zbxtable用户并部署zbxtable二进制文件

useradd zbxtable
tar -zxvf zbxtable-2.1.0.tar.gz -C /usr/local/
mv /usr/local/zbxtable-2.1.0 /usr/local/zbxtable
chown -R zbxtable:zbxtable /usr/local/zbxtable
cd /usr/local/zbxtable/

二、创建数据库
3.安装mysql,并添加数据库及用户

apt-get updata && apt install mysql-server
安装mysql数据库
mysql -u root -p
create database zbxtable character set utf8mb4 collate utf8mb4_bin;
create user zbxtable@127.0.0.1 identified by 'Zbxtable@pwd2022';
grant all privileges on zbxtable.* to zbxtable@127.0.0.1;

4.安装nginx
apt install nginx
ps -ef | grep nginx
systemctl enable nginx && systemctl start nginx
这里要注意,之前安装zabbix-server服务器已经安装了apache2,导致80端口被占用,现在安装nginx无法启动。需要修改nginx

5.安装redis
apt install redis
systemctl enable redis && systemctl start redis

三、修改zbxtable连接配置
6.修改app.conf

root@zbxtables01:/usr/local/zbxtable# cat conf/app.conf
; zbxtable
appname = zbxtable
httpport = 8085
runmode = dev
timeout = 12
token = de0c0d234f054c74b3d87d715f69afb6
copyrequestbody = true
EnableDocs = true

; log
log_level = 6
log_path = logs/app.log
maxlines = 1000
maxsize = 0
maxdays = 10
daily = true

#这里填写之前数据库的配置信息
; database
dbtype = mysql
dbhost = 127.0.0.1
dbuser = zbxtable
dbpass = zbxtablepwd123
dbname = zbxtable
dbport = 3306

;redis
redis_host = 127.0.0.1
redis_port = 6379
redis_pass =
redis_db = 8

#zabbix-server连接信息
; zabbix
zabbix_web = http://10.99.1.66/zabbix
zabbix_user = Admin
zabbix_pass = xxxxx
zabbix_token = 523fde85a0d0e98da08e16d1b8547d35f08816fcfa4dde3f30f29f5591bd4cd

;mail
email_from = wind.luo@huamengtech.net
email_port = 465
email_host = mail.huamengtech.net
email_isSSl = true
email_secret = xxxxx
email_nickname = 运维监控

;wechat
wechat_agentid = 1
wechat_corpid = wxa7c63522727b7790
wechat_secret = 5HA0od9bkvMMFDp8yFswwZIifoSDtmCJ4k

7.将zbxtable、nginx复制到启动项,并重新启动服务

cp /usr/local/zbxtable/zbxtable.service /etc/systemd/system/
cp cp /usr/local/zbxtable/nginx /etc/nginx/conf.d/
systemctl restart zbxtable
systemctl restart nginx

8.登录zbxtable
使用 http://ip:8088 即可访问 ZbxTable
系统默认账号:admin 密码:Zbxtable