ProFTPD login via MySQL langsam

Also jetzt muss ich sagen das ich nach über einer Woche ohne Lösung echt am verzweifeln bin. Ich habe es bis jetzt jeden Tag versucht aber es hat nichts gebracht. Also bitte, bitte, bitte kann mir jemand Helfen. Und fals jemand noch irgendwelche Infos braucht soll er sich melden.

Danke!!!
 
Hi gulp,

Ich hab das gleiche Problem mit meinem ProFTPD.

Ich würde nach meinem Gefühl schätzten, dass es an der MySQL abfrage für den Benutzer liegt. Kann sein, dass er für den Verbindungsaufbau und die Abfrage etwas länger braucht als gewöhnlich. Schau dir am besten mal alle logs genau an (auch die MySQL falls existierend) syslog etc. vll. findest du da ja irgend wo den Fehler.
Außerdem gibt es ne menge Timeouts in deinem Mittschnitt via strace -r -T -p <PID>, vorallem bei den MySQL abfragen.

Gruß Frisch12
 
Das hier im Syslog hat mich etwas verwundert da es ca. 3-4 mal pro Minute auftaucht (glaube aber nicht das das was damit zu tun hat):
Code: 
Apr  8 16:59:01 alpha CRON[12833]: (nobody) CMD (if [ -x /usr/bin/php5 ] && [ -
f /usr/share/serverstats/update.php ]; then /usr/bin/php5 /usr/share/serverstat
s/update.php >

Was anderes hab ich in den Logs nicht gefunden.
Aber kennt jemand ne andere Möglichkeit außer MySQL oder lokale Benutzer für proFTPd die Schneller ist?
Aber MySQL wäre mir doch am Liebstens!

Grüße Gulp
 
Das ist nur nen Cronjob.

Hast du denn irgendeine Verwaltungssoftware installiert z.B. Plesk oder ISPCP?

Gruß Frisch12
 
OK, aber was ist das für ein Cronjob?

Aber zum eigentlichen Thema zurück.
Ja ich habe eine Verwaltungssoftware instaliert und zwar Webmin.
 
Okay Webmin ist eine unsichere software deswegen ist sie auch bei den meisten Hostern verboten.
Versuch mal ISPCP Omega. Das ist auch ganz gut. Besser sogar und installiert alle benötigten Pakete incl. konfiguration automatisch.
Dann sind auch alle deine Fehler weg.

Wenn du dabei Hilfe brauchst schreib mir ne PM

Gruß Frisch12
 
Der ISPSP übernimmt die gesamte konfiguration womit du dich nicht mehr mit fehlern rumärgern musst.

Gruß Frisch12
 
Du scheinst ja das ISPCP zu haben.
Frisch12 said:
Hi gulp,


Ich hab das gleiche Problem mit meinem ProFTPD.
Click to expand...
Du sagst, dass es bei dir auch nicht klapt und das Hilft mir nicht viel!
Und ganz ehrlich ich schreibe die Configs lieber selbst.

Und ich hoffe das mir jemand mit diesen ganzen Infos jezt helfen kann.
 
Hab das ISPCP auf einem Server drauf auf all meinen anderen habe ich ein eigens entwickeltes System installiert.

Wünsche dir noch viel erfolg bei deiner Problem lösung.

Gruß Frisch12
 
Toll, aber das bringt mir mal garnichts ich such jetzt seit 2 Wochen eine Lösung für mein Problem und du erzählst mir was von nem ContollInterface.
Also wenn jemand ne Idee hat bitte melden es ist wirklich wichtig!!!

Also ich bin auch für Alternativen zu MySQL offen!
 
Also ich denke eine Alternative zu MYSQL ist unnötig.
Zeig uns doch mal deine SQL-Tabelle. Bzw. Deine MySQL Einstellungen. Mach mal kurz das Log vom SQL an. Was läuft sonst noch auf dem SQL Server?
Soweit ich gesehen habe benutzt du die ganzen Module die geladen werden gar nicht. Ich würde nichts laden was nicht gebraucht wird. Hat aber nichts direkt mit deinem Problem zu tun.
 
Hier 1 Minute MySQL Log (proftpd) steht ganz am Ende. Das 1 Minuten lange Logfile ist im Anhang!
Code: 
100411 21:00:54	  883 Connect	proftpd@localhost on proftpd
		  883 Query	SELECT username, password, uid, gid, homedir, shell FROM ftp WHERE (username='cem') LIMIT 1
100411 21:01:10	  884 Connect	debian-sys-maint@localhost on 
		  884 Quit	
		  885 Connect	debian-sys-maint@localhost on 
		  885 Query	SHOW VARIABLES LIKE 'pid_file'
		  885 Shutdown

Mein MySQL config

Code: 
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
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

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0

[mysqld]
#
# * Basic Settings
#

#
# * IMPORTANT
#   If you make changes to these settings and your system uses apparmor, you may
#   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#

user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address		= 127.0.0.1
#
# * Fine Tuning
#
key_buffer		= 16M
max_allowed_packet	= 16M
thread_stack		= 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit	= 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#
# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#
# Here you can see queries with especially long duration
#log_slow_queries	= /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id		= 1
#log_bin			= /var/log/mysql/mysql-bin.log
expire_logs_days	= 10
max_binlog_size         = 100M
#binlog_do_db		= include_database_name
#binlog_ignore_db	= include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump]
quick
quote-names
max_allowed_packet	= 16M

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

[isamchk]
key_buffer		= 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

Und ja es laufen noch 3 Forum und 4 Websites auf dem MySQL-Server, alerdings kann ich das als Grund ausschließen da auf meinem Testserver wo nur ProFTPD installier ist das gleiche Problem auftritt!

Und überschüssige Module hab ich deaktiviert.

Probleme bleiben aber bestehen!
 

Attachments

Hast du bitte noch für die selbe Zeit einen Auszug aus der ProFTPD Log.

Wie viele Einträge sind in der MYSQL Tabelle? Könnte ich bitte ein SQLDUMP ohne Daten bekommen.
Lass bitte tuning-primer.sh durchlaufen.
 
Hallo,
füge deiner Config mal folgendes hinzu:
Code: 
SQLLOGFILE /var/log/proftpd/proftpd.sql.log
öder ähnlich.

Anschließend ProFTPD neustarten und nach dem Loginversuch in die Datei schauen.

Freundliche Grüße
flobbie
 
Code: 
SQLLOGFILE /var/log/proftpd/proftpd.sql.log
Click to expand...

Hier ist der Mitschnitt:
Code: 
Apr 12 14:45:56 mod_sql/4.2.2[3790]: defaulting to 'mysql' backend
Apr 12 14:45:56 mod_sql/4.2.2[3790]: backend module 'mod_sql_mysql/4.0.8'
Apr 12 14:45:56 mod_sql/4.2.2[3790]: backend api    'mod_sql_api_v1'
Apr 12 14:45:56 mod_sql/4.2.2[3790]: >>> sql_sess_init
Apr 12 14:45:56 mod_sql/4.2.2[3790]: entering 	mysql cmd_defineconnection
Apr 12 14:45:56 mod_sql/4.2.2[3790]:   name: 'default'
Apr 12 14:45:56 mod_sql/4.2.2[3790]:   user: 'proftpd'
Apr 12 14:45:56 mod_sql/4.2.2[3790]:   host: 'localhost'
Apr 12 14:45:56 mod_sql/4.2.2[3790]:     db: 'proftpd'
Apr 12 14:45:56 mod_sql/4.2.2[3790]:   port: '3306'
Apr 12 14:45:56 mod_sql/4.2.2[3790]:    ttl: '0'
Apr 12 14:45:56 mod_sql/4.2.2[3790]: exiting 	mysql cmd_defineconnection
Apr 12 14:45:56 mod_sql/4.2.2[3790]: entering 	mysql cmd_open
Apr 12 14:45:56 mod_sql/4.2.2[3790]: MySQL connection character set now 'latin1' (from 'ANSI_X3.4-1968')
Apr 12 14:45:56 mod_sql/4.2.2[3790]: connection 'default' opened
Apr 12 14:45:56 mod_sql/4.2.2[3790]: connection 'default' count is now 1
Apr 12 14:45:56 mod_sql/4.2.2[3790]: exiting 	mysql cmd_open
Apr 12 14:45:56 mod_sql/4.2.2[3790]: backend successfully connected.
Apr 12 14:45:56 mod_sql/4.2.2[3790]: mod_sql engine     : on
Apr 12 14:45:56 mod_sql/4.2.2[3790]: negative_cache     : off
Apr 12 14:45:56 mod_sql/4.2.2[3790]: authenticate       : users 
Apr 12 14:45:56 mod_sql/4.2.2[3790]: usertable          : ftp
Apr 12 14:45:56 mod_sql/4.2.2[3790]: userid field       : username
Apr 12 14:45:56 mod_sql/4.2.2[3790]: password field     : password
Apr 12 14:45:56 mod_sql/4.2.2[3790]: uid field          : uid
Apr 12 14:45:56 mod_sql/4.2.2[3790]: gid field          : gid
Apr 12 14:45:56 mod_sql/4.2.2[3790]: homedir field      : homedir
Apr 12 14:45:56 mod_sql/4.2.2[3790]: shell field        : shell
Apr 12 14:45:56 mod_sql/4.2.2[3790]: SQLMinUserUID      : 500
Apr 12 14:45:56 mod_sql/4.2.2[3790]: SQLMinUserGID      : 100
Apr 12 14:45:56 mod_sql/4.2.2[3790]: <<< sql_sess_init
Apr 12 14:45:56 mod_sql/4.2.2[3790]: >>> sql_pre_pass
Apr 12 14:45:56 mod_sql/4.2.2[3790]: <<< sql_pre_pass
Apr 12 14:45:56 mod_sql/4.2.2[3790]: >>> cmd_getpwnam
Apr 12 14:45:56 mod_sql/4.2.2[3790]: entering 	mysql cmd_escapestring
Apr 12 14:45:56 mod_sql/4.2.2[3790]: entering 	mysql cmd_open
Apr 12 14:45:56 mod_sql/4.2.2[3790]: connection 'default' count is now 2
Apr 12 14:45:56 mod_sql/4.2.2[3790]: exiting 	mysql cmd_open
Apr 12 14:45:56 mod_sql/4.2.2[3790]: exiting 	mysql cmd_escapestring
Apr 12 14:45:56 mod_sql/4.2.2[3790]: cache miss for user 'cem'
Apr 12 14:45:56 mod_sql/4.2.2[3790]: : entering 	mysql cmd_select
Apr 12 14:45:56 mod_sql/4.2.2[3790]: entering 	mysql cmd_open
Apr 12 14:45:56 mod_sql/4.2.2[3790]: connection 'default' count is now 3
Apr 12 14:45:56 mod_sql/4.2.2[3790]: exiting 	mysql cmd_open
Apr 12 14:45:56 mod_sql/4.2.2[3790]: query "SELECT username, password, uid, gid, homedir, shell FROM ftp WHERE (username='cem') LIMIT 1"
Apr 12 14:45:56 mod_sql/4.2.2[3790]: entering 	mysql cmd_close
Apr 12 14:45:56 mod_sql/4.2.2[3790]: connection 'default' count is now 2
Apr 12 14:45:56 mod_sql/4.2.2[3790]: exiting 	mysql cmd_close
Apr 12 14:45:56 mod_sql/4.2.2[3790]: exiting 	mysql cmd_select
Apr 12 14:45:56 mod_sql/4.2.2[3790]: NULL shell column value
Apr 12 14:45:56 mod_sql/4.2.2[3790]: cache miss for user 'cem'
Apr 12 14:45:56 mod_sql/4.2.2[3790]: user 'cem' cached
Apr 12 14:45:56 mod_sql/4.2.2[3790]: + pwd.pw_name  : cem
Apr 12 14:45:56 mod_sql/4.2.2[3790]: + pwd.pw_uid   : 65534
Apr 12 14:45:56 mod_sql/4.2.2[3790]: + pwd.pw_gid   : 65534
Apr 12 14:45:56 mod_sql/4.2.2[3790]: + pwd.pw_dir   : /var/ftp/cem
Apr 12 14:45:56 mod_sql/4.2.2[3790]: + pwd.pw_shell : (null)
Apr 12 14:45:56 mod_sql/4.2.2[3790]: <<< cmd_getpwnam
Apr 12 14:45:58 mod_sql/4.2.2[3790]: >>> cmd_auth
Apr 12 14:45:58 mod_sql/4.2.2[3790]: entering 	mysql cmd_escapestring
Apr 12 14:45:58 mod_sql/4.2.2[3790]: entering 	mysql cmd_open
Apr 12 14:45:58 mod_sql/4.2.2[3790]: connection 'default' count is now 3
Apr 12 14:45:58 mod_sql/4.2.2[3790]: exiting 	mysql cmd_open
Apr 12 14:45:58 mod_sql/4.2.2[3790]: exiting 	mysql cmd_escapestring
Apr 12 14:45:58 mod_sql/4.2.2[3790]: cache hit for user 'cem'
Apr 12 14:45:58 mod_sql/4.2.2[3790]: >>> cmd_check
Apr 12 14:45:58 mod_sql/4.2.2[3790]: checking SQLAuthType 'Crypt'
Apr 12 14:45:58 mod_sql/4.2.2[3790]: 'Crypt' auth handler reports success
Apr 12 14:45:58 mod_sql/4.2.2[3790]: cache hit for user 'cem'
Apr 12 14:45:58 mod_sql/4.2.2[3790]: <<< cmd_check
Apr 12 14:45:58 mod_sql/4.2.2[3790]: <<< cmd_auth
Apr 12 14:45:58 mod_sql/4.2.2[3790]: >>> cmd_getpwnam
Apr 12 14:45:58 mod_sql/4.2.2[3790]: cache hit for user 'cem'
Apr 12 14:45:58 mod_sql/4.2.2[3790]: <<< cmd_getpwnam
Apr 12 14:46:37 mod_sql/4.2.2[3790]: entering 	mysql cmd_exit
Apr 12 14:46:37 mod_sql/4.2.2[3790]: entering 	mysql cmd_close
Apr 12 14:46:37 mod_sql/4.2.2[3790]: connection 'default' closed
Apr 12 14:46:37 mod_sql/4.2.2[3790]: connection 'default' count is now 0
Apr 12 14:46:37 mod_sql/4.2.2[3790]: exiting 	mysql cmd_close
Apr 12 14:46:37 mod_sql/4.2.2[3790]: exiting 	mysql cmd_exit
Apr 12 14:58:52 mod_sql/4.2.2[3888]: defaulting to 'mysql' backend
Apr 12 14:58:52 mod_sql/4.2.2[3888]: backend module 'mod_sql_mysql/4.0.8'
Apr 12 14:58:52 mod_sql/4.2.2[3888]: backend api    'mod_sql_api_v1'
Apr 12 14:58:52 mod_sql/4.2.2[3888]: >>> sql_sess_init
Apr 12 14:58:52 mod_sql/4.2.2[3888]: entering 	mysql cmd_defineconnection
Apr 12 14:58:52 mod_sql/4.2.2[3888]:   name: 'default'
Apr 12 14:58:52 mod_sql/4.2.2[3888]:   user: 'proftpd'
Apr 12 14:58:52 mod_sql/4.2.2[3888]:   host: 'localhost'
Apr 12 14:58:52 mod_sql/4.2.2[3888]:     db: 'proftpd'
Apr 12 14:58:52 mod_sql/4.2.2[3888]:   port: '3306'
Apr 12 14:58:52 mod_sql/4.2.2[3888]:    ttl: '0'
Apr 12 14:58:52 mod_sql/4.2.2[3888]: exiting 	mysql cmd_defineconnection
Apr 12 14:58:52 mod_sql/4.2.2[3888]: entering 	mysql cmd_open
Apr 12 14:58:52 mod_sql/4.2.2[3888]: MySQL connection character set now 'latin1' (from 'ANSI_X3.4-1968')
Apr 12 14:58:52 mod_sql/4.2.2[3888]: connection 'default' opened
Apr 12 14:58:52 mod_sql/4.2.2[3888]: connection 'default' count is now 1
Apr 12 14:58:52 mod_sql/4.2.2[3888]: exiting 	mysql cmd_open
Apr 12 14:58:52 mod_sql/4.2.2[3888]: backend successfully connected.
Apr 12 14:58:52 mod_sql/4.2.2[3888]: mod_sql engine     : on
Apr 12 14:58:52 mod_sql/4.2.2[3888]: negative_cache     : off
Apr 12 14:58:52 mod_sql/4.2.2[3888]: authenticate       : users 
Apr 12 14:58:52 mod_sql/4.2.2[3888]: usertable          : ftp
Apr 12 14:58:52 mod_sql/4.2.2[3888]: userid field       : username
Apr 12 14:58:52 mod_sql/4.2.2[3888]: password field     : password
Apr 12 14:58:52 mod_sql/4.2.2[3888]: uid field          : uid
Apr 12 14:58:52 mod_sql/4.2.2[3888]: gid field          : gid
Apr 12 14:58:52 mod_sql/4.2.2[3888]: homedir field      : homedir
Apr 12 14:58:52 mod_sql/4.2.2[3888]: shell field        : shell
Apr 12 14:58:52 mod_sql/4.2.2[3888]: SQLMinUserUID      : 500
Apr 12 14:58:52 mod_sql/4.2.2[3888]: SQLMinUserGID      : 100
Apr 12 14:58:52 mod_sql/4.2.2[3888]: <<< sql_sess_init
Apr 12 14:58:52 mod_sql/4.2.2[3888]: >>> sql_pre_pass
Apr 12 14:58:52 mod_sql/4.2.2[3888]: <<< sql_pre_pass
Apr 12 14:58:52 mod_sql/4.2.2[3888]: >>> cmd_getpwnam
Apr 12 14:58:52 mod_sql/4.2.2[3888]: entering 	mysql cmd_escapestring
Apr 12 14:58:52 mod_sql/4.2.2[3888]: entering 	mysql cmd_open
Apr 12 14:58:52 mod_sql/4.2.2[3888]: connection 'default' count is now 2
Apr 12 14:58:52 mod_sql/4.2.2[3888]: exiting 	mysql cmd_open
Apr 12 14:58:52 mod_sql/4.2.2[3888]: exiting 	mysql cmd_escapestring
Apr 12 14:58:52 mod_sql/4.2.2[3888]: cache miss for user 'cem'
Apr 12 14:58:52 mod_sql/4.2.2[3888]: : entering 	mysql cmd_select
Apr 12 14:58:52 mod_sql/4.2.2[3888]: entering 	mysql cmd_open
Apr 12 14:58:52 mod_sql/4.2.2[3888]: connection 'default' count is now 3
Apr 12 14:58:52 mod_sql/4.2.2[3888]: exiting 	mysql cmd_open
Apr 12 14:58:52 mod_sql/4.2.2[3888]: query "SELECT username, password, uid, gid, homedir, shell FROM ftp WHERE (username='cem') LIMIT 1"
Apr 12 14:58:52 mod_sql/4.2.2[3888]: entering 	mysql cmd_close
Apr 12 14:58:52 mod_sql/4.2.2[3888]: connection 'default' count is now 2
Apr 12 14:58:52 mod_sql/4.2.2[3888]: exiting 	mysql cmd_close
Apr 12 14:58:52 mod_sql/4.2.2[3888]: exiting 	mysql cmd_select
Apr 12 14:58:52 mod_sql/4.2.2[3888]: NULL shell column value
Apr 12 14:58:52 mod_sql/4.2.2[3888]: cache miss for user 'cem'
Apr 12 14:58:52 mod_sql/4.2.2[3888]: user 'cem' cached
Apr 12 14:58:52 mod_sql/4.2.2[3888]: + pwd.pw_name  : cem
Apr 12 14:58:52 mod_sql/4.2.2[3888]: + pwd.pw_uid   : 65534
Apr 12 14:58:52 mod_sql/4.2.2[3888]: + pwd.pw_gid   : 65534
Apr 12 14:58:52 mod_sql/4.2.2[3888]: + pwd.pw_dir   : /var/ftp/cem
Apr 12 14:58:52 mod_sql/4.2.2[3888]: + pwd.pw_shell : (null)
Apr 12 14:58:52 mod_sql/4.2.2[3888]: <<< cmd_getpwnam
Apr 12 14:58:54 mod_sql/4.2.2[3888]: >>> cmd_auth
Apr 12 14:58:54 mod_sql/4.2.2[3888]: entering 	mysql cmd_escapestring
Apr 12 14:58:54 mod_sql/4.2.2[3888]: entering 	mysql cmd_open
Apr 12 14:58:54 mod_sql/4.2.2[3888]: connection 'default' count is now 3
Apr 12 14:58:54 mod_sql/4.2.2[3888]: exiting 	mysql cmd_open
Apr 12 14:58:54 mod_sql/4.2.2[3888]: exiting 	mysql cmd_escapestring
Apr 12 14:58:54 mod_sql/4.2.2[3888]: cache hit for user 'cem'
Apr 12 14:58:54 mod_sql/4.2.2[3888]: >>> cmd_check
Apr 12 14:58:54 mod_sql/4.2.2[3888]: checking SQLAuthType 'Crypt'
Apr 12 14:58:54 mod_sql/4.2.2[3888]: 'Crypt' auth handler reports success
Apr 12 14:58:54 mod_sql/4.2.2[3888]: cache hit for user 'cem'
Apr 12 14:58:54 mod_sql/4.2.2[3888]: <<< cmd_check
Apr 12 14:58:54 mod_sql/4.2.2[3888]: <<< cmd_auth
Apr 12 14:58:54 mod_sql/4.2.2[3888]: >>> cmd_getpwnam
Apr 12 14:58:54 mod_sql/4.2.2[3888]: cache hit for user 'cem'
Apr 12 14:58:54 mod_sql/4.2.2[3888]: <<< cmd_getpwnam
Apr 12 15:03:50 mod_sql/4.2.2[3888]: entering 	mysql cmd_exit
Apr 12 15:03:50 mod_sql/4.2.2[3888]: entering 	mysql cmd_close
Apr 12 15:03:50 mod_sql/4.2.2[3888]: connection 'default' closed
Apr 12 15:03:50 mod_sql/4.2.2[3888]: connection 'default' count is now 0
Apr 12 15:03:50 mod_sql/4.2.2[3888]: exiting 	mysql cmd_close
Apr 12 15:03:50 mod_sql/4.2.2[3888]: exiting 	mysql cmd_exit
 
Ah hab ich überlesen!

Der Dump:
Code: 
-- phpMyAdmin SQL Dump
-- version 3.2.2.1deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 15. April 2010 um 23:02
-- Server Version: 5.1.37
-- PHP-Version: 5.2.10-2ubuntu6.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `proftpd`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ftp`
--

CREATE TABLE IF NOT EXISTS `ftp` (
  `username` varchar(60) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  `gid` int(11) DEFAULT NULL,
  `password` varchar(30) DEFAULT NULL,
  `homedir` varchar(250) DEFAULT '/home/ftp',
  `count` int(11) DEFAULT NULL,
  `ui` bigint(20) NOT NULL AUTO_INCREMENT,
  `shell` varchar(60) DEFAULT NULL,
  `letzter_zugriff` datetime DEFAULT NULL,
  `zugang` char(1) DEFAULT NULL,
  PRIMARY KEY (`ui`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 PACK_KEYS=1 AUTO_INCREMENT=387 ;

tuning-primer.sh sagt nichts bzw. meldet keine Fehler

und der proFTPD log zur gleichen Zeit (ok ich habe es heute unter den gleichen Vorraussetzungen gemacht)

Code: 
Apr 15 23:11:59 alpha proftpd[7473] alpha (95.117.47.122[95.117.47.122]): FTP session opened.
Apr 15 23:12:01 alpha proftpd[7473] alpha (95.117.47.122[95.117.47.122]): Preparing to chroot to directory '/var/ftp/cem'
Apr 15 23:12:01 alpha proftpd[7473] alpha (95.117.47.122[95.117.47.122]): USER cem: Login successful.
Apr 15 23:12:08 alpha proftpd[7473] alpha (95.117.47.122[95.117.47.122]): FTP session closed.

Ich hoffe du kannst damit was anfangen!:)
 
Hi,
ich glaube es liegt weder am MySQL noch an ProFTPd.

Code: 
Apr 15 23:11:59 FTP session opened.
Apr 15 23:12:01 Preparing to chroot to directory '/var/ftp/cem'
Apr 15 23:12:01 USER cem: Login successful.
Apr 15 23:12:08 FTP session closed.
Laut diesen Log dauert der Login 2 Sekunden.

Laut dem SQL-Log welches du gepostet hat, dauert die Abfrage 1 Sekunde.

Hast du mal den Login von localhost probiert? Dauert es da genauso lange?
Hast du eine Firewall oder ähnliche Dienste laufen, die vielleicht die Ports überwachen?

Sonst poste doch mal kurz ein paar Logindaten, damit andere das testen können.

Freundliche Grüße
Flobbie
 
You must log in or register to reply here.
Back
Top