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

Change web setup wizard to not create/drop tables for DB connectivity test purposes.

    XMLWordPrintable

    Details

    • Team:
      Team B
    • Sprint:
      Sprint 62 (Mar 2020)
    • Story Points:
      0.125

      Description

      Currently Zabbix WEB setup wizard is executing following queries to test DB connectivity:

      CREATE TABLE zabbix_installation_test (test_row INTEGER);
      DROP TABLE zabbix_installation_test;
      

      Suggestion is to change it to other SQL command like SELECT, because DB user which is used for web interface connectivity can be created without CREATE TABLE and DROP TABLE privileges for security reasons. In this scenario, setup wizard will fail and zabbix.conf.php file must be created manually. This is the only place where such privileges are used.

        Attachments

          Activity

            People

            Assignee:
            iivs Ivo Kurzemnieks
            Reporter:
            kaspars.mednis Kaspars Mednis
            Votes:
            4 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: