mysqld tcp listening/networking problem (@woody)

hab da eine maschine, die hab ich schon vor jahren von slink auf potato upgedatet, und vor ein paar tagen auf woody. bis auf ein paar kleinigkeiten verlief alles wie erwartet, bzw konnte schnell gefixed werden, bis auf eines:

beim mysqld funktioniert der tcp-access/networking nicht. der tcp-port ist im LISTEN mode und gehört auch dem mysqld prozess, aber nach jedem connect wird die verbindung sofort geschlossen. zum testen hab ich auch alle ipchains-einträge entfernt.

config sieht so aus:

Code:

[i]/etc/mysql/my.cnf[/i]
# You can copy this to one of:
# /etc/mysql/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options

# This will be passed to all mysql clients
[client]
#password       = my_password
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

[safe_mysqld]
err-log         = /var/log/mysql/mysql.err

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
#
# You can also put it into /var/log/mysql/mysql.log but I leave it in /var/log
# for backward compatibility. Both location gets rotated by the cronjob.
#log            = /var/log/mysql/mysql.log
log             = /var/log/mysql.log
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-locking
#
# The skip-networkin option will no longer be set via debconf menu.
# You have to manually change it if you want networking i.e. the server
# listening on port 3306. The default is "disable" - for security reasons.
##- removed by atrox - see iptables config for security -
## skip-networking
set-variable    = key_buffer=16M
set-variable    = max_allowed_packet=1M
set-variable    = thread_stack=128K
#
# Here you can see queries with especially long duration
#log-slow-queries       = /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for replication
#server-id              = 1
#log-bin                = /var/log/mysql/mysql-bin.log
#binlog-do-db           = include_database_name
#binlog-ignore-db       = include_database_name
#
# Read the manual if you want to enable InnoDB!
skip-innodb

[mysqldump]
quick
set-variable    = max_allowed_packet=1M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
set-variable    = key_buffer=16M

woran könnte es (noch) liegen ?


//edit: ahja...

Code:

[i]dpkg -l mysql-server[/i]
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name                   Version                Description
+++-======================-======================-=======================
ii  mysql-server           3.23.51-1woody5        mysql database server binaries

nein leider, das ding mit "skip-networking" ist es leider nicht... das ist bereits auskommentiert

Code:

# [b]mysql --port=3306 --host=xxxxxxxx[/b]
ERROR 2013: Lost connection to MySQL server during query
# [b]telnet 0 3306[/b] # die connection wird sofort nach herstellung wieder geschlossen :(
Trying 0.0.0.0...
Connected to 0.0.0.0.
Escape character is '^]'.
Connection closed by foreign host.
# [b]netstat -anp | grep "3306"[/b]
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
tcp        0      0 127.0.0.1:3306          127.0.0.1:2333          TIME_WAIT   -
tcp        0      0 194.152.xxx.xxx:3306     194.152.xxx.xxx:2331     TIME_WAIT   -
tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      29641/mysqld