Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
1.0.16, 1.1.4, 1.1.5, 1.1.7, 1.2.1
-
None
-
CentOS 7.4 ,columnstore single server
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...
|
|
|
|
Attachments
Issue Links
- relates to
-
MCOL-956 Customer changes to my.cnf be preserved during upgrade
-
- Closed
-