[MCOL-1591] add UMASK check to ColumnStore Cluster Tester script Created: 2018-07-25  Updated: 2023-10-26  Resolved: 2018-08-08

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: 1.1.5
Fix Version/s: 1.1.6

Type: New Feature Priority: Minor
Reporter: David Hill (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2018-15, 2018-16

 Description   

Customer system failed to created table
from Master UM, module file permissions
where incorrect because UMASK setting wasnt correct. was 027, should have been 0022.

this check needs to be added to the ColumnStore
Cluster Test script.

 Comments   
Comment by David Hill (Inactive) [ 2018-08-01 ]

how to test

//set umask to 022 and run test

umask 022
root@dhill-Z370-HD3:/usr/local/mariadb/columnstore/bin# ./columnstoreClusterTester.sh

      • This is the MariaDB Columnstore Cluster System Test Tool ***
    • Validate local OS is supported

Local Node OS System Name : Ubuntu 18.04.1 LTS

    • Run UMASK check

UMASK local setting test passed

    • Run SELINUX check

Local Node SELINUX setting is Not Enabled

    • Run MariaDB Console Password check

Passed, no problems detected with a MariaDB password being set without an associated /root/.my.cnf

    • Run MariaDB ColumnStore Dependent Package Check

Local Node - Passed, all dependency packages are installed
Local Node - Passed, all packages that should not be installed aren't installed

      • Finished Validation of the Cluster, all Tests Passed ***

root@dhill-Z370-HD3:/usr/local/mariadb/columnstore/bin#

// set to non 022, like 077

umask 077
root@dhill-Z370-HD3:/usr/local/mariadb/columnstore/bin# ./columnstoreClusterTester.sh

      • This is the MariaDB Columnstore Cluster System Test Tool ***
    • Validate local OS is supported

Local Node OS System Name : Ubuntu 18.04.1 LTS

    • Run UMASK check

Warning, UMASK test failed, check local UMASK setting. Requirement is set to 0022

Failure occurred, do you want to continue? (y,n) >

Comment by David Hill (Inactive) [ 2018-08-01 ]

https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/531

Comment by Daniel Lee (Inactive) [ 2018-08-08 ]

Build verified: 1.1.6-1 source

/root/columnstore/mariadb-columnstore-server
commit 513775738f72ec990d055a5d47e2511e3c0e34dd
Merge: 3c37210 9236098
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Wed Jul 18 09:37:17 2018 +0100

Merge pull request #123 from drrtuy/MCOL-970

MCOL-970 Slow query log now contains original query even in vtable mode

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit ee40c3ac050ad7b64302673fc4ab08640f64892f
Merge: 0df1b92 979d00a
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Mon Aug 6 13:02:08 2018 -0500

Merge pull request #523 from mariadb-corporation/MCOL-1579

MCOL-1579 Remove chmod of /dev/shm

The cluster tester tool now checks for umask setting. Tested with umask values 022 and 027.

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