Welcome, Guest. Please login or register.
Did you miss your activation email?

Author Topic: [DE] [erledigt] MySQL-Server startet nicht beim Systemstart  (Read 1878 times)

cid-baba

  • Guest
[DE] [erledigt] MySQL-Server startet nicht beim Systemstart
« on: 2011/10/04, 08:17:00 »
Hallöchen,

seit einem DU gestern (exklusive X-Server) startet mysql beim booten nicht :( Im syslog taucht dashier auf:

Code: [Select]

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
Code: [Select]

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
Code: [Select]

# 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