# Arquivo de configuração do proftpd: /etc/proftpd.conf
# Altere os locais que achar necessário de acordo com
# suas necessidades
#
#
#
ServerName      "Nome do Servidor"
ServerType      standalone
ServerIdent     on    "Servers identifying string"
DeferWelcome    on
DefaultServer   on

DisplayLogin    .welcome  # Textfile to display on login
DisplayConnect  .connect  # Textfile to display on connection
DisplayFirstChdir   .firstchdir  # Textfile to display on first changedir

UseReverseDNS   off
IdentLookups    off

Port            21
Umask           022
MaxInstances      15
MaxClientsPerHost 3    # Somente %m Conexões por host são permitidas
MaxClients        10   # Somente %m Conexões simultâneas são permitidas
MaxHostsPerUser   1

User              nobody
Group             nobody

ScoreboardFile    /var/log/scoreboard

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

# Define log-files to use
TransferLog     /var/log/proftpd.xferlog
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

# Set up authentication via SQL
# ===========
AuthOrder       mod_sql.c
SQLAuthTypes    Backend
SQLConnectInfo  [email protected] root senhaXXX
SQLUserInfo     usertable userid passwd uid gid homedir shell
SQLGroupInfo    grouptable groupname gid members
SQLUserWhereClause   "disabled=0 and (NOW()<=expiration or expiration=-1 or expiration=0)"

# 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

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


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

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

<Directory /ftp/usuario1/*>
   AllowOverwrite          on
   HideNoAccess            on
   <Limit STOR MKD WRITE DEL READ>
      AllowAll
   </Limit>
</Directory>

<Directory /ftp/usuario2/*>
   AllowOverwrite          on
   HideNoAccess            on
   <Limit STOR MKD WRITE DEL READ>
      AllowAll
   </Limit>
</Directory>

<Directory /ftp/usuario3/*>
   AllowOverwrite          on
   HideNoAccess            on
   <Limit STOR MKD WRITE DEL READ>
      AllowAll
   </Limit>
</Directory>

<Directory /ftp/usuario4/*>
   AllowOverwrite          on
   HideNoAccess            on
   <Limit STOR MKD WRITE DEL READ>
      AllowAll
   </Limit>
</Directory>