[MCOL-1404] Upgrade done with existing mysql user credentials fails at running post-mysql-install Created: 2018-05-10  Updated: 2019-07-10  Resolved: 2019-07-10

Status: Closed
Project: MariaDB ColumnStore
Component/s: installation
Affects Version/s: 1.0.16, 1.1.4, 1.1.5, 1.1.7, 1.2.1
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Zdravelina Sokolovska (Inactive) Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

CentOS 7.4 ,columnstore single server


Issue Links:
Relates
relates to MCOL-956 Customer changes to my.cnf be preserv... Closed

 Description   

Upgrade done on columnstore single server with existing mysql user credentials fails at running post-mysql-install .
The problem is observed with root installation and and having mysql root user configured with password

The returned Error is" Error running post-mysql-install, password is needed. check /root/.my.cnf " , however the /root/.my.cnf file is configured with the related password.

Note : It's found that the post-mysql-install script is running subsequently the
install_calpont_mysql.sh scripts which is trying to connect mysql via --defaults-extra-file
set to /usr/local/mariadb/columnstore/mysql/my.cnf

The problem is that user might not have provided its mysql password in the $INSTALLDIR/mariadb/columnstore/mysql/my.cnf file,
while columnstore installation requires username and password in $HOME/.my.cnf file;
In addition $INSTALLDIR/mariadb/columnstore/mysql/my.cnf file is not preserved after upgrade.

Running the MariaDB ColumnStore setup scripts
 
post-mysqld-install Successfully Completed
Error running post-mysql-install, password is needed. check /root/.my.cnf
Exiting...

# cat $HOME/.my.cnf
[mysqladmin]
user = root
password = 1

[root@columnstore ~]# ls -l .my.cnf
-rw------- 1 root root 40 May 10 15:07 .my.cnf

[root@columnstore ~]# /usr/local/mariadb/columnstore/bin/postConfigure -u
 
This is the MariaDB ColumnStore System Configuration and Installation tool.
It will Configure the MariaDB ColumnStore System and will perform a Package
Installation of all of the Servers within the System that is being configured.
 
IMPORTANT: This tool should only be run on the Parent OAM Module
           which is a Performance Module, preferred Module #1
 
With the no-Prompting Option being specified, you will be required to have the following:
 
 1. Root user ssh keys setup between all nodes in the system or
    use the password command line option.
 2. A Configure File to use to retrieve configure data, default to Columnstore.xml.rpmsave
    or use the '-c' option to point to a configuration file.
 
The MariaDB ColumnStore Configuration Data is taken from /usr/local/mariadb/columnstore/etc/Columnstore.xml.rpmsave
 
Do you want to utilize the configuration data from the saved copy? [y,n]  >
NOTE: my.cnf file was upgraded based on my.cnf.rpmsave
 
===== Setup System Server Type Configuration =====
 
There are 2 options when configuring the System Server Type: single and multi
 
  'single'  - Single-Server install is used when there will only be 1 server configured
              on the system. It can also be used for production systems, if the plan is
              to stay single-server.
 
  'multi'   - Multi-Server install is used when you want to configure multiple servers now or
              in the future. With Multi-Server install, you can still configure just 1 server
              now and add on addition servers/modules in the future.
 
Select the type of System Server install [1=single, 2=multi] (1) >
 
Performing the Single Server Install.
Enter System Name (columnstore-1) >
 
===== Storage Configuration = internal =====
 
 
Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm1' (1) >
 
 
===== Performing Configuration Setup and MariaDB ColumnStore Startup =====
 
NOTE: Using previous configuration setting for 'NumBlocksPct' = 50%
      Using previous configuration setting for 'TotalUmMemory' = 25%
 
Running the MariaDB ColumnStore setup scripts
 
post-mysqld-install Successfully Completed
Error running post-mysql-install, password is needed. check /root/.my.cnf
Exiting...
 



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2019-07-10 ]

This will go away with convergence

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