Bonsoir, Je viens de mettre en place en serveur ftp avec gestion des
users via mysql, et tout fonctionne. Mais dans le fichier /etc/proftpd.conf, il
y a quelque ligne que je ne comprends pas, voici lesquelles : 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 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 ftpquotatallies 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 Si quelqu’un pouvait m’éclaircir un tout petit
peu et m’expliquer ce que font ces lignes, merci par avance. PS : pour info, je me suis inspirer de la doc sur
http://www.howtoforge.com/proftpd_mysql_virtual_hosting |
- Proftp-Mysql yoann
- Re: Proftp-Mysql laurent besson