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

The --group option in mariadb-install-db behaves differently from other CLI options

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.6.15
    • None
    • Scripts & Clients
    • None
    • mariadb:10.6.15 docker image

    Description

      With -group root, the option is misinterpreted as a server option. With -group=root the option works as expected.

      root@monolith:/# mariadb-install-db --datadir=/tmp/mysql123 --skip-test-db --user=root --group root
      Installing MariaDB/MySQL system tables in '/tmp/mysql123' ...
      2023-09-04 20:27:01 0 [ERROR] Unknown suffix 'r' used for variable 'group_concat_max_len' (value 'root')
      2023-09-04 20:27:01 0 [ERROR] /usr/sbin/mariadbd: Error while setting value 'root' to 'group_concat_max_len'
      

      This is technically correct behavior as the --help output does use an equals sign in the option documentation:

        --group=group_name   The login group to use for running mysqld.  Files and
                             directories created by mysqld will be owned by this
                             group. You must be root to use this option.  By default
                             mysqld runs using your current group and files and
                             directories that it creates will be owned by you.
      

      However, the error message is confusing and makes it hard to figure out what exactly is causing the error.

      This also breaks the usual expectation in MariaDB command line tools that the equals sign between an option and its value is optional. This is how for example mariadb and mariadb-admin behave.

      Attachments

        Activity

          People

            Unassigned Unassigned
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.