# 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/nogroup" and "ftp" for normal operation and anon.

<global>
SQLConnectInfo *** *** ***
SQLUserInfo ftp login password uid gid home shell
# SQLGroupInfo groups groupname id username
# SQLUserWhereClause "valid = 1"
SQLAuthenticate on
SQLAuthTypes Crypt
SyslogLevel debug
</global>

ServerName"TiSpOkEs Webserver"
ServerTypestandalone
DeferWelcomeon
UseReverseDNS off
IdentLookupsoff
TransferLog/var/log/proftpd.xferlog


MultilineRFC2228on
DefaultServeron
ShowSymlinkson
AllowOverwriteon
AllowForeignAddresson
AllowRetrieveRestarton
AllowStoreRestarton
hiddenstoroff

TimeoutNoTransfer600
TimeoutStalled600
TimeoutIdle1200

DisplayLogin                    welcome.msg
DisplayFirstChdir               .message
ListOptions                "-l"
DefaultRoot"~"

DenyFilter\*.*/

debugLevel 6
Serverlog /var/log/proftpd.debug.log
SQLLOGFILE /var/log/proftpd.sql.log
ExtendedLog /var/log/proftpd.log ALL

# Uncomment this if you are using NIS or LDAP to retrieve passwords:
#PersistentPasswdoff

# Uncomment this if you would use TLS module:
#TLSEngine on

# Uncomment this if you would use quota module:
#Quotason

# Uncomment this if you would use ratio module:
#Ratioson

# Port 21 is the standard FTP port.
Port21

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

# Set the user and group that the server normally runs at.
Usernobody
Groupnogroup

<Directory /*>
# Umask 022 is a good standard umask to prevent new files and dirs
# (second parm) from being group and world writable.
  Umask022  022
# Normally, we want files to be overwriteable.
  AllowOverwriteon
</Directory>

# A basic anonymous configuration, no upload directories.

# <Anonymous ~ftp>
#   Userftp
#   Groupnogroup
#   # We want clients to be able to login with "anonymous" as well as "ftp"
#   UserAliasanonymous ftp
#
#   RequireValidShelloff
#
#   # Limit the maximum number of anonymous logins
#   MaxClients10
#
#   # We want 'welcome.msg' displayed at login, and '.message' displayed
#   # in each newly chdired directory.
#   DisplayLoginwelcome.msg
#   DisplayFirstChdir.message
#
#   # Limit WRITE everywhere in the anonymous chroot
#   <Directory *>
#     <Limit WRITE>
#       DenyAll
#     </Limit>
#   </Directory>
#
#   # Uncomment this if you're brave.
#   # <Directory incoming>
#   #   # Umask 022 is a good standard umask to prevent new files and dirs
#   #   # (second parm) from being group and world writable.
#   #   Umask022  022
#   #            <Limit READ WRITE>
#   #            DenyAll
#   #            </Limit>
#   #            <Limit STOR>
#   #            AllowAll
#   #            </Limit>
#   # </Directory>
#
# </Anonymous>

### Log trafic (STOR, RETR commands)
SQLLog STOR,RETR,ERR_STOR,ERR_RETR logtrafic
SQLNamedQuery logtrafic FREEFORM "INSERT INTO history (username, filename, transfertype, transfersize, transferhost, transfer$

### Log user error events (ERR_* commands)
SQLLog ERR_* logevents
SQLNamedQuery logevents FREEFORM "INSERT INTO userevents (username, eventtype, description, eventdate) VALUES ('%u', '%m', '%$