www.ProFTPD.de

Apr 27 04:30:01 mod_sql/4.11[27022]: backend module 'mod_sql_mysql/4.04'
Apr 27 04:30:01 mod_sql/4.11[27022]: backend api    'mod_sql_api_v1'
Apr 27 04:30:01 mod_sql/4.11[27022]: >>> sql_getconf
Apr 27 04:30:01 mod_sql/4.11[27022]: entering   mysql cmd_defineconnection
Apr 27 04:30:01 mod_sql/4.11[27022]:  name: 'default'
Apr 27 04:30:01 mod_sql/4.11[27022]:  user: 'proftpd'
Apr 27 04:30:01 mod_sql/4.11[27022]:  host: 'localhost'
Apr 27 04:30:01 mod_sql/4.11[27022]:    db: 'proftpd_admin'
Apr 27 04:30:01 mod_sql/4.11[27022]:  port: '3306'
Apr 27 04:30:01 mod_sql/4.11[27022]:   ttl: '0'
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting    mysql cmd_defineconnection
Apr 27 04:30:01 mod_sql/4.11[27022]: entering   mysql cmd_open
Apr 27 04:30:01 mod_sql/4.11[27022]: connection 'default' opened
Apr 27 04:30:01 mod_sql/4.11[27022]: connection 'default' count is now 1
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting    mysql cmd_open
Apr 27 04:30:01 mod_sql/4.11[27022]: backend successfully connected.
Apr 27 04:30:01 mod_sql/4.11[27022]: mod_sql status     : on
Apr 27 04:30:01 mod_sql/4.11[27022]: negative_cache     : off
Apr 27 04:30:01 mod_sql/4.11[27022]: authenticate       : users
Apr 27 04:30:01 mod_sql/4.11[27022]: usertable          : usertable
Apr 27 04:30:01 mod_sql/4.11[27022]: userid field       : userid
Apr 27 04:30:01 mod_sql/4.11[27022]: password field     : passwd
Apr 27 04:30:01 mod_sql/4.11[27022]: uid field          : uid
Apr 27 04:30:01 mod_sql/4.11[27022]: gid field          : gid
Apr 27 04:30:01 mod_sql/4.11[27022]: homedir field      : homedir
Apr 27 04:30:01 mod_sql/4.11[27022]: shell field        : shell
Apr 27 04:30:01 mod_sql/4.11[27022]: homedirondemand    : false
Apr 27 04:30:01 mod_sql/4.11[27022]: SQLMinUserUID      : 999
Apr 27 04:30:01 mod_sql/4.11[27022]: SQLMinUserGID      : 999
Apr 27 04:30:01 mod_sql/4.11[27022]: <<< sql_getconf
Apr 27 04:30:01 mod_sql/4.11[27022]: >>> cmd_getpwnam
Apr 27 04:30:01 mod_sql/4.11[27022]: entering   mysql cmd_escapestring
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting    mysql cmd_escapestring
Apr 27 04:30:01 mod_sql/4.11[27022]: cache miss for user 'www'
Apr 27 04:30:01 mod_sql/4.11[27022]: : entering         mysql cmd_select
Apr 27 04:30:01 mod_sql/4.11[27022]: entering   mysql cmd_open
Apr 27 04:30:01 mod_sql/4.11[27022]: connection 'default' count is now 2
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting    mysql cmd_open
Apr 27 04:30:01 mod_sql/4.11[27022]: query "SELECT userid, passwd, uid, gid, homedir, shell FROM usertable WHERE (userid='www') and ((disabled=0 and (NOW()<=expiration or expiration=-1))) LIMIT 1"
Apr 27 04:30:01 mod_sql/4.11[27022]: entering   mysql cmd_close
Apr 27 04:30:01 mod_sql/4.11[27022]: connection 'default' count is now 1
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting    mysql cmd_close
Apr 27 04:30:01 mod_sql/4.11[27022]: exiting    mysql cmd_select
Apr 27 04:30:01 mod_sql/4.11[27022]: <<< cmd_getpwnam
Apr 27 04:30:02 mod_sql/4.11[27022]: entering   mysql cmd_close
Apr 27 04:30:02 mod_sql/4.11[27022]: connection 'default' closed
Apr 27 04:30:02 mod_sql/4.11[27022]: connection 'default' count is now 0
Apr 27 04:30:02 mod_sql/4.11[27022]: exiting    mysql cmd_close
Apr 27 04:30:02 mod_sql/4.11[27022]: running named query 'time_logout' at exit
Apr 27 04:30:02 mod_sql/4.11[27022]: >>> _process_named_query
Apr 27 04:30:02 mod_sql/4.11[27022]: entering   mysql cmd_escapestring

ExtendedLog                     /var/log/proftpd.access_log    WRITE,READ write
ExtendedLog                     /var/log/proftpd.auth_log      AUTH auth
ExtendedLog                     /var/log/proftpd.paranoid_log  ALL default
SQLLogFile                      /var/log/proftpd.mysql

SQLAuthTypes                    Plaintext Backend Empty
SQLAuthenticate                 users*
SQLConnectInfo                  proftpd_admin@localhost proftpd *********
SQLUserInfo                     usertable userid passwd uid gid homedir shell
SQLGroupInfo                    grouptable groupname gid members
SQLUserWhereClause              "disabled=0 and (NOW()<=expiration or expiration=-1)"

# Log the user logging in
SQLLog PASS counter
SQLNamedQuery counter UPDATE "lastlogin=now(), count=count+1 WHERE userid='%u'" usertable

# logout log
SQLLog EXIT time_logout
SQLNamedQuery time_logout UPDATE "lastlogout=now() WHERE userid='%u'" usertable

# display last login time when PASS command is given
SQLNamedQuery login_time SELECT "lastlogin from usertable where userid='%u'"
SQLShowInfo PASS "230" "Last login was: %{login_time}"

# xfer Log in mysql
SQLLog RETR,STOR transfer1
SQLNamedQuery  transfer1 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'c', NULL"
xfer_stat
SQLLOG ERR_RETR,ERR_STOR transfer2
SQLNamedQuery  transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'i', NULL"
SQLNamedQuery  transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'i', NULL"
xfer_stat

AllowStoreRestart                       on
AllowRetrieveRestart                    on
RequireValidShell                       off
PathDenyFilter                          "(\.ftp)|(\.ht)[a-z]+$"
DefaultRoot                             ~
DenyFilter                              \*.*/


<Directory /ftp/*>
        AllowOverwrite                  off
        HideNoAccess                    on
        <Limit READ>
                AllowAll
        </Limit>

        <Limit WRITE>
                DenyGroup               !admins
        </Limit>
</Directory>

<Directory /ftp/incoming/*>
        AllowOverwrite                  on
        HideNoAccess                    on

        <Limit READ>
                DenyGroup               !admins
        </Limit>