Any luck in resolving this issue? I just rebooted by computer, and guess what... mysql refuses to start now.
Mar 22 16:54:05 warthog mysqld_safe[2740]: started Mar 22 16:54:05 warthog mysqld[2744]: 090322 16:54:05 [Warning] option 'net_buffer_length': unsigned value 8388608 adjusted to 1048576 Mar 22 16:54:05 warthog mysqld[2744]: ^G/usr/sbin/mysqld: File '/var/log/mysql/mysql-slow.log' not found (Errcode: 13) Mar 22 16:54:05 warthog mysqld[2744]: 090322 16:54:05 [ERROR] Could not use /var/log/mysql/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. Mar 22 16:54:05 warthog mysqld[2744]: ^G/usr/sbin/mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13) Mar 22 16:54:05 warthog mysqld[2744]: 090322 16:54:05 [ERROR] Aborting Mar 22 16:54:05 warthog mysqld[2744]: Mar 22 16:54:05 warthog mysqld[2744]: 090322 16:54:05 [Note] /usr/sbin/mysqld: Shutdown complete Mar 22 16:54:05 warthog mysqld[2744]: Mar 22 16:54:05 warthog mysqld_safe[2746]: ended Mar 22 16:54:19 warthog /etc/init.d/mysql[2896]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Mar 22 16:54:19 warthog /etc/init.d/mysql[2896]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Mar 22 16:54:19 warthog /etc/init.d/mysql[2896]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Mar 22 16:54:19 warthog /etc/init.d/mysql[2896]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Mar 22 16:54:19 warthog /etc/init.d/mysql[2896]: It does complain about logfiles not being there, but they are, and readible by mysql user. I am starting to get a bit puzzled. Any helps? Ronald harland christofferson wrote: > I am running 2.6.18-5-amd64 > > For some reason, the mysql server stopped and I cannot restart it. I > have not upgraded and the machine was running nominally otherwise for > 120+ days. > > $cat /var/log/messages | grep mysql > > Mar 21 12:04:57 localhost mysqld_safe[7775]: started > Mar 21 12:04:57 localhost mysqld[7778]: ^G/usr/sbin/mysqld: File > '/var/log/mysql/mysql-bin.index' not found (Errcode: 13) > Mar 21 12:04:57 localhost mysqld[7778]: 090321 12:04:57 [ERROR] Aborting > Mar 21 12:04:57 localhost mysqld[7778]: > Mar 21 12:04:57 localhost mysqld[7778]: 090321 12:04:57 [Note] > /usr/sbin/ mysqld: Shutdown complete > Mar 21 12:04:57 localhost mysqld[7778]: > Mar 21 12:04:57 localhost mysqld_safe[7780]: ended > Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: 0 processes alive and > '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in > Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: > ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed > Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: error: 'Can't connect > to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' > Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: Check that mysqld is > running and that the socket: '/var/run/mysqld/mysqld.sock' exists! > Mar 21 12:05:12 localhost /etc/init.d/mysql[7915]: > > > I created a /var/log/mysql/mysql-bin.index file and gave ownership > mysql:mysql. I have no idea if this previously existed or not, or, what > information should be in this file. > > Does anyone have sugg estions? I've been reading all morning but haven't > found anything helpful yet. > > Harland > > > > > > -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
