>
> log = /var/log/mysql/mysql.log
>
> in /etc/mysql/my.cnf to get more debugging info.
>
> Did you try rebooting? or killing existing mysql processes manually?
> Also what if you use 'aptitude' instead of 'apt-get' ?
>
I have tried rebooting and I have tried aptitude, but it is the same.
I have also tried starting directly from /etc/init.d/mysql, but got the
same fail message.
The problem seems to be with a file permission on InnoDB:
Code:
--------------------
Feb 11 12:04:10 ubuntu1 mysqld[9208]: 080211 12:04:10 InnoDB: Operating
system error number 13 in a file operation.
Feb 11 12:04:10 ubuntu1 mysqld[9208]: InnoDB: The error means mysqld does not
have the access rights to
Feb 11 12:04:10 ubuntu1 mysqld[9208]: InnoDB: the directory.
Feb 11 12:04:10 ubuntu1 mysqld[9208]: InnoDB: File name ./ibdata1
Feb 11 12:04:10 ubuntu1 mysqld[9208]: InnoDB: File operation call: 'open'.
Feb 11 12:04:10 ubuntu1 mysqld[9208]: InnoDB: Cannot continue operation.
Feb 11 12:04:10 ubuntu1 mysqld_safe[9214]: ended
Feb 11 12:04:25 ubuntu1 /etc/init.d/mysql[9350]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Feb 11 12:04:25 ubuntu1 /etc/init.d/mysql[9350]: ^G/usr/bin/mysqladmin:
connect to server at 'localhost' failed
Feb 11 12:04:25 ubuntu1 /etc/init.d/mysql[9350]: error: 'Can't connect to
local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Feb 11 12:04:25 ubuntu1 /etc/init.d/mysql[9350]: Check that mysqld is running
and that the socket: '/var/run/mysqld/mysqld.sock' exists!
--------------------
I have gone into /var/lib/mysql to check the permissions and I get:
Code:
--------------------
-rw-r--r-- 1 mysql mysql 0 2008-02-11 11:11 debian-5.0.flag
-rw-rw-rw- 1 mysql mysql 10485760 2008-01-13 11:13 ibdata1
-rw-rw-rw- 1 mysql mysql 5242880 2008-01-13 11:13 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 2007-10-24 12:46 ib_logfile1
drwxrwxrwx 2 mysql mysql 4096 2007-10-24 12:46 mysql
-rw------- 1 mysql mysql 6 2007-10-24 12:46 mysql_upgrade_info
--------------------
There is an ibdata1 file, but it seems to have completely open
permissions.
I am really at a loss about what is happening here.
--
ZeddZull
------------------------------------------------------------------------
ZeddZull's Profile: http://forums.slimdevices.com/member.php?userid=7678
View this thread: http://forums.slimdevices.com/showthread.php?t=43352
_______________________________________________
unix mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/unix
