Changes

Jump to navigation Jump to search

Zabbix (view source)

Revision as of 21:54, 11 September 2023

3,250 bytes added ,  21:54, 11 September 2023
m
→‎Bugs
Line 8: Line 8:  
=== Description ===
 
=== Description ===
   −
[http://www.zabbix.com Zabbix] offers advanced monitoring, alerting and visualisation features today which are missing in other monitoring systems, even some of the best commercial ones:
+
[http://www.zabbix.com Zabbix] offers advanced monitoring, alerting and visualisation features today which are missing in other monitoring systems, even some of the best commercial ones.
    
=== Features ===
 
=== Features ===
Line 131: Line 131:  
=== Full documentation ===
 
=== Full documentation ===
   −
A complete documentation is available as a PDF file here http://www.zabbix.com/documentation.php
+
A complete documentation is available as a PDF file [https://www.zabbix.com/documentation/current/en here.]
−
You'll also find some useful informations on the official [http://www.zabbix.com/wiki/doku.php wiki] of the project and the [http://www.zabbix.com/forum/ forum].
+
You'll also find some useful informations on the official [https://www.zabbix.com/forum/ forum].
    
{{Note box|This wiki page is not a complete guide for Zabbix, but just a starting point to run it on your SME Server using this contrib.
 
{{Note box|This wiki page is not a complete guide for Zabbix, but just a starting point to run it on your SME Server using this contrib.
−
For a complete documentation, please refer to the project documentation: http://www.zabbix.com/documentation.php}}
+
For a complete documentation, please refer to the project documentation: https://www.zabbix.com/documentation/current/en.}}
    
=== Versions ===
 
=== Versions ===
 
The following is the information about the latest release of each component:
 
The following is the information about the latest release of each component:
 
{{#smeversion: smeserver-zabbix-server }}
 
{{#smeversion: smeserver-zabbix-server }}
 +
{{#smeversion: smeserver-zabbix-server-z50 }}
 +
{| class="wikitable"
 +
!Release name
 +
!Release date
 +
!End of Full Support*
 +
!End of Limited Support**
 +
!SME9
 +
!SME10
 +
|-
 +
|Zabbix 6.2
 +
|Jul 5, 2022
 +
|Jan 31, 2023
 +
|Feb 28, 2023
 +
|X
 +
|X
 +
|-
 +
|Zabbix 6.0 LTS
 +
|Feb 8, 2022
 +
|Feb 28, 2025
 +
|Feb 28, 2027
 +
|X
 +
|X
 +
|-
 +
|Zabbix 5.0 '''LTS'''
 +
|May 12, 2020
 +
|May 31, 2023
 +
|May 31, 2025
 +
|X
 +
|yes
 +
|-
 +
|4.4 (EOL)
 +
|
 +
|
 +
|
 +
|yes
 +
|yes
 +
|-
 +
|Zabbix 4.0 '''LTS'''
 +
|October 1, 2018
 +
|October 31, 2021
 +
|October 31, 2023
 +
|yes
 +
|X
 +
|}
    
=== Requirements ===
 
=== Requirements ===
Line 159: Line 203:  
===== Installation=====
 
===== Installation=====
 
<tabs container=""><tab name="SME 10">
 
<tabs container=""><tab name="SME 10">
 +
to install zabbix 4.4
 
  yum install smeserver-extrarepositories-zabbix -y
 
  yum install smeserver-extrarepositories-zabbix -y
 
  db yum_repositories setprop zabbix44 status enabled
 
  db yum_repositories setprop zabbix44 status enabled
Line 168: Line 213:  
zabbix42  zabbix44  zabbix45  zabbix50  zabbix51  zabbix52  zabbix53  
 
zabbix42  zabbix44  zabbix45  zabbix50  zabbix51  zabbix52  zabbix53  
   −
Zabbix is not provided as server on Rhel 7 for version 4.5 and up. This is because of base php version, which could be worked around using php-fpm, but would also us to build it.
+
Zabbix is not provided as server on Rhel 7 for version 5.1 and up. This is because of base php version, which could be worked around using php-fpm, but would also need  us to build it.
    
install zabbix 50 server
 
install zabbix 50 server
Line 188: Line 233:  
to install Zabbix server, just use yum:
 
to install Zabbix server, just use yum:
 
  yum --enablerepo=smecontribs,fws,remi-safe install smeserver-zabbix-server --exclude=smeserver-zabbix-proxy
 
  yum --enablerepo=smecontribs,fws,remi-safe install smeserver-zabbix-server --exclude=smeserver-zabbix-proxy
−
NB: the --exclude=smeserver-zabbix-proxy is due to a conflict in late 2019 on SME9 as FWS started using zabbix from zabbix repo instead of building it. We will fix this for SME10 in few months.
+
NB: the --exclude=smeserver-zabbix-proxy is due to a conflict in late 2019 on SME9 as FWS started using zabbix from zabbix repo instead of building it.
   −
then go to your server-manager to set php5.4 or higher as default php for your SME, or you will not be able to access to zabbix web gui, or just issue the following
+
Then go to your server-manager to set php5.4 or higher as default php for your SME, or you will not be able to access to zabbix web gui, or just issue the following
 
  config setprop php54 PhpModule enabled  #replace here with php55 or php56 if you have other needs
 
  config setprop php54 PhpModule enabled  #replace here with php55 or php56 if you have other needs
 
  signal-event php-update
 
  signal-event php-update
Line 230: Line 275:     
The main web interface is available (if not disabled with the key WebAccess) on https://server.domain.tld/zabbix.
 
The main web interface is available (if not disabled with the key WebAccess) on https://server.domain.tld/zabbix.
−
The default user is '''Admin''' (with uppercase A as first letter), with strong password found in the config property AdminPasswd starting smeserver-zabbix-server 0.1-29. If you change it, it will not be overwritten on update. ( prior that the default was '''zabbix''', in this case you should change this password ASAP)
+
The default user is '''Admin''' (with uppercase A as first letter), with strong password found in the config property AdminPasswd starting smeserver-zabbix-server 0.1-29. If you change it, it will not be overwritten on update. ( prior that the default was '''zabbix''', in this case you should change this password ASAP)<syntaxhighlight lang="bash">
−
 
+
config getprop zabbix-server AdminPassword
−
Here are some screenshots of what you can get with zabbix
+
</syntaxhighlight>Here are some screenshots of what you can get with zabbix
 
[[File:Zabbix_graph_cpu.png|768px|thumb|center|CPU Usage Graph]]
 
[[File:Zabbix_graph_cpu.png|768px|thumb|center|CPU Usage Graph]]
 
[[File:Zabbix_graph_mem.png|768px|thumb|center|Memory Usage Graph]]
 
[[File:Zabbix_graph_mem.png|768px|thumb|center|Memory Usage Graph]]
Line 289: Line 334:     
*'''Template_icmp''': will configure two items to check if the server is alive, and measure the latency. It also provides latency graphs and some triggers (if latency is too high, if host is down since more than 5min and if hosts is down for more than 1 hour)
 
*'''Template_icmp''': will configure two items to check if the server is alive, and measure the latency. It also provides latency graphs and some triggers (if latency is too high, if host is down since more than 5min and if hosts is down for more than 1 hour)
 +
 +
=== Monitoring ressources ===
 +
 +
* https://github.com/zabbix/community-templates
 +
* https://git.lapiole.org/rpms/zabbix-agent-addons
 +
*
    
=== Upgrading 4.4 to 5.0 ===
 
=== Upgrading 4.4 to 5.0 ===
 
see this page https://www.zabbix.com/documentation/5.0/en/manual/installation/upgrade_notes_500. Mostly you will need to  
 
see this page https://www.zabbix.com/documentation/5.0/en/manual/installation/upgrade_notes_500. Mostly you will need to  
   −
* migrate your db from mariadb 5.5 to mariadb 10.5 with its user
+
* migrate your db from mariadb 5.5 to mariadb 10.5 with its user if not already done
−
* fix the  row format to dynamic
+
* fix the  row format to dynamic<syntaxhighlight lang="bash">
−
* install 5.0 using rpms
+
echo "USE $(config getprop zabbix-server DbName); alter table hosts row_format = dynamic; "|mysql105
−
* fix the table with database/mysql/double.sql
+
</syntaxhighlight>
−
<syntaxhighlight lang="mysql">
+
* fix ENGINE if forgotten before (y'''ou better doing it before importing it''', converting the history table could take days (yes days not hours)
−
USE zabbixdb;
+
<syntaxhighlight lang="bash">
−
alter table hosts row_format = dynamic;
+
echo "SELECT CONCAT('ALTER TABLE ',TABLE_NAME,' ENGINE=InnoDB;')  FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE='MyISAM' AND table_schema = 'zabbixdb';" |mysql105 -s|mysql105 zabbixdb
−
ALTER TABLE trends
+
</syntaxhighlight>
−
MODIFY value_min DOUBLE PRECISION DEFAULT '0.0000' NOT NULL,
+
* fix collation, for the issue "[Z3005] query failed: [1071] Specified key was too long; max key length is 3072 bytes [create index items_1 on items (hostid,key_(1021))]" [https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/401826-database-upgrade-failed-specified-key-was-too-long-max-key-length-is-3072-bytes see here.]<syntaxhighlight lang="bash">
−
MODIFY value_avg DOUBLE PRECISION DEFAULT '0.0000' NOT NULL,
+
echo "SELECT CONCAT('ALTER TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,' CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;') FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'zabbixdb';" |mysql105 -s |mysql10
−
MODIFY value_max DOUBLE PRECISION DEFAULT '0.0000' NOT NULL;
+
</syntaxhighlight>
−
ALTER TABLE history MODIFY value DOUBLE PRECISION DEFAULT '0.0000' NOT NULL;
+
* fix the table with database/mysql/double.sql<syntaxhighlight lang="mysql">
 +
cat /usr/share/doc/zabbix-server-mysql-5.0.30/double.sql |mysql105 `config getprop zabbix-server DbName`
 +
</syntaxhighlight>
 +
* fix the  foreign key for the issue "[Z3005] query failed: [1091] Can't DROP FOREIGN KEY `c_items_1`; check that it exists [alter table items drop foreign key c_items_1]" [https://www.zabbix.com/forum/zabbix-troubleshooting-and-problems/402412-zabbix-4-4-8-to-5-0-upgrade-failure see here]<syntaxhighlight lang="bash">
 +
echo "ALTER TABLE items ADD CONSTRAINT c_items_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE;
 +
CREATE INDEX items_1 ON items (hostid);" |mysql105 zabbixdb
 +
</syntaxhighlight>
 +
 
 +
* install 5.0 using rpms<syntaxhighlight lang="bash">
 +
db yum_repositories setprop zabbix44 status disabled
 +
db yum_repositories setprop zabbix50 status enabled
 +
db yum_repositories setprop zabbix50-frontend status enabled
 +
expand-template /etc/yum.smerepos.d/sme-base.repo
 +
rpm -e --nodeps zabbix-web-mysql zabbix-web smeserver-zabbix-server
 +
yum install smeserver-zabbix-server-z50 --enablerepo=smecontribs,smetest,smedev
 +
</syntaxhighlight>
 +
** fix collation after install
 +
<syntaxhighlight lang="bash">
 +
echo "alter database $(config getprop zabbix-server DbName) character set utf8mb4 collate utf8mb4_bin;" |mysql105
 +
wget https://www.zabbix.com/documentation/current/assets/en/manual/appendix/install/utf8mb4_convert.sql
 +
cat utf8mb4_convert.sql |mysql105 `config getprop zabbix-server DbName`
 +
echo "SET @ZABBIX_DATABASE = '$(config getprop zabbix-server DbName)'; \
 +
set innodb_strict_mode = OFF;  \
 +
CALL zbx_convert_utf8(); \
 +
set innodb_strict_mode = ON; \
 +
drop procedure zbx_convert_utf8;"|mysql105 `config getprop zabbix-server DbName`
 
</syntaxhighlight>
 
</syntaxhighlight>
   Line 312: Line 388:  
mysqldump `config getprop zabbix-server DbName` > zabbixdb.sql
 
mysqldump `config getprop zabbix-server DbName` > zabbixdb.sql
 
echo "CREATE DATABASE IF NOT EXISTS `config getprop zabbix-server DbName` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;"| mysql105
 
echo "CREATE DATABASE IF NOT EXISTS `config getprop zabbix-server DbName` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;"| mysql105
−
mysql105 `config getprop zabbix-server DbName`< zabbixdb.sql
+
cat zabbixdb.sql |sed 's/ENGINE=MyISAM/ENGINE=InnoDB/g'|mysql105 `config getprop zabbix-server DbName`
    
echo "CREATE USER IF NOT EXISTS `config getprop zabbix-server DbUser`@localhost IDENTIFIED BY '`config getprop zabbix-server DbPassword`';"| mysql105
 
echo "CREATE USER IF NOT EXISTS `config getprop zabbix-server DbUser`@localhost IDENTIFIED BY '`config getprop zabbix-server DbPassword`';"| mysql105
Line 323: Line 399:  
=== Bugs ===
 
=== Bugs ===
 
Please raise bugs under the SME-Contribs section in [http://bugs.contribs.org/enter_bug.cgi bugzilla]
 
Please raise bugs under the SME-Contribs section in [http://bugs.contribs.org/enter_bug.cgi bugzilla]
−
and select the smeserver-zabbix component or use on of this link:
+
and select the smeserver-zabbix-server component or use {{BugzillaFileBug|product=SME%20Contribs|component=smeserver-zabbix-server|title=this link.}}
−
====smeserver-zabbix-server====
+
Below is an overview of the current issues for this contrib:{{#bugzilla:columns=id,product,version,status,summary |sort=id|order=desc |component=smeserver-zabbix-server|noresultsmessage="No open bugs found."}}
−
new bug for {{BugzillaFileBug|product=SME%20Contribs|component=smeserver-zabbix-server|title=server}}
+
 
−
{{#bugzilla:columns=id,product,version,status,summary |sort=id|order=desc |component=smeserver-zabbix-server|noresultsmessage="No open bugs found."}}
+
===Changelog===
 +
Only released version in smecontrib are listed here.
    +
{{#smechangelog: smeserver-zabbix-server }}
     
Gieres
3,054

edits

Retrieved from "https://wiki.koozali.org/Special:MobileDiff/41838...42310"

Navigation menu