[Bug 153217] package mysql-server 5.0.45-1ubuntu3 failed to install/upgrade: dependency problems - leaving unconfigured

Fri Oct 19 19:37:41 UTC 2007

You have been subscribed to a public bug:

/var/log/daemon.log:
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: To do so, start the server, then issue the following commands:
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: /usr/bin/mysqladmin -u root password 'new-password'
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: /usr/bin/mysqladmin -u root -h rvroede-laptop password 'new-password'
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: See the manual for more instructions.
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: Please report any problems with the /usr/bin/mysqlbug script!
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]:
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: The latest information about MySQL is available on the web at
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: http://www.mysql.com
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24155]: Support MySQL by buying support/licenses at http://shop.mysql.com
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24218]: ERROR: 1046  No database selected
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24218]: 071016 10:17:07 [ERROR] Aborting
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24218]:
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24218]: 071016 10:17:07 [Note] /usr/sbin/mysqld: Shutdown complete
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24218]:
Oct 16 10:17:07 rvroede-laptop mysqld_safe[24310]: started
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: The first specified data file ./ibdata1 did not exist:
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: a new database to be created!
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08  InnoDB: Setting file ./ibdata1 size to 10 MB
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Database physically writes the file full: wait...
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Database physically writes the file full: wait...
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Database physically writes the file full: wait...
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Doublewrite buffer not found: creating new
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Doublewrite buffer created
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Creating foreign key constraint system tables
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: InnoDB: Foreign key constraint system tables created
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08  InnoDB: Started; log sequence number 0 0
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08 [ERROR] Aborting
Oct 16 10:17:08 rvroede-laptop mysqld[24313]:
Oct 16 10:17:08 rvroede-laptop mysqld[24313]: 071016 10:17:08  InnoDB: Starting shutdown...
Oct 16 10:17:10 rvroede-laptop mysqld[24313]: 071016 10:17:10  InnoDB: Shutdown completed; log sequence number 0 43655
Oct 16 10:17:10 rvroede-laptop mysqld[24313]: 071016 10:17:10 [Note] /usr/sbin/mysqld: Shutdown complete
Oct 16 10:17:10 rvroede-laptop mysqld[24313]:
Oct 16 10:17:10 rvroede-laptop mysqld_safe[24340]: ended

netstat -apn | grep 3306 is empty, so the port is free.

Running from the commandline, I found this:
root at rvroede-laptop:~# /usr/sbin/mysqld --print-defaults
/usr/sbin/mysqld would have been started with the following arguments:
--user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --basedir=/usr --datadir=/var/lib/mysql --tmpdir=/tmp --language=/usr/share/mysql/english --skip-external-locking --bind-address=127.0.0.1 --key_buffer=16M --max_allowed_packet=16M --thread_stack=128K --thread_cache_size=8 --query_cache_limit=1M --query_cache_size=16M --log_bin=/var/log/mysql/mysql-bin.log --expire_logs_days=10 --max_binlog_size=100M --skip-bdb --old_passwords=false
root at rvroede-laptop:~# /usr/sbin/mysqld --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --basedir=/usr --datadir=/var/lib/mysql --tmpdir=/tmp --language=/usr/share/mysql/english --skip-external-locking --bind-address=127.0.0.1 --key_buffer=16M --max_allowed_packet=16M --thread_stack=128K --thread_cache_size=8 --query_cache_limit=1M --query_cache_size=16M --log_bin=/var/log/mysql/mysql-bin.log --expire_logs_days=10 --max_binlog_size=100M --skip-bdb --old_passwords=false
071016 10:30:52  InnoDB: Started; log sequence number 0 43655
071016 10:30:52 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
071016 10:30:52 [ERROR] Do you already have another mysqld server running on port: 3306 ?
071016 10:30:52 [ERROR] Aborting

071016 10:30:52  InnoDB: Starting shutdown...
071016 10:30:54  InnoDB: Shutdown completed; log sequence number 0 43655
071016 10:30:54 [Note] /usr/sbin/mysqld: Shutdown complete

Again that error. I changed the port to 3307, but it gave the same
error, now for 3307.

Good old strace gave me:
bind(13, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 EADDRNOTAVAIL (Cannot assign requested address)

So I commented out "bind-address           = 127.0.0.1" in
/etc/mysql/my.cnf and it starts.

ProblemType: Package
Architecture: i386
Date: Tue Oct 16 10:17:22 2007
DistroRelease: Ubuntu 7.10
ErrorMessage: dependency problems - leaving unconfigured
NonfreeKernelModules: nvidia
Package: mysql-server 5.0.45-1ubuntu3
PackageArchitecture: all
SourcePackage: mysql-dfsg-5.0
Title: package mysql-server 5.0.45-1ubuntu3 failed to install/upgrade: dependency problems - leaving unconfigured
Uname: Linux rvroede-laptop 2.6.22-14-generic #1 SMP Wed Oct 10 06:00:47 GMT 2007 i686 GNU/Linux

** Affects: knetworkmanager (Ubuntu)
     Importance: Undecided
         Status: Confirmed

** Tags: apport-package
-- 
package mysql-server 5.0.45-1ubuntu3 failed to install/upgrade: dependency problems - leaving unconfigured
https://bugs.launchpad.net/bugs/153217
You received this bug notification because you are a member of Kubuntu Team, which is a bug contact for knetworkmanager in ubuntu.