www.ProFTPD.de

Jul 30 19:56:28 mod_sql/4.10[19937]: backend module 'mod_sql_mysql/4.04'
Jul 30 19:56:28 mod_sql/4.10[19937]: backend api    'mod_sql_api_v1'
Jul 30 19:56:28 mod_sql/4.10[19937]: >>> sql_getconf
Jul 30 19:56:28 mod_sql/4.10[19937]: entering   mysql cmd_defineconnection
Jul 30 19:56:28 mod_sql/4.10[19937]:  name: 'default'
Jul 30 19:56:28 mod_sql/4.10[19937]:  user: 'root'
Jul 30 19:56:28 mod_sql/4.10[19937]:  host: 'localhost'
Jul 30 19:56:28 mod_sql/4.10[19937]:    db: 'webspace'
Jul 30 19:56:28 mod_sql/4.10[19937]:  port: '3306'
Jul 30 19:56:28 mod_sql/4.10[19937]:   ttl: '0'
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting    mysql cmd_defineconnection
Jul 30 19:56:28 mod_sql/4.10[19937]: entering   mysql cmd_open
Jul 30 19:56:28 mod_sql/4.10[19937]: connection 'default' opened
Jul 30 19:56:28 mod_sql/4.10[19937]: connection 'default' count is now 1
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting    mysql cmd_open
Jul 30 19:56:28 mod_sql/4.10[19937]: backend successfully connected.
Jul 30 19:56:28 mod_sql/4.10[19937]: mod_sql status     : on
Jul 30 19:56:28 mod_sql/4.10[19937]: negative_cache     : off
Jul 30 19:56:28 mod_sql/4.10[19937]: authenticate       : users
Jul 30 19:56:28 mod_sql/4.10[19937]: usertable          : users
Jul 30 19:56:28 mod_sql/4.10[19937]: userid field       : userid
Jul 30 19:56:28 mod_sql/4.10[19937]: password field     : passwd
Jul 30 19:56:28 mod_sql/4.10[19937]: uid field          : uid
Jul 30 19:56:28 mod_sql/4.10[19937]: gid field          : gid
Jul 30 19:56:28 mod_sql/4.10[19937]: homedir field      : homedir
Jul 30 19:56:28 mod_sql/4.10[19937]: shell field        : shell
Jul 30 19:56:28 mod_sql/4.10[19937]: homedirondemand    : false
Jul 30 19:56:28 mod_sql/4.10[19937]: SQLMinUserUID      : 500
Jul 30 19:56:28 mod_sql/4.10[19937]: SQLMinUserGID      : 100
Jul 30 19:56:28 mod_sql/4.10[19937]: <<< sql_getconf
Jul 30 19:56:28 mod_sql/4.10[19937]: >>> cmd_getpwnam
Jul 30 19:56:28 mod_sql/4.10[19937]: entering   mysql cmd_escapestring
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting    mysql cmd_escapestring
Jul 30 19:56:28 mod_sql/4.10[19937]: cache miss for user 'demo2'
Jul 30 19:56:28 mod_sql/4.10[19937]: >>> sql_lookup
Jul 30 19:56:28 mod_sql/4.10[19937]: >>> _process_named_query
Jul 30 19:56:28 mod_sql/4.10[19937]: entering   mysql cmd_escapestring
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting    mysql cmd_escapestring
Jul 30 19:56:28 mod_sql/4.10[19937]: entering   mysql cmd_query
Jul 30 19:56:28 mod_sql/4.10[19937]: entering   mysql cmd_open
Jul 30 19:56:28 mod_sql/4.10[19937]: connection 'default' count is now 2
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting    mysql cmd_open
Jul 30 19:56:28 mod_sql/4.10[19937]: query "SELECT kunden.username, kunden.password as passwd, kunden.uid, kunden.gid, kunden.homedir, kunden.shell FROM kunden left join traffic on traffic.user = kunden.id WHERE kunden.username = 'demo2' and traffic <= (traffic_limit*(1024*1024)) and kunden.online = 1 and kunden.ftp = 1"
Jul 30 19:56:28 mod_sql/4.10[19937]: entering   mysql cmd_close
Jul 30 19:56:28 mod_sql/4.10[19937]: connection 'default' count is now 1
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting    mysql cmd_close
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting    mysql cmd_query
Jul 30 19:56:28 mod_sql/4.10[19937]: <<< _process_named_query
Jul 30 19:56:28 mod_sql/4.10[19937]: <<< sql_lookup
Jul 30 19:56:28 mod_sql/4.10[19937]: cache miss for user 'demo2'
Jul 30 19:56:28 mod_sql/4.10[19937]: user 'demo2' cached
Jul 30 19:56:28 mod_sql/4.10[19937]: + pwd.pw_name  : demo2
Jul 30 19:56:28 mod_sql/4.10[19937]: + pwd.pw_uid   : 65534
Jul 30 19:56:28 mod_sql/4.10[19937]: + pwd.pw_gid   : 65534
Jul 30 19:56:28 mod_sql/4.10[19937]: + pwd.pw_dir   : /srv/www/htdocs/demo2
Jul 30 19:56:28 mod_sql/4.10[19937]: + pwd.pw_shell : /bin/false
Jul 30 19:56:28 mod_sql/4.10[19937]: <<< cmd_getpwnam
Jul 30 19:56:28 mod_sql/4.10[19937]: >>> cmd_auth
Jul 30 19:56:28 mod_sql/4.10[19937]: entering   mysql cmd_escapestring
Jul 30 19:56:28 mod_sql/4.10[19937]: exiting    mysql cmd_escapestring
Jul 30 19:56:28 mod_sql/4.10[19937]: cache hit for user 'demo2'
Jul 30 19:56:28 mod_sql/4.10[19937]: >>> cmd_check
Jul 30 19:56:28 mod_sql/4.10[19937]: checking auth_type Plaintext
Jul 30 19:56:28 mod_sql/4.10[19937]: 'Plaintext' auth handler reports success
Jul 30 19:56:28 mod_sql/4.10[19937]: cache hit for user 'demo2'
Jul 30 19:56:28 mod_sql/4.10[19937]: <<< cmd_check
Jul 30 19:56:28 mod_sql/4.10[19937]: <<< cmd_auth
Jul 30 19:56:28 mod_sql/4.10[19937]: >>> cmd_getpwnam
Jul 30 19:56:28 mod_sql/4.10[19937]: cache hit for user 'demo2'
Jul 30 19:56:28 mod_sql/4.10[19937]: <<< cmd_getpwnam

# 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 FTP Server"
ServerType          standalone
DefaultServer       on
RequireValidShell   off
#AuthPAM             off
#AuthPAMConfig       ftp
SystemLog                /var/log/proftpd
#SyslogLevel             debug


# 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            nobody
Group            nogroup

RootLogin Off

# Normally, we want files to be overwriteable.
<Directory />
  AllowOverwrite      on
</Directory>

# A basic anonymous configuration, no upload directories.
<Global>
    DefaultRoot /
</Global>

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

SQLLogFile /var/log/proftpd.sql.log

SQLAuthenticate users
SQLUserInfo custom:/login
SQLAuthTypes Plaintext
SQLConnectInfo webspace@localhost root xxxxx
SQLMinUserGID 100
SQLMinUserUID 500
SQLDefaultUserGID 65534
SQLDefaultUserUID 65534

SQLNamedQuery login FREEFORM "SELECT kunden.username, kunden.password as passwd, kunden.uid, kunden.gid, kunden.homedir, kunden.shell FROM kunden left join traffic on traffic.user = kunden.id WHERE kunden.username = '%U' and traffic <= (traffic_limit*(1024*1024)) and kunden.online = 1 and kunden.ftp = 1"

DefaultRoot   ~