由 5sky 在 06-18-2004 10:57 发表:
[求助]proftpd1.29+mod_quotatab提示错误
file:
proftpd-1.2.9.tar.gz
proftpd-mod-quotatab-1.2.11.tar.gz
安装一切正常.能运行.
可打开/var/quota则出现以下错误提示.
> quote:
>
> * * *
>
>
>
> 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配制部分
> quote:
>
> * * *
>
>
>
> 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
>
>
>
> * * *
由 myy