www.ProFTPD.de
13. März 2007, 22:03:01 *
Willkommen Gast. Bitte einloggen oder registrieren.
Haben Sie Ihre Aktivierungs E-Mail übersehen?

Einloggen mit Benutzername, Passwort und Sitzungslänge
News: SMF - Neu installiert!
 
   Übersicht   Hilfe Suche Login Registrieren  
Seiten: [1]   Nach unten
  Drucken  
Autor Thema: MySQL - Abbruch bei Datenverbindung  (Gelesen 270 mal)
0 Mitglieder und 1 Gast betrachten dieses Thema.
axel
Gast
« 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
Gespeichert
stonki
Administrator
ProFTPD
*****
Offline Offline

Beiträge: 1853


15318939
Profil anzeigen WWW E-Mail
« Antwort #1 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
Gespeichert

www.stonki.de:    the more I see, the more I know.......
www.proftpd.de:   Deutsche ProFTPD Dokumentation
www.krename.net:  Der Batch Renamer für KDE
www.kbarcode.net: Die Barcode Solution für KDE
axel
Gast
« Antwort #2 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:
Gespeichert
Anonymous
Gast
« Antwort #3 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...
Gespeichert
axel
Gast
« Antwort #4 am: 14. Februar 2005, 07:25:29 »

:?:
Gespeichert
Seiten: [1]   Nach oben
  Drucken  
 
Gehe zu:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC Prüfe XHTML 1.0 Prüfe CSS
Seite erstellt in 0.083 Sekunden mit 15 Zugriffen.