mySQL läuft nicht mehr

imported_loisl · Jul 19, 2008

Jetzt habe ich was angestellt und weiss nicht so genau was

so ich habe da noch was in der /etc/bind/named.conf gefunden ... bzw. habe ich doch admin.85-31-187-210.blue.kundenkontroller.de in admnin.s10.fast-server.eu geändert.

also neue /var/cache/bind/admin.s10.fast-server.eu.db erstellt
und etc/bind/named.conf geändert.

nach dem reboot habe ich im ispcp-Login "ERROR: Unable to connect to SQL server !
SQL returned: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)" ....

den neuen Eintrag nochmals auskommentiert und reboot

Code:

.....
// bind Data BEGIN.

// dmn [admin.85-31-187-210.blue.kundencontroller.de] cfg entry BEGIN.
zone "admin.85-31-187-210.blue.kundencontroller.de" {
	type	master;
	file	"/var/cache/bind/admin.85-31-187-210.blue.kundencontroller.de.db";
	notify	YES;
};
// dmn [admin.85-31-187-210.blue.kundencontroller.de] cfg entry END.

// dmn [admin.s10.fast-server.eu] cfg entry BEGIN.
//zone "admin.s10.fast-server.eu" {
//        type    master;
//        file    "/var/cache/bind/admin.s10.fast-server.eu.db";
//        notify  YES;
//};
// dmn [admin.s10.fast-server.eu] cfg entry END.
.....

MySQL LÄUFT NICHT

Code:

Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

lg loisl

yavhcsu · Jul 19, 2008

Gib mal die logs dazu! Schau mal hier!

imported_loisl · Jul 19, 2008

Die logs sind leer (=0)
mysql.err und mysql.log

imported_loisl · Jul 19, 2008

jetzt bin glaube an dem Punkt, wo ich so viel nachträglich geändert habe, dass ispCP irgendwelche Probleme hat ....

Werde das ispCP noch mal komplett neu aufsetzten

damit ich die vermeidbaren Fehler ausschliessen kann

Danke nochmal vorerst und lg
loisl

CentY · Jul 19, 2008

Also neuinstallieren müsstest du deswegen ganz sicher nicht :x Ist bestimmt nur eine Kleinigkeit mit dem MySQL Server der sich bestimmt in der /var/log/syslog oder /var/log/messages geäußert hatte.

imported_loisl · Jul 19, 2008

OK .... überzeugt sooo wild bin ich auch nicht darauf

Die /var/log/messages steht nichts von "sql" aber habe was in /var/log/syslog bin ich fündig geworden

Code:

.....
Jul 19 11:53:20 s10 mysqld_safe[1999]: started
Jul 19 11:53:21 s10 mysqld[2002]: 080719 11:53:21  InnoDB: Started; log sequence number 0 4037329
Jul 19 11:53:21 s10 mysqld[2002]: 080719 11:53:21 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Jul 19 11:53:21 s10 mysqld[2002]: 080719 11:53:21 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Jul 19 11:53:21 s10 mysqld[2002]: 080719 11:53:21 [ERROR] Aborting
Jul 19 11:53:21 s10 mysqld[2002]:
Jul 19 11:53:21 s10 mysqld[2002]: 080719 11:53:21  InnoDB: Starting shutdown...
Jul 19 11:53:23 s10 mysqld[2002]: 080719 11:53:23  InnoDB: Shutdown completed; log sequence number 0 4037329
Jul 19 11:53:23 s10 mysqld[2002]: 080719 11:53:23 [Note] /usr/sbin/mysqld: Shutdown complete  
Jul 19 11:53:23 s10 mysqld[2002]:
Jul 19 11:53:23 s10 mysqld_safe[2054]: ended
Jul 19 11:53:30 s10 kernel: eth0: no IPv6 routers present
Jul 19 11:53:34 s10 /etc/init.d/mysql[2228]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jul 19 11:53:34 s10 /etc/init.d/mysql[2228]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jul 19 11:53:34 s10 /etc/init.d/mysql[2228]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul 19 11:53:34 s10 /etc/init.d/mysql[2228]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul 19 11:53:34 s10 /etc/init.d/mysql[2228]:
........
Jul 19 12:39:10 s10 mysqld_safe[1996]: started
Jul 19 12:39:10 s10 mysqld[1999]: 080719 12:39:10  InnoDB: Started; log sequence number 0 4037329
Jul 19 12:39:10 s10 mysqld[1999]: 080719 12:39:10 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Jul 19 12:39:10 s10 mysqld[1999]: 080719 12:39:10 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Jul 19 12:39:10 s10 mysqld[1999]: 080719 12:39:10 [ERROR] Aborting
Jul 19 12:39:10 s10 mysqld[1999]:
Jul 19 12:39:10 s10 mysqld[1999]: 080719 12:39:10  InnoDB: Starting shutdown...
Jul 19 12:39:13 s10 mysqld[1999]: 080719 12:39:13  InnoDB: Shutdown completed; log sequence number 0 4037329
Jul 19 12:39:13 s10 mysqld[1999]: 080719 12:39:13 [Note] /usr/sbin/mysqld: Shutdown complete  
Jul 19 12:39:13 s10 mysqld[1999]:
Jul 19 12:39:13 s10 mysqld_safe[2045]: ended
Jul 19 12:39:20 s10 kernel: eth0: no IPv6 routers present
Jul 19 12:39:24 s10 /etc/init.d/mysql[2228]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jul 19 12:39:24 s10 /etc/init.d/mysql[2228]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jul 19 12:39:24 s10 /etc/init.d/mysql[2228]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul 19 12:39:24 s10 /etc/init.d/mysql[2228]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul 19 12:39:24 s10 /etc/init.d/mysql[2228]:
........
Jul 19 13:02:50 s10 mysqld_safe[1146]: started
Jul 19 13:02:50 s10 mysqld[11499]: 080719 13:02:50 [Warning] Can't create test file /var/lib/mysql/s10.lower-test
Jul 19 13:02:50 s10 mysqld[11499]: 080719 13:02:50 [Warning] Can't create test file /var/lib/mysql/s10.lower-test
Jul 19 13:02:50 s10 mysqld[11499]: 080719 13:02:50 [Warning] One can only use the --user switch if running as root
Jul 19 13:02:50 s10 mysqld[11499]:
Jul 19 13:02:50 s10 mysqld[11499]: ^G/usr/sbin/mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13)
Jul 19 13:02:50 s10 mysqld[11499]: 080719 13:02:50 [ERROR] Aborting
Jul 19 13:02:50 s10 mysqld[11499]:
Jul 19 13:02:50 s10 mysqld[11499]: 080719 13:02:50 [Note] /usr/sbin/mysqld: Shutdown complete 
Jul 19 13:02:50 s10 mysqld[11499]:
Jul 19 13:02:50 s10 mysqld_safe[11501]: ended
Jul 19 13:03:06 s10 /etc/init.d/mysql[11732]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jul 19 13:03:06 s10 /etc/init.d/mysql[11732]: Could not open required defaults file: /etc/mysql/debian.cnf
Jul 19 13:03:06 s10 /etc/init.d/mysql[11732]: Fatal error in defaults handling. Program aborted
Jul 19 13:03:06 s10 /etc/init.d/mysql[11732]:
........

Armadillo · Jul 19, 2008

Hey, hast du mal überprüft, on noch ein mysql-server läuft?

Code:

ps -Af | grep mysql

Das sollte alle laufenden mysql-prozesse anzeigen.

Wenn nicht, dan überprüf mal, ob es diese Datei noch gibt:

Code:

ls- l /var/run/mysqld/mysqld.sock

Wenn ja, lösch die Datei und versuch den mysqlserver nochmal zu starten.

imported_loisl · Jul 19, 2008

# ps -Af | grep mysql
root 32027 31319 0 16:50 pts/0 00:00:00 grep mysql
# ls -l /var/run/mysqld/mysqld.sock
ls: /var/run/mysqld/mysqld.sock: Datei oder Verzeichnis nicht gefunden
# /etc/init.d/mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
#

Armadillo · Jul 19, 2008

Kann es sein dass du in deinem Startscript nen Fehler hast:

^G/usr/sbin/mysqld

was tut das ^G da

imported_loisl · Jul 19, 2008

Oh ja, das steht da wirklich in den log-Dateien ...
Da ist der Fehler

Wie kann ich Startscript ändern???

lg loisl

CentY · Jul 19, 2008

Öhm in /etc/init.d/mysql sollte es liegen einfach mit einem Editor deiner Wahl joe vim nano pico was auch immer.

imported_loisl · Jul 20, 2008

sooooo jetzt kenne ich das Problem ?????

... darum immer besser nur eine Änderung ausführen dann wass man wo man den Fehler suchen muss ...

lg loisl

/var/log/syslog

Code:

.....
Jul 20 00:44:48 green mysqld_safe[2064]: started
Jul 20 00:44:48 green mysqld[2067]: 080720  0:44:48  InnoDB: Started; log sequence number 0 43655
Jul 20 00:44:48 green mysqld[2067]: 080720  0:44:48 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Jul 20 00:44:48 green mysqld[2067]: 080720  0:44:48 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Jul 20 00:44:48 green mysqld[2067]: 080720  0:44:48 [ERROR] Aborting
Jul 20 00:44:48 green mysqld[2067]:
Jul 20 00:44:48 green mysqld[2067]: 080720  0:44:48  InnoDB: Starting shutdown...
Jul 20 00:44:50 green mysqld[2067]: 080720  0:44:50  InnoDB: Shutdown completed; log sequence number 0 43655
Jul 20 00:44:50 green mysqld[2067]: 080720  0:44:50 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 20 00:44:50 green mysqld[2067]:
Jul 20 00:44:50 green mysqld_safe[2113]: ended
Jul 20 00:44:58 green kernel: eth0: no IPv6 routers present
Jul 20 00:45:02 green /etc/init.d/mysql[2296]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jul 20 00:45:02 green /etc/init.d/mysql[2296]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jul 20 00:45:02 green /etc/init.d/mysql[2296]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul 20 00:45:02 green /etc/init.d/mysql[2296]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul 20 00:45:02 green /etc/init.d/mysql[2296]:
.....

Geänderte /etc/network/interfaces

Code:

# auto-generated system-config
# part of KDCTRL-NOC and FADC

auto eth0
iface eth0 inet static
      address 85.31.187.210
      netmask 255.255.254.0
      network 85.31.187.0
      broadcast 85.31.187.255
      gateway 85.31.186.1

auto eth0:1
iface eth0:1 inet static
      address 91.143.91.103
      netmask 255.255.255.0
      network 91.143.91.0
      broadcast 91.143.91.255

auto eth0:2
iface eth0:2 inet static
      address 91.143.91.108
      netmask 255.255.255.0
      network 91.143.91.0
      broadcast 91.143.91.255

ALTE /etc/network/interfaces
kein mySQL Problem und das "^G/usr/sbin/mysqld" auch nicht da

Code:

# auto-generated system-config
# part of KDCTRL-NOC and FADC

auto lo eth0
iface lo inet loopback
iface eth0 inet static
      address 85.31.187.210
      netmask 255.255.254.0
      broadcast 85.31.187.255
      gateway 85.31.186.1

imported_loisl · Jul 20, 2008

GELÖST

/etc/network/interfaces

Code:

# * Loopbackadapter
auto lo
iface lo inet loopback

# * Haupt-IP
# ***********************************fast-server.eu
auto eth0
iface eth0 inet static
      address 85.31.187.210
      netmask 255.255.254.0
      broadcast 85.31.187.255
      gateway 85.31.186.1

# * zusätzliche IP-Adressen
# ***********************************ifarbe.de
auto eth0:1
iface eth0:1 inet static
      address 91.143.91.103
      netmask 255.255.255.0
      broadcast 91.143.91.255

auto eth0:2
# ***********************************ifotograf.de
iface eth0:2 inet static
      address 91.143.91.108
      netmask 255.255.255.0
      broadcast 91.143.91.255

mySQL läuft nicht mehr

imported_loisl

New Member

yavhcsu

Registered User

imported_loisl

New Member

imported_loisl

New Member

CentY

Registered User

imported_loisl

New Member

Armadillo

Registered User

imported_loisl

New Member

Armadillo

Registered User

imported_loisl

New Member

CentY

Registered User

imported_loisl

New Member

imported_loisl

New Member

We value your privacy