Include /etc/proftpd/modules.conf
ServerName "FTP"
ServerType standalone
DeferWelcome off
MultilineRFC2228 on
DefaultServer on
ShowSymlinks on
TimeoutNoTransfer 600
TimeoutStalled 600
TimeoutIdle 1200
DisplayLogin welcome.msg
DisplayFirstChdir .message
ListOptions "-l"
DenyFilter \*.*/
TLSEngine on
TLSRequired on
TLSProtocol SSLv23
TLSCACertificateFile /etc/proftpd/ca.crt
TLSRSACertificateFile /etc/proftpd/cert.crt
TLSRSACertificateKeyFile /etc/proftpd/cert.key
QuotaEngine on
QuotaLog /var/log/quota.log
QuotaDisplayUnits Mb
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
QuotaLock /var/run/proftpd.quotalock
QuotaShowQuotas on
SQLNamedQuery get-quota-limit SELECT "username, 'user', 'false', 'hard', quota,
0, 0, 0, 0, 0 FROM ftpusers WHERE username = '%{0}'"
SQLNamedQuery get-quota-tally SELECT "username, 'user', used , 0, 0, 0, 0, 0
FROM ftpusers WHERE username = '%{0}' and '%{1}'='user'"
SQLNamedQuery update-quota-tally UPDATE "used = used + %{0} WHERE username =
'%{6}'" ftpusers
SQLNamedQuery insert-quota-tally UPDATE "used = used WHERE username = '%{0}'"
ftpusers
Port 21
MaxInstances 30
User nobody
Group nogroup
Bind 10.12.0.1
Umask 002 002
AllowOverwrite on
DelayEngine off
PassivePorts 49152 65534
DefaultRoot ~
SQLEngine on
SQLAuthenticate users
AuthOrder mod_sql.c
SQLAuthTypes Plaintext
SQLConnectInfo [EMAIL PROTECTED]:3306 proftpd PASSWORDHERE 30
SQLDefaultGID 101
SQLDefaultUID 14001
SQLUserInfo ftpusers username password '33' '14001'
concat('/opt/chroot/',homedir) '/bin/false'
SQLUserWhereClause "ftp='1'"
RequireValidShell off
<Class all>
From 0.0.0.0/0
</Class>
<Limit ALL>
AllowClass all
</Limit>
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
