[MCOL-607] post-install change /var/log/mariadb to 777 permissions, causing issues Created: 2017-03-06  Updated: 2023-10-26  Resolved: 2017-03-17

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: 1.0.5
Fix Version/s: 1.0.8

Type: Bug Priority: Major
Reporter: David Hill (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2017-5, 2017-6

 Description   

reported by a user:

After installation, I received daily messages with a subject of “Anacron job 'cron.daily on …” – see the details below my signature.

It appears the “root” installation I performed resulted in each of the folders below having 777 permissions

I resolved them with the following commands.
chmod 755 /var/log/mariadb
chmod 755 /var/log/mariadb/columnstore
chmod 755 /var/log/mariadb/columnstore/archive
chmod 755 /var/log/mariadb/columnstore/trace
chmod 755 /var/log/mariadb/columnstore/corefiles

Looks like change was made in the 1.0.5 for non-root fixes that effect root installs

[builder@ip-172-30-0-125 install_scripts]$ git checkout columnstore-1.0.4
Previous HEAD position was 9ad8a31... mcol-404
HEAD is now at 2d0a7f5... merge develop branch

[builder@ip-172-30-0-125 install_scripts]$ grep "/var/log/mariadb" post-install | grep chmod
chmod 1755 /var/log/mariadb/columnstore/trace >/dev/null 2>&1
chmod 755 /var/log/mariadb/columnstore/corefiles > /dev/null 2>&1
sudo chmod -R 755 /var/log/mariadb/columnstore

[builder@ip-172-30-0-125 install_scripts]$ git checkout columnstore-1.0.5
Previous HEAD position was 2d0a7f5... merge develop branch
HEAD is now at 9ad8a31... mcol-404

[builder@ip-172-30-0-125 install_scripts]$ grep "/var/log/mariadb" post-install | grep chmod
sudo chmod -R 777 /var/log/mariadb
chmod 755 /var/log/mariadb/columnstore/corefiles > /dev/null 2>&1



 Comments   
Comment by David Thompson (Inactive) [ 2017-03-06 ]

Note that in my testing, my environment had a default umask set of 0022 which masks this problem.

Comment by David Hill (Inactive) [ 2017-03-08 ]

pull request MCOL-607

Comment by Daniel Lee (Inactive) [ 2017-03-17 ]

Build verified: 1.0.8-1

rw------. 1 root root 1782 Mar 17 20:00 maillog
drwxr-xr-x. 3 root root 4096 Mar 17 20:00 mariadb
rw------. 1 root root 824016 Mar 17 20:11 messages
drwx------. 2 root root 4096 Jun 10 2014 ppp

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