Zabbix5.0.30源码安装（人大金仓）
centos 7.5
nginx 1.23.0 源码安装
mysql 5.7 rpm 安装
php 7.2 rpm 安装
zabbix 5.0.30 源码安装
1、=============================================== nignx 1.23.0 安装
yum groupinstall 'Development Tools'
yum install -y vim lrzsz gcc gcc-c++ lsof zip unzip tree net-tools wget ntpdate conntrack-tools automake autoconf pcre pcre-devel libtool iproute telnet openssl openssl-devel bzip2 bzip2-devel libcurl libcurl-devel libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel gmp gmp-devel readline readline-devel libxslt libxslt-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel ncurses curl gdbm-devel libXpm-devel libX11-devel gd-devel gmp-devel expat-devel xmlrpc-c xmlrpc-c-devel libicu-devel libmemcached-devel make unixODBC unixODBC-devel libssh2-devel OpenIPMI-devel libevent-devel curl-* net-snmp* libxml2-* tar libevent golang
# useradd nginx -s /sbin/nologin -M
# cd /opt/ && wget http://nginx.org/download/nginx-1.23.0.tar.gz
# tar xf nginx-1.23.0.tar.gz
# cd nginx-1.23.0/
# ./configure --user=nginx --group=nginx --prefix=/usr/local/nginx --sbin-path=/usr/local/nginx/sbin/nginx --conf-path=/usr/local/nginx/etc/nginx.conf --error-log-path=/var/log/nginx/error.log --http-log-path=/var/log/nginx/access.log --pid-path=/var/log/nginx/nginx.pid --with-http_stub_status_module --with-http_ssl_module --with-http_gzip_static_module --with-http_v2_module --with-stream --with-stream_ssl_module --with-stream_ssl_preread_module --with-http_realip_module --with-pcre
# make && make install
# /usr/local/nginx/sbin/nginx -t
# cp -arp /usr/local/nginx/sbin/nginx /usr/bin/
================================================nginx开机启动
# vim /usr/lib/systemd/system/nginx.service
[Unit]
Description=nginx
After=network.target remote-fs.target nss-lookup.target
[Service]
Type=forking
ExecStart=/usr/local/nginx/sbin/nginx
ExecReload=/usr/local/nginx/sbin/nginx -s reload
ExecStop=/usr/local/nginx/sbin/nginx -s stop
[Install]
WantedBy=multi-user.target
systemctl daemon-reload
systemctl start nginx
systemctl status nginx.service
systemctl enable nginx.service
================================================nginx主配置文件
cat /usr/local/nginx/etc/nginx.conf
user root;
worker_processes auto;
error_log /var/log/nginx/error.log notice;
pid /var/log/nginx/nginx.pid;
events {
worker_connections 1024;
}
http {
include /usr/local/nginx/etc/mime.types;
default_type application/octet-stream;
log_format main '$remote_addr - $remote_user [$time_local] "$request" '
'$status $body_bytes_sent "$http_referer" '
'"$http_user_agent" "$http_x_forwarded_for"';
access_log /var/log/nginx/access.log main;
sendfile on;
keepalive_timeout 65;
include /usr/local/nginx/etc/conf.d/*.conf;
}
================================================nginx添加zabbix虚拟主机
mkdir /usr/local/nginx/etc/conf.d
cat /usr/local/nginx/etc/conf.d/zabbix.conf
server {
listen 80;
server_name localhost;
location / {
root /usr/local/nginx/html;
index index.html index.htm index.php;
}
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root html;
}
location /status {
stub_status on;
allow all;
access_log off;
}
location ~ \.php$ {
#root /usr/local/nginx/html;
fastcgi_pass 127.0.0.1:9000;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME /usr/local/nginx/html$fastcgi_script_name;
include fastcgi_params;
}
}
# systemctl restart nginx
# curl localhost/status
2、=============================================== mysql 5.7 安装
# rpm -Uvh mysql57-community-release-el7-10.noarch.rpm
# yum install -y mysql-community-server mysql-devel
# systemctl start mysqld.service
# systemctl status mysqld.service
# systemctl enable mysqld # systemctl daemon-reload
# grep 'temporary password' /var/log/mysqld.log
# mysql -u root -psData#888
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'sData#888'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'sData#888' WITH GRANT OPTION;
mysql> create database zabbix character set utf8 collate utf8_bin;
mysql> grant all privileges on zabbix.* to 'zabbix'@'%' identified by 'sData#888';
mysql> FLUSH PRIVILEGES;
3、=============================================== php 7.4
首先安装 EPEL 源 yum install epel-release 安装 REMI 源 yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm
yum install php74-php-mysqlnd php74-php-pgsql php74-php-bcmath php74-php-fpm php74-php-gd php74-php-xml php74-php-ldap php74-php-mbstring php74-php-xml
*******************************************************************************
php74-php-pgsql ：一个用于PHP的PostgreSQL数据库模块
备注：如果数据库是postgresql，需要换高版本
yum install postgresql-devel -y（默认为9.2.24版本，需换成高版本）
yum install centos-release-scl-rh
rpm -Uvh https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
# yum install postgresql11-devel
find / -type f -name "pg_config"
ln -s /usr/pgsql-10/bin/pg_config /usr/bin/pg_config
*******************************************************************************
vim /etc/opt/remi/php74/php.ini
post_max_size = 32M
max_input_time = 600
max_execution_time = 300
date.timezone = Asia/Shanghai
systemctl enable php74-php-fpm
systemctl start php74-php-fpm
systemctl status php74-php-fpm
4、=============================================== zabbix 5.0.30
groupadd zabbix
useradd -g zabbix zabbix -s /sbin/nologin
tar xf zabbix-5.0.30.tar.gz
cd zabbix-5.0.30
./configure --prefix=/usr/local/sdata/monitor --enable-server --enable-agent --enable-proxy --enable-java --with-libxml2 --with-net-snmp --with-libcurl --enable-ipv6 --with-openipmi --with-ssh2 --with-unixodbc --with-openssl --with-ldap --with-mysql --with-postgresql （2选1）
--enable-agent2 需要go环境
make && make install
vim /usr/local/zabbix/etc/zabbix_server.conf
DBHost=localhost
DBName=zabbix
DBUser=zabbix
DBPassword=sData#888
复制前端数据
mkdir /usr/local/nginx/html/zabbix
cd /opt/zabbix-5.0.30/ui
cp -arp * /usr/local/nginx/html/zabbix/
导入数据库
cd /opt/zabbix-5.0.30/database/mysql
mysql -u root -psData#888 zabbix < schema.sql
mysql -u root -psData#888 zabbix < images.sql
mysql -u root -psData#888 zabbix < data.sql
设置开机开机自启
# cp /opt/zabbix-5.0.30/misc/init.d/fedora/core/* /etc/init.d/
# chkconfig zabbix_server on
# chkconfig zabbix_agentd on
# vim /etc/init.d/zabbix_server
BASEDIR=/usr/local/zabbix
# vim /etc/init.d/zabbix_agentd
BASEDIR=/usr/local/zabbix
#启动zabbix
systemctl daemon-reload
/etc/init.d/zabbix_server start
/etc/init.d/zabbix_agentd start
启动zabbix-java-gateway
# /usr/local/zabbix/sbin/zabbix_java/startup.sh 【需要java环境】
完成后可以查看状态
# systemctl status zabbix_server
# systemctl status zabbix_agentd
开机启动其他参考
# vim /usr/lib/systemd/system/zabbix-server.service
[Unit]
Description=Zabbix
After=network.target
[Service]
Environment=“CONFFILE=/usr/local/zabbix/etc/zabbix_server.conf”
Type=forking
Restart=on-failure
PIDFile=/tmp/zabbix_server.pid
KillMode=control-group
ExecStart=/usr/local/zabbix/sbin/zabbix_server -c $CONFFILE
ExecStop=/bin/kill -SIGTERM $MAINPID
RestartSec=10s
[Install]
WantedBy=multi-user.target
systemctl daemon-reload
systemctl enable zabbix-server
systemctl stop zabbix-server
systemctl start zabbix-server
systemctl restart zabbix-server
# vim /lib/systemd/system/nginx.service
[UNIT]
Deion=nginx - high performance web server
Documentation=http://nginx.org/en/docs/
After=network-online.target remote-fs.target nss-lookup.target
Wants=network-online.target
[Service]
Type=forking
PIDFile=/usr/local/nginx/logs/nginx.pid
ExecStart=/usr/local/nginx/sbin/nginx -c /usr/local/nginx/conf/nginx.conf
ExecReload=/bin/kill -s HUP $MAINPID
ExecStop=/bin/kill -s TERM $MAINPID
[Install]
WantedBy=multi-user.target
# systemctl daemon-reload
# systemctl enable nginx
# systemctl stop nginx
# systemctl restart nginx
============================================================================================================================================
20230311国产人大进仓数据库(Kingbase) V008R006C007B0012作为zabbix监控数据库
zabbix5.0.30里的/opt/zabbix-5.0.30/database/postgresql/data.sql无法直接导入到人大金仓数据库，需要删除data.sql里面【.E'】中的【E】
1、验证环境
zabbix 4.0.20（zabbix5导入data.sql报错，这里用zabbix4）
Kingbase E8
php 7.4
nginx 1.23.0
2、安装过程
php安装postgresql-devel 数据库支持模块
Kingbase 开启PG模式（Oracle模式没测试）
zabbix 源码安装 开启前端支持--with-postgresql
3、人大金仓数据安装
安装java
yum install -y java-11-openjdk java-11-openjdk-devel
# vim /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
# sysctl -p
useradd kingbase
passwd kingbase sData#888
mkdir /opt/Kingbase/ES/V8 -p
cp license_26558_0.dat /opt/Kingbase/ES/
chown kingbase:kingbase -R /opt/Kingbase/ES/
===========================================================
安装过程
# mount KingbaseES_V008R006C007B0012_Lin64_install.iso /mnt/
su - kingbase
cd /mnt/
sh setup.sh -i console
授权文件
/opt/Kingbase/ES/license_26558_0.dat
安装目录
/opt/Kingbase/ES/V8/
用户名密码
system/sData#888
请输入数据库兼容模式。
1- PG
安装完成后切换到root用户
人大金仓数据库登录
$ ksql -p 54321 -U system test
创建用户
create user zabbix with superuser password 'sData#888';
创建数据库并授权
create database zabbix ENCODING ='utf-8' LC_COLLATE="zh_CN.utf-8" LC_CTYPE="zh_CN.utf-8";
grant all on database zabbix to zabbix;
导入sql
$ ksql -Uzabbix -d zabbix -p 54321 -W -f schema.sql
$ ksql -Uzabbix -d zabbix -p 54321 -W -f images.sql
$ ksql -Uzabbix -d zabbix -p 54321 -W -f data.sql
常用命令
# \l --查看所有数据库
# \l zabbix --查看单个数据库
# \du --查看所有用户
# \du zabbix --查看某个用户属性
# \c zabbix --切换数据库
# \d --查看当前数据库下所有表
# \d users --查看当前数据库下的用户表结构
# drop database zabbix; 删除数据库
查看表内容
# SELECT * FROM "users";
查看当前数据库、当前用户
# select current_database();
# select current_user;
# select version();
切换至kingbases用户，来到bin目录下，使用sys_ctl启动数据库(默认已经启动了)
su kingbase
cd /opt/Kingbase/ES/V8/Server/bin
./sys_ctl -D /opt/Kingbase/ES/V8/data/ start
浙公网安备 33010602011771号