mysql安装
1. 创建mysql目录
sudo mkdir -p ~/mysql/data ~/mysql/logs ~/mysql/conf
2. 新增mysql配置
sudo cp -r my.cnf ~/mysql/conf/ && cd ~/mysql/
3. 启动mysql
sudo docker run -p 3306:3306 \
--name mysql-server \
-v $PWD/conf/my.cnf:/etc/mysql/my.cnf \
-v $PWD/logs:/logs \
-v $PWD/data:/mysql_data \
-e MYSQL_ROOT_PASSWORD=root_pwd \
-e MYSQL_DATABASE=zabbix \
-e MYSQL_USER=zabbix \
-e MYSQL_PASSWORD=zabbix_pwd \
-d daocloud.io/library/mysql:5.7
zabbix java gateway安装
sudo docker run --name zabbix-java-gateway -t \
-d zabbix/zabbix-java-gateway:latest
zabbix server安装
sudo docker run --name zabbix-server-mysql -t \
-e PHP_TZ="Asia/Shanghai" \
-e DB_SERVER_HOST="mysql-server" \
-e MYSQL_DATABASE="zabbix" \
-e MYSQL_USER="zabbix" \
-e MYSQL_PASSWORD="zabbix_pwd" \
-e MYSQL_ROOT_PASSWORD="root_pwd" \
-e ZBX_JAVAGATEWAY="zabbix-java-gateway" \
--link mysql-server:mysql \
--link zabbix-java-gateway:zabbix-java-gateway \
-p 10051:10051 \
-d zabbix/zabbix-server-mysql:latest
zabbix web安装
sudo docker run --name zabbix-web-nginx-mysql -t \
-e PHP_TZ="Asia/Shanghai" \
-e DB_SERVER_HOST="mysql-server" \
-e MYSQL_DATABASE="zabbix" \
-e MYSQL_USER="zabbix" \
-e MYSQL_PASSWORD="zabbix_pwd" \
-e MYSQL_ROOT_PASSWORD="root_pwd" \
--link mysql-server:mysql \
--link zabbix-server-mysql:zabbix-server \
-p 80:80 \
-d zabbix/zabbix-web-nginx-mysql:latest
zabbix agent安装
windows安装
官网下载agent软件包(zabbix_agents_3.4.6.win.zip),解压到c:/zabbix下
修改配置C:\zabbix\conf\ zabbix_agentd.win.conf
LogFile=C:\zabbix\zabbix_agentd.log
Server=192.168.17.44
ServerActive=192.168.17.44
Hostname=WIN-0IRTKRANCQ1
注册agent(以管理员用户执行)
C:\zabbix\bin\win64\zabbix_agentd.exe-c C:\zabbix\conf\zabbix_agentd.win.conf -i
启动agent(以管理员用户执行)
zabbix_agentd.exe --start
linux安装
sudo docker run --name gateway-zabbix-agent \
-p 10050:10050 \
-e ZBX_HOSTNAME="gateway-ubuntu" \
-e ZBX_SERVER_HOST="192.168.17.44" \
-d zabbix/zabbix-agent:ubuntu-3.4-latest
zabbix主机监控
我们涉及的系统,主要是windows和linux操作系统,交换机等设备
windows主机监控
准备
待监控机器安装zabbix agent,具体参考zabbix agent windows安装
新增主机
image.png
image.png
配置主机检测模版
image.png
linux主机监控
linux监控类似windows监控,需要安装zabbix agent linux版本,然后新增主机,选择对应主机模版即可
注意:所有的机器,在配置主机名字需要与待监控主机hostname名字相同
数据库监控
oracle监控
配置jdk
创建oracle监控用户
创建用户
CREATE USER ZABBIX IDENTIFIED BY zabbix DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
赋予用户权限
GRANT ALTER SESSION TO zabbix;
GRANT CREATE SESSION TO zabbix;
GRANT CONNECT TO zabbix;
ALTER USER zabbix DEFAULT ROLE ALL;
GRANT SELECT ON V_$INSTANCE TO zabbix;
GRANT SELECT ON DBA_USERS TO zabbix;
GRANT SELECT ON V_$LOG_HISTORY TO zabbix; GRANT SELECT ON V_$LOG TO zabbix; GRANT SELECT ON V_$PARAMETER TO zabbix;
GRANT SELECT ON SYS.DBA_AUDIT_SESSION TO zabbix;
GRANT SELECT ON V_$LOCK TO zabbix;
GRANT SELECT ON DBA_REGISTRY TO zabbix;
GRANT SELECT ON V_$LIBRARYCACHE TO zabbix;
GRANT SELECT ON V_$SYSSTAT TO zabbix;
GRANT SELECT ON V_$PARAMETER TO zabbix;
GRANT SELECT ON V_$LATCH TO zabbix;
GRANT SELECT ON V_$PGASTAT TO zabbix;
GRANT SELECT ON V_$SGASTAT TO zabbix;
GRANT SELECT ON V_$LIBRARYCACHE TO zabbix;
GRANT SELECT ON V_$PROCESS TO zabbix;
GRANT SELECT ON DBA_DATA_FILES TO zabbix;
GRANT SELECT ON DBA_TEMP_FILES TO zabbix;
GRANT SELECT ON DBA_FREE_SPACE TO zabbix;
GRANT SELECT ON V_$SYSTEM_EVENT TO zabbix;
GRANT SELECT ON V_$locked_object TO zabbix;
GRANT SELECT ON dba_objects TO zabbix;
GRANT SELECT ON dba_tablespaces TO zabbix;
GRANT SELECT ON v_$SESSION TO zabbix;
如果是oracle11g,需要执行以下语句
exec dbms_network_acl_admin.create_acl(acl =>'resolve.xml',description => 'resolve acl', principal =>'ZABBIX',is_grant => true, privilege => 'resolve');
exec dbms_network_acl_admin.assign_acl(acl =>'resolve.xml', host =>'*');
验证
select utl_inaddr.get_host_name('127.0.0.1') from dual;
安装orabbix
下载解压
wget https://sourceforge.net/projects/orabbix/files/orabbix-1.2.3.zip
sudo mkdir /usr/local/orabbix
sudo mv orabbix-1.2.3.zip /usr/local/orabbix/
cd /usr/local/orabbix/&& sudo unzip orabbix-1.2.3.zip
修改配置
cd conf && sudo cp config.props.sample config.props
sudo vi config.props