Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-9138

zabbix fails to work with recent versions of mysql_aurora - "content_type" column name is reserved

XMLWordPrintable

    • S24-W16/17, S24-W18/19
    • 1

      Zabbix server produces error:

      34385:20240419:074505.215 [Z3005] query failed: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'content_type,script,timeout,process_tags from media_type where mediatypeid=1' at line 1 [select mediatypeid,type,smtp_server,smtp_helo,smtp_email,exec_path,gsm_modem,username,passwd,smtp_port,smtp_security,smtp_verify_peer,smtp_verify_host,smtp_authentication,exec_params,maxsessions,maxattempts,attempt_interval,content_type,script,timeout,process_tags from media_type where mediatypeid=1]
      

      The same error is when test from command line.
      If edit the query and enclose the name by double quotes ("content_type") - it works.

      Frontend also shows an error "Cannot find specified media type" when manually test it, see screenshot.

      This error appeared after upgrading DB engine from 5.7.mysql_aurora.2.11.4 to 8.0.mysql_aurora.3.06.0

      Related discussion is https://github.com/znuny/Znuny/issues/548

      Not sure how this can/should be addressed in zabbix. Should be discussed.

            sasha Alexander Vladishev
            zalex_ua Oleksii Zagorskyi
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: