proftp+mysql+quota怎麼設置用戶目錄？
麻煩高手現身看看這個問題怎麼解決。。。
現在mysql的ftp資料庫表裡有兩個用戶，分別是000000和user1，不清楚在目錄許可權控制處寫這兩個用戶的名字，還是寫FTPUSER？以下是配置文件。。。尤其是最後那地方不明白。。。
ServerName "Serv-U FTP Server v5.0 for Winsock ready...\"
ServerType standalone
ServerIdent off ##屏蔽伺服器信息
DefaultServer on
Port 21
Umask 022
MaxInstances 30 ##最大進程數30
User FTPUSER
Group FTPGRP
DefaultRoot ~ ftpusers
AllowStoreRestart on ##斷點續傳
AllowRetrieveRestart on
#RateReadBPS 80000 ##設置上傳下載速率80K
#RateWriteBPS 80000
MaxClients 10 ##設置最大登錄數
RootLogin off
PassivePorts 65520 65534
LogFormat auth "%h %a %t \"%r\" %s"
LogFormat write "%h %a %t \"%r\" %s"
LogFormat read "%h %a %t \"%r\" %s"
ExtendedLog /var/log/proftp/write.log WRITE write
ExtendedLog /var/log/proftp/read.log READ read
ExtendedLog /var/log/proftp/auth.log AUTH auth
SQLLogFile /var/log/proftp/sql.log
SQLBackend mysql
SQLAuthenticate on
SQLConnectInfo proftp@localhost:3306 root 000000 ##設置mysql參數
SQLAuthTypes Backend Plaintext ##資料庫認證的類型
SQLUserInfo FTPUSERS userid passwd uid gid home shell ##指定用來做用戶認證的表的有關信息
SQLGroupInfo FTPGRPS grpname gid members ##指定用來做用戶組認證的表的有關信息
RequireValidShell off ##設置如果shell為空時允許用戶登錄
SQLHomedirOnDemand on ##如果home目錄不存在，則系統會為根據它的home項新建一個目錄
# Update count every time user logs in
SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "count=count+1,accessed=now() WHERE userid='%u'" ftpuser
# Update modified everytime user uploads or deletes a file
SQLLog STOR,DELE modified
SQLNamedQuery modified UPDATE "modified=now() WHERE userid='%u'" ftpuser
#磁碟限額部分
QuotaDirectoryTally on
#磁碟限額單位 b"|"Kb"|"Mb"|"Gb"
QuotaDisplayUnits "Kb"
QuotaEngine on
#磁碟限額日誌記錄
QuotaLog "/var/log/proftp/quotalog"
# 打開磁碟限額信息，當登陸FTP帳戶后，使用命令 "quote SITE QUOTA" 后可顯示當前用戶的磁碟限額
QuotaShowQuotas on
#以下是SQL調用語句，不用修改直接拷貝過去
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}'" 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
#<Directory />
#AllowOverwrite on
#</Directory>
#<Directory /home/FTP/000000>
#<Limit RMD RNFR DELE RETR> #不允許刪除，改名，下載
#DenyGroup FTPGRP
#</Limit>
#TransferRate RETR 50 user 000000
#TransferRate STOR 100 user 000000
#</Directory>
<Directory /home/FTP/*>
<Limit CWD MKD RNFR WRITE STOR>
AllowUser FTPUSER
</Limit>
<Limit DELE READ RETR>
DenyUser FTPUSER
</Limit>
</Directory>
《解決方案》
急啊。。。。
