Google Maps Add-on for Splunk Enterprise

https://splunkbase.splunk.com/app/368/

下載這個 APP google-maps-add-on-for-splunk-enterprise_113.tgz 並安裝它.
即可使用 geoip 的 搜尋語法.

host="web1" | geoip | search geoip_country_name="Hong Kong"

Zabbix 2.0.X Upgrade 2.2.X

本  LAB 為將 zabbix server 在異機上 Upgrade 的作法與說明


先備份 Zabbix 的 DB..


[root@zabbix-old ~]# mysqldump zabbix >  zabbix.20.sql

透過 sftp的方式將 Zabbix 的備份檔複制到新的 Zabbix 主機.

再進去新的主機內,設定 zabbix 所需的 Mysql 的帳密與權限設定.

[root@zabbix-new]# mysql


mysql> CREATE DATABASE IF NOT EXISTS zabbix default charset utf8 COLLATE utf8_general_ci;
mysql> GRANT ALL ON zabbix.* TO zabbix@localhost IDENTIFIED BY 'zabbix';
mysql> flush privileges;

匯入 zabbix 的 DB

[root@zabbix-new ~]#mysql zabbix < zabbix.20.sql


驗證帳密..

[root@zabbix-new ~]#mysql -uzabbix -pzabbix


驗證 DB & Tables

[root@zabbix-new ~]# mysql -uzabbix -pzabbix zabbix
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 558
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> show tables;
+-----------------------+
| Tables_in_zabbix      |
+-----------------------+
| acknowledges          |
| actions               |
| alerts                |
.....

略
.....

.....

再來的設定就比照 zabbix 的標準安裝方式.放 WEB 的 PHP 資訊.
與設定 zabbix server/agent 的 configuration .

如果是使用新機,請將 IP 改回舊版 Zabbix Server 的設定.

確定都沒問題後.即可啟用 zabbix_server zabbix_agent 的服務.
這樣才可以再度連入該 Zabbix Server URL,進行初使化作業.


為確保可以順利升版,建議先備份 DB 再使用異機方式去 Upgrade.
這樣比較安全.當然可以在原機上直接 Upgrade..

參考資訊

https://www.zabbix.com/forum/showthread.php?t=43561


jhenry

Try restarting the zabbix-server service and then watch the zabbix server log file. It should have some messages about trying to upgrade the DB to the new version. You'll need to wait for it to get to 100% before you can access the PHP front end.

If there are errors or the upgrade fails, open a bug report with the Zabbix devs.


https://www.zabbix.com/documentation/2.2/manual/installation/upgrade_notes_220

https://www.zabbix.com/documentation/2.2/manual/installation/upgrade

其它注意事項如下:

Housekeeper is disabled after upgrading to Zabbix 2.2. The desired housekeeper
functionality should be checked and enabled manually in Administration → General → Housekeeper,
if necessary.


Housekeeper changes

https://www.zabbix.org/wiki/Docs/howto/mysql_partition