##
## 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>
|