mysql-server 5.0.67-0ubuntu1 not starts

[Italo Canepa]

Binary package hint: mysql-server-5.0

My pc is amd64, with Ubuntu 8.10.
From today after an upgrade of mysql (august 25 2008) mysqld not starts.
The gnome service-admin shows mysql is on! But I cannot find the process.

icanepa@anakin:~$ mysql -u italo -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
icanepa@anakin:~$

icanepa@anakin:~$ lsb_release -rd
Description: Ubuntu intrepid (development branch)
Release: 8.10

[Andrei Coman (comandrei)]

Well from your process list it seems that MySQL isn't started.
sudo /etc/init.d/mysql start might do the trick.

[Italo Canepa (italoc)]

I try it but:

icanepa@anakin:~$ sudo /etc/init.d/mysql start
[sudo] password for icanepa:
 * Starting MySQL database server mysqld [fail]
icanepa@anakin:~$

[Norbert Tretkowski (tretkowski)]

Check /var/log/syslog for errors from mysqld.

[Italo Canepa (italoc)]

I removed mysql from system, restart the machine, and in services windows I see mysql. (look png image attached)
After I install mysql but installation fails:post installation script return error code 1
mysql-server has problems with dependecies - not confgured.

syslog before removing software was:
Aug 25 13:55:53 anakin mysqld_safe[8601]: started
Aug 25 13:55:53 anakin mysqld[8605]: 080825 13:55:53 [ERROR] /usr/sbin/mysqld: unknown option '--skip-federated'
Aug 25 13:55:53 anakin mysqld[8605]:
Aug 25 13:55:53 anakin mysqld_safe[8607]: ended
Aug 25 13:56:07 anakin /etc/init.d/mysql[8760]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 25 13:56:07 anakin /etc/init.d/mysql[8760]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 25 13:56:07 anakin /etc/init.d/mysql[8760]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 25 13:56:07 anakin /etc/init.d/mysql[8760]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Aug 25 13:56:07 anakin /etc/init.d/mysql[8760]:

[Norbert Tretkowski (tretkowski)]

Not a bug.

The federated engine was disabled upstream by default, and there's a note about that in /usr/share/doc/mysql-server-5.0/NEWS.Debian.gz, which users who are running a development branch should have read before reporting such a "bug".

[Italo Canepa (italoc)]

Thank you Robert,
I was not knowing this fact.

Is this the file?
icanepa@anakin:/usr/share/doc/mysql-server-5.0$ zcat NEWS.Debian.gz
mysql-dfsg-5.0 (5.0.45-2) unstable; urgency=low

  * Binary logging is now disabled by default. If you really need it (e.g. on
    a replication master), remove the comment from the log_bin line in my.cnf.

 -- Norbert Tretkowski <email address hidden> Sat, 10 Nov 2007 16:26:35 +0100

mysql-dfsg-5.0 (5.0.18-9) unstable; urgency=low

  * Rotation of the binary logs is now configured in /etc/mysql/my.cnf with
    "expire-logs-days" which defaults to 20 days. The old file
    /etc/mysql/debian-log-rotate.conf should be removed together with
    /etc/cron.daily/mysql-server after this value has been adjusted. Note that
    the old variable defined the number of files whereas the new one defines
    a time span in days.

 -- Christian Hammers <email address hidden> Tue, 24 Jan 2006 22:18:21 +0100
icanepa@anakin:/usr/share/doc/mysql-server-5.0$

[Norbert Tretkowski (tretkowski)]

Yes, but it seems like you have a mixture of different versions of the mysql package installed. Could you post the output of "dpkg -l | grep mysql"?

[Italo Canepa (italoc)]

Ok,
before reading your post, i try another time to reinstall mysql.

Here's the version of my packages:
icanepa@anakin:/usr/share/doc/mysql-server-5.0$ dpkg -l | grep mysql
ii libdbd-mysql-perl 4.007-1build1 A Perl5 database interface to the MySQL database
ii libmysql-java 5.1.6+dfsg-1ubuntu2 Java database (JDBC) driver for MySQL
ii libmysqlclient15off 5.0.51a-6ubuntu3 MySQL database client library
ii mysql-admin 5.0~rc12-2.2ubuntu2 GUI tool for intuitive MySQL administration
ii mysql-client 5.0.67-0ubuntu1 MySQL database client (metapackage depending on the latest versi
ii mysql-client-5.0 5.0.51a-6ubuntu3 MySQL database client binaries
ii mysql-common 5.0.67-0ubuntu1 MySQL database common files
ii mysql-gui-tools-common 5.0~rc12-2.2ubuntu2 Architecture independent files for MySQL GUI Tools
rc mysql-navigator 1.4.2-11 GUI client program for MySQL database server
ii mysql-query-browser 5.0~rc12-2.2ubuntu2 Official GUI tool to query MySQL database
iU mysql-server 5.0.67-0ubuntu1 MySQL database server (metapackage depending on the latest versi
iF mysql-server-5.0 5.0.51a-6ubuntu3 MySQL database server binaries
icanepa@anakin:/usr/share/doc/mysql-server-5.0$

[Jean-Louis Dupond (dupondje)]

Install: http://nl.archive.ubuntu.com/ubuntu/pool/main/m/mysql-dfsg-5.0/mysql-common_5.0.51a-6ubuntu3_all.deb

Then it works again ... The newest version of mysql in intrepid failed for AMD64 ... but the common version gets updated ... so it fucks up !

[Norbert Tretkowski (tretkowski)]

> [ERROR] /usr/sbin/mysqld: unknown option '--skip-federated'

Sounds like the FEDERATED engine is not compiled in. Upstream decided to disabled the FEDERATED engine by default via the my.cnf file, but mysqld has to be compiled with support for FEDERATED engine, otherwise it does not know about the --skip-federated option.

[Chuck Short (zulcss)]

This should be fixed now, thanks for the bug report.

Regards
chuck