[debian-mysql] Bug#530787: invoke-rc.d: initscript mysql, action "start" failed after installation

[Tomasz Kaźmierczak]

Removing the 'skip-federated' option from /etc/mysql/my.cnf does not resolve the problem for me - the server still fails to start. However, the option has influence on what is written to the /var/log/daemon.log.

The daemon.log with the 'skip-federated' option set:

Aug 13 22:06:42 localhost mysqld_safe[4051]: started
Aug 13 22:06:42 localhost mysqld[4054]: 090813 22:06:42 [ERROR] /usr/sbin/mysqld: unknown option '--skip-federated'
Aug 13 22:06:42 localhost mysqld[4054]:
Aug 13 22:06:42 localhost mysqld_safe[4057]: ended
Aug 13 22:06:57 localhost /etc/init.d/mysql[4212]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 13 22:06:57 localhost /etc/init.d/mysql[4212]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 13 22:06:57 localhost /etc/init.d/mysql[4212]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 13 22:06:57 localhost /etc/init.d/mysql[4212]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 13 22:06:57 localhost /etc/init.d/mysql[4212]:



The daemon.log without the 'skip-federated' option:

Aug 13 22:11:02 localhost mysqld_safe[4531]: started
Aug 13 22:11:02 localhost mysqld[4534]: InnoDB: The first specified data file ./ibdata1 did not exist:
Aug 13 22:11:02 localhost mysqld[4534]: InnoDB: a new database to be created!
Aug 13 22:11:02 localhost mysqld[4534]: 090813 22:11:02  InnoDB: Setting file ./ibdata1 size to 10 MB
Aug 13 22:11:02 localhost mysqld[4534]: InnoDB: Database physically writes the file full: wait...
Aug 13 22:11:03 localhost mysqld[4534]: 090813 22:11:03  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB
Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Database physically writes the file full: wait...
Aug 13 22:11:03 localhost mysqld[4534]: 090813 22:11:03  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB
Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Database physically writes the file full: wait...
Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Doublewrite buffer not found: creating new
Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Doublewrite buffer created
Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Creating foreign key constraint system tables
Aug 13 22:11:03 localhost mysqld[4534]: InnoDB: Foreign key constraint system tables created
Aug 13 22:11:03 localhost mysqld[4534]: 090813 22:11:03  InnoDB: Started; log sequence number 0 0
Aug 13 22:11:03 localhost mysqld[4534]: 090813 22:11:03 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Aug 13 22:11:03 localhost mysqld_safe[4545]: ended
Aug 13 22:11:16 localhost /etc/init.d/mysql[4695]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 13 22:11:16 localhost /etc/init.d/mysql[4695]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 13 22:11:16 localhost /etc/init.d/mysql[4695]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 13 22:11:16 localhost /etc/init.d/mysql[4695]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 13 22:11:16 localhost /etc/init.d/mysql[4695]:


I've just installed the mysql-server because of that dumb dependency of kaddressbook on it, so it was a clean MySQL installation on my system. The version is 5.0.51a-24+lenny1 (current from testing)