Bug #27973 | Can't change location of InnoDB data and log files - error number 13 | ||
---|---|---|---|
Submitted: | 20 Apr 2007 9:11 | Modified: | 21 Apr 2007 20:21 |
Reporter: | Eddie Duffy | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.0.18 | OS: | Linux (Fedora Core 5) |
Assigned to: | CPU Architecture: | Any | |
Tags: | 13, 5, data, directory, error, innodb, log, MySQL |
[20 Apr 2007 9:11]
Eddie Duffy
[20 Apr 2007 9:18]
Eddie Duffy
Our my.cnf file
Attachment: my.cnf (application/octet-stream, text), 5.05 KiB.
[20 Apr 2007 12:10]
Valeriy Kravchuk
Thank you for a problem report. Please, send the results of: ls -l /database Please, check if SELinux is ON (it is, by default) on your FC5.
[20 Apr 2007 13:18]
Eddie Duffy
The output from ls -l /database was fairly uninteresting as the files had not been created yet: [root@cds02m ~]# ls -l /database total 16 drwx------ 2 root root 16384 Apr 18 13:01 lost+found But aha! SELinux was indeed enabled and enforcing. I've now changed the status to 'permissive' and MySQL starts/stop OK in all circumstances. (I can fine-tune SELinux later if I want to enforce it.) [root@cds02m ~]# ls -l /database total 2831100 -rw-rw---- 1 mysql mysql 2097152000 Apr 20 14:10 ibdata1 -rw-rw---- 1 mysql mysql 10485760 Apr 20 14:10 ibdata2 -rw-rw---- 1 mysql mysql 394264576 Apr 20 14:10 ib_logfile0 -rw-rw---- 1 mysql mysql 394264576 Apr 20 14:08 ib_logfile1 drwx------ 2 mysql mysql 16384 Apr 18 11:45 lost+found [root@cds02m ~]# ps -fu mysql UID PID PPID C STIME TTY TIME CMD mysql 2875 2845 0 14:10 pts/0 00:00:00 /usr/libexec/mysqld --defaults-f So many thanks for your help, Valeriy! It's all OK now. Eddie.
[21 Apr 2007 20:21]
Valeriy Kravchuk
Closed as caused by SELinux settings.