mysqld tcp listening/networking problem (@woody)
atrox 11.07.2003 - 01:07 851 3
atrox
in fairy dust... I trust!
|
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: [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... [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
Bearbeitet von atrox am 11.07.2003, 12:30
|
spunz
Super ModeratorSuper Moderator
|
|
atrox
in fairy dust... I trust!
|
nein leider, das ding mit "skip-networking" ist es leider nicht... das ist bereits auskommentiert # [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
|
atrox
in fairy dust... I trust!
|
argl.. die lösung ist: die woody-version ist --with-libwrap compiliert, und deshalb anfällig auf einträge in der /etc/hosts.allow .
|