Username :   testdevel
User ID :  10001
Groups :  devel
Disabled :  No
 
Groupname :   devel
Members :   testdevel
Group ID :  10002
Description :  devel

lftp testdevel@server:~> ls
-rw-r--r--   1 testdevel (?)          1674 Apr 18 14:13 test.txt

server:/home/ftp/devel# ll
total 4
-rw-r--r--  1 10001 10002 1674 2005-04-18 14:13 test.txt

##
## SQL
##
 
SQLAuthTypes                    Backend
SQLAuthenticate                 users*
SQLConnectInfo                  USER@localhost proftpd PASSWORD
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" xfer_stat
 
 
RequireValidShell                       off
PathDenyFilter                          "(\.ftp)|(\.ht)[a-z]+$"
#DefaultRoot                            ~
DefaultRoot                             /home/ftp/
DenyFilter                              \*.*/
 
 
## HOME : repertoire /home/ftp
<Directory /home/ftp>
        AllowOverWrite                  off
        HideNoAccess                    off
        <Limit WRITE>
                DenyAll
        </Limit>
        <Limit READ>
                AllowAll
        </Limit>
</Directory>
<Directory /home/ftp/*/*>
        <Limit WRITE>
                AllowAll
        </Limit>
</Directory>
 
## groupe DEVEL
<Directory /home/ftp/devel>
        AllowOverWrite                  off
        HideNoAccess                    off
        <Limit WRITE>
                AllowGroup              devel
        </Limit>
        <Limit READ>
                AllowAll
        </Limit>
</Directory>