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

zabbix server & proxy should check db schema basics

    Details

    • Type: Change Request
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.0.4
    • Fix Version/s: None
    • Component/s: Proxy (P), Server (S)
    • Labels:

      Description

      zabbix mysql database is required to have utf8 encoding and utf8_bin collation (for the database to be case sensitive).
      while partially documented in ZBX-6323, it was still quite invisible for many users as all the relevant upgrade notes were not updated (and even if they were, users would still miscreate the db).
      many users report all kinds of issues :

      the time spent on such cases could be saved if the incorrect database config coud be detected and communicated to the user.
      it is suggested that server & proxy check encoding & collation upon startup for all tables; if any are found to be wrong, report that as a warning in the logfile (but still start up to give the user some breathing room)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              richlv richlv
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: