"Der perfekte Server" start von mysqld -> failed

[kesandal]

Hallo zusammen,
ich bin die Anleitung "Der perfekte Server" durchgegangen, komme jedoch nicht weiter

Ich habe alles 1:1 befolgt von Anfang an.
Es handelt sich um eine VM, Debian x64, 4Kerne und 4GB.

lenny1:/var/log# apt-get install postfix postfix-mysql postfix-doc mysql-client mysql-server openssl getmail4 rkhunter binutils dovecot-imapd dovecot-pop3d
Reading package lists... Done
Building dependency tree
Reading state information... Done
postfix is already the newest version.
postfix-mysql is already the newest version.
postfix-doc is already the newest version.
mysql-client is already the newest version.
mysql-server is already the newest version.
openssl is already the newest version.
getmail4 is already the newest version.
rkhunter is already the newest version.
binutils is already the newest version.
dovecot-imapd is already the newest version.
dovecot-pop3d is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 0B of additional disk space will be used.
Setting up mysql-server-5.0 (5.0.51a-24+lenny5) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.0; however:
Package mysql-server-5.0 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mysql-server-5.0
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
lenny1:/var/log#

Hat jemand von Euch eine Idee woran es liegen könnte?
In /var/logs finde ich keinen mysql-log.

Vielen Dank im Voraus
Kesandal

 

[Rolli-Ronny]

Das Problem liegt darin das du schon einige Sachen installiert hattest die du nach der Anleitung jetzt noch einmal installieren willst.Welche schon installiert sind siehst du ja in der Liste welche du gepostet hast.Mein Rat daher deinstallieren erst einmal das was schon von den genannten installiert ist ausser openssh.Und dann jetzt du genau nach der Anleitung vor damit am Ende auch auch ISPconfig läuft weil wenn du nämlich wild durch einander installierst kann es nämlich sein das ISPconfig nachher nicht will.Das steht auch an irgend einer Stelle in der Anleitung drin.

 

[kesandal]

Hallo,
vielen Dank für Deine Antwort.

Habe meine VM recovert und es nochmal probiert.
Ich komme aber nicht weiter....

[...]
The following packages will be REMOVED:
exim4 exim4-base exim4-config exim4-daemon-light
The following NEW packages will be installed:
binutils dovecot-common dovecot-imapd getmail4 libdbd-mysql-perl libdbi-perl
libhtml-template-perl libmd5-perl libmysqlclient15off libnet-daemon-perl
libplrpc-perl libpq5 libterm-readkey-perl mysql-client mysql-client-5.0
mysql-common mysql-server mysql-server-5.0 openssl openssl-blacklist postfix
postfix-doc postfix-mysql psmisc python-support rkhunter ssl-cert unhide
0 upgraded, 28 newly installed, 4 to remove and 0 not upgraded.
Need to get 55.5MB of archives.
After this operation, 151MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
[...]
Preconfiguring packages ...
(Reading database ... 21316 files and directories currently installed.)
Removing exim4 ...
dpkg: exim4-base: dependency problems, but removing anyway as you request:
exim4-daemon-light depends on exim4-base (>= 4.69).
Removing exim4-base ...
Stopping MTA: exim4_listener.
Removing exim4-config ...
dpkg: exim4-daemon-light: dependency problems, but removing anyway as you reques t:
bsd-mailx depends on exim4 | mail-transport-agent; however:
Package exim4 is not installed.
Package mail-transport-agent is not installed.
Package exim4-daemon-light which provides mail-transport-agent is to be remove d.
at depends on exim4 | mail-transport-agent; however:
Package exim4 is not installed.
Package mail-transport-agent is not installed.
Package exim4-daemon-light which provides mail-transport-agent is to be remove d.
Removing exim4-daemon-light ...
Stopping MTA:.
Processing triggers for man-db ...
Selecting previously deselected package mysql-common.
(Reading database ... 21180 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.0.51a-24+lenny5_all.deb) ...
Selecting previously deselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.38-1.1_all.deb) ...
Selecting previously deselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2017-1.1_all.deb) ...
Selecting previously deselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.605-1_amd64.deb) ...
Selecting previously deselected package libmysqlclient15off.
Unpacking libmysqlclient15off (from .../libmysqlclient15off_5.0.51a-24+lenny5_am d64.deb) ...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.007-1+lenny1_amd64.deb ) ...
Selecting previously deselected package mysql-client-5.0.
Unpacking mysql-client-5.0 (from .../mysql-client-5.0_5.0.51a-24+lenny5_amd64.de b) ...
Selecting previously deselected package psmisc.
Unpacking psmisc (from .../psmisc_22.6-1_amd64.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.0.51a-24+lenny5) ...
Selecting previously deselected package mysql-server-5.0.
(Reading database ... 21495 files and directories currently installed.)
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.51a-24+lenny5_amd64.de b) ...
Selecting previously deselected package openssl.
Unpacking openssl (from .../openssl_0.9.8g-15+lenny11_amd64.deb) ...
Selecting previously deselected package openssl-blacklist.
Unpacking openssl-blacklist (from .../openssl-blacklist_0.4.2_all.deb) ...
Selecting previously deselected package binutils.
Unpacking binutils (from .../binutils_2.18.1~cvs20080103-7_amd64.deb) ...
Selecting previously deselected package libpq5.
Unpacking libpq5 (from .../libpq5_8.3.12-0lenny1_amd64.deb) ...
Selecting previously deselected package dovecot-common.
Unpacking dovecot-common (from .../dovecot-common_1%3a1.0.15-2.3+lenny1_amd64.de b) ...
Selecting previously deselected package dovecot-imapd.
Unpacking dovecot-imapd (from .../dovecot-imapd_1%3a1.0.15-2.3+lenny1_amd64.deb) ...
Selecting previously deselected package python-support.
Unpacking python-support (from .../python-support_0.8.4lenny2_all.deb) ...
Selecting previously deselected package getmail4.
Unpacking getmail4 (from .../getmail4_4.7.8-1_all.deb) ...
Selecting previously deselected package libhtml-template-perl.
Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.9-1_all.deb) . ..
Selecting previously deselected package libmd5-perl.
Unpacking libmd5-perl (from .../libmd5-perl_2.03-1_all.deb) ...
Selecting previously deselected package libterm-readkey-perl.
Unpacking libterm-readkey-perl (from .../libterm-readkey-perl_2.30-4_amd64.deb) ...
Selecting previously deselected package mysql-client.
Unpacking mysql-client (from .../mysql-client_5.0.51a-24+lenny5_all.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.0.51a-24+lenny5_all.deb) ...
Selecting previously deselected package ssl-cert.
Unpacking ssl-cert (from .../ssl-cert_1.0.23_all.deb) ...
Selecting previously deselected package postfix.
Unpacking postfix (from .../postfix_2.5.5-1.1_amd64.deb) ...
Selecting previously deselected package rkhunter.
Unpacking rkhunter (from .../rkhunter_1.3.2-6_all.deb) ...
Selecting previously deselected package postfix-doc.
Unpacking postfix-doc (from .../postfix-doc_2.5.5-1.1_all.deb) ...
Selecting previously deselected package postfix-mysql.
Unpacking postfix-mysql (from .../postfix-mysql_2.5.5-1.1_amd64.deb) ...
Selecting previously deselected package unhide.
Unpacking unhide (from .../unhide_20080519-2_amd64.deb) ...
Processing triggers for man-db ...
Setting up libnet-daemon-perl (0.38-1.1) ...
Setting up libplrpc-perl (0.2017-1.1) ...
Setting up libdbi-perl (1.605-1) ...
Setting up libmysqlclient15off (5.0.51a-24+lenny5) ...
Setting up libdbd-mysql-perl (4.007-1+lenny1) ...
Setting up mysql-client-5.0 (5.0.51a-24+lenny5) ...
Setting up psmisc (22.6-1) ...
Setting up mysql-server-5.0 (5.0.51a-24+lenny5) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
subprocess post-installation script returned error exit status 1
Setting up openssl (0.9.8g-15+lenny11) ...
Setting up openssl-blacklist (0.4.2) ...
Setting up binutils (2.18.1~cvs20080103-7) ...
Setting up libpq5 (8.3.12-0lenny1) ...
Setting up dovecot-common (1:1.0.15-2.3+lenny1) ...

Creating config file /etc/dovecot/dovecot.conf with new version

Creating config file /etc/dovecot/dovecot-ldap.conf with new version

Creating config file /etc/dovecot/dovecot-sql.conf with new version
adduser: Warning: The home directory `/usr/lib/dovecot' does not belong to the user you are currently creating.
Creating generic self-signed certificate: /etc/ssl/certs/dovecot.pem
(replace with hand-crafted or authorized one if needed).
Setting up dovecot-imapd (1:1.0.15-2.3+lenny1) ...
Restarting IMAP/POP3 mail server: dovecot.
Setting up python-support (0.8.4lenny2) ...
Setting up getmail4 (4.7.8-1) ...
Setting up libhtml-template-perl (2.9-1) ...
Setting up libmd5-perl (2.03-1) ...
Setting up libterm-readkey-perl (2.30-4) ...
Setting up mysql-client (5.0.51a-24+lenny5) ...
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.0; however:
Package mysql-server-5.0 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
Setting up ssl-cert (1.0.23) ...
Setting up postfix (2.5.5-1.1) ...
Adding group `postfix' (GID 110) ...
Done.
Adding system user `postfix' (UID 107) ...
Adding new user `postfix' (UID 107) with group `postfix' ...
Not creating home directory `/var/spool/postfix'.
Creating /etc/postfix/dynamicmaps.cf
Adding tcp map entry to /etc/postfix/dynamicmaps.cf
Adding group `postdrop' (GID 111) ...
Done.
setting myhostname: lenny1.example.com
setting alias maps
setting alias database
setting myorigin
setting destinations: lenny1.example.com, localhost.example.com, , localhost
setting relayhost:
setting mynetworks: 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128
setting mailbox_command
setting mailbox_size_limit: 0
setting recipient_delimiter: +
setting inet_interfaces: all

Postfix is now set up with a default configuration. If you need to make
changes, edit
/etc/postfix/main.cf (and others) as needed. To view Postfix configuration
values, see postconf(1).

After modifying main.cf, be sure to run '/etc/init.d/postfix reload'.

Running newaliases
Stopping Postfix Mail Transport Agent: postfix.
Starting Postfix Mail Transport Agent: postfix.
Setting up rkhunter (1.3.2-6) ...
Updating the file properties database:
[ Rootkit Hunter version 1.3.2 ]
File created: searched for 151 files, found 121
Setting up postfix-doc (2.5.5-1.1) ...
Setting up postfix-mysql (2.5.5-1.1) ...
Adding mysql map entry to /etc/postfix/dynamicmaps.cf
Setting up unhide (20080519-2) ...
Using '/usr/sbin/unhide-linux26' to provide 'unhide'.
Errors were encountered while processing:
mysql-server-5.0
mysql-server

 

[Rolli-Ronny]

Das Problem ist offentsichtlich der mysql-server und eine Log Datei wirdt du nicht finden weil ja der mysql-server nicht läuft.

 

[kesandal]

Das Problem ist offentsichtlich der mysql-server und eine Log Datei wirdt du nicht finden weil ja der mysql-server nicht läuft.

hmm.. ja...
Wie gehte ich denn dieses Problem an?

Die Aussage, dass der Server nicht gestartet wurde ist ja nicht viel aussagend.
Gibt es vielleicht irgendwo noch eine Log-Datei die mir näheres verrät?

Danke
Kesandal

 

[Rolli-Ronny]

Schau mal in /var/log ob sich dort etwas findet.

 

[kesandal]

Hallo,
danke für Deine Hilfe!


In der syslog habe ich folgendes gefunden:

Jan 15 13:00:34 lenny1 mysqld[8622]: 110115 13:00:34 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Jan 15 13:00:34 lenny1 mysqld[8622]: 110115 13:00:34 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Jan 15 13:00:34 lenny1 mysqld[8622]: 110115 13:00:34 [ERROR] Aborting
Jan 15 13:00:34 lenny1 mysqld[8622]:
Jan 15 13:00:34 lenny1 mysqld[8622]: 110115 13:00:34  InnoDB: Starting shutdown...
Jan 15 13:00:37 lenny1 mysqld[8622]: 110115 13:00:37  InnoDB: Shutdown completed; log sequence number 0 43655
Jan 15 13:00:37 lenny1 mysqld[8622]: 110115 13:00:37 [Note] /usr/sbin/mysqld: Shutdown complete
Jan 15 13:00:37 lenny1 mysqld[8622]:
 
Jan 15 13:00:48 lenny1 /etc/init.d/mysql[8808]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' $
Jan 15 13:00:48 lenny1 /etc/init.d/mysql[8808]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jan 15 13:00:48 lenny1 /etc/init.d/mysql[8808]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock$
Jan 15 13:00:48 lenny1 /etc/init.d/mysql[8808]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 15 13:00:48 lenny1 /etc/init.d/mysql[8808]:

Hilft uns das weiter?

Viele Grüße

 

[Wurstbrot]

Jan 15 13:00:48 lenny1 /etc/init.d/mysql[8808]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jan 15 13:00:48 lenny1 /etc/init.d/mysql[8808]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock$
Jan 15 13:00:48 lenny1 /etc/init.d/mysql[8808]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 15 13:00:48 lenny1 /etc/init.d/mysql[8808]:

Das hilft doch mal ein wenig weiter - hast das ganze mal überprüft?

 

[kesandal]

Überprüft.. hmm

Wenn ich wüsste wo ich anfangen soll

Meine /etc/network/interfaces lifert folgendes:

# This file describes the network interfaces available on your system
# and how to activate them. For more information, see interfaces(5).
#
auto eth0
iface eth0 inet static
address 192.168.0.100
netmask 255.255.255.0
network 192.168.0.0
broadcast 192.168.0.255
gateway 192.168.0.30

und meine /etc/hosts/ hat folgenden Inhalt:

127.0.0.1       localhost.localdomain   localhost
127.168.0.100   lenny1.example.com      lenny1
# The following lines are desirable for IPv6 capable hosts
::1     localhost ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts

Viele Grüße

 

[Wurstbrot]

Huhu,

Jan 15 13:00:48 lenny1 /etc/init.d/mysql[8808]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

mysqld rennt und das socket existiert auch wirklich?

EDIT: Moment laufen tut der ja gar ned - also wird mysqld auch nicht rennen - das socket exisitert?

 

[kesandal]

Ich denke es läuft nicht...

Wenn ich mysqld eintippe erhalte ich folgendes:

lenny1:/var/log# mysqld
110116 22:59:36  InnoDB: Started; log sequence number 0 43655
110116 22:59:36 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
110116 22:59:36 [ERROR] Do you already have another mysqld server running on port: 3306 ?
110116 22:59:36 [ERROR] Aborting
110116 22:59:36  InnoDB: Starting shutdown...

vllt. ist meine hosts falsch?


Edit:

EDIT: Moment laufen tut der ja gar ned - also wird mysqld auch nicht rennen - das socket exisitert?

Ich schaue eben nach wie ich es prüfe.

Edit2:

Im Netz habe ich folgendes gefunden:

"Hierzu sollte man prüfen, ob der Socket vorhanden ist (normalerweise /tmp/mysql.socket) oder eine Verbindung mittels telnet hostname 3306 aufbauen. Durch mysqladmin version können ebenfalls weitere Informationen ausgegeben werden. "

Eine mysql.socket scheint es nicht zu geben.
Auch kann ich keine telnet-Verbindung auf 3306 aufbauen.

Mit mysqladmin version erhalte ich:

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

 

[Laubie]

Dann schau doch mal mit netstat -nlp was da auf port 3306 lauscht.
und schau doch mal mit top ob nicht doch ein mysql - oder ein anderer sql-dienst - läuft.

Grüße
Laubie

 

[Wurstbrot]

Denke dass da aus der vorherigen Installation noch iwie was reinfunkt... wurde ja nicht sauber deinstalliert...

Deinstalliere mal nur mysql installiere neu und versuche mal zu starten

 

[kesandal]

Hallo,
ich habe das System nochmal komplett neu aufgesetzt.

Jetzt klappt es einwandfrei.

Danke für Eure Hilfe

 

[Wurstbrot]

gleich n re-install geht doch oftmals schneller als rumfrickeln

-- closed --