Hallöchen,
seit einem DU gestern (exklusive X-Server) startet mysql beim booten nicht
Im syslog taucht dashier auf:
Oct 4 08:00:29 BenediktADesktop mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Oct 4 08:00:29 BenediktADesktop mysqld: 111004 8:00:29 [Note] Plugin 'FEDERATED' is disabled.
Oct 4 08:00:29 BenediktADesktop mysqld: 111004 8:00:29 InnoDB: Initializing buffer pool, size = 8.0M
Oct 4 08:00:29 BenediktADesktop mysqld: 111004 8:00:29 InnoDB: Completed initialization of buffer pool
Oct 4 08:00:29 BenediktADesktop mysqld: 111004 8:00:29 InnoDB: Started; log sequence number 0 44233
Oct 4 08:00:29 BenediktADesktop mysqld: 111004 8:00:29 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Oct 4 08:00:29 BenediktADesktop mysqld: 111004 8:00:29 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Oct 4 08:00:29 BenediktADesktop mysqld: 111004 8:00:29 [ERROR] Aborting
Oct 4 08:00:29 BenediktADesktop mysqld:
Oct 4 08:00:29 BenediktADesktop mysqld: 111004 8:00:29 InnoDB: Starting shutdown...
Oct 4 08:00:35 BenediktADesktop mysqld: 111004 8:00:35 InnoDB: Shutdown completed; log sequence number 0 44233
Oct 4 08:00:35 BenediktADesktop mysqld: 111004 8:00:35 [Note] /usr/sbin/mysqld: Shutdown complete
Oct 4 08:00:35 BenediktADesktop mysqld:
Oct 4 08:00:35 BenediktADesktop mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Oct 4 08:00:44 BenediktADesktop /etc/init.d/mysql[3604]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Oct 4 08:00:44 BenediktADesktop /etc/init.d/mysql[3604]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Oct 4 08:00:44 BenediktADesktop /etc/init.d/mysql[3604]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Oct 4 08:00:44 BenediktADesktop /etc/init.d/mysql[3604]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Oct 4 08:00:44 BenediktADesktop /etc/init.d/mysql[3604]:
Wenn ich mich aber anmelde und dann als root /etc/init.d mysql start aufrufe startet der Server anstandslos
Oct 4 08:03:23 BenediktADesktop mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Oct 4 08:03:23 BenediktADesktop mysqld: 111004 8:03:23 [Note] Plugin 'FEDERATED' is disabled.
Oct 4 08:03:23 BenediktADesktop mysqld: 111004 8:03:23 InnoDB: Initializing buffer pool, size = 8.0M
Oct 4 08:03:23 BenediktADesktop mysqld: 111004 8:03:23 InnoDB: Completed initialization of buffer pool
Oct 4 08:03:23 BenediktADesktop mysqld: 111004 8:03:23 InnoDB: Started; log sequence number 0 44233
Oct 4 08:03:23 BenediktADesktop mysqld: 111004 8:03:23 [Note] Event Scheduler: Loaded 0 events
Oct 4 08:03:23 BenediktADesktop mysqld: 111004 8:03:23 [Note] /usr/sbin/mysqld: ready for connections.
Oct 4 08:03:23 BenediktADesktop mysqld: Version: '5.1.58-1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
Oct 4 08:03:24 BenediktADesktop /etc/mysql/debian-start[4844]: Upgrading MySQL tables if necessary.
Oct 4 08:03:24 BenediktADesktop /etc/mysql/debian-start[4847]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Oct 4 08:03:24 BenediktADesktop /etc/mysql/debian-start[4847]: Looking for 'mysql' as: /usr/bin/mysql
Oct 4 08:03:24 BenediktADesktop /etc/mysql/debian-start[4847]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Oct 4 08:03:24 BenediktADesktop /etc/mysql/debian-start[4847]: This installation of MySQL is already upgraded to 5.1.58, use --force if you still need to run mysql_upgrade
Oct 4 08:03:24 BenediktADesktop /etc/mysql/debian-start[4854]: Checking for insecure root accounts.
Oct 4 08:03:24 BenediktADesktop /etc/mysql/debian-start[4858]: Triggering myisam-recover for all MyISAM tables
Kann mir jemand helfen wo das Problem liegt? Reinstall der MySQL-Pakete hab ich schon versucht...
EDIT:
Nach auskommentieren der Zeile in der /etc/mysql/my.conf
# bind-address = 192.168.178.24
funktioniert es wieder - nur ist mysql dann ja nicht mehr von außen erreichbar, und das wäre für Mythtv wichtig.
EDIT2: Hat sich erledigt - der Networkmanager ist schuld.
Lg
cid-baba