Changes

Jump to navigation Jump to search

Zabbix (view source)

Revision as of 21:54, 11 September 2023

5,998 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 157: Line 201:  
The server is the core component of Zabbix software. It uses one database (MySQL in this contrib) to store configuration, performance and integrity information. The server can check network services with simple check (ICMP, TCP etc...) for agent-less monitoring, it can monitor network devices using SNMP and is also the central component to which agent report information (agent can work in active, passive, or both mode). The server will also analyse all the information and send alerts depending on very flexible triggers.
 
The server is the core component of Zabbix software. It uses one database (MySQL in this contrib) to store configuration, performance and integrity information. The server can check network services with simple check (ICMP, TCP etc...) for agent-less monitoring, it can monitor network devices using SNMP and is also the central component to which agent report information (agent can work in active, passive, or both mode). The server will also analyse all the information and send alerts depending on very flexible triggers.
   −
===== Installation on SME9=====
+
===== 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
 
  signal-event yum-modify
 
  signal-event yum-modify
−
  yum install smeserver-zabbix-server --enablerepo=smetest,smecontribs,smedev
+
  yum install smeserver-zabbix-server --enablerepo=smecontribs
    
<br />
 
<br />
 +
the following version are available :
 +
zabbix42  zabbix44  zabbix45  zabbix50  zabbix51  zabbix52  zabbix53
 +
 +
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
 +
  yum install smeserver-extrarepositories-zabbix -y
 +
db yum_repositories setprop zabbix50 status enabled
 +
db yum_repositories setprop zabbix50-frontend status enabled
 +
expand-template /etc/yum.smerepos.d/sme-base.repo
 +
yum install smeserver-zabbix-server-z50 --enablerepo=smecontribs
 +
 +
 
</tab>
 
</tab>
 
<tab name="SME 9">
 
<tab name="SME 9">
Line 175: 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 190: Line 248:     
Here's the list of available DB parameters for zabbix-server service on SME:
 
Here's the list of available DB parameters for zabbix-server service on SME:
 +
*'''AdminPassword''': A random password is generated during the installation for Admin user. Replace the default weak zabbix password upon install.
 
*'''DbName''': The name of the database where everything is stored. Default is 'zabbixdb'
 
*'''DbName''': The name of the database where everything is stored. Default is 'zabbixdb'
 
*'''DbPassword''': The password of the database. A random password is generated during the installation
 
*'''DbPassword''': The password of the database. A random password is generated during the installation
Line 216: 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 password '''zabbix''' (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 275: 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 ===
 +
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 if not already done
 +
* fix the  row format to dynamic<syntaxhighlight lang="bash">
 +
echo "USE $(config getprop zabbix-server DbName); alter table hosts row_format = dynamic; "|mysql105
 +
</syntaxhighlight>
 +
* fix ENGINE if forgotten before (y'''ou better doing it before importing it''', converting the history table could take days (yes days not hours)
 +
<syntaxhighlight lang="bash">
 +
echo "SELECT CONCAT('ALTER TABLE ',TABLE_NAME,' ENGINE=InnoDB;')  FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE='MyISAM' AND table_schema = 'zabbixdb';" |mysql105 -s|mysql105 zabbixdb
 +
</syntaxhighlight>
 +
* 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">
 +
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
 +
</syntaxhighlight>
 +
* 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>
 +
 +
=== Migrate DB from mariadb 5.5. to mariadb 10.5 ===
 +
The script will check if zabbixdb is present in mariadb 5.5. path, as long as it is it will keep using this db, even if one is present in mariadb 10.5.<syntaxhighlight lang="bash">
 +
# need testing, writing inspired from Nextcloud contrib page
 +
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
 +
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 "GRANT ALL PRIVILEGES ON `config getprop zabbix-server DbName`.* TO `config getprop zabbix-server DbUser`@localhost; FLUSH PRIVILEGES;" | mysql105
 +
 +
echo "drop database `config getprop zabbix-server DbName`;" |mysql
 +
signal-event smeserver-zabbix-server-update
 +
</syntaxhighlight>{{Warning box|These lines of code need to be tested first, try on a test environment and be prepared to restore a backup of your db.}}
    
=== 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/40594...42310"

Navigation menu