default install, 1st login, auditlog insert sql query fail - cannot log in

XMLWordPrintable

    • Type: Incident report
    • Resolution: Workaround proposed
    • Priority: Trivial
    • None
    • Affects Version/s: 4.4.7
    • Component/s: Frontend (F)
    • None
    • Environment:
      ubuntu 18.04, mariadb 10.4, php 7.2

       

      Hi.

      Installation:

      default 18.04 ubuntu install on amd64, with no graphical components. The server is dedicated for zabbix.

      mariadb repo added: 10.4

      zabbix repo addid: 4.4

      installation follwoed from here:

      https://www.zabbix.com/documentation/current/manual/installation/install_from_packages/debian_ubuntu#importing_data

      database data imported from share/doc/zabbix-server-mysql/ , database collation had been corrected as written in the howto.

      webpage comes up. Upon forst login, it throws the error on the screenshot. I tried to manually run the script written in the error, but it says, that there is no default value for one of the columns. So I checked if the table is correctly added. It is. It does exists.

       

      Shouldnt't this be some kind of mariadb 10.4 incompatibility?

            Assignee:
            Eduards Matuls (Inactive)
            Reporter:
            Éliás Tamás
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: