[debian-mysql] Bug#420131: proftpd.conf

[Daniel VASARHELYI]

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 USERNAME at HOSTNAME: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>