\uff08\u4e00\uff09
\u8fd9\u51e0\u5929\uff0c\u516c\u53f8\u7ec8\u4e8e\u653e\u5047\u4e86\uff0c\u7ec8\u4e8e\u53ef\u4ee5\u5b89\u4e0b\u5fc3\u6765\u597d\u597d\u5b66\u4e9bproftp+mysql+quota\u3002<\/p>\n
\u5b89\u88c5proftp\u4e4b\u524d\uff0c\u5fc5\u987b\u5148\u505a\u4e00\u4e2a\u5de5\u4f5c\uff0c\u5047\u5982\u4f60\u7684mysql\u662f\u81ea\u5df1\u7f16\u8bd1\u7684\uff0c\u90a3\u5c31\u5fc5\u987b\u5148\u4fee\u6539\/etc\/ld.so.conf\uff0c\u5426\u5219\u540e\u9762\u8fd0\u884cproftp\u4f1a\u62a5\u9519\u3002
vi \/etc\/ld.so.conf<\/p>\n
\u6dfb\u52a0\u4e0b\u9762\u4e00\u884c:<\/p>\n
\/usr\/local\/mysql\/lib\/mysql<\/p>\n
\u6ce8\u610f\u5927\u5bb6\u5982\u679cmysql\u7684\u5b89\u88c5\u8def\u5f84\u4e8e\u6211\u4e0d\u4e00\u6837\uff0c\u5219\u586b\u5199\u76f8\u5e94\u7684\u8def\u5f84\uff0c\u6709\u5173mysql\u7684\u7f16\u8bd1\u5b89\u88c5\u8bf7\u53c2\u8003\u300aLinux+Apache+Mysql+PHP\u5178\u578b\u914d\u7f6e\u300b\u3002 <\/p>\n
1\u3002\u4e0b\u8f7d\u76f8\u5173\u8f6f\u4ef6<\/p>\n
wget ftp:\/\/ftp.proftpd.org\/distrib\/source\/proftpd-1.2.9.tar.gz<\/a> wget http:\/\/www.castaglia.org\/proftpd\/modules\/proftpd-mod-quotatab-1.2.11.tar.gz<\/a> 2\u3002\u89e3\u538b\u7f16\u8bd1<\/p>\n tar zvxf proftpd-1.2.9.tar.gz \u627e\u5230#include \u8fd9\u4e00\u884c\uff0c\u5c06mysql.h\u6539\u6210\u4f60\u7684\u7cfb\u7edf\u4e2d\u6b64\u6587\u4ef6\u6240\u5728\u7684\u8def\u5f84\uff0c\u5982\/usr\/local\/mysql\/include\/mysql\/mysql.h <\/p>\n \u7f16\u8bd1\uff1a<\/p>\n .\/configure \\ \u8fd9\u91cc\u6211\u4eec\u7f16\u8bd1\u7684\u65f6\u5019\u5df2\u7ecf\u52a0\u8fdb\u4e86mysql,quota,ratio\u7b49\u6a21\u5757\u7684\u652f\u6301\uff0c\u6211\u4f1a\u5728\u540e\u9762\u8bb2\u4ed6\u4eec\u7684\u5e94\u7528<\/p>\n ok, \u73b0\u5728\u6211\u4eec\u53ef\u4ee5\u6765\u542f\u52a8proftp\u4e86\uff0c\u53ea\u8981<\/p>\n \/usr\/local\/proftpd\/sbin\/proftpd \u5176\u5b9e\u9ed8\u8ba4\u7684proftp\u6ee1\u8db3\u65e5\u5e38\u7684\u670d\u52a1\u5668\u7ba1\u7406\u7528\u8fd8\u662f\u7ef0\u7ef0\u6709\u4f59\u7684\uff0c\u6709\u4e2a\u5730\u65b9\u8fd8\u662f\u8981\u4fee\u6539\u4e00\u4e0b\uff0c\u5c31\u662f\u9ed8\u8ba4proftp\u7684\u914d\u7f6e\u6587\u4ef6\u4e0d\u652f\u6301ftp\u7eed\u4f20\uff0c\u6240\u4ee5\u6211\u4eec\u53ea\u8981<\/p>\n vi \/usr\/local\/proftpd\/etc\/proftpd.conf AllowRetrieveRestart on \u521b\u5efaproftpd\u811a\u672c<\/p>\n \u53ea\u8981\u5728proftp\u7684\u6e90\u4ee3\u7801\u76ee\u5f55<\/p>\n cp proftpd-1.2.9\/contrib\/dist\/rpm\/proftpd.init.d \/etc\/rc.d\/init.d\/proftpd<\/p>\n \u8bb0\u5f97\u4fee\u6539proftpd\u6587\u4ef6\uff0c\u4e00\u822c\u8981\u4fee\u6539proftpd\u7684\u5b9e\u9645\u8def\u5f84<\/p>\n chmod 755 \/etc\/rc.d\/init.d\/proftpd \u4ee5\u540e\u5c31\u53ef\u4ee5\u7528\u8fd9\u4e2a\u6559\u672c\u6765\u542f\u52a8\uff0c\u505c\u6b62\uff0c\u91cd\u542fproftp<\/p>\n \u5475\u5475\uff0c\u4eca\u5929\u5c31\u8bb2\u8fd9\u4e9b\uff0c\u660e\u5929\u8bb2\u4e9bproftp\u7684\u4e00\u4e9b\u57fa\u7840\u914d\u7f6e\uff1a\uff09<\/p>\n <\/p>\n <\/p>\n <\/p>\n \uff08\u4e8c\uff09<\/p>\n \u4e0a\u6b21\u6211\u4eec\u8bb2\u4e86proftp\u7684\u57fa\u672c\u5b89\u88c5\uff0c\u7531\u4e8e\u6211\u4eec\u540e\u9762\u6709\u5173\u4e8emysql\u548cquota\u7684\u8bbe\u7f6e\uff0c\u6240\u4ee5\u7f16\u8bd1\u7684\u65f6\u5019\u628a\u76f8\u5e94\u7684\u6a21\u5757\u90fd\u7f16\u8bd1\u8fdb\u53bb\u4e86\uff0c\u5982\u679c\u4f60\u4e0d\u9700\u8981mysql\u548c\u78c1\u76d8\u9650\u989d\u7684\u529f\u80fd\uff0c\u5b8c\u5168\u53ef\u4ee5\u4e0d\u9700\u8981\u8fd9\u4e48\u7f16\u8bd1\u3002<\/p>\n \u8fd9\u91cc\u8981\u8bb2\u4e00\u4e2a\u975e\u5e38\u5b9e\u7528\u7684\u547d\u4ee4\uff0c<\/p>\n \/usr\/local\/proftpd\/sbin\/ftpshut ftpshut [ -l min ] [ -d min ] time [ warning-message ... ]<\/p>\n -l min: \u5728ftp\u5173\u95ed\u670d\u52a1\u4e4b\u524d\u7684\u51e0\u5206\u949f\u5185\uff0c\u5c1d\u8bd5\u5efa\u7acb\u65b0\u7684ftp\u8fde\u63a5\u5747\u4e0d\u88ab\u63a5\u53d7 \u6ce8\u610f\uff0c\u8fd9\u91cc\u6211\u4eec\u7528\u8fd9\u4e2a\u547d\u4ee4\u662f\u628aftp\u670d\u52a1\u7ed9\u505c\u4e86\uff0c\u4f46\u5b9e\u9645\u7684proftpd\u8fdb\u7a0b\u8fd8\u6ca1\u505c\u6b62\uff0c\u6240\u4ee5\u4e00\u822c\u8c03\u8bd5ftp\u4f1a\u4f7f\u7528\u5230\u8fd9\u4e2a\u547d\u4ee4\u3002<\/p>\n \u4e3e\u4f8b\uff1a ftpshut -l 20 -d 10 +30 \"FTP Server Will shutdown at time\"<\/p>\n \u5176\u5b9eftpshut\u5c31\u662f\u4ea7\u751f\/etc\/shutmsg ,\u4f60\u53ea\u8981\u5220\u9664\u8fd9\u4e2a\u6587\u4ef6ftp\u53c8\u53ef\u4ee5\u91cd\u65b0\u670d\u52a1\uff0c\u6216\u8005 ftpshut -R<\/p>\n \u597d\u4e86\uff0c\u5f00\u59cb\u8bb2\u4e00\u4e9bproftpd\u7684\u57fa\u672c\u914d\u7f6e\u5427\uff0c\u5176\u5b9e\u5927\u5bb6\u5982\u679c\u719f\u6089apache\u7684\u914d\u7f6e\u7684\u8bdd\uff0c\u4f60\u4f1a\u53d1\u73b0proftpd\u7684\u8bbe\u7f6e\u57fa\u672c\u90fd\u662f\u7c7b\u4f3c\u7684\uff0c\u5b83\u7684\u914d\u7f6e\u57fa\u672c\u683c\u5f0f\u662f<\/p>\n \uff03\u5168\u5c40\u8bbe\u7f6e \uff03\u67d0\u4e2a\u76ee\u5f55\u7684\u8bbe\u7f6e \uff03\u5173\u4e8e\u533f\u540d\u7528\u6237\u7684\u8bbe\u7f6e \u6211\u4eec\u7528\u5230\u7684\u6bd4\u8f83\u591a\u7684\u53ef\u80fd\u662fLimit\u7684\u4f7f\u7528\uff0cLimit\u5927\u81f4\u6709\u4ee5\u4e0b\u52a8\u4f5c\uff0c\u57fa\u672c\u80fd\u8986\u76d6\u5168\u90e8\u7684\u6743\u9650\u4e86\uff0c\u5927\u5bb6\u7075\u6d3b\u4f7f\u7528\u5c31\u662f\u4e86\u3002<\/p>\n CMD\uff1aChange Working Directory \u6539\u53d8\u76ee\u5f55 AllowUser \u9488\u5bf9\u67d0\u4e2a\u7528\u6237\u5141\u8bb8\u7684Limit TransferRate STOR|RETR \u901f\u5ea6\uff08Kbytes\/s\uff09 user \u4f7f\u7528\u8005<\/p>\n \u4e0b\u9762\u6211\u4eec\u4ee5\u4f8b\u5b50\u6765\u89e3\u8bf4proftp\u7684\u914d\u7f6e\uff0c\u8fd9\u6837\u5927\u5bb6\u53ef\u80fd\u66f4\u52a0\u5bb9\u6613\u7406\u89e3\u3002<\/p>\n 1\u3002ftp\u670d\u52a1\u5668\u652f\u6301\u65ad\u70b9\u7eed\u4f20\uff0c\u4e14\u6700\u5927\u652f\u6301\u540c\u65f610\u4eba\u5728\u7ebf\uff0c\u6bcf\u4e2aip\u53ea\u5141\u8bb8\u4e00\u4e2a\u8fde\u63a5\uff1b \u5148\u662f\u524d\u671f\u7684\u7528\u6237\u548c\u7ec4\u6dfb\u52a0\u4ee5\u53ca\u76ee\u5f55\u7684\u6743\u9650\u8bbe\u7f6e<\/p>\n group add ftpusers \u6ce8\u610f#\u8868\u793a\u6ce8\u91ca\uff0c\u5bf9\u8bbe\u7f6e\u6ca1\u5f71\u54cd\uff0c\u53ef\u4ee5\u4e0d\u5199<\/p>\n ServerName \"Frank's FTP Server\" <Directory \/> <\/p>\n \u6211\u8fd9\u91cc\u5b9e\u73b0\u7684\u65b9\u5f0f\u8fd8\u53ef\u4ee5\u901a\u8fc7<\/p>\n <Anonymous ~kaoyan><\/p>\n ...<\/p>\n ...<\/p>\n <\/Anonymous><\/p>\n <><Anonymous ~upload><\/p>\n ...<\/p>\n ...<\/p>\n <\/Anonymous><\/p>\n \u800c\u4e14\u66f4\u52a0\u7075\u6d3b\uff0c\u5177\u4f53\u7528\u90a3\u79cd\u65b9\u5f0f\uff0c\u770b\u5927\u5bb6\u4e86\uff0c\u6211\u53ea\u662f\u7ed9\u5927\u5bb6\u5165\u4e2a\u95e8\u800c\u5df2<\/p>\n \u597d\u4e86\uff0c\u4eca\u5929\u5c31\u8bb2\u5230\u8fd9\u91cc\uff0c\u660e\u5929\u7ee7\u7eed\u8bb2\u4e00\u4e9bproftp\u7684\u5176\u4ed6\u914d\u7f6e<\/p>\n <\/p>\n <\/p>\n <\/p>\n \uff08\u4e09\uff09<\/p>\n \u524d\u9762\u7684\u4e24\u4e2a\u7b14\u8bb0\uff0c\u6211\u60f3\u5927\u5bb6\u5bf9proftp\u7684\u8bbe\u7f6e\u5e94\u8be5\u6709\u4e9b\u8ba4\u8bc6,\u662f\u4e0d\u662f\u8ddfapache\u7684\u914d\u7f6e\u5dee\u4e0d\u591a\u5427\u3002\u6211\u60f3\u914d\u7f6e\u8fc7Serv_U\u670d\u52a1\u5668\u7684\uff0c\u518d\u7a0d\u5fae\u770b\u4e00\u4e0bproftp\u7684\u914d\u7f6e\u89c4\u5219\uff0c\u5e94\u8be5\u80fd\u9a6c\u4e0a\u80fd\u914d\u7f6e\u51fa\u4e00\u4e2a\u5f3a\u5927\u7684proftp\u670d\u52a1\u5668\u3002<\/p>\n \u8fd9\u91cc\u6211\u4eec\u518d\u8bb2\u4e00\u4e9bproftp\u7684\u5176\u4ed6\u53c2\u6570\u914d\u7f6e\uff1a<\/p>\n MaxHostsPerUser 1 \"\u5bf9\u4e0d\u8d77\uff0c\u6bcf\u4e2a\u5e10\u6237\u6700\u591a\u5141\u8bb8\u6765\u6e90ip\u4e3a1\u4e2a\" MaxClientsPerUser 1 \"\u5bf9\u4e0d\u8d77\uff0c\u6bcf\u4e2a\u5e10\u6237\u5728\u6bcf\u4e2a\u5ba2\u6237\u7aef\u6700\u591a\u53ef\u4ee5\u540c\u65f6\u767b\u96461\u6b21\" MaxClientsPerHost 1 \"\u5bf9\u4e0d\u8d77\uff0c\u540c\u4e00\u4e2a\u5ba2\u6237\u7aef\u53ea\u80fd\u6700\u591a1\u4e2a\u5e10\u53f7\u53ef\u4ee5\u767b\u9646\" \u5475\u5475\uff0c\u8fd9\u4e09\u4e2aMax\u53c2\u6570\u6bd4\u8f83\u5bb9\u6613\u641e\u6655\uff0c\u5927\u5bb6\u53ef\u8981\u641e\u6e05\u4ed6\u4eec\u7684\u542b\u4e49\u54e6\uff1a\uff09<\/p>\n WtmpLog on TimeoutIdle 600 DisplayLogin welcome.msg \u5173\u4e8e\u6b22\u8fce\u6587\u4ef6\u7684\u8bbe\u7f6e\u5305\u542b\u5982\u4e0b\u53c2\u6570<\/p>\n %T \u76ee\u524d\u7684\u65f6\u95f4 \u77e5\u9053\u8fd9\u4e9b\u53c2\u6570\uff0c\u6211\u4eec\u5c31\u53ef\u4ee5\u5199\u51fa\u4e00\u4e2a\u53cb\u597d\u7684\u6b22\u8fce\u8bed<\/p>\n vi \/home\/kaoyan\/welcome.msg<\/p>\n \u6b22\u8fce\u60a8%U\uff0c \u8fd9\u662fFrank\u7684\u6d4b\u8bd5FTP\u670d\u52a1\u5668\uff1b \u8ba9proftp\u652f\u6301\u73b0\u5728\u6d41\u884c\u7684FXP\u4f20\u8f93\u65b9\u5f0f\uff0c\u9ed8\u8ba4\u662f\u4e0d\u652f\u6301\u7684\u3002 AllowForeignAddress on<\/p>\n PassivePorts 49152 65534 #\u7aef\u53e3\u4e5f\u53ef\u81ea\u5df1\u6307\u5b9a\u559c\u6b22\u7684<\/p>\n \u5343\u4e07\u522b\u5fd8\u4e86\u5728\u5ba2\u6237\u7aef\u4e5f\u8981\u8bbe\u7f6e\u6210\u652f\u6301FXP\u54e6\uff0c\u5426\u5219\u60f3\u6211\u8bd5\u9a8c\u4e86\u597d\u51e0\u6b21\uff0c\u4e00\u76f4\u4ee5\u4e3a\u670d\u52a1\u5668\u6ca1\u8bbe\u7f6e\u597d\uff0c\u5176\u5b9e\u5c31\u662f\u5ba2\u6237\u7aef\u6ca1\u8bbe\u7f6e\uff0c\u5475\u5475\u3002<\/p>\n \u5982\u4f55\u8ba9root\u80fd\u767b\u9646\uff0c\u9ed8\u8ba4proftp\u662f\u4e0d\u652f\u6301root\u767b\u9646\uff0c\u6211\u4eec\u53ef\u4ee5\u8bbe\u7f6e\u8ba9root\u4e5f\u80fd\u767b\u9646ftp\uff0c\u4e0d\u8fc7\u6211\u5728\u8fd9\u91cc\u8fd8\u662f\u5efa\u8bae\u5927\u5bb6\u6700\u597d\u4e0d\u8981\u8ba9root\u80fd\u767b\u9646ftp\uff0c\u8bbe\u7f6e\u5982\u4e0b<\/p>\n RootLogin on <Limit LOGIN> \u865a\u62dfftp\u7684\u5efa\u7acb\uff0c\u4e00\u822c\u7528\u4e8e\u4e00\u53f0ftp\u670d\u52a1\u5668\u6709\u597d\u591aip\u5730\u5740\uff0c\u6216\u8005ftp\u7528\u4e0d\u540c\u7684\u7aef\u53e3\uff0c\u57fa\u672c\u8bbe\u7f6e\u8bed\u6cd5\u662f:<\/p>\n \u6bd4\u5982\u6211\u4eec\u8981\u505a\u4e00\u4e2a\u7aef\u53e3\u662f5555\u7684ftp\u670d\u52a1\u5668\uff1a<\/p>\n <VirtualHost 210.51.0.124> \u81f3\u4e8e\u865a\u62df\u4e3b\u673a\u4e2d\u7684\u5176\u4ed6\u8bbe\u7f6e\u8ddf\u6211\u4ee5\u524d\u8bb2\u7684\u57fa\u672c\u5dee\u4e0d\u591a<\/p>\n \u4e0a\u4f20\/\u4e0b\u8f7d\u6bd4\u7387\u8bbe\u7f6e\uff0c\u6211\u60f3\u7528\u8fc7Serv_U\u7684\u670b\u53cb\u4e00\u5b9a\u77e5\u9053\u8fd9\u4e2a\u529f\u80fd\u7684\u4f7f\u7528\uff0c\u6211\u4eec\u8fd9\u91cc\u8ba9proftp\u4e5f\u5b9e\u73b0\u8fd9\u4e2a\u529f\u80fd\u3002 touch \/home\/kaoyan\/ratio.dat Ratios on \u5728\u76f8\u5e94\u7684\u8bbe\u7f6e\u9879\u91cc\u6dfb\u52a0<\/p>\n UserRatio ftp1 0 0 2 1000 ok,\u91cd\u542f\u4e00\u4e0b\uff0c\u4ee5\u540eftp1\u5c31\u53ef\u4ee5\u542f\u7528\u4e0a\u4f20\/\u4e0b\u8f7d\u6bd4\u7387\u4e86<\/p>\n <\/p>\n <\/p>\n <\/p>\n \uff08\u56db\uff09<\/p>\n \u4eca\u5929\u6211\u4eec\u8bb2proftp\uff0bmysql\uff0bquota\u7684\u5e94\u7528\uff0c\u6211\u60f3\u5927\u5bb6\u6700\u671f\u5f85\u7684\u5c31\u662f\u8fd9\u4e2a\u4e86\u5427<\/p>\n 1.\u9996\u5148\u6211\u4eec\u5efa\u7acb\u76f8\u5e94\u7684\u7528\u6237\u548c\u7528\u6237\u7ec4<\/p>\n groupadd -g 5500 ftpgroup mysql mysql -uroot -ppassword CREATE TABLE `ftpgroup` ( INSERT INTO `ftpgroup` VALUES ('ftpgroup', 5500, 'ftpuser');<\/p>\n CREATE TABLE `ftpquotalimits` ( CREATE TABLE `ftpquotatallies` ( CREATE TABLE `ftpuser` ( \u6ce8\u610f\u8fd9\u91cc\u5927\u5bb6\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u586b\u5199\u81ea\u5df1\u6570\u636e\u5e93\u7684\u7528\u6237\u540d\u548c\u5bc6\u7801\uff0c\u5982\u679c\u5927\u5bb6\u5bf9\u6570\u636e\u5e93\u64cd\u4f5c\u4e0d\u719f\u6089\u7684\u8bdd\uff0c\u4e0d\u59a8\u53ef\u4ee5\u7528phpmyadmin\u6765\u64cd\u4f5c\u3002<\/p>\n 3.\u914d\u7f6eproftp\u6587\u4ef6<\/p>\n ServerName \"Frank's FTP Server\" ServerType standalone DefaultServer on Umask 022<\/p>\n MaxInstances 30 User nobody MaxHostsPerUser 1 \"Sorry, you may not connect more than one time.\" RootLogin off SQLAuthTypes Backend Plaintext # databasename@host<\/a> database_user user_password QuotaEngine on SQLNamedQuery get-quota-tally SELECT \"name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_i SQLNamedQuery update-quota-tally UPDATE \"bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used SQLNamedQuery insert-quota-tally INSERT \"%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}\" ftpquotatallies<\/p>\n QuotaLimitTable sql:\/get-quota-limit <\/p>\n ok,\u5c31\u8fd9\u4e48\u7b80\u5355\uff0c\u91cd\u542f\u4e00\u4e0bproftp\u670d\u52a1\u5c31\u5df2\u7ecf\u80fd\u4f7f\u7528proftp\uff0bmysql\uff0bquota\u7684\u529f\u80fd<\/p>\n \u6211\u4eec\u53ef\u4ee5\u5728\u6570\u636e\u5e93ftpuser\u6dfb\u52a0\u4e00\u4e2a\u865a\u62df\u7528\u6237\uff0c<\/p>\n INSERT INTO `ftpuser` VALUES (1, 'test', 'ftppasswd', 5500, 5500, '\/home\/test', '\/sbin\/nologin'); \u5982\u679c\u4f60\u60f3\u8bbe\u7f6equota\uff0c\u53ea\u8981\u5728ftpquotalimits\u8868\u91cc\u8bbe\u7f6e\u4e00\u4e0b\u5c31\u884c\u4e86\uff0c\u8fd9\u4e2a\u8868\u91cc\u7684\u5404\u4e2a\u53c2\u6570\u5206\u522b\u4ee3\u8868\uff1a<\/p>\n quotalimits\u8868 \u8001\u5b9e\u8bf4\u7528mysql\u548cquota\u6a21\u5757\u6765\u9a8c\u8bc1\u7528\u6237\u548c\u8bbe\u7f6e\u78c1\u76d8\u9650\u989d\uff0c\u4f46\u6211\u603b\u89c9\u5f97\u8fd8\u662f\u4e0d\u591f\u5b8c\u5584\uff0c\u56e0\u4e3a\u5728\u8fd9\u4e2a\u65b9\u6cd5\u4e2d\uff0c\u6570\u636e\u5e93\u8868\u91cc\u8fd8\u6ca1\u6709\u76f8\u5e94\u7684\u6743\u9650\u7684\u5b57\u6bb5\uff0c\u6240\u4ee5\u8bf4\u76f8\u5e94\u7528\u6237\u7684\u6743\u9650\u8fd8\u662f\u5f97\u7528\u5b9e\u9645\u5f97\u7528\u6237\u5373mysql\u5bf9\u5e94\u5f97uid\u548cgid\u6765\u63a7\u5236\u6743\u9650\uff0c\u90a3\u5929\u8981\u662fmysql\u6570\u636e\u5e93\u4e5f\u80fd\u5b8c\u5168\u63a7\u5236\u6743\u9650\u5c31\u597d\u4e86\u3002<\/p>\n \u5927\u5bb6\u5982\u679c\u89c9\u5f97\u683c\u5f0f\u62f7\u8d1d\u7684\u65f6\u5019\u53ef\u80fd\u4f1a\u51fa\u9519\u7684\u8bdd\uff0c\u4e0d\u59a8\u76f4\u63a5\u4e0b\u8f7d\u6211\u7684\u914d\u7f6e\u6587\u4ef6\u548c\u6570\u636e\u5e93\u8868<\/p>\n \u4e0b\u8f7dproftpd.conf \u8fd9\u4e2a\u6625\u8282\u4e00\u76f4\u5728\u5b66\u4e60proftp\uff0c\u7ec8\u4e8e\u53ef\u4ee5\u677e\u53e3\u6c14\u4e86\uff0c\u5e0c\u671b\u6211\u7684\u5b66\u4e60\u7b14\u8bb0\u53ef\u4ee5\u5bf9\u4e00\u4e9b\u60f3\u5b66\u4e60proftp\u7684\u670b\u53cb\u6709\u6240\u5e2e\u52a9\uff0c\u8bf7\u591a\u4ea4\u6d41\u3002<\/p>\n <\/p>\n
\u4e0b\u8f7dproftp\u7684\u6700\u65b0\u7248\u672c1.2.9 <\/p>\n
\u8fd9\u662f\u914d\u5408proftp\u7684\u78c1\u76d8\u9650\u989d\u7684\u6a21\u5757 <\/p>\n
tar zvxf proftpd-mod-quotatab-1.2.11.tar.gz
cp mod_quotatab\/*.c proftpd-1.2.9\/contrib\/
cp mod_quotatab\/*.h proftpd-1.2.9\/contrib\/
vi proftpd-1.2.9\/contrib\/mod_sql_mysql.c<\/p>\n
--prefix=\/usr\/local\/proftpd \\
--with-modules=mod_sql:mod_sql_mysql:mod_quotatab\\
:mod_quotatab_sql:mod_ratio \\
--with-includes=\/usr\/local\/mysql\/include\/mysql \\
--with-libraries=\/usr\/local\/mysql\/lib\/mysql
make
make install<\/p>\n
\u7528\u4f60\u7684ftp\u5ba2\u6237\u7aef\u8bd5\u9a8c\u4ee5\u4e0b\uff0c\u5e94\u8be5\u53ef\u4ee5\u6b63\u5e38\u767b\u9646\uff0c\u5305\u62ec\u533f\u540d\u548clinux\u7528\u6237\u540d\u53ef\u4ee5\u3002<\/p>\n
\u6dfb\u52a0\u4ee5\u4e0b\u4e24\u884c<\/p>\n
AllowStoreRestart on
\u91cd\u65b0\u542f\u52a8\u4ee5\u4e0bproftp\uff0c\u5c31\u53ef\u4ee5\u6b63\u5e38\u7eed\u4f20\u6587\u4ef6\u4e86\u3002<\/p>\n
ok<\/p>\n
\u8fd9\u4e2a\u547d\u4ee4\u8fd8\u662f\u6bd4\u8f83\u5b9e\u7528\u7684\uff0c\u56e0\u4e3a\u4f60\u53ef\u80fd\u9700\u8981\u4e0d\u65ad\u7684\u8c03\u6574\u4f60\u7684\u670d\u52a1\u5668\uff0c\u800c\u8fd9\u4e2a\u547d\u4ee4\u5c31\u975e\u5e38\u7075\u6d3b\uff0c\u53ef\u4ee5\u5728\u4e0d\u505c\u6b62proftpd\u8fdb\u7a0b\u7684\u524d\u63d0\u4e0b\uff0c\u5b9a\u65f6\u505c\u6b62ftp\u8fde\u63a5\uff0c\u8fd9\u91cc\u5c06\u4f1a\u8be6\u7ec6\u8bf4\u5b83\u662f\u600e\u4e48\u4f7f\u7528\u7684\u3002<\/p>\n
-d min: \u5728ftp\u5173\u95ed\u670d\u52a1\u4e4b\u524d\u7684\u51e0\u5206\u949f\u5185\uff0c\u5df2\u7ecf\u5efa\u7acb\u7684ftp\u8fde\u63a5\u5c06\u88ab\u4e2d\u6b62
time: \u5728\u591a\u5c11\u65f6\u95f4\u540e\uff0c\u670d\u52a1\u5668\u5c06\u5173\u95edftp\u670d\u52a1\uff0c\u683c\u5f0f\u6709\u4e24\u79cd
\uff0bnumber \u7ecf\u8fc7number\u5206\u949f\u540e\u5173\u95ed
MMHH \u5728\u4eca\u5929MM\uff1aHH\u670d\u52a1\u5668\u5c06\u5173\u95ed<\/p>\n
\u518d\u7ecf\u8fc730\u5206\u949f\u540e\uff0cFTP\u670d\u52a1\u5c06\u5173\u95ed\uff0c\u5728\u8fd9\u4e4b\u524d\u768420\u5206\u949f\u4e0d\u53ef\u63a5\u53d7\u4efb\u4f55\u65b0\u7684ftp\u8fde\u63a5\uff0c\u5df2\u7ecf\u5efa\u7acb\u7684\u5728\u670d\u52a1\u5173\u95ed\u524d10\u5206\u949f\u5f3a\u5236\u65ad\u7ebf\uff0c\u5e76\u5728\u5ba2\u6237\u7aef\u663e\u793a“FTP Server Will shutdown at time”<\/p>\n
\u76f4\u63a5<\/p>\n
\u8bbe\u7f6e\u9879\u76ee1 \u53c2\u65701
\u8bbe\u7f6e\u9879\u76ee2 \u53c2\u65702<\/p>\n
<Directory \"\u8def\u5f84\u540d\">
...
...
<\/Directory><\/p>\n
<Anonymous \"\u533f\u540d\u767b\u9646\u7684\u76ee\u5f55\">
...
...
<Limit \u9650\u5236\u52a8\u4f5c>
...
...
<\/Limit>
<\/Anonymous><\/p>\n
MKD\uff1aMaKe Directory \u5efa\u7acb\u76ee\u5f55\u7684\u6743\u9650
RNFR\uff1a ReName FRom \u66f4\u6539\u76ee\u5f55\u540d\u7684\u6743\u9650
DELE\uff1aDELEte \u5220\u9664\u6587\u4ef6\u7684\u6743\u9650
RMD\uff1aReMove Directory \u5220\u9664\u76ee\u5f55\u7684\u6743\u9650
RETR\uff1aRETRieve \u4ece\u670d\u52a1\u7aef\u4e0b\u8f7d\u5230\u5ba2\u6237\u7aef\u7684\u6743\u9650
STOR\uff1aSTORe \u4ece\u5ba2\u6237\u7aef\u4e0a\u4f20\u5230\u670d\u52a1\u7aef\u7684\u6743\u9650
READ\uff1a\u53ef\u8bfb\u7684\u6743\u9650\uff0c\u4e0d\u5305\u62ec\u5217\u76ee\u5f55\u7684\u6743\u9650\uff0c\u76f8\u5f53\u4e8eRETR\uff0cSTAT\u7b49
WRITE\uff1a\u5199\u6587\u4ef6\u6216\u8005\u76ee\u5f55\u7684\u6743\u9650\uff0c\u5305\u62ecMKD\u548cRMD
DIRS\uff1a\u662f\u5426\u5141\u8bb8\u5217\u76ee\u5f55\uff0c\u76f8\u5f53\u4e8eLIST\uff0cNLST\u7b49\u6743\u9650\uff0c\u8fd8\u662f\u6bd4\u8f83\u5b9e\u7528\u7684
ALL\uff1a\u6240\u6709\u6743\u9650
LOGIN\uff1a\u662f\u5426\u5141\u8bb8\u767b\u9646\u7684\u6743\u9650
\u9488\u5bf9\u4e0a\u9762\u8fd9\u4e2aLimit\u6240\u5e94\u7528\u7684\u5bf9\u8c61\uff0c\u53c8\u5305\u62ec\u4ee5\u4e0b\u8303\u56f4 <\/p>\n
DenyUser \u9488\u5bf9\u67d0\u4e2a\u7528\u6237\u7981\u6b62\u7684Limit
AllowGroup \u9488\u5bf9\u67d0\u4e2a\u7528\u6237\u7ec4\u5141\u8bb8\u7684Limit
DenyGroup \u9488\u5bf9\u67d0\u4e2a\u7528\u6237\u7ec4\u7981\u6b62\u7684Limit
AllowAll \u9488\u5bf9\u6240\u6709\u7528\u6237\u7ec4\u5141\u8bb8\u7684Limit
DenyAll \u9488\u5bf9\u6240\u6709\u7528\u6237\u7981\u6b62\u7684Limit
\u5173\u4e8e\u9650\u5236\u901f\u7387\u7684\u53c2\u6570\u4e3a\uff1a <\/p>\n
2\u3002\u5141\u8bb8ftpusers\u7528\u6237\u7ec4\u53ea\u80fd\u8bbf\u95ee\u81ea\u5df1\u7684\u76ee\u5f55\uff0c\u800c\u4e0d\u80fd\u8bbf\u95ee\u4e0a\u7ea7\u6216\u8005\u5176\u4ed6\u76ee\u5f55\uff1b
3\u3002\u7528\u6237\u767b\u9646\u670d\u52a1\u5668\u65f6\u4e0d\u663e\u793aftp\u670d\u52a1\u5668\u7248\u672c\u4fe1\u606f\uff0c\u4ee5\u589e\u52a0\u5b89\u5168\u6027\uff1b
4\u3002\u5efa\u7acb\u4e00\u4e2akaoyan\u7684ftp\u5e10\u6237\uff0c\u5c5e\u4e8eftpusers\u7ec4\uff0ckaoyan\u7528\u6237\u53ea\u5141\u8bb8\u4e0b\u8f7d\uff0c\u6ca1\u6709\u53ef\u5199\u7684\u6743\u9650\u3002\u4e0b\u8f7d\u901f\u7387\u9650\u5236\u572850Kbytes\/s\u3002
5\u3002\u5efa\u7acb\u4e00\u4e2aupload\u7528\u6237\uff0c\u4e5f\u5c5e\u4e8eftpusers\u7ec4\uff0c\u540ckaoyan\u7528\u6237\u7684\u5bbf\u4e3b\u76ee\u5f55\u4e00\u6837\uff0c\u5141\u8bb8upload\u7528\u6237\u4e0a\u4f20\u6587\u4ef6\u548c\u521b\u5efa\u76ee\u5f55\u7684\u6743\u9650\uff0c\u4f46\u4e0d\u5141\u8bb8\u4e0b\u8f7d\uff0c\u5e76\u4e14\u4e0d\u5141\u8bb8\u5220\u9664\u76ee\u5f55\u548c\u6587\u4ef6\u7684\u6743\u9650\uff0c\u4e0a\u4f20\u7684\u901f\u7387\u63a7\u5236\u5728100Kbytes\/s<\/p>\n
useradd -d \/home\/kaoyan -g ftpusers -s \/bin\/fales kaoyan
useradd -d \/home\/kaoyan -g ftpusers -s \/bin\/fales upload
chown -R kaoyan:upload \/home\/kaoyan
chmod -R 775 \/home\/kaoyan
\u5982\u679c\u4f60\u53ea\u60f3ftpusers\u7ec4\u7684\u7528\u6237\u8bbf\u95ee\uff0c\u53ef\u4ee5\u8bbe\u7f6e\u6210770\u90fd\u884c\u3002
\u8bbe\u7f6e\/usr\/local\/proftpd\/etc\/proftpd.conf<\/p>\n
ServerType standalone
DefaultServer on
Port 21
Umask 022
MaxInstances 30 #\u6700\u591a\u670930\u4e2aproftpd\u7684PID
User nobody
Group nobody
TimeoutStalled 10
MaxClients 10 #\u6700\u591a\u5141\u8bb810\u4e2a\u7528\u6237\u5728\u7ebf
MaxClientsPerHost 1 \"\u5bf9\u4e0d\u8d77\uff0c\u4e00\u4e2aIP\u53ea\u5141\u8bb8\u4e00\u4e2a\u8fde\u63a5\"
AllowStoreRestart on
#\u5141\u8bb8\u65ad\u70b9\u7eed\u4f20\uff08\u4e0a\u4f20\uff09\uff0c\u65ad\u70b9\u7eed\u7eed\uff08\u4e0b\u8f7d\uff09\u662f\u9ed8\u8ba4\u652f\u6301\u7684\uff0c\u4e0d\u7528\u8bbe\u7f6e
DisplayLogin welcome.msg #\u6b22\u8fce\u8bcd\u6587\u4ef6
ServerIdent off #\u5c4f\u853d\u670d\u52a1\u5668\u7248\u672c\u4fe1\u606f
DefaultRoot ~ ftpusers #\u8bbe\u7f6eftpusers\u7ec4\u53ea\u80fd\u8bbf\u95ee\u81ea\u5df1\u7684\u76ee\u5f55<\/p>\n
AllowOverwrite on
<\/Directory>
<Directory \/home\/kaoyan>
<Limit WRITE> #\u4e0d\u5141\u8bb8\u5199
DenyUser kaoyan
<\/Limit>
<Limit RMD RNFR DELE RETR> #\u4e0d\u5141\u8bb8\u5220\u9664\uff0c\u6539\u540d\uff0c\u4e0b\u8f7d
DenyUser upload
<\/Limit>
TransferRate RETR 50 user kaoyan
TransferRate STOR 100 user upload
<\/Directory><\/p>\n
#MaxHostsPerUser \u5bf9\u9632\u6b62ftp\u5e10\u53f7\u8fd8\u662f\u6bd4\u8f83\u6709\u7528\u7684\u3002<\/p>\n
#\u8fd9\u4e2a\u53c2\u6570\u53ef\u4ee5\u9632\u6b62\u591a\u7ebf\u7a0b\u8f6f\u4ef6\u4e0b\u8f7d\u5bf9\u670d\u52a1\u5668\u7684\u7834\u574f<\/p>\n
#\u6bd4\u5982ftp\u670d\u52a1\u7aef\u6709\u597d\u591a\u5e10\u6237\u4f60\u90fd\u6709\uff0c\u4f46\u4e5f\u53ea\u80fd\u75281\u4e2a\u5e10\u53f7\u767b\u9646<\/p>\n
#\u662f\u5426\u8981\u628aftp\u8bb0\u5f55\u5728\u65e5\u5fd7\u4e2d\uff0c\u5982\u679c\u4e0d\u60f3\u53ef\u4ee5\u8bbe\u7f6e\u6210off\u5c4f\u853d\u6389log\u65e5\u5fd7\u3002<\/p>\n
#\u5ba2\u6237\u7aefidel\u65f6\u95f4\u8bbe\u7f6e\uff0c\u9ed8\u8ba4\u5c31\u662f600\u79d2<\/p>\n
#\u8bbe\u7f6eftp\u767b\u9646\u6b22\u8fce\u4fe1\u606f\u6587\u4ef6<\/p>\n
%F \u6240\u5728\u786c\u76d8\u5269\u4e0b\u7684\u5bb9\u91cf
%C \u76ee\u524d\u6240\u5728\u7684\u76ee\u5f55
%R Client \u7aef\u7684\u4e3b\u673a\u540d\u79f0
%L Server \u7aef\u7684\u4e3b\u673a\u540d\u79f0
%U \u4f7f\u7528\u8005\u5e10\u6237\u540d\u79f0
%M \u6700\u5927\u5141\u8bb8\u8fde\u63a5\u4eba\u6570
%N \u76ee\u524d\u7684\u670d\u52a1\u5668\u8fde\u63a5\u4eba\u6570
%E FTP\u670d\u52a1\u5668\u7ba1\u7406\u5458\u7684 email
%i \u672c\u6b21\u4e0a\u4f20\u7684\u6587\u4ef6\u6570\u91cf
%o \u672c\u6b21\u4e0b\u8f7d\u7684\u6587\u4ef6\u6570\u91cf
%t \u672c\u6b21\u4e0a\u4f20+\u4e0b\u8f7d\u7684\u6587\u4ef6\u6570\u91cf<\/p>\n
\u76ee\u524d\u65f6\u95f4\u662f\uff1a%T\uff1b
\u672c\u670d\u52a1\u5668\u6700\u591a\u5141\u8bb8%M\u4e2a\u7528\u6237\u8fde\u63a5\u6570\uff1b
\u76ee\u524d\u670d\u52a1\u5668\u4e0a\u5df2\u6709%N\u4e2a\u7528\u6237\u8fde\u63a5\u6570\uff1b
\u76ee\u524d\u4f60\u6240\u5728\u7684\u76ee\u5f55\u662f%C;
\u76ee\u5f55\u6240\u5728\u7684\u786c\u76d8\u8fd8\u5269\u4e0b%F\u5b57\u8282\u3002<\/p>\n
\u53ea\u8981\u5728\u670d\u52a1\u7aef\u8bbe\u7f6e<\/p>\n
\u5982\u4f55\u7981\u6b62\u67d0\u4e2a\u5730\u5740\u8bbf\u95eeftp
\u6bd4\u5982\u7981\u6b6210.1.1\u7f51\u6bb5\u7684\u673a\u5668\u8bbf\u95eeftp\uff0c\u53ef\u4ee5\u8fd9\u4e48\u8bbe\u7f6e<\/p>\n
Order deny,allow
Deny from 10.1.1.
Allow from all
<\/Limit><\/p>\n
ServerName \"Frank FTP Server\"
Port 5555
...
<Directory \u76ee\u5f55>
...
<Limit \u52a8\u4f5c>
...
<\/Limit>
...
<\/Directory>
<\/VirtualHost><\/p>\n
\u8981\u5b9e\u73b0\u529f\u80fd\u6ce8\u610f\u7f16\u8bd1\u7684\u65f6\u5019\u52a0\u5165ratio\u6a21\u5757\uff0c\u5426\u5219proftp\u9ed8\u8ba4\u662f\u4e0d\u652f\u6301\uff0c\u5047\u8bbe\u6709\u4e2a\u5e10\u6237ftp1\u7684ftp\u76ee\u5f55\u5728\/home\/kaoyan \uff0c\u7136\u540e\u6211\u4eec\u8bbe\u7f6eftp1\u7684\u4e0a\u4f20\/\u4e0b\u8f7d\u6bd4\u7387\u662f1\uff1a2\uff08\u5373\u4e0a\u4f201M\uff0c\u5c31\u53ef\u4ee5\u4e0b\u8f7d2M\uff09<\/p>\n
touch \/home\/kaoyan\/ratio.tmp
chmod -R 666 \/home\/kaoyan
\u5728proftpd.conf\u8bbe\u7f6e\u5982\u4e0b<\/p>\n
SaveRatios on
RatioFile \/home\/kaoyan\/ratio.dat
RatioTempFile \/home\/kaoyan\/ratio.tmp<\/p>\n
#UserRatio \"\u4f7f\u7528\u8005\u5e10\u6237\" fileratio filequota byteratio bytequota
#\u3000 fileratio \uff1a\u4ee5\u6587\u4ef6\u4e3a\u57fa\u7840\u7684\u6bd4\u7387\uff0c\u901a\u5e38\u4e0d\u9650\u5236\uff0c\u6545\u4e3a 0
#\u3000 filequota \uff1a\u9884\u8bbe\u7f6e\u80fd\u4e0b\u8f7d\u591a\u5c11\u6587\u4ef6\uff0c\u4e0d\u9650\u5236\u65f6\u4e3a 0
#\u3000 byteratio \uff1a\u5c31\u662f\u4e0a\u4f20\/\u4e0b\u8f7d\u7684\u6bd4\u4f8b,\u5982\u679c\u6570\u5b57\u4e3a2\uff0c\u8868\u793a1:2
#\u3000 bytequota \uff1a\u9884\u8bbe\u7f6e\u80fd\u4e0b\u8f7d\u591a\u5c11 KBytes \u7684\u6587\u4ef6
#\u4e0a\u9762\u8bbe\u7f6e\u7684\u5c31\u662f1\uff1a2\u7684\u6bd4\u7387\uff0c\u9ed8\u8ba4\u53ea\u5141\u8bb8\u4e0b\u8f7d1M\u7684\u6587\u4ef6<\/p>\n
adduser -u 5500 -s \/bin\/false -d \/bin\/null -c \"proftpd user\" -g ftpgroup ftpuser
2.\u64cd\u4f5c\u6570\u636e\u5e93<\/p>\n
create database ftpdb
grant select, update on ftpdb.* to proftpd@localhost<\/a> identified by 'password'
use ftpdb<\/p>\n
`groupname` varchar(16) NOT NULL default '',
`gid` smallint(6) NOT NULL default '5500',
`members` varchar(16) NOT NULL default '',
KEY `groupname` (`groupname`)
) TYPE=MyISAM COMMENT='ProFTP group table';<\/p>\n
`name` varchar(30) default NULL,
`quota_type` enum('user','group','class','all') NOT NULL default 'user',
`per_session` enum('false','true') NOT NULL default 'false',
`limit_type` enum('soft','hard') NOT NULL default 'soft',
`bytes_in_avail` float NOT NULL default '0',
`bytes_out_avail` float NOT NULL default '0',
`bytes_xfer_avail` float NOT NULL default '0',
`files_in_avail` int(10) unsigned NOT NULL default '0',
`files_out_avail` int(10) unsigned NOT NULL default '0',
`files_xfer_avail` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;<\/p>\n
`name` varchar(30) NOT NULL default '',
`quota_type` enum('user','group','class','all') NOT NULL default 'user',
`bytes_in_used` float NOT NULL default '0',
`bytes_out_used` float NOT NULL default '0',
`bytes_xfer_used` float NOT NULL default '0',
`files_in_used` int(10) unsigned NOT NULL default '0',
`files_out_used` int(10) unsigned NOT NULL default '0',
`files_xfer_used` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;<\/p>\n
`id` int(10) unsigned NOT NULL auto_increment,
`userid` varchar(32) NOT NULL default '',
`passwd` varchar(32) NOT NULL default '',
`uid` smallint(6) NOT NULL default '5500',
`gid` smallint(6) NOT NULL default '5500',
`homedir` varchar(255) NOT NULL default '',
`shell` varchar(16) NOT NULL default '\/sbin\/nologin',
`count` int(11) NOT NULL default '0',
`accessed` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='ProFTP user table' ;<\/p>\n
Port 21<\/p>\n
MaxLoginAttempts 3<\/p>\n
Group nobody<\/p>\n
MaxClientsPerUser 2 \"Only one such user at a time.\"
MaxClientsPerHost 3 \"Sorry, you may not connect more than one time.\"<\/p>\n
RequireValidShell off
TimeoutStalled 10
MaxClients 10
AllowForeignAddress on
AllowStoreRestart on
ServerIdent off
DefaultRoot ~ ftpgroup<\/p>\n
#Backend\u8868\u793a\u7528\u6237\u8ba4\u8bc1\u65b9\u5f0f\u4e3aMySQL\u6570\u636e\u5e93\u7684\u8ba4\u8bc1\u65b9\u5f0f
#Plaintext\u8868\u793a\u660e\u6587\u8ba4\u8bc1\u65b9\u5f0f\uff0c\u6392\u5728\u6700\u524d\u9762\u7684\u4e3a\u6700\u5148\u4f7f\u7528\u7684\u65b9\u5f0f
SQLAuthenticate users* groups*<\/p>\n
SQLConnectInfo ftpdb@localhost<\/a> proftpd password
SQLUserInfo ftpuser userid passwd uid gid homedir shell
SQLGroupInfo ftpgroup groupname gid members
SQLHomedirOnDemand on
#\u5982\u679c\u7528\u6237\u4e3b\u76ee\u5f55\u4e0d\u5b58\u5728\uff0c\u5219\u7cfb\u7edf\u4f1a\u6839\u636e\u6b64\u7528\u6237\u5728\u7528\u6237\u6570\u636e\u8868\u4e2d\u7684homedir\u5b57\u6bb5\u7684\u503c\u65b0\u5efa\u4e00\u4e2a\u76ee\u5f55
# 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<\/p>\n
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_avai
l, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM ftpquotalimits WHERE name = '%{0}'
AND quota_type = '%{1}'\"<\/p>\n
n_used, files_out_used, files_xfer_used FROM ftpquotatallies WHERE name = '%{0}' AND quota_type = '%{1}'\"<\/p>\n
+ %{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}'\" ftpquota
tallies<\/p>\n
QuotaTallyTable sql:\/get-quota-tally\/update-quota-tally\/insert-quota-tally<\/p>\n
\u5927\u5bb6\u53ef\u4ee5\u5728phpmyadmin\u91cc\u76f4\u63a5\u64cd\u4f5c\u6dfb\u52a0\u4e00\u4e2a\u7528\u6237\uff0c\u76f8\u4fe1\u4e0d\u7528\u6211\u6559\u5927\u5bb6\u600e\u4e48\u6dfb\u52a0\u5427\uff1a\uff09<\/p>\n
name\uff1a - \u7528\u6237\u5e10\u53f7
quota type\uff1a - user, group, class, all (we use user)
per_session\uff1a - true or false (we use true)
limit_type\uff1a - \u786c\u9650\u5236 or \u8f6f\u9650\u5236 (\u6211\u4eec\u4e00\u822c\u7528\u786c\u9650\u5236)
bytes_in_avail\uff1a - \u5141\u8bb8\u4e0a\u4f20\u7684\u5b57\u8282\u6570
bytes_out_avail\uff1a - \u5141\u8bb8\u4e0b\u8f7d\u7684\u5b57\u8282\u6570
bytes_xfer_avail\uff1a - \u5141\u8bb8\u4f20\u8f93\u7684\u5b57\u8282\u6570\uff08\u5305\u62ec\u4e0a\u4f20\/\u4e0b\u8f7d\uff09
files_in_avail\uff1a - \u5141\u8bb8\u4e0a\u4f20\u7684\u6587\u4ef6\u6570
files_out_avail\uff1a - \u5141\u8bb8\u4e0b\u8f7d\u7684\u6587\u4ef6\u6570
files_xfer_avail\uff1a - \u5141\u8bb8\u4f20\u8f93\u7684\u6587\u4ef6\u6570\uff08\u5305\u62ec\u4e0a\u4f20\/\u4e0b\u8f7d\uff09<\/p>\n
<\/a>\u4e0b\u8f7dftpdb.sql
<\/a>\u53ea\u662f\u6211\u7684\u6570\u636e\u5e93\u8868\u91cc\u5bf9\u5e94\u7684uid\u548cgid\u90fd\u662f5500\uff0c\u5927\u5bb6\u53ef\u6839\u636e\u81ea\u5df1\u7684\u60c5\u51b5\u4fee\u6539\uff1a\uff09\u6ce8\u610f\u6d88\u5316\u54e6\u3002<\/p>\n