hill, David.Hall Where in the MariaDB Columnstore mysql code(modified mariadb server) code is it using hardcoded directory path /usr/local/MariaDB/Columnstore ? is it in my.cnf or start/stop scripts Or in actual C/C++ code ?

It's in the actual code in a number of spots.. I came across them when I had to make the change from /usr/local/Calpont to /usr/local/MariaDB/Columnstore. So it was hardcoded during the conversion, but Hall would need to provide that info. I don't know if the original mysql was hardcoded or not. Maybe it was and this would work for non-root installs, but it doesnt seem like it would..

Need input from Hall.

[~David.Hall Please provide response to above two comments. We need to know about this in order to complete release notes

dleeyhHave you tested install as non-root ? If not can you try please and provide your findings ?

I will also do a setup and test of the non-root install...

David Hill

here is the first run of a non-root install, investigating issues:

post-mysqld-install Successfully Completed
cat: /home/infinidb/MariaDB/Columnstore/mysql/db/*.pid: No such file or directory
/home/infinidb/MariaDB/Columnstore/mysql/mysql-Columnstore: line 212: my_print_defaults: command not found
/home/infinidb/MariaDB/Columnstore/mysql/mysql-Columnstore: line 324: cd: /usr/local/MariaDB/Columnstore/mysql: No such file or directory
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/home/infinidb/MariaDB/Columnstore/mysql/lib/mysql/mysql.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/home/infinidb/MariaDB/Columnstore/mysql/lib/mysql/mysql.sock' (2 "No such file or directory")
/home/infinidb/MariaDB/Columnstore/mysql/mysql-Columnstore: line 212: my_print_defaults: command not found
Error running post-mysql-install, /tmp/post-mysql-install.log

Starting MariaDB Columnstore Database Platform

MariaDB Columnstore Database Platform Starting, please wait ... FAILED

ERROR: MariaDB Columnstore Process failed to start, check log files in /var/log/Columnstore

This error is trying to launch mysqld from /usr/local due to the hard coded paths, I do believe..

But in any case, non-root install isn't working at this time...

Works needs to be done for this area..

[infinidb@node1 bin]$ ./post-mysql-install --installdir=/home/infinidb/MariaDB/Columnstore/
/home/infinidb/MariaDB/Columnstore//mysql/mysql-Columnstore: line 212: my_print_defaults: command not found
/home/infinidb/MariaDB/Columnstore//mysql/mysql-Columnstore: line 324: cd: /usr/local/MariaDB/Columnstore/mysql: No such file or directory
Starting MySQLCouldn't find MySQL server (/usr/local/MariaD[FAILED]store/mysql/bin/mysqld_safe)
checking for engine columnstore...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/home/infinidb/MariaDB/Columnstore/mysql/lib/mysql/mysql.sock' (2 "No such file or directory")
columnstore doesn't exist
checking for engine columnstore...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/home/infinidb/MariaDB/Columnstore/mysql/lib/mysql/mysql.sock' (2 "No such file or directory")
columnstore doesn't exist
ERROR: missing or invalid password, or InfiniDB plugin install missing
/home/infinidb/MariaDB/Columnstore//mysql/mysql-Columnstore: line 212: my_print_defaults: command not found
MySQL server PID file could not be found! [FAILED]
[infinidb@node1 bin]$

hillPlease provide estimate on scope of effort that will be needed to fix this.

completed a single node and multi combo pm and multi separate um/pm non-root installs.

successfully ran the nightly regression test.

How-to-install, daniel follow the infinidb non-root install procedure.

The columnstore install documents needs to be updated with the non-root install procured for next release of 1.0.2-1.

review install script changes

I will add in github info

all changes made to mariadb-columnstore-engine in devel.

commit 7ed3c435daea25179e9d1976fa0b7b9fb7197242
Author: david hill <david.hill@mariadb.com>
Date: Mon Jul 11 12:17:06 2016 -0500

MCOL-58 - non-root install install script changes

commit e5c961c2f5f664590c0de72aaa121b0b03d932b4
Author: david hill <david.hill@mariadb.com>
Date: Fri Jul 8 10:45:00 2016 -0500

MCOL-58 - add sudo for ldconfig command

commit f512476add0bb25f54ac47196a7e21cac9fe4b58
Author: david hill <david.hill@mariadb.com>
Date: Fri Jul 8 10:36:16 2016 -0500

MCOL-58 - added sudo to a ln line

Reviewed