The mysql server is running on a newly installed ubuntu 8.04. (I wanted to move the mysql server into KVM. KVM itself is running on ubuntu 10.04. )
/mysql belongs to mysql:mysql and is accessible. all subfiles are also accessible
i've already set the /etc/security/limits.conf to the following value:
* soft nofile 65535
* hard nofile 65535
when i try to startup i get the following error:
110406 10:34:45 [Warning] Could not increase number of max_open_files to more than 1024 (request: 2858)
110406 10:34:45 [Warning] Can't create test file /mysql/datadir/dbslave3.lower-test
110406 10:34:45 [Warning] Can't create test file /mysql/datadir/dbslave3.lower-test
/usr/sbin/mysqld: File '/mysql/logs/mysql-slow.log' not found (Errcode: 13)
110406 10:34:45 [ERROR] Could not use /mysql/logs/mysql-slow.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
/usr/sbin/mysqld: File '/mysql/logs/mysql-bin.index' not found (Errcode: 13)
110406 10:34:45 [ERROR] Aborting
110406 10:34:45 [Note] /usr/sbin/mysqld: Shutdown complete
when i enter ulimit -n 65535
and then try to startup the server, i get the following error:
110406 10:41:43 [Warning] Can't create test file /mysql/datadir/dbslave3.lower-test
110406 10:41:43 [Warning] Can't create test file /mysql/datadir/dbslave3.lower-test
/usr/sbin/mysqld: File '/mysql/logs/mysql-slow.log' not found (Errcode: 13)
110406 10:41:43 [ERROR] Could not use /mysql/logs/mysql-slow.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
/usr/sbin/mysqld: File '/mysql/logs/mysql-bin.index' not found (Errcode: 13)
110406 10:41:43 [ERROR] Aborting
110406 10:41:43 [Note] /usr/sbin/mysqld: Shutdown complete
So what's wrong here? when doing a su - mysql -s /bin/bash
, i can create the files and open them.
Is it because i've moved the mysql into KVM?
EDIT: I've also changed the disks from /dev/vda (VirtIO) to /dev/sda (IDE). But still the same behaviour. Maybe it's not KVM, just something wrong in the guest itself.
See you,