URL: https://www.overclockers.at/linux/mysqld_tcp_listening_networking_problem_woody_85596/page_1 - zur Vollversion wechseln!
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:
woran könnte es (noch) liegen ?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
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
http://www.wcm.at/vb2/showthread.ph...threadid=102859
?
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
argl.. die lösung ist:
die woody-version ist --with-libwrap compiliert, und deshalb anfällig auf einträge in der /etc/hosts.allow .
overclockers.at v4.thecommunity
© all rights reserved by overclockers.at 2000-2024