Centos7+lnmp+zabbix4+分离mysql实验

wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo #下载最新的base
yum install epel-release #安装epel
yum install http://repo.zabbix.com/zabbix/4.0/rhel/7/x86_64/zabbix-release-4.0-1.el7.noarch.rpm #安装zabbix

yum install nginx -y
yum install zabbix-server-mysql zabbix-web-mysql zabbix-get
yum install -y php php-devel php-fpm php-mysql php-common php-devel php-gd libjpeg* php-imap php-
ldap php-odbc php-pear php-xml php-xmlrpc php-mbstring php-mcrypt php-bcmath php-mhash libmcrypt libmcrypt-devel

[root@web1 yum.repos.d]# rpm -qa |grep zabbix
zabbix-release-4.0-.el7.noarch
zabbix-server-mysql-4.0.-.el7.x86_64
zabbix-web-mysql-4.0.-.el7.noarch
zabbix-web-4.0.-.el7.noarch
zabbix-get-4.0.-.el7.x86_64
[root@web1 yum.repos.d]# rpm -qa |grep zabbix
zabbix-release-4.0-.el7.noarch
zabbix-server-mysql-4.0.-.el7.x86_64
zabbix-web-mysql-4.0.-.el7.noarch
zabbix-web-4.0.-.el7.noarch
zabbix-get-4.0.-.el7.x86_64
[root@web1 yum.repos.d]# rpm -qa |grep php*
php-process-5.4.-.el7.x86_64
php-ldap-5.4.-.el7.x86_64
php-xml-5.4.-.el7.x86_64
hyphen-2.8.-.el7.x86_64
php-mysql-5.4.-.el7.x86_64
php-mcrypt-5.4.-.el7.x86_64
libmspack-0.5-0.4.alpha.el7.x86_64
php-gd-5.4.-.el7.x86_64
php-bcmath-5.4.-.el7.x86_64
php-pear-1.9.-.el7.noarch
plymouth-graphics-libs-0.8.-0.26..el7.centos.x86_64
php-mbstring-5.4.-.el7.x86_64
php-pdo-5.4.-.el7.x86_64
php-imap-5.4.-.el7.x86_64
php-xmlrpc-5.4.-.el7.x86_64
libreoffice-graphicfilter-5.0.6.2-.el7.x86_64
gvfs-gphoto2-1.22.-.el7.x86_64
graphite2-1.3.-.el7_2.x86_64
php-common-5.4.-.el7.x86_64
php-odbc-5.4.-.el7.x86_64
php-fpm-5.4.-.el7.x86_64
libgphoto2-2.5.-.el7.x86_64
php-5.4.-.el7.x86_64
php-devel-5.4.-.el7.x86_64
php-cli-5.4.-.el7.x86_64
python2-cryptography-1.3.-.el7.x86_64
hyphen-en-2.8.-.el7.noarch
[root@web1 yum.repos.d]#

Installed:
zabbix-get.x86_64 :4.0.-.el7 zabbix-server-mysql.x86_64 :4.0.-.el7 zabbix-web-mysql.noarch :4.0.-.el7 Dependency Installed:
OpenIPMI-libs.x86_64 :2.0.-.el7 OpenIPMI-modalias.x86_64 :2.0.-.el7 fping.x86_64 :3.10-.el7
iksemel.x86_64 :1.4-.el7.centos zabbix-web.noarch :4.0.-.el7 Complete!

yum install -y mariadb-embedded mariadb-libs mariadb-bench mariadb mariadb-server

Installed:
mariadb.x86_64 :5.5.-.el7_5 mariadb-bench.x86_64 :5.5.-.el7_5 mariadb-embedded.x86_64 :5.5.-.el7_5 Dependency Installed:
perl-Compress-Raw-Bzip2.x86_64 :2.061-.el7 perl-Compress-Raw-Zlib.x86_64 :2.061-.el7
perl-DBI.x86_64 :1.627-.el7 perl-Data-Dumper.x86_64 :2.145-.el7
perl-GD.x86_64 :2.49-.el7 perl-IO-Compress.noarch :2.061-.el7
perl-Net-Daemon.noarch :0.48-.el7 perl-PlRPC.noarch :0.2020-.el7 Updated:
mariadb-libs.x86_64 :5.5.-.el7_5 Complete!
[root@web2 yum.repos.d]# rpm -qa |grep mariadb
mariadb-libs-5.5.-.el7_5.x86_64
mariadb-embedded-5.5.-.el7_5.x86_64
mariadb-bench-5.5.-.el7_5.x86_64
mariadb-5.5.-.el7_5.x86_64
[root@web2 yum.repos.d]#

[root@web2 /]# rpm -qa |grep mariadb
mariadb-embedded-5.5.-.el7_5.x86_64
mariadb-5.5.-.el7_5.x86_64
mariadb-server-5.5.-.el7_5.x86_64
mariadb-bench-5.5.-.el7_5.x86_64
mariadb-libs-5.5.-.el7_5.x86_64

[root@web1 yum.repos.d]# cat /etc/nginx/conf.d/default.conf
server {
listen ;
server_name 192.168.216.51;
index index.html index.htm index.php;
charset utf-;
root /usr/share/nginx/html; location ~.*\.php$ {
fastcgi_pass unix:/dev/shm/php-fpm.sock;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
include fastcgi_params;
try_files $uri = ;
} location ~.*\.(gif|jpg|jpeg|png|bmp|swf|flv|mp3|wma)$ {
expires 30d;
}
location ~.*\.(js|css)$ {
expires 12h;
} }

listen = /dev/shm/php-fpm.sock
listen.owner = nobody
listen.group = nobody
user = nginx
group = nginx

[root@web1 yum.repos.d]# systemctl start nginx
[root@web1 yum.repos.d]# systemctl start php-fpm
[root@web1 yum.repos.d]# netstat -untlp |grep
tcp 0.0.0.0: 0.0.0.0:* LISTEN /nginx: master
tcp6 ::: :::* LISTEN /nginx: master
[root@web1 yum.repos.d]# netstat -untlp |grep php*
[root@web1 yum.repos.d]# ps -aux |grep php*
root 0.0 0.7 ? Ss : : php-fpm: master process (/etc/php-fpm.conf)
nginx 0.0 0.3 ? S : : php-fpm: pool www
nginx 0.0 0.3 ? S : : php-fpm: pool www
nginx 0.0 0.3 ? S : : php-fpm: pool www
nginx 0.0 0.3 ? S : : php-fpm: pool www
nginx 0.0 0.3 ? S : : php-fpm: pool www
root 0.0 0.0 pts/ S+ : : grep --color=auto php*

[root@web1 html]# pwd
/usr/share/nginx/html
[root@web1 html]# cat index.php
<?php
phpinfo();
?> [root@web1 html]#

Installed:
mariadb-server.x86_64 :5.5.-.el7_5 Dependency Installed:
perl-DBD-MySQL.x86_64 :4.023-.el7 Complete!
[root@web2 yum.repos.d]# systemctl start mariadb
[root@web2 yum.repos.d]# netstat -untlp |grep
tcp 0.0.0.0: 0.0.0.0:* LISTEN /mysqld
[root@web2 yum.repos.d]# systemctl enable mariadb

[root@web2 yum.repos.d]# mysql #进入数据库
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is
Server version: 5.5.-MariaDB MariaDB Server Copyright (c) , , Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> CREATE DATABASE zabbix character set utf8 collate utf8_bin;#创建database
Query OK, row affected (0.00 sec) MariaDB [(none)]> GRANT all privileges ON *.* TO 'zabbix'@'%' IDENTIFIED BY 'admin123'; #建账户授权
Query OK, rows affected (0.00 sec) MariaDB [(none)]> flush privileges;#刷新
Query OK, rows affected (0.00 sec) MariaDB [(none)]> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A Database changed
MariaDB [mysql]> update user set password=password('admin123') where user='root'; #改root密码
Query OK, rows affected (0.00 sec)
Rows matched: Changed: Warnings: MariaDB [mysql]> flush privileges;
Query OK, rows affected (0.00 sec)

[root@web1 html]# mv index.php index.php.phpinfo
[root@web1 html]# vim index.php
<?php
$link=mysql_connect('192.168.216.52','zabbix','admin123');
if($link) echo "<h1>The database connection was successful!</h1>";
else echo "<h1>The database connection was Fail!!</h1>";
mysql_close();
?>

[root@web1 html]# rpm -ql zabbix-server-mysql-4.0.-.el7.x86_64
/etc/logrotate.d/zabbix-server
/etc/zabbix/zabbix_server.conf
/usr/lib/systemd/system/zabbix-server.service
/usr/lib/tmpfiles.d/zabbix-server.conf
/usr/lib/zabbix/alertscripts
/usr/lib/zabbix/externalscripts
/usr/sbin/zabbix_server_mysql
/usr/share/doc/zabbix-server-mysql-4.0.
/usr/share/doc/zabbix-server-mysql-4.0./AUTHORS
/usr/share/doc/zabbix-server-mysql-4.0./COPYING
/usr/share/doc/zabbix-server-mysql-4.0./ChangeLog
/usr/share/doc/zabbix-server-mysql-4.0./NEWS
/usr/share/doc/zabbix-server-mysql-4.0./README
15 /usr/share/doc/zabbix-server-mysql-4.0.4/create.sql.gz #就是要找这个数据库脚本
/usr/share/man/man8/zabbix_server..gz
/var/log/zabbix
/var/run/zabbix

[root@web1 zabbix-server-mysql-4.0.]# gunzip create.sql.gz #解压缩
[root@web1 zabbix-server-mysql-4.0.]# ll
total
-rw-r--r-- root root Feb : AUTHORS
-rw-r--r-- root root Feb : ChangeLog
-rw-r--r-- root root Feb : COPYING
7 -rw-r--r-- 1 root root 5920915 Feb 4 18:02 create.sql
-rw-r--r-- root root Feb : NEWS
-rw-r--r-- root root Feb : README
[root@web1 zabbix-server-mysql-4.0.]# scp create.sql root@192.168.216.52:/ #发送到52上，数据库服务器

[root@web2 /]# mysql -uroot zabbix < /create.sql -p
Enter password:
[root@web2 /]# mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is
Server version: 5.5.-MariaDB MariaDB Server Copyright (c) , , Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use zabbix;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A Database changed
MariaDB [zabbix]> show tables;
+----------------------------+
| Tables_in_zabbix |
+----------------------------+
| acknowledges |
| actions |
| alerts |
| application_discovery |
| application_prototype |
| application_template |
| applications |
| auditlog |
| auditlog_details |
| autoreg_host |
| conditions |
| config |
| corr_condition |
| corr_condition_group |
| corr_condition_tag |
| corr_condition_tagpair |
| corr_condition_tagvalue |
| corr_operation |
| correlation |
| dashboard |
| dashboard_user |
| dashboard_usrgrp |
| dbversion |
| dchecks |
| dhosts |
| drules |
| dservices |
| escalations |
| event_recovery |
| event_suppress |
| event_tag |
| events |
| expressions |
| functions |
| globalmacro |
| globalvars |
| graph_discovery |
| graph_theme |
| graphs |
| graphs_items |
| group_discovery |
| group_prototype |
| history |
| history_log |
| history_str |
| history_text |
| history_uint |
| host_discovery |
| host_inventory |
| hostmacro |
| hosts |
| hosts_groups |
| hosts_templates |
| housekeeper |
| hstgrp |
| httpstep |
| httpstep_field |
| httpstepitem |
| httptest |
| httptest_field |
| httptestitem |
| icon_map |
| icon_mapping |
| ids |
| images |
| interface |
| interface_discovery |
| item_application_prototype |
| item_condition |
| item_discovery |
| item_preproc |
| items |
| items_applications |
| maintenance_tag |
| maintenances |
| maintenances_groups |
| maintenances_hosts |
| maintenances_windows |
| mappings |
| media |
| media_type |
| opcommand |
| opcommand_grp |
| opcommand_hst |
| opconditions |
| operations |
| opgroup |
| opinventory |
| opmessage |
| opmessage_grp |
| opmessage_usr |
| optemplate |
| problem |
| problem_tag |
| profiles |
| proxy_autoreg_host |
| proxy_dhistory |
| proxy_history |
| regexps |
| rights |
| screen_user |
| screen_usrgrp |
| screens |
| screens_items |
| scripts |
| service_alarms |
| services |
| services_links |
| services_times |
| sessions |
| slides |
| slideshow_user |
| slideshow_usrgrp |
| slideshows |
| sysmap_element_trigger |
| sysmap_element_url |
| sysmap_shape |
| sysmap_url |
| sysmap_user |
| sysmap_usrgrp |
| sysmaps |
| sysmaps_elements |
| sysmaps_link_triggers |
| sysmaps_links |
| tag_filter |
| task |
| task_acknowledge |
| task_check_now |
| task_close_problem |
| task_remote_command |
| task_remote_command_result |
| timeperiods |
| trends |
| trends_uint |
| trigger_depends |
| trigger_discovery |
| trigger_tag |
| triggers |
| users |
| users_groups |
| usrgrp |
| valuemaps |
| widget |
| widget_field |
+----------------------------+
rows in set (0.00 sec)

[root@web1 zabbix-server-mysql-4.0.]# systemctl restart zabbix-server
[root@web1 zabbix-server-mysql-4.0.]# ！net
bash: ！net: command not found...
[root@web1 zabbix-server-mysql-4.0.]# !net
netstat -untlpo
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name Timer
tcp 0.0.0.0: 0.0.0.0:* LISTEN /systemd off (0.00//)
tcp 0.0.0.0: 0.0.0.0:* LISTEN /nginx: master off (0.00//)
tcp 192.168.122.1: 0.0.0.0:* LISTEN /dnsmasq off (0.00//)
tcp 0.0.0.0: 0.0.0.0:* LISTEN /sshd off (0.00//)
tcp 127.0.0.1: 0.0.0.0:* LISTEN /cupsd off (0.00//)
tcp 127.0.0.1: 0.0.0.0:* LISTEN /master off (0.00//)
tcp 0.0.0.0: 0.0.0.0:* LISTEN /zabbix_server off (0.00//)
tcp6 ::: :::* LISTEN /systemd off (0.00//)
tcp6 ::: :::* LISTEN /nginx: master off (0.00//)
tcp6 ::: :::* LISTEN /sshd off (0.00//)
tcp6 ::: :::* LISTEN /cupsd off (0.00//)
tcp6 ::: :::* LISTEN /master off (0.00//)
tcp6 ::: :::* LISTEN /zabbix_server off (0.00//)
udp 0.0.0.0: 0.0.0.0:* /avahi-daemon: r off (0.00//)
udp 0.0.0.0: 0.0.0.0:* /avahi-daemon: r off (0.00//)
udp 192.168.122.1: 0.0.0.0:* /dnsmasq off (0.00//)
udp 0.0.0.0: 0.0.0.0:* /dnsmasq off (0.00//)
udp 0.0.0.0: 0.0.0.0:* /lightdm off (0.00//)
udp6 ::: :::* /lightdm off (0.00//)
[root@web1 zabbix-server-mysql-4.0.]#

PHP Fatal error: require_once(): Failed opening required '/etc/zabbix/web/maintenance.inc.php' (include_path='.:/usr/share/pear:/usr/share/php') in /usr/share/zabbix/include/classes/core/ZBase.php on line " while reading response header from upstream, client: 192.168.216.1, server: 192.168.216.51, request: "GET /index.php HTTP/1.1", upstream: "fastcgi://unix:/dev/shm/php-fpm.sock:", host: "192.168.216.51"

chown -R zabbix:zabbix /etc/zabbix
chown -R zabbix:zabbix /usr/share/zabbix
chown -R zabbix:zabbix /usr/lib/zabbix
chmod -R /etc/zabbix/web

post_max_size = 32M max_execution_time = max_input_time = date.timezone = PRC

[root@web1 share]# !tail
tail - /var/log/nginx/error.log
// :: [error] #: * upstream sent too big header while reading response header from upstream, client: 192.168.216.1, server: 192.168.216.51, request: "GET /setup.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "192.168.216.51"
// :: [error] #: * upstream sent too big header while reading response header from upstream, client: 192.168.216.1, server: 192.168.216.51, request: "GET /setup.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "192.168.216.51"
// :: [error] #: * upstream sent too big header while reading response header from upstream, client: 192.168.216.1, server: 192.168.216.51, request: "GET /setup.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "192.168.216.51"
// :: [error] #: * upstream sent too big header while reading response header from upstream, client: 192.168.216.1, server: 192.168.216.51, request: "GET /setup.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "192.168.216.51"
// :: [error] #: * upstream sent too big header while reading response header from upstream, client: 192.168.216.1, server: 192.168.216.51, request: "GET /setup.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "192.168.216.51"
[root@web1 share]# vim /etc/nginx/conf.d/default.conf

[root@web1 share]# vim /etc/nginx/conf.d/default.conf server {
listen ;
server_name 192.168.216.51;
index index.html index.htm index.php;
charset utf-;
root /usr/share/zabbix;
location / {
#max_fails=;
#fail_timeout=;
root /usr/share/zabbix;
} location ~.*\.php$ {
fastcgi_connect_timeout ;
root /usr/share/zabbix;
fastcgi_send_timeout ;
fastcgi_read_timeout ;
21 fastcgi_buffers 8 16k;
22 fastcgi_buffer_size 32k;
#fastcgi_pass unix:/dev/shm/php-fpm.sock;
fastcgi_pass 127.0.0.1:;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
include fastcgi_params;
try_files $uri = ;
} location ~.*\.(gif|jpg|jpeg|png|bmp|swf|flv|mp3|wma)$ {
expires 30d;
}
location ~.*\.(js|css)$ {
expires 12h;
} }