|
Titel: MySQL - Abbruch bei Datenverbindung Beitrag von: axel am 05. Februar 2005, 17:22:57 Hi!
Ich versuche ProFTPD in der 1.2.10 unter Debian mit MySQL im Backend einzurichten. Er connected auch, allerdings hängt sich die Verbindung dann auf. Aufbau der Tabellen: Code: CREATE TABLE `ftp_groups` ( `pn_groupid` varchar(10) NOT NULL default '', `pn_gid` int(10) unsigned NOT NULL auto_increment, `pn_members` varchar(255) NOT NULL default '', PRIMARY KEY (`pn_gid`) ) TYPE=MyISAM AUTO_INCREMENT=1235 ; CREATE TABLE `ftp_quotatallies` ( `pn_name` varchar(30) NOT NULL default '', `pn_quota_type` enum('user','group','class','all') NOT NULL default 'user', `pn_bytes_in_used` float NOT NULL default '0', `pn_bytes_out_used` float NOT NULL default '0', `pn_bytes_xfer_used` float NOT NULL default '0', `pn_files_in_used` int(10) unsigned NOT NULL default '0', `pn_files_out_used` int(10) unsigned NOT NULL default '0', `pn_files_xfer_used` int(10) unsigned NOT NULL default '0' ) TYPE=MyISAM; CREATE TABLE `ftp_users` ( `pn_name` varchar(30) NOT NULL default '', `pn_passwd` varchar(80) NOT NULL default '', `pn_uid` int(11) default NULL, `pn_gid` int(11) default NULL, `pn_homedir` varchar(255) default NULL, `pn_count` int(11) NOT NULL default '0', `pn_per_session` enum('false','true') NOT NULL default 'false', `pn_limit_type` enum('soft','hard') NOT NULL default 'hard', `pn_bytes_in_avail` float NOT NULL default '0', `pn_bytes_out_avail` float NOT NULL default '0', `pn_bytes_xfer_avail` float NOT NULL default '0', `pn_files_in_avail` int(10) unsigned NOT NULL default '0', `pn_files_out_avail` int(10) unsigned NOT NULL default '0', `pn_files_xfer_avail` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`pn_name`) ) TYPE=MyISAM; Konfig: Code: # # /etc/proftpd.conf -- This is a basic ProFTPD configuration file. # To really apply changes reload proftpd after modifications. # ServerName "MeinServer" ServerType standalone ServerAdmin webmaster@meinserver.de ServerIdent on "ftp.meinserver.de" DeferWelcome on DefaultServer on Port 21 # Umask 022 is a good standard umask to prevent new files and dirs # (second parm) from being group and world writable. Umask 022 # To prevent DoS attacks, set the maximum number of child processes # to 30. If you need to allow more than 30 concurrent connections # at once, simply increase this value. Note that this ONLY works # in standalone mode, in inetd mode you should use an inetd server # that allows you to limit maximum number of processes per service # (such as xinetd) MaxInstances 30 <Directory /> AllowOverwrite on </Directory> #FXP Unterstuetzung AllowForeignAddress on # Maximal-Werte setzen MaxClientsPerHost 2 "Nicht mehr als %m Verbindungen" MaxClients 8 "Leider sind schon %m Clients verbunden" MaxLoginAttempts 3 # Restart erlauben AllowStoreRestart on AllowRetrieveRestart on # Jail all users into their virtual home dir DefaultRoot ~ RequireValidShell off # Logging options TransferLog /var/log/proftpd.xferlog # Some logging formats LogFormat default "%h %l %u %t \"%r\" %s %b" LogFormat auth "%v [%P] %h %t \"%r\" %s" LogFormat write "%h %l %u %t \"%r\" %s %b" # Log file/dir access ExtendedLog /var/log/proftpd.access_log WRITE,READ write # Record all logins ExtendedLog /var/log/proftpd.auth_log AUTH auth # Paranoia logging level.... ExtendedLog /var/log/proftpd.paranoid_log ALL default MultilineRFC2228 on ShowSymlinks on TimeoutNoTransfer 600 TimeoutStalled 600 TimeoutIdle 1200 DisplayLogin proftpd-welcome.msg DisplayFirstChdir .message ListOptions "-l" DenyFilter \*.*/ # Uncomment this if you would use TLS module: #TLSEngine on # Set the user and group that the server normally runs at. User nobody Group nogroup # Delay engine reduces impact of the so-called Timing Attack described in # http://security.lss.hr/index.php?page=details&ID=LSS-2004-10-02 # It is on by default. #DelayEngine off IdentLookups off RootLogin off <Limit LOGIN> Order deny,allow AllowGroup ftptest </Limit> # Mysql Zugangskontrolle SQLConnectInfo db@localhost db sdjf7Fbj274FFkfy8D SQLAuthenticate users groups SQLAuthTypes Crypt SQLDefaultGID 65534 SQLDefaultUID 65534 SQLMinUserGID 1000 SQLMinUserUID 1000 SQLUserInfo ftp_users pn_name pn_passwd pn_uid pn_gid pn_homedir null SQLGroupInfo ftp_groups pn_groupid pn_gid pn_members SQLDefaultHomeDir /tmp SQLLog PASS updatecount SQLNamedQuery updatecount UPDATE "pn_count=pn_count+1 WHERE name='%u'" ftp_users SQLLogFile /var/log/proftpd.sql.log QuotaEngine on QuotaDirectoryTally on QuotaDisplayUnits Kb QuotaShowQuotas on SQLNamedQuery get-quota-limit \ SELECT "pn_name, 'pn_user', pn_per_session, pn_limit_type, pn_bytes_in_avail, \ pn_bytes_out_avail, pn_bytes_xfer_avail, pn_files_in_avail, pn_files_out_avail, \ pn_files_xfer_avail \ FROM ftp_users \ WHERE pn_name = '%{0}' AND 'pn_user' = '%{1}'" SQLNamedQuery get-quota-tally \ SELECT "pn_name, pn_quota_type, pn_bytes_in_used, pn_bytes_out_used, \ pn_bytes_xfer_used, pn_files_in_used, pn_files_out_used, pn_files_xfer_used \ FROM ftp_quotatallies \ WHERE pn_name = '%{0}' AND pn_quota_type = '%{1}'" SQLNamedQuery update-quota-tally \ UPDATE "pn_bytes_in_used = pn_bytes_in_used + %{0}, \ pn_bytes_out = pn_bytes_out_used + %{1}, pn_bytes_xfer_used = pn_bytes_xfer_used + %{2}, \ pn_files_in_used = pn_files_in_used + %{3}, pn_files_out_used = pn_files_out_used + %{4}, \ pn_files_xfer_used = pn_files_xfer_used + %{5} \ WHERE pn_name = '%{6}' AND pn_quota_type = '%{7}'" ftp_quotatallies SQLNamedQuery insert-quota-tally \ INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" ftp_quotatallies QuotaLimitTable sql:/get-quota-limit QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally Log: Code: Feb 05 17:06:16 mod_sql/4.11[12474]: backend module 'mod_sql_mysql/4.04' Feb 05 17:06:16 mod_sql/4.11[12474]: backend api 'mod_sql_api_v1' Feb 05 17:06:16 mod_sql/4.11[12474]: >>> sql_getconf Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_defineconnection Feb 05 17:06:16 mod_sql/4.11[12474]: name: 'default' Feb 05 17:06:16 mod_sql/4.11[12474]: user: 'db' Feb 05 17:06:16 mod_sql/4.11[12474]: host: 'localhost' Feb 05 17:06:16 mod_sql/4.11[12474]: db: 'db' Feb 05 17:06:16 mod_sql/4.11[12474]: port: '3306' Feb 05 17:06:16 mod_sql/4.11[12474]: ttl: '0' Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_defineconnection Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' opened Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 1 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: backend successfully connected. Feb 05 17:06:16 mod_sql/4.11[12474]: mod_sql status : on Feb 05 17:06:16 mod_sql/4.11[12474]: negative_cache : off Feb 05 17:06:16 mod_sql/4.11[12474]: authenticate : users groups Feb 05 17:06:16 mod_sql/4.11[12474]: usertable : ftp_users Feb 05 17:06:16 mod_sql/4.11[12474]: userid field : pn_name Feb 05 17:06:16 mod_sql/4.11[12474]: password field : pn_passwd Feb 05 17:06:16 mod_sql/4.11[12474]: uid field : pn_uid Feb 05 17:06:16 mod_sql/4.11[12474]: gid field : pn_gid Feb 05 17:06:16 mod_sql/4.11[12474]: homedir field : pn_homedir Feb 05 17:06:16 mod_sql/4.11[12474]: homedir(default) : '/tmp' Feb 05 17:06:16 mod_sql/4.11[12474]: shell field : NULL Feb 05 17:06:16 mod_sql/4.11[12474]: homedirondemand : false Feb 05 17:06:16 mod_sql/4.11[12474]: group table : ftp_groups Feb 05 17:06:16 mod_sql/4.11[12474]: groupname field : pn_groupid Feb 05 17:06:16 mod_sql/4.11[12474]: grp gid field : pn_gid Feb 05 17:06:16 mod_sql/4.11[12474]: grp members field : pn_members Feb 05 17:06:16 mod_sql/4.11[12474]: SQLMinUserUID : 1000 Feb 05 17:06:16 mod_sql/4.11[12474]: SQLMinUserGID : 1000 Feb 05 17:06:16 mod_sql/4.11[12474]: SQLDefaultUID : 65534 Feb 05 17:06:16 mod_sql/4.11[12474]: SQLDefaultGID : 65534 Feb 05 17:06:16 mod_sql/4.11[12474]: <<< sql_getconf Feb 05 17:06:16 mod_sql/4.11[12474]: >>> cmd_getgroups Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_escapestring Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_escapestring Feb 05 17:06:16 mod_sql/4.11[12474]: cache miss for user 'testuser' Feb 05 17:06:16 mod_sql/4.11[12474]: : entering mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 2 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: query "SELECT pn_name, pn_passwd, pn_uid, pn_gid, pn_homedir FROM ftp_users WHERE (pn_nam e='testuser') LIMIT 1" Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 1 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: cache miss for user 'testuser' Feb 05 17:06:16 mod_sql/4.11[12474]: user 'testuser' cached Feb 05 17:06:16 mod_sql/4.11[12474]: + pwd.pw_name : testuser Feb 05 17:06:16 mod_sql/4.11[12474]: + pwd.pw_uid : 1234 Feb 05 17:06:16 mod_sql/4.11[12474]: + pwd.pw_gid : 1234 Feb 05 17:06:16 mod_sql/4.11[12474]: + pwd.pw_dir : /home/testuser Feb 05 17:06:16 mod_sql/4.11[12474]: + pwd.pw_shell : Feb 05 17:06:16 mod_sql/4.11[12474]: cache miss for gid '1234' Feb 05 17:06:16 mod_sql/4.11[12474]: : entering mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 2 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: query "SELECT pn_groupid FROM ftp_groups WHERE (pn_gid = 1234) LIMIT 1" Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 1 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: : entering mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 2 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: query "SELECT pn_groupid, pn_gid, pn_members FROM ftp_groups WHERE (pn_groupid = 'ftptest ')" Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 1 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: cache miss for group 'ftptest' Feb 05 17:06:16 mod_sql/4.11[12474]: group 'ftptest' cached Feb 05 17:06:16 mod_sql/4.11[12474]: + grp.gr_name : ftptest Feb 05 17:06:16 mod_sql/4.11[12474]: + grp.gr_gid : 1234 Feb 05 17:06:16 mod_sql/4.11[12474]: + grp.gr_mem : testuser Feb 05 17:06:16 mod_sql/4.11[12474]: : entering mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 2 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: query "SELECT pn_groupid, pn_gid, pn_members FROM ftp_groups WHERE (pn_members = 'aguckel s' OR pn_members LIKE 'testuser,%' OR pn_members LIKE '%,testuser' OR pn_members LIKE '%,testuser,%')" Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 1 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: cache hit for group 'ftptest' Feb 05 17:06:16 mod_sql/4.11[12474]: <<< cmd_getgroups Feb 05 17:06:16 mod_sql/4.11[12474]: >>> cmd_getgroups Feb 05 17:06:16 mod_sql/4.11[12474]: cache hit for user 'testuser' Feb 05 17:06:16 mod_sql/4.11[12474]: cache hit for group ftptest Feb 05 17:06:16 mod_sql/4.11[12474]: : entering mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 2 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: query "SELECT pn_groupid, pn_gid, pn_members FROM ftp_groups WHERE (pn_members = 'aguckel s' OR pn_members LIKE 'testuser,%' OR pn_members LIKE '%,testuser' OR pn_members LIKE '%,testuser,%')" Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 1 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: cache hit for group 'ftptest' Feb 05 17:06:16 mod_sql/4.11[12474]: <<< cmd_getgroups Feb 05 17:06:16 mod_sql/4.11[12474]: >>> cmd_getpwnam Feb 05 17:06:16 mod_sql/4.11[12474]: cache hit for user 'testuser' Feb 05 17:06:16 mod_sql/4.11[12474]: <<< cmd_getpwnam Feb 05 17:06:16 mod_sql/4.11[12474]: >>> cmd_gid2name Feb 05 17:06:16 mod_sql/4.11[12474]: cache hit for group ftptest Feb 05 17:06:16 mod_sql/4.11[12474]: <<< cmd_gid2name Feb 05 17:06:16 mod_sql/4.11[12474]: >>> cmd_auth Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_escapestring Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_escapestring Feb 05 17:06:16 mod_sql/4.11[12474]: cache hit for user 'testuser' Feb 05 17:06:16 mod_sql/4.11[12474]: >>> cmd_check Feb 05 17:06:16 mod_sql/4.11[12474]: checking auth_type Crypt Feb 05 17:06:16 mod_sql/4.11[12474]: 'Crypt' auth handler reports success Feb 05 17:06:16 mod_sql/4.11[12474]: cache hit for user 'testuser' Feb 05 17:06:16 mod_sql/4.11[12474]: <<< cmd_check Feb 05 17:06:16 mod_sql/4.11[12474]: <<< cmd_auth Feb 05 17:06:16 mod_sql/4.11[12474]: >>> cmd_getpwnam Feb 05 17:06:16 mod_sql/4.11[12474]: cache hit for user 'testuser' Feb 05 17:06:16 mod_sql/4.11[12474]: <<< cmd_getpwnam Feb 05 17:06:16 mod_sql/4.11[12474]: >>> sql_escapestr Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_escapestring Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_escapestring Feb 05 17:06:16 mod_sql/4.11[12474]: <<< sql_escapestr Feb 05 17:06:16 mod_sql/4.11[12474]: >>> sql_lookup Feb 05 17:06:16 mod_sql/4.11[12474]: >>> _process_named_query Feb 05 17:06:16 mod_sql/4.11[12474]: : entering mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 2 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: query "SELECT pn_name, 'pn_user', pn_per_session, pn_limit_type, pn_bytes_in_avail, p n_bytes_out_avail, pn_bytes_xfer_avail, pn_files_in_avail, pn_files_out_avail, pn_files_xfer_avail FROM ftp_users WHERE pn_name = 'testuser' AND 'pn_user' = 'user'" Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 1 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: <<< _process_named_query Feb 05 17:06:16 mod_sql/4.11[12474]: <<< sql_lookup Feb 05 17:06:16 mod_sql/4.11[12474]: >>> sql_escapestr Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_escapestring Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_escapestring Feb 05 17:06:16 mod_sql/4.11[12474]: <<< sql_escapestr Feb 05 17:06:16 mod_sql/4.11[12474]: >>> sql_lookup Feb 05 17:06:16 mod_sql/4.11[12474]: >>> _process_named_query Feb 05 17:06:16 mod_sql/4.11[12474]: : entering mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 2 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: query "SELECT pn_name, 'pn_user', pn_per_session, pn_limit_type, pn_bytes_in_avail, p n_bytes_out_avail, pn_bytes_xfer_avail, pn_files_in_avail, pn_files_out_avail, pn_files_xfer_avail FROM ftp_users WHERE pn_name = 'ftptest' AND 'pn_user' = 'group'" Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 1 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: <<< _process_named_query Feb 05 17:06:16 mod_sql/4.11[12474]: <<< sql_lookup Feb 05 17:06:16 mod_sql/4.11[12474]: >>> sql_lookup Feb 05 17:06:16 mod_sql/4.11[12474]: >>> _process_named_query Feb 05 17:06:16 mod_sql/4.11[12474]: : entering mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 2 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: query "SELECT pn_name, 'pn_user', pn_per_session, pn_limit_type, pn_bytes_in_avail, p n_bytes_out_avail, pn_bytes_xfer_avail, pn_files_in_avail, pn_files_out_avail, pn_files_xfer_avail FROM ftp_users WHERE pn_name = '' AND 'pn_user' = 'all'" Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 1 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_select Feb 05 17:06:16 mod_sql/4.11[12474]: <<< _process_named_query Feb 05 17:06:16 mod_sql/4.11[12474]: <<< sql_lookup Feb 05 17:06:16 mod_sql/4.11[12474]: >>> log_master Feb 05 17:06:16 mod_sql/4.11[12474]: >>> _process_named_query Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_escapestring Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_escapestring Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_update Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 2 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_open Feb 05 17:06:16 mod_sql/4.11[12474]: query "UPDATE ftp_users SET pn_count=pn_count+1 WHERE name='testuser'" Feb 05 17:06:16 mod_sql/4.11[12474]: entering mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: connection 'default' count is now 1 Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_close Feb 05 17:06:16 mod_sql/4.11[12474]: exiting mysql cmd_update Feb 05 17:06:16 mod_sql/4.11[12474]: <<< _process_named_query Feb 05 17:06:16 mod_sql/4.11[12474]: <<< log_master Debug: Code: localhost - ProFTPD 1.2.10 (stable) (built do mrt 22 18:28:32 CET 2001) standalone mode STARTUP localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - FTP session requested from unknown class localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - connected - local : 213.239.217.195:21 localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - connected - remote : 84.169.32.167:9623 localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - FTP session opened. localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'USER testuser' to mod_rewrite localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'USER testuser' to mod_tls localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'USER testuser' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'USER testuser' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'USER testuser' to mod_delay localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'USER testuser' to mod_auth localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching CMD command 'USER testuser' to mod_ratio localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching CMD command 'USER testuser' to mod_auth localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'USER testuser' to mod_sql localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'USER testuser' to mod_delay localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - mod_delay/0.4: delaying for 1318 usecs localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching LOG_CMD command 'USER testuser' to mod_sql localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching LOG_CMD command 'USER testuser' to mod_log localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_rewrite localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_tls localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_delay localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_radius localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching CMD command 'PASS (hidden)' to mod_auth localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - Config for Guite1: localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - Limit localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - Order localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - AllowGroup localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - / localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - AllowOverwrite localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - Umask localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - AllowForeignAddress localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - MaxClientsPerHost localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - MaxClients localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - AllowStoreRestart localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - AllowRetrieveRestart localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - RequireValidShell localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - TransferLog localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - ShowSymlinks localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - DisplayLogin localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - DisplayFirstChdir localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - ListOptions localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - DenyFilter localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - RootLogin localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLConnectInfo localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLAuthenticate localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLAuthTypes localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLDefaultGID localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLDefaultUID localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLMinUserGID localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLMinUserUID localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLLog_PASS localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLNamedQuery_updatecount localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLNamedQuery_get-quota-limit localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLNamedQuery_get-quota-tally localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLNamedQuery_update-quota-tally localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLNamedQuery_insert-quota-tally localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLLog_PASS localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - ServerIdent localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - DeferWelcome localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - DefaultServer localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - Umask localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - AllowForeignAddress localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - MaxClientsPerHost localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - MaxClients localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - MaxLoginAttempts localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - AllowStoreRestart localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - AllowRetrieveRestart localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - DefaultRoot localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - RequireValidShell localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - TransferLog localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - ExtendedLog localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - ExtendedLog localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - ExtendedLog localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - ShowSymlinks localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - TimeoutNoTransfer localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - TimeoutStalled localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - TimeoutIdle localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - DisplayLogin localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - DisplayFirstChdir localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - ListOptions localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - DenyFilter localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - UserID localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - UserName localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - GroupID localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - GroupName localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - IdentLookups localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - RootLogin localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLConnectInfo localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLAuthenticate localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLAuthTypes localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLDefaultGID localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLDefaultUID localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLMinUserGID localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLMinUserUID localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLUserTable localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLUsernameField localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLPasswordField localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLUidField localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLGidField localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLHomedirField localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLGroupTable localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLGroupnameField localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLGroupGIDField localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLGroupMembersField localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLDefaultHomedir localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLLog_PASS localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLNamedQuery_updatecount localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLLogFile localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - QuotaEngine localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - QuotaDirectoryTally localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - QuotaDisplayUnits localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - QuotaShowQuotas localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLNamedQuery_get-quota-limit localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLNamedQuery_get-quota-tally localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLNamedQuery_update-quota-tally localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - SQLNamedQuery_insert-quota-tally localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - QuotaLimitTable localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - QuotaTallyTable localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - CURRENT-CLIENTS localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - USER localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - USER testuser: Login successful. localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - Preparing to chroot() the environment, path = '/home/testuser' localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - Environment successfully chroot()ed. localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - in dir_check_full(): path = '/', fullpath = '/home/testuser/'. localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'PASS (hidden)' to mod_sql localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'PASS (hidden)' to mod_cap localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - mod_cap/1.0: capabilities '= cap_net_bind_service+ep' localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'PASS (hidden)' to mod_ifsession localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'PASS (hidden)' to mod_readme localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'PASS (hidden)' to mod_delay localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - mod_delay/0.4: delaying for 22342 usecs localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'PASS (hidden)' to mod_radius localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'PASS (hidden)' to mod_tls localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'PASS (hidden)' to mod_ratio localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'PASS (hidden)' to mod_quotatab localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'PASS (hidden)' to mod_log localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'PASS (hidden)' to mod_ls localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'PASS (hidden)' to mod_auth localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching LOG_CMD command 'PASS (hidden)' to mod_sql localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching LOG_CMD command 'PASS (hidden)' to mod_log localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching LOG_CMD command 'PASS (hidden)' to mod_ratio localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'SYST' to mod_rewrite localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'SYST' to mod_tls localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'SYST' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'SYST' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching CMD command 'SYST' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'SYST' to mod_sql localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching LOG_CMD command 'SYST' to mod_sql localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching LOG_CMD command 'SYST' to mod_log localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'FEAT' to mod_rewrite localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'FEAT' to mod_tls localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'FEAT' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'FEAT' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching CMD command 'FEAT' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'FEAT' to mod_sql localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching LOG_CMD command 'FEAT' to mod_sql localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching LOG_CMD command 'FEAT' to mod_log localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PWD' to mod_rewrite localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PWD' to mod_tls localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PWD' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PWD' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching CMD command 'PWD' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'PWD' to mod_sql localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching LOG_CMD command 'PWD' to mod_sql localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching LOG_CMD command 'PWD' to mod_log localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'TYPE A' to mod_rewrite localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'TYPE A' to mod_tls localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'TYPE A' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'TYPE A' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching CMD command 'TYPE A' to mod_xfer localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'TYPE A' to mod_sql localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching LOG_CMD command 'TYPE A' to mod_sql localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching LOG_CMD command 'TYPE A' to mod_log localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PORT 84,169,32,167,37,158' to mod_rewrite localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PORT 84,169,32,167,37,158' to mod_tls localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PORT 84,169,32,167,37,158' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'PORT 84,169,32,167,37,158' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching CMD command 'PORT 84,169,32,167,37,158' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching POST_CMD command 'PORT 84,169,32,167,37,158' to mod_sql localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching LOG_CMD command 'PORT 84,169,32,167,37,158' to mod_sql localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching LOG_CMD command 'PORT 84,169,32,167,37,158' to mod_log localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'LIST' to mod_rewrite localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'LIST' to mod_tls localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'LIST' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'LIST' to mod_core localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'LIST' to mod_ratio localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching CMD command 'LIST' to mod_ls Titel: MySQL - Abbruch bei Datenverbindung Beitrag von: stonki am 07. Februar 2005, 08:47:34 Danke für die vollständigen Infos. Also mod_sql klappt ja, ich würde sagen es liegt an der Firewall.
Server IP: localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - connected - local : 213.239.217.195:21 Client IP: localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - connected - remote : 84.169.32.167:9623 Dann wird ein Port aufgemacht: localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching xxx command 'PORT 84,169,32,167,37,158' to mod_xxxx localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'LIST' to mod_rewrite Dann soll gelistet werden. Nun wird als Port für den passiven Bereich 37*256+158 genommen, also 9630. Ist dieser offen ? Ansonsten sehe ich eine Menge Module, wie mod_tls. Schalte die zu Testzwecken mal alle aus. cu stonki Titel: MySQL - Abbruch bei Datenverbindung Beitrag von: axel am 08. Februar 2005, 10:19:59 Zitat von: "stonki" Danke für die vollständigen Infos. Also mod_sql klappt ja, ich würde sagen es liegt an der Firewall. Server IP: localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - connected - local : 213.239.217.195:21 Client IP: localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - connected - remote : 84.169.32.167:9623 Dann wird ein Port aufgemacht: localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching xxx command 'PORT 84,169,32,167,37,158' to mod_xxxx localhost (p54A920A7.dip0.t-ipconnect.de[84.169.32.167]) - dispatching PRE_CMD command 'LIST' to mod_rewrite Dann soll gelistet werden. Nun wird als Port für den passiven Bereich 37*256+158 genommen, also 9630. Ist dieser offen ? Ansonsten sehe ich eine Menge Module, wie mod_tls. Schalte die zu Testzwecken mal alle aus. cu stonki Bleibt denn dieser Port immer der gleiche? Abgesehen davon läuft iirc auf dem Server keine Firewall, höchstens im Netzwerk... Ehrlich gesagt weiss ich nicht, was ich tun muss um weiter zu kommen :roll: Titel: MySQL - Abbruch bei Datenverbindung Beitrag von: Anonymous am 08. Februar 2005, 17:04:14 Jetzt habe ich in einem neuen Versuch einen andern passiven Port erhalten (49504).
Meinst Du denn die Firewall bei mir daheim? Ich hab hier zwar nen Router, aber alle möglichen anderen FTP-Verbindungen klappen auch ohne Probleme... Titel: push Beitrag von: axel am 14. Februar 2005, 07:25:29 :?:
|