Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28672

Several server options / settings still not visible from SQL level

Details

    Description

      E.g. the actual used values of allow-suspicious-udfs and skip-grant-tables can't be seen in SHOW GLOBAL VARIABLES output, and are not listed in INFORMATION_SCHEMA.SYSTEM_VARIABLES either.

      As both of these settings have security implications it should be possible to see their current value from the SQL level though, for audit / secure configuration check purposes.

      Especially with the now added GLOBAL_VALUE_ORIGIN and GLOBAL_VALUE_PATH information in I_S SYSTEM_VARIABLES, every setting that can be done via command line or my.cnf should actually be visible in SYSTEM_VARIABLES ...?

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24815 Add 'allow-suspicious-udfs' and 'skip-grant-tables' to system variables

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          split to

          Task - A task that needs to be done. MDEV-30188 Ensure all binlog* variables are visible as system variables

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-30189 Add remaining mariadbd replication command line options as system variables

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Stalled

          Activity

            Ascending order - Click to sort in descending order
            danblack Daniel Black added a comment -

            Original from MDEV-24815. See that MDEV for options and categories of variables to exclude (plugin enable/disables/alias/deprecated ones/perf schema settings).

            Paraphrased from hholzgra:

            debug / testing options:

            • debug-abort-slave-event-count
            • debug-disconnect-slave-event-count
            • debug-gdb
            • debug-max-binlog-dump-events
            • debug-no-sync
            • debug-sporadic-binlog-dump-fail
            • safe-mode

            Replication options

            • binlog-do-db
            • binlog-ignore-db
            • binlog-row-event-max-size
            • master-info-file
            • master-retry-count
            • replicate-rewrite-db
            • replicate-same-server-id
            • show-slave-auth-info
            • skip-slave-start

            skip-grant-tables - resolved in MDEV-25419

            bootstrap maybe of use.

            Remaining cases that seem to be valid, and do not fit into other categories above:

            • allow-suspicious-udfs resolved in MDEV-24815
            • aria-log-dir-path
            • des-key-file
            • innodb-status-file
            • log-ddl-recovery
            • log-isam
            • log-tc
            • memlock
            • old-style-user-limits,,
            • safe-user-create
            • silent-startup
            • skip-host-cache
            • ssl
            • stack-trace
            • sysdate-is-now
            • tc-heuristic-recover
            • transaction-isolation
            • transaction-read-only
            danblack Daniel Black added a comment - Original from MDEV-24815 . See that MDEV for options and categories of variables to exclude (plugin enable/disables/alias/deprecated ones/perf schema settings). Paraphrased from hholzgra : debug / testing options: debug-abort-slave-event-count debug-disconnect-slave-event-count debug-gdb debug-max-binlog-dump-events debug-no-sync debug-sporadic-binlog-dump-fail safe-mode Replication options binlog-do-db binlog-ignore-db binlog-row-event-max-size master-info-file master-retry-count replicate-rewrite-db replicate-same-server-id show-slave-auth-info skip-slave-start skip-grant-tables - resolved in MDEV-25419 bootstrap maybe of use. Remaining cases that seem to be valid, and do not fit into other categories above: allow-suspicious-udfs resolved in MDEV-24815 aria-log-dir-path des-key-file innodb-status-file log-ddl-recovery log-isam log-tc memlock old-style-user-limits,, safe-user-create silent-startup skip-host-cache ssl stack-trace sysdate-is-now tc-heuristic-recover transaction-isolation transaction-read-only
            bnestere Brandon Nesterenko added a comment -

            The replication options will be handled in different subtasks. Specifically:

            bnestere Brandon Nesterenko added a comment - The replication options will be handled in different subtasks. Specifically: replicate-rewrite-db ( MDEV-15530 ) binlog-do-db ( MDEV-30188 ) binlog-ignore-db ( MDEV-30188 ) binlog-row-event-max-size ( MDEV-30188 ) master-info-file ( MDEV-30189 ) master-retry-count ( MDEV-30189 ) replicate-same-server-id ( MDEV-30189 ) show-slave-auth-info ( MDEV-30189 ) skip-slave-start ( MDEV-30189 )

            People

              Unassigned Unassigned
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.