systemd de zabbix-2.2.9 agent

 ArchLinux, Fedora, Gadget, Raspberry Pi, ZABBIX  systemd de zabbix-2.2.9 agent はコメントを受け付けていません。
5月 222015
 

久々にめぽ

# cat > /etc/tmpfiles.d/zabbix-agentd.conf <<END
d /run/zabbix 0755 zabbix zabbix
END
# systemd-tmpfiles --create zabbix-agentd.conf
# cat > /etc/systemd/system/zabbix-agentd.service <<END
[Unit]
Description=Zabbix Agentd Daemon
Requires=network-online.target
After=network-online.target

[Service]
Type=forking
PIDFile=/run/zabbix/zabbix_agentd.pid
ExecStart=/usr/local/sbin/zabbix_agentd
Restart=on-failure
RestartSec=10

[Install]
WantedBy=multi-user.target
END

CentOS 7.0 de Percona XtraDB Cluster 5.6.21 + zabbix 2.4.3

 CentOS, XtraDB, ZABBIX  CentOS 7.0 de Percona XtraDB Cluster 5.6.21 + zabbix 2.4.3 はコメントを受け付けていません。
1月 112015
 
# yum install http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm
# yum install http://www.percona.com/redir/downloads/percona-release/redhat/latest/percona-release-0.1-3.noarch.rpm
# yum install http://repo.zabbix.com/zabbix/2.4/rhel/7/x86_64/zabbix-release-2.4-1.el7.noarch.rpm
# yum install httpd Percona-XtraDB-Cluster-56 zabbix-agent zabbix-get zabbix-sender zabbix-server-mysql zabbix-web-japanese zabbix-web-mysql
# cat > /etc/my.cnf.d/my-plus.cnf <<END
[client]
default_character_set = utf8

[mysqld]
thread_handling = pool-of-threads
innodb_flush_method = O_DSYNC

default_storage_engine = innodb
character_set_server = utf8
collation_server = utf8_general_ci
default-time-zone = +9:00
lc_time_names=ja_JP
ft_min_word_len = 3
query_cache_type = 0

[mysql]
no-auto-rehash
default_character_set = utf8
END
# systemctl start mysql
# mysql_secure_installation
Set root password? [Y/n] n
Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] n
Remove test database and access to it? [Y/n] y
Reload privilege tables now? [Y/n] y
# mysql
mysql> create database zabbix character set utf8;
mysql> grant all privileges on zabbix.* to 'zabbix'@'%' identified by 'zabbix';
mysql> use zabbix
mysql> source /usr/share/doc/zabbix-server-mysql-2.4.3/create/schema.sql
mysql> source /usr/share/doc/zabbix-server-mysql-2.4.3/create/images.sql
mysql> source /usr/share/doc/zabbix-server-mysql-2.4.3/create/data.sql
mysql> flush privileges;
mysql> quit
# cat >> /etc/zabbix/zabbix_server.conf <<END

DBPassword=zabbix
StartSNMPTrapper=1
END
# systemctl start zabbix-server
# systemctl start zabbix-agent
# vi /etc/httpd/conf.d/zabbix.conf
php_value date.timezone Asia/Tokyo

<VirtualHost *:80>
    DocumentRoot /usr/share/zabbix
</VirtualHost>
# systemctl start httpd
# firewall-cmd --add-service=http --zone=public --permanent
# firewall-cmd --zone=public --add-port=3306/tcp --permanent
# firewall-cmd --zone=public --add-port=10050/tcp --permanent
# firewall-cmd --zone=public --add-port=10051/tcp --permanent
# firewall-cmd --zone=public --add-port=162/udp --permanent
# firewall-cmd --reload
# systemctl enable mysql
# systemctl enable zabbix-server
# systemctl enable zabbix-agent
# systemctl enable httpd

ZABBIX 2.2 を mysqldump する?

 MariaDB, MySQL, ZABBIX  ZABBIX 2.2 を mysqldump する? はコメントを受け付けていません。
6月 052014
 

とりあえずコレで……

mysqldump \
--single-transaction \
--force \
-–no-data \
-–add-drop-table \
zabbix \
>zabbix-schema.sql

mysqldump \
--single-transaction \
--quick \
--compress \
--force \
--hex-blob \
--disable-keys \
--no-create-info \
--default-character-set=utf8 \
--ignore-table=zabbix.history \
--ignore-table=zabbix.history_log \
--ignore-table=zabbix.history_str \
--ignore-table=zabbix.history_str_sync \
--ignore-table=zabbix.history_sync \
--ignore-table=zabbix.history_text \
--ignore-table=zabbix.history_uint \
--ignore-table=zabbix.history_uint_sync \
--ignore-table=zabbix.trends \
--ignore-table=zabbix.trends_uint \
zabbix \
>zabbix-data.sql

centos 6.5 (x86_64) de mysql 5.6.16 + zabbix 2.2.2

 CentOS, MySQL, ZABBIX  centos 6.5 (x86_64) de mysql 5.6.16 + zabbix 2.2.2 はコメントを受け付けていません。
3月 082014
 
# yum localinstall http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
# yum localinstall http://repo.zabbix.com/zabbix/2.2/rhel/6/x86_64/zabbix-release-2.2-1.el6.noarch.rpm
# yum update
# yum install mysql-community-client mysql-community-server
# yum install zabbix-server-mysql zabbix-web-mysql zabbix-web-japanese
# yum install zabbix-agent net-snmp-utils
# vi /etc/my.cnf
default_storage_engine = innodb
character_set_server = utf8
collation_server = utf8_general_ci
lc_time_names=ja_JP
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DSYNC
innodb_log_files_in_group = 3
# service mysqld start
# mysql_secure_installation
# mysql
create database zabbix character set utf8;
grant all privileges on zabbix.* to zabbix@localhost identified by 'zabbix';
\q
# vi /etc/zabbix/zabbix_server.conf
NodeID=1
DBPassword=zabbix
# cd /usr/share/doc/zabbix-server-mysql-2.2.2/create
# mysql zabbix < schema.sql
# mysql zabbix < images.sql
# mysql zabbix < data.sql
# zabbix_server -n 1
# service zabbix-server start
# /etc/httpd/conf.d/zabbix.conf
php_value date.timezone Asia/Tokyo
<VirtualHost *:80>
    DocumentRoot /usr/share/zabbix
</VirtualHost>
# service httpd start
# chkconfig mysqld on
# chkconfig zabbix-server on
# chkconfig zabbix-agent on
# chkconfig httpd on