Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1184

non-root Log Rotation not working

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.1.2
    • 1.1.3
    • None
    • None
    • amazon ami non-root install
    • 2018-03

    Description

      ColumnStore logs should rotate to an archive directory every 24 hours. Its not working on non-root due to permissions errors.

      logrotate -f columnstore
      error: skipping "/var/log/mariadb/columnstore/alarm.log" because parent directory has insecure permissions (It's world writable or writable by group which is not "root") Set "su" directive in config file to tell logrotate which user/group should be used for rotation.
      error: skipping "/var/log/mariadb/columnstore/crit.log" because parent directory has insecure permissions (It's world writable or writable by group which is not "root") Set "su" directive in config file to tell logrotate which user/group should be used for rotation.
      error: skipping "/var/log/mariadb/columnstore/debug.log" because parent directory has insecure permissions (It's world writable or writable by group which is not "root") Set "su" directive in config file to tell logrotate which user/group should be used for rotation.
      error: skipping "/var/log/mariadb/columnstore/err.log" because parent directory has insecure permissions (It's world writable or writable by group which is not "root") Set "su" directive in config file to tell logrotate which user/group should be used for rotation.
      error: skipping "/var/log/mariadb/columnstore/info.log" because parent directory has insecure permissions (It's world writable or writable by group which is not "root") Set "su" directive in config file to tell logrotate which user/group should be used for rotation.
      error: skipping "/var/log/mariadb/columnstore/uiCommands.log" because parent directory has insecure permissions (It's world writable or writable by group which is not "root") Set "su" directive in config file to tell logrotate which user/group should be used for rotation.
      error: skipping "/var/log/mariadb/columnstore/warning.log" because parent directory has insecure permissions (It's world writable or writable by group which is not "root") Set "su" directive in config file to tell logrotate which user/group should be used for rotation.
      error: skipping "/var/log/mariadb/columnstore/load_brm.log1" because parent directory has insecure permissions (It's world writable or writable by group which is not "root") Set "su" directive in config file to tell logrotate which user/group should be used for rotation.
      error: skipping "/var/log/mariadb/columnstore/reset_locks.log1" because parent directory has insecure permissions (It's world writable or writable by group which is not "root") Set "su" directive in config file to tell logrotate which user/group should be used for rotation.
      error: skipping "/var/log/mariadb/columnstore/save_brm.log1" because parent directory has insecure permissions (It's world writable or writable by group which is not "root") Set "su" directive in config file to tell logrotate which user/group should be used for rotation.
      error: skipping "/home/mariadb-user/mariadb/columnstore/mysql/db/ip-172-30-0-6.err" because parent directory has insecure permissions (It's world writable or writable by group which is not "root") Set "su" directive in config file to tell logrotate which user/group should be used for rotation.
      error: skipping "/home/mariadb-user/mariadb/columnstore/mysql/db/ip-172-30-0-6.us-west-2.compute.internal.err" because parent directory has insecure permissions (It's world writable or writable by group which is not "root") Set "su" directive in config file to tell logrotate which user/group should be used for rotation.
      [root@ip-172-30-0-6 logrotate.d]# pwd
      /etc/logrotate.d
      [root@ip-172-30-0-6 logrotate.d]#

      ll
      total 476
      -rwxrwxrwx 1 syslog adm 9821 Jan 26 22:48 alarm.log
      drwxrwxrwx 2 syslog adm 6 Jan 24 20:15 archive
      drwxr-xr-x 2 syslog adm 6 Jan 24 20:15 corefiles
      -rwxr-xr-x 1 mariadb-user mariadb-user 1848 Jan 26 22:36 crit.log
      -rwxrwxrwx 1 syslog adm 398580 Jan 29 15:21 debug.log
      -rwxr-xr-x 1 mariadb-user mariadb-user 3127 Jan 26 22:47 err.log
      -rwxrwxrwx 1 syslog adm 40584 Jan 29 15:21 info.log
      rw-rr- 1 mariadb-user mariadb-user 78 Jan 29 15:21 load_brm.log1
      rw-rr- 1 mariadb-user mariadb-user 229 Jan 29 15:21 reset_locks.log1
      rw-rr- 1 mariadb-user mariadb-user 81 Jan 26 22:47 save_brm.log1
      drwxrwxrwx 2 syslog adm 15 Jan 26 21:32 trace
      rw-rw-r- 1 mariadb-user mariadb-user 326 Jan 26 22:49 uiCommands.log
      -rwxrwxrwx 1 syslog adm 4819 Jan 26 22:48 warning.log
      [root@ip-172-30-0-6 columnstore]# cd ..
      [root@ip-172-30-0-6 mariadb]# ll
      total 4
      drwxrwxrwx 5 syslog adm 4096 Jan 29 15:20 columnstore
      [root@ip-172-30-0-6 mariadb]#

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            hill David Hill (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.