[MCOL-421] system upgrade install fails when a mysql root password is set Created: 2016-11-28  Updated: 2023-10-26  Resolved: 2016-12-08

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: 1.0.5
Fix Version/s: 1.0.6

Type: Bug Priority: Major
Reporter: David Hill (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
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

 Comments   
Comment by David Thompson (Inactive) [ 2016-11-29 ]

Workaround is to temporarily clear the password for the root mariadb user prior to upgrade and reapply after upgrade is complete.

Comment by David Hill (Inactive) [ 2016-11-29 ]

code change, testing now...

passed on a single-server install:

post-mysqld-install Successfully Completed
NOTE: Using MariaDB Columnstore password from /root/.my.cnf
post-mysql-install Successfully Completed

-----------------------------------
testing multi-node next

Comment by David Hill (Inactive) [ 2016-12-02 ]

a few more changes for mulit-node support...

Changes are in the engine report MCOL-421

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

testing

used to set password:

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

used to clear password

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

when password is set, this file has to exist on the server where mysqld resides that has the password set for upgrades to work..

/root/.my.cnf containing:

[mysqladmin]
user = root
password = Calpont1

Make sure the permissions are set appropriately:

  1. chmod 0600 /root/.my.cnf
Comment by David Hill (Inactive) [ 2016-12-02 ]

D Hall is out on friday, your the lucky one...

the main changes were made to post-mysql-install file.
But other changes in apps that call this..

Comment by Ben Thompson (Inactive) [ 2016-12-06 ]

Review completed.

Comment by Daniel Lee (Inactive) [ 2016-12-08 ]

Build verified: 1.0.6-1

mcsadmin> getsoft
getsoftwareinfo Thu Dec 8 20:21:53 2016

Name : mariadb-columnstore-platform
Version : 1.0.6
Release : 1
Architecture: x86_64
Install Date: Thu 08 Dec 2016 08:18:00 PM UTC
Group : Applications/Databases
Size : 10017001
License : Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details.
Signature : (none)
Source RPM : mariadb-columnstore-platform-1.0.6-1.src.rpm
Build Date : Wed 07 Dec 2016 07:08:09 PM UTC

Verified single server and 1um2pm configuration on centos 7, upgraded from 1.0.5-1.

Generated at Thu Feb 08 02:20:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.