|
|
小弟用了吃奶的力气,终于安装了proftpd+quota+mysql,但在启动proftpd进程时出错。。信息如下:
- Fatal: unknown configuration directive 'bytes_in_avail,' on line 55 of '/usr/local/proftpd/etc/proftpd.conf'.
我比较菜,知道是proftpd.conf里有问题,可我都是按那篇教程一点点做的啊,请大家帮我看看到底错在哪儿了。这是我的配置文件proftpd.conf
#------------------------------------------------------
ServerName "FTP server"
ServerType standalone
DefaultServer on
Port 21
Umask 022
MaxInstances 30
User ftp
Group ftp
DefaultRoot ~
SystemLog /usr/local/proftpd/logs/ftp.log
TransferLog /usr/local/proftpd/logs/ftp.transferlog
MaxLoginAttempts 30
AllowRetrieveRestart on
#for quota configure
QuotaDirectoryTally on
QuotaDisplayUnits Kb
QuotaEngine on
QuotaLog /usr/local/proftpd/logs/Quota.log
QuotaShowQuotas on
#for mysql configure
<Global>
SQLConnectInfo ftp@localhost:3306 ftpuser test#@
SQLAuthTypes Backend Plaintext
SQLUserInfo FTPUSERS userid passwd uid gid home shell
SQLGroupInfo FTPGRPS groupname gid members
RequireValidShell off
SQLAuthenticate users
SQLHomedirOnDemand on
#MySQL
SQLNamedQuery get-quota-limit SELECT "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 quotalimits WHERE name = '%{0}' AND quota_type = '%{1}'"SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used,bytes_out_used,bytes_xfer_used,files_in_used,files_out_used,files_xfer_used FROM quotatallies WHERE name = '%{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 name = '%{6}' AND quota_type = '%{7}'"
quotatalliesSQLNamedQuery 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
</Global>
MaxInstances 30
# Normally, we want files to be overwriteable.
<Directory />
AllowOverwrite on
</Directory>
#-------------------------------------------------------
系统是rh8,proftpd-1.2.8,mysql-3.23.53,quotatab-1.2.7 |
|