ich habe die üblichen Updates gemacht, aber meine config-Dateien nicht ersetzt. Mysql startet momentan nicht mehr. Vorher konnte ich es mit mysqld starten, aber phpmyadmin funktionierte nicht.
Confixx sagt mir auch:"The locale key is unknown
No such file or directory"
mysqld liefert einen Fehler:
english/errmsg.sys existiert tatsächlich nicht. Vorher existierte es.120409 23:48:12 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'
120409 23:48:12 [Note] Plugin 'FEDERATED' is disabled.
120409 23:48:12 [Note] Plugin 'InnoDB' is disabled.
120409 23:48:12 [ERROR] Aborting
120409 23:48:12 [Note]
mysql-Logdateien existieren nicht.
syslog (letzten paar Zeilen):
restarts, reinstalls, reboots, etc. funktionieren alle nicht. Selbst "apt-get remove mysql-server" funktioniert nicht, da gleich im Anschluss wieder versucht wird, MySQL zu starten, obwohl es doch deinstalliert sein müsste?Apr 9 23:46:05 vps7011 postgrey[3096]: 2012/04/09-23:46:05 postgrey (type Net::Server::Multiplex) starting! pid(3096)
Apr 9 23:46:05 vps7011 postgrey[3096]: Binding to TCP port 10023 on host localhost
Apr 9 23:46:05 vps7011 postgrey[3096]: Setting gid to "113 113"
Apr 9 23:46:05 vps7011 postgrey[3096]: Setting uid to "110"
Apr 9 23:46:06 vps7011 spamd[3102]: logger: removing stderr method
Apr 9 23:46:07 vps7011 spamd[3104]: spamd: server started on port 783/tcp (running version 3.3.1)
Apr 9 23:46:07 vps7011 spamd[3104]: spamd: server pid: 3104
Apr 9 23:46:07 vps7011 spamd[3104]: spamd: server successfully spawned child process, pid 3105
Apr 9 23:46:07 vps7011 spamd[3104]: spamd: server successfully spawned child process, pid 3107
Apr 9 23:46:07 vps7011 spamd[3104]: prefork: child states: IS
Apr 9 23:46:07 vpsxxxx spamd[3104]: prefork: child states: II
Apr 9 23:46:07 vps7011 postfix/master[3181]: daemon started -- version 2.7.1, configuration /etc/postfix
Apr 9 23:46:07 vps7011 xinetd[3205]: attribute: disable should not be in default section [file=/etc/xinetd.conf] [line=12]
Apr 9 23:46:07 vps7011 xinetd[3205]: Reading included configuration file: /etc/xinetd.d/chargen [file=/etc/xinetd.conf] [line=15]
Apr 9 23:46:07 vps7011 xinetd[3205]: Reading included configuration file: /etc/xinetd.d/daytime [file=/etc/xinetd.d/daytime] [line=28]
Apr 9 23:46:07 vps7011 xinetd[3205]: Reading included configuration file: /etc/xinetd.d/discard [file=/etc/xinetd.d/discard] [line=26]
Apr 9 23:46:07 vps7011 xinetd[3205]: Reading included configuration file: /etc/xinetd.d/echo [file=/etc/xinetd.d/echo] [line=25]
Apr 9 23:46:07 vps7011 xinetd[3205]: Reading included configuration file: /etc/xinetd.d/time [file=/etc/xinetd.d/time] [line=26]
Apr 9 23:46:07 vps7011 xinetd[3205]: removing chargen
Apr 9 23:46:07 vps7011 xinetd[3205]: removing chargen
Apr 9 23:46:07 vps7011 xinetd[3205]: removing daytime
Apr 9 23:46:07 vps7011 xinetd[3205]: removing daytime
Apr 9 23:46:07 vps7011 xinetd[3205]: removing discard
Apr 9 23:46:07 vps7011 xinetd[3205]: removing discard
Apr 9 23:46:07 vps7011 xinetd[3205]: removing echo
Apr 9 23:46:07 vps7011 xinetd[3205]: removing echo
Apr 9 23:46:07 vps7011 xinetd[3205]: removing time
Apr 9 23:46:07 vps7011 xinetd[3205]: removing time
Apr 9 23:46:07 vps7011 xinetd[3205]: xinetd Version 2.3.14 started with libwrap loadavg options compiled in.
Apr 9 23:46:07 vps7011 xinetd[3205]: Started working: 0 available services
Apr 9 23:46:07 vps7011 init: no more processes left in this runlevel
Apr 9 23:46:12 vps7011 ntpd[3092]: step-systime: Operation not permitted
Apr 9 23:46:15 vpsxxxx ntpdate[3216]: the NTP socket is in use, exiting
Apr 9 23:46:24 vpsxxxx pop3d-ssl: Connection, ip=[::ffff:88.80.212.124]
Apr 9 23:46:24 vpsxxxx pop3d-ssl: LOGOUT, ip=[::ffff:88.80.212.124]
Apr 9 23:46:24 vpsxxxx pop3d-ssl: Disconnected, ip=[::ffff:88.80.212.124]
Apr 9 23:46:26 vpsxxxx pop3d: Connection, ip=[::ffff:88.80.212.124]
Apr 9 23:46:26 vpsxxxx pop3d: LOGOUT, ip=[::ffff:88.80.212.124]
Apr 9 23:46:26 vpsxxxx pop3d: Disconnected, ip=[::ffff:88.80.212.124]
Apr 9 23:47:20 vpsxxxx imapd: Connection, ip=[::ffff:88.80.212.124]
Apr 9 23:47:20 vpsxxxx imapd: LOGOUT, ip=[::ffff:88.80.212.124], rcvd=11, sent=307
Apr 9 23:47:20 vpsxxxx postfix/smtpd[3240]: connect from monitor.alfahosting.org[88.80.212.124]
Apr 9 23:47:20 vpsxxxx postfix/smtpd[3240]: disconnect from monitor.alfahosting.org[88.80.212.124]
Apr 9 23:48:01 vpsxxxx /USR/SBIN/CRON[3243]: (root) CMD (sleep 62; /root/confixx/confixx_counterscript.pl)
Apr 9 23:48:34 vpsxxxx imapd-ssl: Connection, ip=[::ffff:88.80.212.124]
Apr 9 23:48:34 vpsxxxx imapd-ssl: LOGOUT, ip=[::ffff:88.80.212.124], rcvd=11, sent=309
Apr 9 23:49:04 vpsxxxx /USR/SBIN/CRON[3242]: (CRON) error (grandchild #3243 failed with exit status 1)
Apr 9 23:49:04 vpsxxxx postfix/pickup[3188]: 2AE68B7A05DF: uid=0 from=<root>
Apr 9 23:49:04 vpsxxxx postfix/cleanup[3258]: 2AE68B7A05DF: message-id=<20120409214904.2AE68B7A05DF@vpsxxxx.alfahosting-vps.de>
Apr 9 23:49:04 vpsxxxx postfix/qmgr[3187]: 2AE68B7A05DF: from=<root@vpsxxxx.alfahosting-vps.de>, size=1006, nrcpt=1 (queue active)
Apr 9 23:49:04 vpsxxxx spamd[3105]: spamd: connection from localhost.localdomain [127.0.0.1] at port 52956
Apr 9 23:49:04 vpsxxxx spamd[3105]: config: failed to load user (nobody) scores from SQL database: config: SQL error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Apr 9 23:49:04 vpsxxxx spamd[3105]: spamd: service unavailable: Error fetching user preferences via SQL
Apr 9 23:49:04 vpsxxxx spamd[3104]: prefork: child states: II
Apr 9 23:49:20 vpsxxxx mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Apr 9 23:49:20 vpsxxxx mysqld: 120409 23:49:20 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'
Apr 9 23:49:20 vpsxxxx mysqld: 120409 23:49:20 [Note] Plugin 'FEDERATED' is disabled.
Apr 9 23:49:20 vpsxxxx mysqld: 120409 23:49:20 [Note] Plugin 'InnoDB' is disabled.
Apr 9 23:49:20 vpsxxxx mysqld: 120409 23:49:20 [ERROR] Aborting
Apr 9 23:49:20 vpsxxxx mysqld:
Apr 9 23:49:20 vpsxxxx mysqld: 120409 23:49:20 [Note]
Apr 9 23:49:20 vpsxxxx mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Apr 9 23:49:34 vpsxxxx /etc/init.d/mysql[3763]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Apr 9 23:49:34 vpsxxxx /etc/init.d/mysql[3763]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Apr 9 23:49:34 vpsxxxx /etc/init.d/mysql[3763]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Apr 9 23:49:34 vpsxxxx /etc/init.d/mysql[3763]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Apr 9 23:49:34 vpsxxxx /etc/init.d/mysql[3763]:
Apr 9 23:50:00 vpsxxxx postfix/local[3260]: 2AE68B7A05DF: to=<root@vpsxxxx.alfahosting-vps.de>, orig_to=<root>, relay=local, delay=56, delays=0.1/0/0/56, dsn=2.0.0, status=sent (delivered to command: procmail)
Apr 9 23:50:00 vpsxxxx postfix/qmgr[3187]: 2AE68B7A05DF: removed
Apr 9 23:50:01 vpsxxxx /USR/SBIN/CRON[3772]: (root) CMD (sleep 62; /root/confixx/confixx_counterscript.pl)
Apr 9 23:50:01 vpsxxxx /USR/SBIN/CRON[3774]: (www-data) CMD ([ -x /usr/share/awstats/tools/update.sh ] && /usr/share/awstats/tools/update.sh)
Apr 9 23:50:02 vpsxxxx postfix/pickup[3188]: 0D9AFB7A05DF: uid=33 from=<www-data>
Apr 9 23:50:02 vpsxxxx postfix/cleanup[3258]: 0D9AFB7A05DF: message-id=<20120409215002.0D9AFB7A05DF@vpsxxxx.alfahosting-vps.de>
Apr 9 23:50:02 vpsxxxx postfix/qmgr[3187]: 0D9AFB7A05DF: from=<www-data@vpsxxxx.alfahosting-vps.de>, size=1210, nrcpt=1 (queue active)
Apr 9 23:50:02 vpsxxxx spamd[3105]: spamd: connection from localhost.localdomain [127.0.0.1] at port 53442
Apr 9 23:50:02 vpsxxxx spamd[3105]: config: failed to load user (www-data) scores from SQL database: config: SQL error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Apr 9 23:50:02 vpsxxxx spamd[3105]: spamd: service unavailable: Error fetching user preferences via SQL
Apr 9 23:50:02 vpsxxxx postfix/local[3260]: 0D9AFB7A05DF: to=<www-data@vpsxxxx.alfahosting-vps.de>, orig_to=<www-data>, relay=local, delay=0.02, delays=0.01/0/0/0.01, dsn=2.0.0, status=sent (delivered to command: procmail)
Apr 9 23:50:02 vpsxxxx postfix/qmgr[3187]: 0D9AFB7A05DF: removed
Apr 9 23:50:02 vpsxxxx spamd[3104]: prefork: child states: II
/var/run/mysqld/mysqld.sock existiert momentan nicht.
Weiterer Ausschnitt:
Code: Alles auswählen
120409 23:53:37 [Note]
vpsxxxx:~# /etc/init.d/mysql status
MySQL is stopped..
vpsxxxx:~# apt-get --reinstall install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 1 reinstalled, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up mysql-server-5.5 (5.5.22-1~dotdeb.0) ...
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.5 (--configure):
subprocess installed post-installation script returned error exit status 1
configured to not write apport reports
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.5; however:
Package mysql-server-5.5 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
configured to not write apport reports
Errors were encountered while processing:
mysql-server-5.5
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
Anfangs hatte Mysql teilweise(!) funktioniert. Manche Tabellen funktionierten nicht, aber die meisten schon. phpmyadmin zeigte auch eine weiße Seite, sodass ich all diese Maßnahmen machen musste, aber ohne Erfolg.