Details

    • New Feature
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 1.1.3
    • 1.2.1
    • installation
    • None

    Description

      The non root install currently requires that you enable passwordless sudo access for the account which is not as desirable. For an initial phase of improvement here, we should allow all normal ongoing operational use cases (query, dml, cpimport, shutdown, startup, etc) to work with no sudo access. Installation and system mainteance tasks such as addModule could still depend on sudo access but the more we can simplify the better.

      After initial review, the decision was made to move towards a model where we more mirror the core mariadb server which will be needed for convergence anyways:

      • Move away from the dedicated split of root and non root installs.
      • Officially support only os package installs (i.e. rpm deb).
      • Binary install will still be needed unofficially for dev setups or supporting non standard linux distros.
      • The os package install should install the columnstore components and run under the mysql user (like server).
      • Any required root steps then can be done as package scripts which are run as root.
      • Migration paths will need to be developed / tested for upgrade.

      Attachments

        Issue Links

          Activity

            change to do the mysql_update script during the mariadb/msqyl post-install setup. There was an issue when it was done at the end of postConfigure.

            hill David Hill (Inactive) added a comment - change to do the mysql_update script during the mariadb/msqyl post-install setup. There was an issue when it was done at the end of postConfigure.

            checked into develop for 1.2.1... Patrick and I will continue retesting it from the develop branch.

            hill David Hill (Inactive) added a comment - checked into develop for 1.2.1... Patrick and I will continue retesting it from the develop branch.

            I have successful done non-root installs for centos 7 and ubuntu 18. On centos 7, I did the standard way and the DBS way (no sudo access during uninstall)

            Will test other OS's

            hill David Hill (Inactive) added a comment - I have successful done non-root installs for centos 7 and ubuntu 18. On centos 7, I did the standard way and the DBS way (no sudo access during uninstall) Will test other OS's

            Tested debian8/9 ubuntu 16/18

            hill David Hill (Inactive) added a comment - Tested debian8/9 ubuntu 16/18

            These are the items that this issue was going to try to achieve. Some of them were and others we place into other JIRAs for future releases. Here is more information on each item

            Move away from the dedicated split of root and non root installs.
            Officially support only os package installs (i.e. rpm deb).
            Binary install will still be needed unofficially for dev setups or supporting non standard linux distros.
            The os package install should install the columnstore components and run under the mysql user (like server).

            This is all covered by new JIRA https://jira.mariadb.org/browse/MCOL-1501

            What was done for this jira for 1.2.1

            1. Still have separate root and non-root installs
            2. Non-root still require the use of binary packages
            3. In the documents, we recommend installing and running in the 'mysql' user. but its not required.
            4. Only 1 command is required to be done as root and its running the script syslogSetup.sh
            5. Some installs will still require sudo commands to be added to /etc/sudoers and its documented here:

            https://mariadb.com/kb/en/library/preparing-for-and-installing-columnstore-version-121/#update-sudo-configuration-if-needed-by-root-user

            hill David Hill (Inactive) added a comment - These are the items that this issue was going to try to achieve. Some of them were and others we place into other JIRAs for future releases. Here is more information on each item Move away from the dedicated split of root and non root installs. Officially support only os package installs (i.e. rpm deb). Binary install will still be needed unofficially for dev setups or supporting non standard linux distros. The os package install should install the columnstore components and run under the mysql user (like server). This is all covered by new JIRA https://jira.mariadb.org/browse/MCOL-1501 What was done for this jira for 1.2.1 1. Still have separate root and non-root installs 2. Non-root still require the use of binary packages 3. In the documents, we recommend installing and running in the 'mysql' user. but its not required. 4. Only 1 command is required to be done as root and its running the script syslogSetup.sh 5. Some installs will still require sudo commands to be added to /etc/sudoers and its documented here: https://mariadb.com/kb/en/library/preparing-for-and-installing-columnstore-version-121/#update-sudo-configuration-if-needed-by-root-user

            People

              elena.kotsinova Elena Kotsinova (Inactive)
              dthompson David Thompson (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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