Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3701

LP:455520 - mariadb .debs: /var/lib/mysql/test owned by root and so unusable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      After installing MariaDB from .deb files (assuming all fixes to preceding bugs are applied and install succeeds), I get this:

      root@ubuntu-x86-vm:~# ls -la /var/lib/mysql/
      total 20564
      drwxr-xr-x 4 mysql mysql 4096 2009-10-19 19:20 .
      drwxr-xr-x 34 root root 4096 2009-10-19 19:19 ..
      rw-rr- 1 root root 0 2009-10-19 19:19 debian-5.1.flag
      rw-rw--- 1 mysql mysql 10485760 2009-10-19 19:20 ibdata1
      rw-rw--- 1 mysql mysql 5242880 2009-10-19 19:20 ib_logfile0
      rw-rw--- 1 mysql mysql 5242880 2009-10-19 19:19 ib_logfile1
      rw-rw--- 1 mysql mysql 16384 2009-10-19 19:19 maria_log.00000001
      rw-rw--- 1 mysql mysql 52 2009-10-19 19:19 maria_log_control
      drwxr-xr-x 2 mysql root 4096 2009-10-19 19:20 mysql
      rw------ 1 root root 17 2009-10-19 19:20 mysql_upgrade_info
      rw-rw--- 1 mysql mysql 4 2009-10-19 19:19 pbxt-lock
      drwx------ 2 root root 4096 2009-10-19 19:19 test

      note that 'test' is owned by root. This makes it impossible to create any tables in 'test' database:

      MySQL [test]> create table t1(a int);
      ERROR 1005 (HY000): Can't create table 't1' (errno: 13)

      MySQL [test]> create database db1;
      Query OK, 1 row affected (0.00 sec)

      MySQL [test]> create table db1.t1(a int);
      Query OK, 0 rows affected (0.05 sec)

      Fix suggestion: make the installation procedure set correct permissions.

      Attachments

        Activity

          Re: mariadb .debs: /var/lib/mysql/test owned by root and so unusable
          Buildbot tests show this is now fixed.

          knielsen Kristian Nielsen added a comment - Re: mariadb .debs: /var/lib/mysql/test owned by root and so unusable Buildbot tests show this is now fixed.

          Launchpad bug id: 455520

          ratzpo Rasmus Johansson (Inactive) added a comment - Launchpad bug id: 455520

          People

            Unassigned Unassigned
            psergei Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.