Titel: mod_quotatab Problem Beitrag von: mKe am 22. Dezember 2004, 03:28:40 Hallo,
ich hab proftpd erstmal so kompiliert: Code: ./configure \ --sysconfdir=/etc \ --localstatedir=/var \ --prefix=/usr \ --with-modules=mod_sql:mod_sql_mysql:mod_quotatab:mod_quotatab_sql \ --with-includes=/usr/include/mysql \ --with-libraries=/usr/lib/mysql \ && make \ && make install Dann hab ich alle nötigen SQL-Tabellen angelegt und es geht alles prima. Jetzt versuche ich einen Quota via SQL zum laufen zu bekommen. Hier die Config: Code: Z100: # mod_quota tab Z101: QuotaEngine on Z102: QuotaShowQuotas on Z103: QuotaLimitTable sql:/get-quota-limit Z104: QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally Z105: 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}'" Z106: 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}'" Z107: 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 Z108: SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" quotatallies Wenn ich jetzt folgendes mache bekomm ich einen Fehler: Code: # /usr/local/sbin/proftpd -td5 Checking syntax of configuration file - parsing '/etc/proftpd.conf' configuration - <Directory /*>: adding section for resolved path '/*' - Compiling deny regex '.quota$'. - Allocated deny regex at location 0x80bb5b0. - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated. Use AuthOrder for setting authoritativeness - Fatal: unknown configuration directive 'QuotaEngine' on line 101 of '/etc/proftpd.conf'. Warum ? Finde momentan selber keine Lösung, könnte auch an meiner Übermüdung liegen *g* Ich hoffe ihr könnt mir dabei schnell helfen. P.S.: System->Suse 9.0 Grüße mKe |