-
Problem report
-
Resolution: Unresolved
-
Major
-
None
-
6.0.17, 6.4.2, 7.0.0alpha1
-
None
-
Zabbix 6.0 Azure Appliance
Upgrade from Zabbix 6.0.4 to version bigger than Zabbix 6.0.10 will fail on Azure Appliance because user on database zabbix_srv@localhost doesn't have enough privileges to his zabbix database. It requires bigger. **
Steps to reproduce:
- Create VM with installed zabbix 6.0 LTS via Azure Appliance (it will install Zabbix 6.0.4)
- Prepare to upgrade your Zabbix to latest LTS version. => Login to mysql and put command (according to changes in database from Zabbix 6.0.11):
"set global log_bin_trust_function_creators = 1;" - Upgrade your Zabbix server with commands:
{}"# systemctl stop zabbix-server"{}
"# dnf update zabbix-server -y"
"# systemctl start zabbix-server"
Result:
Zabbix server is not running because zabbix_srv@localhost user doesn't have permission to create trigger on database (see attached logs).
User zabbix_srv@localhost doesn't have correct permission on database:
mysql> show grants for 'zabbix_srv'@'localhost'; +------------------------------------------------------------------------------------------------------------------------+ | Grants for zabbix_srv@localhost | +------------------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO `zabbix_srv`@`localhost` | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `zabbix`.* TO `zabbix_srv`@`localhost` | +------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec)mysql>
Expected:
Database schema upgrade should pass successfuly.
Workaround and possible solution:
Give to zabbix_srv@localhost full privilage to database (as it's provided on [zabbix.com/download(https://www.zabbix.com/download?zabbix=6.0&os_distribution=centos&os_version=9&components=server_frontend_agent&db=mysql&ws=apache) instruction)
"grant all privileges on zabbix.* to zabbix_srv@localhost;"