Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-22828

Database upgrade failed on Azure appliance

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • 6.0.17, 6.4.2, 7.0.0alpha1
    • Documentation (D)
    • 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:

      1. Create VM with installed zabbix 6.0 LTS via Azure Appliance (it will install Zabbix 6.0.4)
      2. 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;"
      3. 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;"

       

       

       

            zabbix.dev Zabbix Development Team
            Godfather Mateusz Dampc
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: