1. 安装MySQL
yum install -y yum-utils
rpm -ivh https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm ---使用官方的mysql源
yum-config-manager --disable mysql80-community ---关闭mysql8.0的yum源
yum-config-manager --enable mysql57-community ---启用mysql5.7的yum源
yum install -y mysql-community-server
systemctl start mysqld
grep 'temporary password' /var/log/mysqld.log ---获取mysql的初始随机root密码,mysql5.7后新增的
mysql -uroot -p ---使用root进入数据库,输入密码
mysql > ALTER USER 'root'@'localhost' IDENTIFIED BY 'Zabbix2018!'; ---修改mysql中root用户的密码
mysql > flush privileges; ---刷新权限
mysql > quit
vi /etc/my.cnf ---把原来的都删掉,把下面两段复制过去
[mysql]
socket = /var/lib/mysql/mysql.sock
[mysqld]
user = mysql
port = 3306
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
bind-address = 0.0.0.0
pid-file = /var/run/mysqld/mysqld.pid
character-set-server = utf8
collation-server = utf8_general_ci
log-error = /var/log/mysqld.log
调优配置
max_connections = 10240
open_files_limit = 65535
innodb_buffer_pool_size = 1G
innodb_flush_log_at_trx_commit = 2
innodb_log_file_size =256M
systemctl restart mysqld ---修改完配置重启mysql
2. YUM部署Zabbix服务器
安装Zabbix
rpm -ivh http://repo.zabbix.com/zabbix/4.0/rhel/7/x86_64/zabbix-release-4.0-1.el7.noarch.rpm
yum install -y zabbix-server-mysql zabbix-web-mysql
yum install -y zabbix-agent ---Server端可以不装Agent服务
mysql -uroot -p
mysql > create database zabbix;
mysql > grant all on zabbix.* to 'zabbix'@'%' identified by 'Zabbix2018!'; ---授予zabbix用户zabbix数据库的所有权限,%表示所有任意主机
mysql > flush privileges; ---刷新权限
mysql > quit
vi /etc/httpd/conf/httpd.conf ---如果打开一片空白,证明前面yum install -y zabbix-server-mysql zabbix-web-mysql这里没安装好,重新安装一遍
DirectoryIndex index.html index.php ---找到DirectoryIndex,后面添加index.php
vi /var/www/html/index.php
<?php
$link=mysql_connect('192.168.1.234','zabbix','Zabbix2018!'); ---IP根据实际情况更改
if($link) echo "<h1>Success!!</h1>";
else echo "Fail!!";
mysql_close();
?>
setenforce 0 ---临时关闭SELinux
vi /etc/selinux/config
SELINUX=disabled ---把SELinux的状态改为disabled
systemctl stop firewalld
systemctl disable firewalld
systemctl start httpd
访问http://192.168.1.234,出现“Success!!”说明测试成功,可以用zabbix账户成功连进192.168.1.234的数据库
导入表结构和数据
cd /usr/share/doc/zabbix-server-mysql-4.0.2/ ---版本可能不一样,根据实际情况进行更改
zcat create.sql.gz | mysql -uroot -p zabbix ---输入密码
启动Zabbix Server进程
vi /etc/zabbix/zabbix_server.conf
DBHost=localhost
DBName=zabbix
DBUser=zabbix
DBPassword=Zabbix2018!
:wq
systemctl start zabbix-server
systemctl enable zabbix-server
vi /etc/httpd/conf.d/zabbix.conf
php_value date.timezone Asia/Shanghai ---只添加这项即可
:wq
systemctl restart httpd
3. 连通性测试
yum install zabbix-get -y
zabbix_get -s <被监控主机> -p 10050 -k "system.hostname"
部署完后可以在Server端用zabbix_get -s192.168.1.110 -p 10050 -k "system.hostname"等zabbix预定义命令来测试Server端是否能从Agent端获取到数据
注意:连通性测试要等客户端安装了zabbix-agent并开启后才能进行测试
在浏览器上输入192.168.1.107/zabbix进入Zabbix的管理web界面
image.png
image.png
image.png
image.png
image.png
image.png
image.png
image.png
点击右上角所示图标
image.png
image.png
变成中文界面了
4. 解决中文乱码
image.png
如图所示,中文部分都是乱码
[root@localhost fonts]# cd /usr/share/zabbix/fonts/
[root@localhost fonts]# ls
graphfont.ttf
[root@localhost fonts]# ll graphfont.ttf
lrwxrwxrwx. 1 root root 33 Nov 2 14:45 graphfont.ttf -> /etc/alternatives/zabbix-web-font
[root@localhost fonts]# ll /etc/alternatives/zabbix-web-font
lrwxrwxrwx. 1 root root 38 Nov 2 14:45 /etc/alternatives/zabbix-web-font -> /usr/share/fonts/dejavu/DejaVuSans.ttf
[root@localhost fonts]# ll /usr/share/fonts/dejavu/DejaVuSans.ttf
-rw-r--r--. 1 root root 720012 Feb 27 2011 /usr/share/fonts/dejavu/DejaVuSans.ttf
如上所示,zabbix所用的字体最终是链接到/usr/share/fonts/dejavu/下的DejaVuSans.ttf文件上的
[root@localhost fonts]# cd /usr/share/fonts/dejavu
[root@localhost dejavu]# ls
DejaVuSans-BoldOblique.ttf DejaVuSansCondensed-BoldOblique.ttf DejaVuSansCondensed-Oblique.ttf DejaVuSans-ExtraLight.ttf DejaVuSans.ttf
DejaVuSans-Bold.ttf DejaVuSansCondensed-Bold.ttf DejaVuSansCondensed.ttf DejaVuSans-Oblique.ttf
[root@localhost dejavu]# mv DejaVuSans.ttf{,.bak} ---把DejaVuSans.ttf改成别的名字
[root@localhost dejavu]# ls
DejaVuSans-BoldOblique.ttf DejaVuSansCondensed-BoldOblique.ttf DejaVuSansCondensed-Oblique.ttf DejaVuSans-ExtraLight.ttf DejaVuSans.ttf.bak
DejaVuSans-Bold.ttf DejaVuSansCondensed-Bold.ttf DejaVuSansCondensed.ttf DejaVuSans-Oblique.ttf
[root@localhost dejavu]# rz ---把要替换的中文字体上传上来(windows字体一般存放在c:/windows/fonts目录下)
[root@localhost dejavu]# ls
DejaVuSans-BoldOblique.ttf DejaVuSansCondensed-BoldOblique.ttf DejaVuSansCondensed-Oblique.ttf DejaVuSans-ExtraLight.ttf DejaVuSans.ttf.bak
DejaVuSans-Bold.ttf DejaVuSansCondensed-Bold.ttf DejaVuSansCondensed.ttf DejaVuSans-Oblique.ttf simsun.ttc
[root@localhost dejavu]# mv simsun.ttc DejaVuSans.ttf ---把字体名字改成DejaVuSans.ttf
image.png
字体显示正常了