Administrace komentářů

cat /etc/proftpd/proftpd.conf
ServerName                      "ProFTPD"
ServerType                      standalone
ServerIdent                     on "Welcome to the FTP server. Please login..."
ServerAdmin                     president@whitehouse.gov
DeferWelcome                    on
DefaultServer                   on
DefaultRoot                     ~
RequireValidShell               off
RootLogin                       off
AuthPAM                         off
AuthPAMConfig                   ftp
Port                            21
Umask                           022 022
MaxInstances                    50
User                            nobody
Group                           nogroup
AllowOverwrite                  on
AllowForeignAddress             off     # kvuli povoleni server-server stahovani musi byt on
AllowRetrieveRestart            on      # resume download
AllowStoreRestart               on      # resume upload

#DebugLevel                     5
PassivePorts                    49152 65534


ShowSymlinks                    on
TimeoutNoTransfer               600
TimeoutStalled                  600
TimeoutIdle                     1200
ListOptions                     "-|"
DenyFilter                      \*.*/
                                                                                                                                                                                                              
SQLMinID                        20                                                                                                                                                                            
                                                                                                                                                                                                              
SQLConnectInfo                  login@server:3306 pass LULH45aYExb7Gztu                                                                                                                               
SQLAuthTypes                    Crypt                                                                                                                                                                         
SQLUserInfo                     users userid password uid gid homedir shell                                                                                                                                   
SQLGroupInfo                    groups groupname gid members                                                                                                                                                  
SQLAuthenticate                 users* groups*                                                                                                                                                                
SQLLogFile                      /var/log/proftpd.sql.log                                                                                                                                                      
AuthOrder                       mod_sql.c                                                                                                                                                                     
                                                                       
SQLLog                          PASS updatecount                                                                                                                                                              
SQLNamedQuery                   updatecount UPDATE "count=count+1, accessed=now() WHERE userid='%u'" users                                                                                                    
SQLLog                          STOR,DELE modified                                                                                                                                                            
SQLNamedQuery                   modified UPDATE "modified=now() WHERE userid='%u'" users                                                                                                                      

# User quotas
# ===========
QuotaEngine on
QuotaDirectoryTally on
QuotaDisplayUnits Mb
QuotaShowQuotas on


SQLNamedQuery                   get-quota-limit SELECT "userid, 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 users WHERE userid = '%{0}' AND \
                                quota_type = '%{1}'"

SQLNamedQuery                   get-quota-tally SELECT "userid, quota_type, bytes_in_used, \
                                bytes_out_used, bytes_xfer_used, files_in_used, files_out_used, files_xfer_used \
                                FROM quotatallies WHERE userid = '%{0}' AND quota_type = '%{1}'"

SQLNamedQuery                   update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, \
                                bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, \
                                files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, \
                                files_xfer_used = files_xfer_used + %{5} WHERE userid = '%{6}' AND quota_type = '%{7}'" quotatallies

SQLNamedQuery                   insert-quota-tally INSERT "%{0}, %{1}, '%{2}', '%{3}', '%{4}', '%{5}', '%{6}', '%{7}'" quotatallies
QuotaLimitTable                 sql:/get-quota-limit

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

# Banner

SQLNamedQuery gettally  SELECT "ROUND((bytes_in_used/1048576),2) FROM quotatallies WHERE userid='%u'"
SQLNamedQuery getlimit  SELECT "ROUND((bytes_in_avail/1048576),2) FROM users WHERE userid='%u'"
SQLNamedQuery getfree   SELECT "ROUND(((users.bytes_in_avail-quotatallies.bytes_in_used)/1048576),2) FROM users,quotatallies WHERE users.userid = '%u' AND quotatallies.userid = '%u'"

SQLShowInfo   LIST    "226" "Used %{gettally}MB from %{getlimit}MB. You have %{getfree}MB available space."


<Directory /var/ftp/_upload/*>
    <Limit WRITE STOR MKD XMKD>
        AllowALL
    </Limit>
    <Limit READ RMD XRMD DELE>
        DenyAll
    </Limit>
</Directory>