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:
[EMAIL PROTECTED]:~# /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
[EMAIL PROTECTED]:~# /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.
--
kubuntu-bugs mailing list
[EMAIL PROTECTED]
https://lists.ubuntu.com/mailman/listinfo/kubuntu-bugs
