Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-421

system upgrade install fails when a mysql root password is set

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.5
    • Fix Version/s: 1.0.6
    • Component/s: oam
    • Labels:
      None
    • Sprint:
      2016-23, 2016-24

      Description

      Setup a mysql root user password following the below instructions and got an error reported from postConfigure:

      post-mysqld-install Successfully Completed
      NOTE: Using MariaDB Columnstore password from /root/.my.cnf
      ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
      ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
      Error running post-mysql-install, /tmp/post-mysql-install.log

      ---------------------------------------------------------------------

      setup:

      /usr/local/mariadb/columnstore/mysql/bin/mysqladmin --socket=/usr/local/mariadb/columnstore/mysql/lib/mysql/mysql.sock -u root password 'Calpont1'

      You will then also need to let cron jobs work on the database so create a personal mysql config file for root in /root/.my.cnf containing:

      [mysqladmin]
      user = root
      password = Calpont1

      Make sure the permissions are set appropriately:

      1. chmod 0600 /root/.my.cnf

        Attachments

          Activity

            People

            Assignee:
            dleeyh Daniel Lee
            Reporter:
            hill David Hill (Inactive)
            Votes:
            0 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.