Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Do
-
None
-
None
Description
Users sometimes request instructions on how to configure cpimport to work with a non-root user. Apparently there used to be some directions on how to do this in InfiniDB as alluded to in this support issue, but not present in our current docs.
One of our VPs has been kind enough to provide this explanation, but a proper entry in the KB would help users as well:
With a root install, there are some additional steps to run cpimport as a
|
non root user with mode 1. The simplest is to setuid root the cpimport
|
process:
|
|
|
sudo chmod +s /usr/local/mariadb/columnstore/bin/cpimport
|
|
|
or you can broaden the privileges of each pm data directory, for example:
|
|
|
cd /usr/local/mariadb/columnstore
|
chmod 777 -R data1
|
|
|
The reason it works in mode 2 is because the cpimport invocation is actually
|
triggering a local cpimport process invocation on each pm which is launched
|
as root.
|
|