[MDEV-3701] LP:455520 - mariadb .debs: /var/lib/mysql/test owned by root and so unusable Created: 2009-10-19  Updated: 2012-10-04  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Sergei Petrunia Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug455520.xml    

 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.



 Comments   
Comment by Kristian Nielsen [ 2009-10-23 ]

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

Comment by Rasmus Johansson (Inactive) [ 2009-10-23 ]

Launchpad bug id: 455520

Generated at Thu Feb 08 06:50:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.