MySQL-Server lässt sich nicht installieren

[Nemesis]

Hi,
ich hab hier Pobleme mit MySQL ... ich krieg den Server nicht installiert:

# apt-get install mysql-server-5.1
Paketlisten werden gelesen... Fertig
Abhängigkeitsbaum wird aufgebaut       
Statusinformationen werden eingelesen... Fertig
mysql-server-5.1 ist schon die neueste Version.
Die folgenden Pakete wurden automatisch installiert und werden nicht mehr benötigt:
  sendmail-base procmail sensible-mda sendmail-cf
Verwenden Sie »apt-get autoremove«, um sie zu entfernen.
0 aktualisiert, 0 neu installiert, 0 zu entfernen und 8 nicht aktualisiert.
1 nicht vollständig installiert oder entfernt.
Nach dieser Operation werden 0 B Plattenplatz zusätzlich benutzt.
Möchten Sie fortfahren [J/n]? 
mysql-server-5.1 (5.1.49-3) wird eingerichtet ...
Stopping MySQL database server: mysqld.
insserv: Script clamav-freshclam is broken: incomplete LSB comment.
insserv: missing `Provides:' entry: please add.
insserv: missing `Required-Start:' entry: please add even if empty.
insserv: missing `Required-Stop:'  entry: please add even if empty.
insserv: missing `Default-Start:'  entry: please add even if empty.
insserv: missing `Default-Stop:'   entry: please add even if empty.
insserv: Script clamav-freshclam is broken: incomplete LSB comment.
insserv: missing `Provides:' entry: please add.
insserv: missing `Required-Start:' entry: please add even if empty.
insserv: missing `Required-Stop:'  entry: please add even if empty.
insserv: missing `Default-Start:'  entry: please add even if empty.
insserv: missing `Default-Stop:'   entry: please add even if empty.
insserv: Script clamav-freshclam is broken: incomplete LSB comment.
insserv: missing `Provides:' entry: please add.
insserv: missing `Required-Start:' entry: please add even if empty.
insserv: missing `Required-Stop:'  entry: please add even if empty.
insserv: missing `Default-Start:'  entry: please add even if empty.
insserv: missing `Default-Stop:'   entry: please add even if empty.
insserv: Script clamav-freshclam is broken: incomplete LSB comment.
insserv: missing `Provides:' entry: please add.
insserv: missing `Required-Start:' entry: please add even if empty.
insserv: missing `Required-Stop:'  entry: please add even if empty.
insserv: missing `Default-Start:'  entry: please add even if empty.
insserv: missing `Default-Stop:'   entry: please add even if empty.
insserv: Script clamav-freshclam is broken: incomplete LSB comment.
insserv: missing `Provides:' entry: please add.
insserv: missing `Required-Start:' entry: please add even if empty.
insserv: missing `Required-Stop:'  entry: please add even if empty.
insserv: missing `Default-Start:'  entry: please add even if empty.
insserv: missing `Default-Stop:'   entry: please add even if empty.
insserv: Script clamav-freshclam is broken: incomplete LSB comment.
insserv: missing `Provides:' entry: please add.
insserv: missing `Required-Start:' entry: please add even if empty.
insserv: missing `Required-Stop:'  entry: please add even if empty.
insserv: missing `Default-Start:'  entry: please add even if empty.
insserv: missing `Default-Stop:'   entry: please add even if empty.
insserv: Script clamav-freshclam is broken: incomplete LSB comment.
insserv: missing `Provides:' entry: please add.
insserv: missing `Required-Start:' entry: please add even if empty.
insserv: missing `Required-Stop:'  entry: please add even if empty.
insserv: missing `Default-Start:'  entry: please add even if empty.
insserv: missing `Default-Stop:'   entry: please add even if empty.
insserv: Script ulteo-ovd is broken: incomplete LSB comment.
insserv: missing valid name for `Provides:' please add.
insserv: Script clamav-freshclam is broken: incomplete LSB comment.
insserv: missing `Provides:' entry: please add.
insserv: missing `Required-Start:' entry: please add even if empty.
insserv: missing `Required-Stop:'  entry: please add even if empty.
insserv: missing `Default-Start:'  entry: please add even if empty.
insserv: missing `Default-Stop:'   entry: please add even if empty.
insserv: Script ulteo-ovd is broken: incomplete LSB comment.
insserv: missing valid name for `Provides:' please add.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: Fehler beim Bearbeiten von mysql-server-5.1 (--configure):
 Unterprozess installiertes post-installation-Skript gab den Fehlerwert 1 zurÃ\u0152ck
configured to not write apport reports
                                      Fehler traten auf beim Bearbeiten von:
 mysql-server-5.1
E: Sub-process /usr/bin/dpkg returned an error code (1)

was der da mit clamav-freshclam für ein Problem hat, ist mir auch ein Rätsel.
Ich komm nicht drauf, was hier hängt. Weiss wer weiter?

Thx!

 

[HeadCrash]

Hallo,

wenn ich das richtig versteh meckert er die LSB Kommentare im "clamav-freshclam"-Skript an. Habe ich nirgends installiert, da sollten aber Kommentare analog zu

#!/bin/sh -e
### BEGIN INIT INFO
# Provides:          apache2
# Required-Start:    $local_fs $remote_fs $network $syslog
# Required-Stop:     $local_fs $remote_fs $network $syslog
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Short-Description: Start/stop apache2 web server

gesetzt sein.

mfg
HeadCrash

 

[Nemesis]

hm ... das init-script schaut da schon ganz merkwürdig aus:

#deactivated by wbmclamav##!/bin/sh
#deactivated by wbmclamav#
#deactivated by wbmclamav#### BEGIN INIT INFO
#deactivated by wbmclamav## Provides:          clamav-freshclam
#deactivated by wbmclamav## Required-Start:    $remote_fs $syslog
#deactivated by wbmclamav## Should-Start:      clamav-daemon
#deactivated by wbmclamav## Required-Stop:     $remote_fs $syslog
#deactivated by wbmclamav## Should-Stop:
#deactivated by wbmclamav## Default-Start:     2 3 4 5
#deactivated by wbmclamav## Default-Stop:      0 1 6
#deactivated by wbmclamav## Short-Description: ClamAV virus database updater
#deactivated by wbmclamav## Description:       Clam AntiVirus virus database updater
#deactivated by wbmclamav#### END INIT INFO
#deactivated by wbmclamav#
#deactivated by wbmclamav#DAEMON=/usr/bin/freshclam
#deactivated by wbmclamav#NAME=freshclam
#deactivated by wbmclamav#DESC="ClamAV virus database updater"
#deactivated by wbmclamav#[ -x $DAEMON ] || exit 0
#deactivated by wbmclamav#
#deactivated by wbmclamav#CLAMAV_CONF_FILE=/etc/clamav/clamd.conf
#deactivated by wbmclamav#FRESHCLAM_CONF_FILE=/etc/clamav/freshclam.conf
#deactivated by wbmclamav#PIDFILE=/var/run/clamav/freshclam.pid
#deactivated by wbmclamav#[ -f /var/lib/clamav/interface ] && INTERFACE=`cat /var/lib/clamav/interface`
#deactivated by wbmclamav#
#deactivated by wbmclamav#status_of_proc () {
#deactivated by wbmclamav#    local pidfile daemon name status
#deactivated by wbmclamav#
#deactivated by wbmclamav#    pidfile=
#deactivated by wbmclamav#    OPTIND=1
#deactivated by wbmclamav#    while getopts p: opt ; do
#deactivated by wbmclamav#        case "$opt" in
#deactivated by wbmclamav#            p)  pidfile="$OPTARG";;
#deactivated by wbmclamav#        esac
#deactivated by wbmclamav#    done
#deactivated by wbmclamav#    shift $(($OPTIND - 1))
#deactivated by wbmclamav#
#deactivated by wbmclamav#    if [ -n "$pidfile" ]; then
#deactivated by wbmclamav#        pidfile="-p $pidfile"
#deactivated by wbmclamav#    fi
#deactivated by wbmclamav#    daemon="$1"
#deactivated by wbmclamav#    name="$2"
#deactivated by wbmclamav#
#deactivated by wbmclamav#    status="0"
#deactivated by wbmclamav#    pidofproc $pidfile $daemon >/dev/null || status="$?"
#deactivated by wbmclamav#    if [ "$status" = 0 ]; then
#deactivated by wbmclamav#        log_success_msg "$name is running"
#deactivated by wbmclamav#        return 0
#deactivated by wbmclamav#    else
#deactivated by wbmclamav#        log_failure_msg "$name is not running"
#deactivated by wbmclamav#        return $status
#deactivated by wbmclamav#    fi
...

eine suche nach wbm in verbindung mit clamav ergab:

/var/backups/wbmclamav_system_backups
/var/backups/wbmclamav_system_backups/.backup_flag
/var/backups/wbmclamav_system_backups/etc
/var/backups/wbmclamav_system_backups/etc/clamav
/var/backups/wbmclamav_system_backups/etc/init.d
/var/backups/wbmclamav_system_backups/etc/network
/var/backups/wbmclamav_system_backups/etc/clamav/clamd.conf
/var/backups/wbmclamav_system_backups/etc/clamav/freshclam.conf
/var/backups/wbmclamav_system_backups/etc/init.d/clamav-daemon
/var/backups/wbmclamav_system_backups/etc/init.d/clamav-freshclam
/var/backups/wbmclamav_system_backups/etc/network/if-down.d
/var/backups/wbmclamav_system_backups/etc/network/if-up.d
/var/backups/wbmclamav_system_backups/etc/network/if-down.d/clamav-freshclam-ifupdown
/var/backups/wbmclamav_system_backups/etc/network/if-up.d/clamav-freshclam-ifupdown

hm ... aber was das ist, und wo das wohl herkommt ... kein plan :-/

 

[Goodspeed]

Na steht doch da

deactivated by wbmclamav

Keine Ahnung, was wbmclamav tun und warum ... gibts AFAIK nicht in den Debian-Repos ...

 

[Nemesis]

sag ich doch ... aber was das ist, und wo das wohl herkommt ... kein plan :-/
ich hab mal das orginal aud dem deb drüber gebügelt. jetzt taucht im syslogfolgendes auf:

Mar 31 20:56:39 NemesisSVR mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Mar 31 20:56:39 NemesisSVR mysqld: 110331 20:56:39 [Note] Plugin 'FEDERATED' is disabled.
Mar 31 20:56:39 NemesisSVR mysqld: /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
Mar 31 20:56:39 NemesisSVR mysqld: 110331 20:56:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Mar 31 20:56:39 NemesisSVR mysqld: 110331 20:56:39  InnoDB: Started; log sequence number 0 4458015
Mar 31 20:56:39 NemesisSVR mysqld: 110331 20:56:39 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
Mar 31 20:56:39 NemesisSVR mysqld: 110331 20:56:39 [ERROR] Aborting
Mar 31 20:56:39 NemesisSVR mysqld:
Mar 31 20:56:39 NemesisSVR mysqld: 110331 20:56:39  InnoDB: Starting shutdown...
Mar 31 20:56:44 NemesisSVR mysqld: 110331 20:56:44  InnoDB: Shutdown completed; log sequence number 0 4458015
Mar 31 20:56:44 NemesisSVR mysqld: 110331 20:56:44 [Note] /usr/sbin/mysqld: Shutdown complete
Mar 31 20:56:44 NemesisSVR mysqld:
Mar 31 20:56:44 NemesisSVR mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Mar 31 20:56:53 NemesisSVR /etc/init.d/mysql[13071]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar 31 20:56:53 NemesisSVR /etc/init.d/mysql[13071]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Mar 31 20:56:53 NemesisSVR /etc/init.d/mysql[13071]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Mar 31 20:56:53 NemesisSVR /etc/init.d/mysql[13071]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Mar 31 20:56:53 NemesisSVR /etc/init.d/mysql[13071]:

 

[Goodspeed]

Hab zwar keine Frage gesehen, aber ich wink trotzdem mal ...

Mar 31 20:56:39 NemesisSVR mysqld: 110331 20:56:39 [ERROR] Can't open the mysql.plugin table. [B]Please run mysql_upgrade to create it[/B].

 

[Nemesis]

hehe, da beisst sich jetzt wohl der hund in den schwanz ... oder so ähnlich ... mysql_upgrade läuft erst, wenn mysql läuft:

# mysql_upgrade 
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' 
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

und der läuft wiederum erst, wenn er die tabelle hat. verzwickte lage :-/

 

[Goodspeed]

Läuft noch irgendein mysqld-Prozess?
Exisitert /var/run/mysqld/mysqld.sock? Welche Rechte?

 

[foexle]

ne der läuft wohl nicht ....
versuch mal

dpkg-reconfigure mysql-server

 

[Nemesis]

kein mysql-prozess und auch die mysqld.sock existiert auch net.
und das mit rekonfigurieren hab ich auch schon probiert:

# dpkg-reconfigure mysql-server-5.1
/usr/sbin/dpkg-reconfigure: mysql-server-5.1 ist kaputt oder nicht komplett installiert

 

[foexle]

dann wüsste ich auf anhieb nur noch

apt-get install -f

 

[Nemesis]

hehe, auch das hab ich schon probiert ... da wären wir dann wieder am anfang

0 aktualisiert, 0 neu installiert, 0 zu entfernen und 8 nicht aktualisiert.
1 nicht vollständig installiert oder entfernt.
Nach dieser Operation werden 0 B Plattenplatz zusätzlich benutzt.
mysql-server-5.1 (5.1.49-3) wird eingerichtet ...
Stopping MySQL database server: mysqld.
insserv: Script ulteo-ovd is broken: incomplete LSB comment.
insserv: missing valid name for `Provides:' please add.
insserv: missing `Provides:' entry: please add.
insserv: missing `Required-Start:' entry: please add even if empty.
insserv: missing `Required-Stop:'  entry: please add even if empty.
insserv: missing `Default-Start:'  entry: please add even if empty.
insserv: missing `Default-Stop:'   entry: please add even if empty.
insserv: Script ulteo-ovd is broken: incomplete LSB comment.
insserv: missing valid name for `Provides:' please add.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: Fehler beim Bearbeiten von mysql-server-5.1 (--configure):
 Unterprozess installiertes post-installation-Skript gab den Fehlerwert 1 zurück
configured to not write apport reports
                                      Fehler traten auf beim Bearbeiten von:
 mysql-server-5.1
E: Sub-process /usr/bin/dpkg returned an error code (1)

 

[foexle]

so ich hab mal gegoogelt ...
schau doch mal in
/etc/init.d/mysqld nach ob die "start"-Sektion funktioniert. Falls nicht musst du diese reparieren.

Augenscheinlich ist das hier

insserv: Script ulteo-ovd is broken: incomplete LSB comment.
insserv: missing valid name for `Provides:' please add.
insserv: missing `Provides:' entry: please add.
insserv: missing `Required-Start:' entry: please add even if empty.
insserv: missing `Required-Stop:'  entry: please add even if empty.
insserv: missing `Default-Start:'  entry: please add even if empty.
insserv: missing `Default-Stop:'   entry: please add even if empty.
insserv: Script ulteo-ovd is broken: incomplete LSB comment.
insserv: missing valid name for `Provides:' please add.

ein anderer Fehler. Hast du ulteo-ovd mittels einem rpm-Paketes installiert ?


Greetz

 

[Nemesis]

das ulteo-zeugs ist mal nebensächlich ... das fliegt bei gelegenheit runter ... aber ich würd sagen, da stimmt was gehörig nicht ... wenn ich clamav installiere zerballert er die /var/lib/dpkg/status:

grep-status: /var/lib/dpkg/status:18995: Doppelpunkt wurde erwartet

das init-script vom mysqld sieht normal aus, nix auffälliges.

 

[foexle]

taucht etwas in syslog oder messages auf ?

 

[Nemesis]

hm ... quick'n'dirty ... wenn man skip-bdb in der my.cnf auskommentiert, dann gehts

 

[Goodspeed]

Wie sieht denn die /var/lib/dpkg/status aus? Steht da auch der wbmclamav-Schmarn drin?
Welches Paket befindet sich denn in Zeile 18995?

 

[Nemesis]

ich hab das ganze clamav-zeugs inkl. configs runtergeworfen und neu installiert, jetzt mekkert er da auch nichtmehr.

danke!