manual:installation:known_issues

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
manual:installation:known_issues [2020/12/07 11:44]
martins-v net-snmp-perl has been removed in RHEL/CentOS 8.0-8.2; re-added in RHEL 8.3 (ZBX-17192)
manual:installation:known_issues [2021/01/27 20:27] (current)
Line 11: Line 11:
   [Z3001] connection to database '​zabbix'​ failed: [1227] Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation   [Z3001] connection to database '​zabbix'​ failed: [1227] Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
  
-That is due to MySQL 8.0.0 starting to enforce special permissions for setting session variables. However, in 8.0.18 this behaviour ​was removed: [[https://​dev.mysql.com/​doc/​refman/​8.0/​en/​server-system-variables.html|As of MySQL 8.0.18, setting the session value of this system variable is no longer a restricted operation.]]+That is due to MySQL 8.0.0 starting to enforce special permissions for setting session variables. However, in 8.0.18 this behavior ​was removed: [[https://​dev.mysql.com/​doc/​refman/​8.0/​en/​server-system-variables.html|As of MySQL 8.0.18, setting the session value of this system variable is no longer a restricted operation.]]
  
 The workaround is based on granting additional privileges to the ''​zabbix''​ user: The workaround is based on granting additional privileges to the ''​zabbix''​ user:
Line 32: Line 32:
  
 Upgrading Zabbix may fail if database tables were created with MariaDB 10.2.1 and before, because in those versions the default row format is compact. This can be fixed by changing the row format to dynamic (see also [[https://​support.zabbix.com/​browse/​ZBX-17690|ZBX-17690]]). Upgrading Zabbix may fail if database tables were created with MariaDB 10.2.1 and before, because in those versions the default row format is compact. This can be fixed by changing the row format to dynamic (see also [[https://​support.zabbix.com/​browse/​ZBX-17690|ZBX-17690]]).
 +
 +=== Database TLS connection with MariaDB ===
 +
 +Database TLS connection is not supported with the '​verify_ca'​ option for the DBTLSConnect [[:​manual/​appendix/​config/​zabbix_server|parameter]] if MariaDB is used.
 +
 === Global event correlation === === Global event correlation ===