proftpd # cat proftpd.conf
# This is a basic ProFTPD configuration file (rename it to
# 'proftpd.conf' for actual use.  It establishes a single server
# and a single anonymous login.  It assumes that you have a user/group
# "nobody" and "ftp" for normal operation and anon.

ServerName      "ProFTPD"
ServerType      standalone
DefaultServer     on


#
# Logging options
#
TransferLog                     /var/log/proftpd/xferlog
SystemLog                       /var/log/proftpd/ftplog

# 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

# Port 21 is the standard FTP port.
Port    21

# Umask 022 is a good standard umask to prevent new dirs and files
# 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

# Set the user and group under which the server will run.
User    proftpd
Group    proftpd

AllowRetrieveRestart            on
AllowStoreRestart               on

TransferRate RETR               8

MaxInstances                    10
MaxClients                      10
MaxClientsPerHost               2

# Normally, we want files to be overwriteable.
<Directory /home/ftp/>
    HiddenStor    off
    HideNoAccess     off
    AllowOverwrite              off
    AllowRetrieveRestart        on
    AllowStoreRestart           on
</Directory>

DefaultRoot     ~ !users

<Limit LOGIN>
  Order        deny,allow
  AllowGroup      portal
  AllowGroup      system
</Limit>

SQLConnectInfo              proftpd@127.0.0.1 ********* ********
SQLAuthenticate             users groups
SQLAuthTypes                Crypt Backend
SQLHomedirOnDemand      on
SQLDefaultHomedir           /home/ftp
SQLUserInfo                 users userid passwd uid gid homedir shell
SQLGroupInfo                groups groupid gid members

SqlLogFile      /var/log/proftpd/sql_log

SQLLog                      PASS logincount
SQLNamedQuery               logincount UPDATE "login_count=login_count+1 WHERE userid='%u'" users
SQLLog                      PASS lastlogin
SQLNamedQuery               lastlogin UPDATE "last_login=now() WHERE userid='%u'" users
SQLLog RETR                 dlbytescount
SQLNamedQuery               dlbytescount UPDATE "dl_bytes=dl_bytes+%b WHERE userid='%u'" users
SQLLog RETR             dlcount
SQLNamedQuery               dlcount UPDATE "dl_count=dl_count+1 WHERE userid='%u'" users
SQLLog STOR                 ulbytescount
SQLNamedQuery               ulbytescount UPDATE "ul_bytes=ul_bytes+%b WHERE userid='%u'" users
SQLLog STOR                 ulcount
SQLNamedQuery               ulcount UPDATE "ul_count=ul_count+1 WHERE userid='%u'" users
RequireValidShell           off

SQLUserWhereClause          "disabled!=1 and (NOW()<=expires or expires=-1)"

# wget -c --passive-ftp "ftp://******:******@192.168.2.29/******/*File*"
--11:02:00--  ftp://******:*password*@192.168.2.29/******/*File*
           => `*File*'
Verbindungsaufbau zu 192.168.2.29:21... verbunden.
Anmelden als lo4dro ... Angemeldet!
==> SYST ... fertig.    ==> PWD ... fertig.
==> TYPE I ... fertig.  ==> CWD /****** ... fertig.
==> SIZE *File* ... fertig.
==> PASV ... fertig.    ==> REST 32768 ...
REST schlug fehl; »*File*« wird nicht abgeschnitten.