[求助]proftpd1.29+mod_quotatab提示错误

5sky

file:
proftpd-1.2.9.tar.gz
proftpd-mod-quotatab-1.2.11.tar.gz

安装一切正常.能运行.
可打开/var/quota则出现以下错误提示.

Jun 18 10:47:30 mod_quotatab/1.2.11[30012]: error: unable to resolve SQLNamedQuery name 'get-quota-tally'
Jun 18 10:47:30 mod_quotatab/1.2.11[30012]: error: unable to open QuotaTallyTable: Invalid argument
Jun 18 10:47:30 mod_quotatab/1.2.11[30012]: turning QuotaEngine off
Jun 18 10:49:41 mod_quotatab/1.2.11[30013]: error: unable to resolve SQLNamedQuery name 'get-quota-tally'
Jun 18 10:49:41 mod_quotatab/1.2.11[30013]: error: unable to open QuotaTallyTable: Invalid argument
Jun 18 10:49:41 mod_quotatab/1.2.11[30013]: turning QuotaEngine off

请高手帮忙看看.问题在哪?

proftpd.conf MysQL配制部分

SQLAuthTypes Backend Plaintext
SQLAuthenticate users* groups*

SQLConnectInfo ftpdb@localhost ftpd 12345
SQLUserInfo ftpuser userid passwd uid gid homedir shell
SQLGroupInfo ftpgroup groupname gid members
SQLHomedirOnDemand on

SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "count=count+1,accessed=now() WHERE userid='%u'" ftpuser

SQLLog STOR,DELE modified
SQLNamedQuery modified UPDATE "modified=now() WHERE userid='%u'" ftpuser

QuotaEngine on
QuotaDirectoryTally on
QuotaDisplayUnits Mb
QuotaShowQuotas on
QuotaLog "/var/log/quota"

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 ftpquotalimits 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}'" ftpquotatallies

SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" ftpquotatallies

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

myym

我在make的 时候就抱错了，不知道什么原因，有些学linux的兄弟在装贴别人的帖子时，帖子里的错误的地方也一并发上来，这样不太好。我忘记在make时所抱的错误了，后来就没搞过它了，总是抱错

myym

能否和`5sky共同学习一下这个问题，我的qq是
275268323
兄弟能不能加我的qq号

5sky

[root@g2mdb etc]# tail -n  0 --follow=name --retry /var/log/quota
Jun 18 12:47:06 mod_quotatab/1.2.11[30244]: found limit entry for user 'upload'
Jun 18 12:47:06 mod_quotatab/1.2.11[30244]: creating new tally entry to match limit entry
Jun 18 12:47:06 mod_quotatab/1.2.11[30244]: new tally entry successfully created