DebugLevel 1 
#
# To have more informations about Proftpd configuration
# look at : http://www.proftpd.org/
#
# 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" and "ftp" for normal operation and anon.


ServerIdent         on "RCN Business Solutions FTP Server ready."
ServerAdmin                     "customer support [[email protected]]"



ServerName                      "RCN Business Solutions fbsdweb3" 
ServerType                      standalone
DefaultServer                   on
RequireValidShell    	off

ScoreboardFile			/var/run/proftpd.scoreboard

# Port 21 is the standard FTP port.
Port				21

# Umask 022 is a good standard umask to prevent new dirs and files
# from being group and world writable.
Umask				022


AllowLogSymlinks on

ListOptions                     "-a"

CreateHome on 755 dirmode 755

DefaultRoot ~

#AuthOrder mod_sql.c
#PersistentPasswd off

# 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).
MaxInstances			150

# Set the user and group under which the server will run.
User				nobody
Group				nogroup


ServerLog /var/log/proftpd-server.log
QuotaLog /var/log/proftpd-quota.log
TransferLog  /var/log/proftpd-xfer.log
SQLLogFile /var/log/proftpd-mysql.log

QuotaEngine on
QuotaDisplayUnits "Mb"
QuotaShowQuotas on

SQLAuthenticate users*

SQLAuthTypes Crypt

SQLConnectInfo [email protected] proftpd pr0ftpd PERSESSION

SQLUserInfo custom:/sql-login
# usertable userid passwd uid gid homedir shell 

SQLNamedQuery sql-login	FREEFORM "select username, encrypt(password), uid, 999,home_dir,'none' from user_table where  username = '%U' and status='Active'" 

# name, quota_type, per_session, limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM ftpquotalimits 

SQLNamedQuery get-quota-limit FREEFORM "select username ,'user','false','hard',0,0,(disk_quota * 1024 * 1024) ,0,0,0 from user_table where username = '%{0}' and status='Active'"

SQLNamedQuery get-quota-tally SELECT "name, 'user', 0,0,bytes_xfer_used, 0,0,0 FROM quotatallies WHERE name = '%{0}'"

SQLNamedQuery update-quota-tally FREEFORM "update quotatallies set bytes_xfer_used = bytes_xfer_used + %{2}  WHERE name = '%{6}'"

SQLNamedQuery insert-quota-tally FREEFORM "INSERT into quotatallies set name= %{0}"


QuotaLimitTable sql:/get-quota-limit

QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally

MaxClientsPerHost               3 "The maximum number of simultaneous connections from your host has been reached"

# Normally, we want files to be overwriteable.
# We do *not* want users CHMOD'ing their home directories. The
# contents, yes. The directories themselves? No. It generates
# tickets. Tickets are bad.

<Directory ~>
  AllowOverwrite        on
  <Limit SITE_CHMOD>
    DenyAll
  </Limit>
</Directory>

<Directory ~/*>
  <Limit SITE_CHMOD>
    AllowAll
  </Limit>
</Directory>

<Directory ~/logs/*>
<Limit WRITE>
      DenyAll
    </Limit>
</Directory>


#LogFormat                       default "%h %l %u %t \"%r\" %s %b [%P]"
#ExtendedLog                     /var/log/proftpd.log ALL default


TimeoutIdle                     600
TimeoutLogin                    300
TimeoutNoTransfer               600
TimeoutStalled                  300


MultilineRFC2228 on


DisplayConnect /welcome/connect
DisplayLogin   /.ht_proftpd_firstchdir 



#LsDefaultOptions                "-a"
#PathDenyFilter                  "^(\.quota$)"
DenyFilter                      (/\*/\.)|(\.\*\./\*)

AllowRetrieveRestart            On
AllowStoreRestart               On
IdentLookups                    Off
UseReverseDNS                   Off