{"id":18165,"date":"2014-01-22T06:49:28","date_gmt":"2014-01-21T22:49:28","guid":{"rendered":"https:\/\/2blog.ilc.edu.tw\/25793\/2014\/01\/22\/%e5%bb%ba%e7%ab%8b%e5%a4%a7%e6%89%b9-pureftpd-ftp-server-%e7%9a%84-mysql-%e5%b8%b3%e8%99%9f\/"},"modified":"2014-01-22T06:49:28","modified_gmt":"2014-01-21T22:49:28","slug":"%e5%bb%ba%e7%ab%8b%e5%a4%a7%e6%89%b9-pureftpd-ftp-server-%e7%9a%84-mysql-%e5%b8%b3%e8%99%9f","status":"publish","type":"post","link":"https:\/\/2blog.ilc.edu.tw\/25793\/2014\/01\/22\/%e5%bb%ba%e7%ab%8b%e5%a4%a7%e6%89%b9-pureftpd-ftp-server-%e7%9a%84-mysql-%e5%b8%b3%e8%99%9f\/","title":{"rendered":"\u5efa\u7acb\u5927\u6279 PureFTPd FTP Server \u7684 MySQL \u5e33\u865f"},"content":{"rendered":"

\u5229\u7528 awk\u00a0\u7684\u529f\u80fd\u65b9\u4fbf\u53ef\u4ee5\u5927\u6279\u7522\u751f PureFTPd FTP Server\u00a0\u7684 MySQL\u00a0\u5e33\u865f\u7684 MySQL\u00a0\u8a9e\u6cd5\u548c\u81ea\u52d5\u5efa\u7acb\u4f7f\u7528\u8005\u76ee\u9304\u53ca\u6539\u8b8a\u76ee\u9304\u7fa4\u7d44\u53ca\u64c1\u6709\u8005\u7684\u8a9e\u6cd5\u3002<\/p>\n

\u865b\u64ec\u4f7f\u7528\u8005\u7684 UID 500
# grep virtualuser \/etc\/passwd<\/span>
virtualuser:x:500:500::\/home\/virtualuser:\/sbin\/nologin<\/span><\/p>\n

\u865b\u64ec\u7fa4\u7d44\u7684 GID 500
# grep virtualgrp \/etc\/group<\/span>
virtualgrp:x:500:<\/span><\/p>\n

\u865b\u64ec\u4f7f\u7528\u8005\u7684\u5e33\u865f\u53ca\u5bc6\u78bc\u8cc7\u6599
# cat 102_class41.lst<\/span>
\u56db\u5fe0 01 \u8521\u4e2d\u706b s0990499 123456 s0990<\/span>
\u56db\u5fe0 02 \u9673\u5927\u6c34 s0990999 234567 s0990<\/span>
[@more@]\u5efa\u7acb MySQL\u00a0\u865b\u64ec\u4f7f\u7528\u8005\u7684 SQL\u00a0\u8cc7\u6599
# vim mksql.awk<\/span>
# \u5e33\u865f\u5bc6\u78bc\u6a94\u683c\u5f0f<\/span>
# \u56db\u5fe0 01 \u8521\u4e2d\u706b s0990499 123456 s0990<\/span>
{print “insert into users values (‘”$4″‘,'”$5″‘,’500′,’500’,’\/home\/”$6″\/”$4″‘);”<\/span><\/p>\n

\u6e2c\u8a66
# awk -f mksql.awk 102_class41.lst<\/span> > 102_class41.sql<\/span>
insert into users values (‘s0990499′,’123456′,’500′,’500′,’\/home\/s0990\/s0990499’);<\/span>
insert into users values (‘s0990999′,’234567′,’500′,’500′,’\/home\/s0990\/s0990999’);<\/span><\/p>\n

\u4f7f\u7528\u65b9\u5f0f
# \/usr\/bin\/mysql -u root -p pure-ftpd < 102_class41.sql<\/span><\/p>\n

\u5efa\u7acb\u4f7f\u7528\u8005\u865b\u64ec\u76ee\u9304
# vim mkuserdir.awk<\/span>
# \u5efa\u7acb\u4f7f\u7528\u8005\u76ee\u9304<\/span>
{print “mkdir -p \/home\/”$6″\/”$4 }<\/span>
# \u66f4\u6539\u6a94\u6848\u76ee\u9304\u7684\u6240\u5c6c\u64c1\u6709\u8005\u53ca\u7fa4\u7d44<\/span>
{print “chown -R\u00a0 500:500\u00a0 \/home\/”$6″\/”$4″ ” }<\/span><\/p>\n

\u6e2c\u8a66
# awk -f mkuserdir.awk 102_class41.lst<\/span>
mkdir -p \/home\/s0990\/s0990499<\/span>
chown -R\u00a0 500:500\u00a0 \/home\/s0990\/s0990499<\/span>
mkdir -p \/home\/s0990\/s0990999<\/span>
chown -R\u00a0 500:500\u00a0 \/home\/s0990\/s0990999<\/span><\/p>\n

\u4f7f\u7528\u65b9\u5f0f
# awk -f mkuserdir.awk 102_class41.lst\u00a0 | sh<\/span><\/p>\n

\u9a57\u8b49\u76ee\u9304\u662f\u5426\u6709\u5efa\u7acb
# ls -l \/home\/s0990\/<\/span>
drwxr-xr-x. 2 virtualuser virtualgrp 4096 2014-01-02 10:58 s0990499\/<\/span>
drwxr-xr-x. 2 virtualuser virtualgrp 4096 2014-01-02 10:58 s0990999\/<\/span><\/p>\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

\u5229\u7528 awk\u00a0\u7684\u529f\u80fd\u65b9\u4fbf\u53ef\u4ee5\u5927\u6279\u7522\u751f PureFTPd FTP Server\u00a0\u7684 MySQL\u00a0\u5e33\u865f\u7684 MySQ … <\/p>\n

\u95b1\u8b80\u5168\u6587\u3008\u5efa\u7acb\u5927\u6279 PureFTPd FTP Server \u7684 MySQL \u5e33\u865f\u3009<\/span><\/a><\/p>\n","protected":false},"author":55,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[130,116,102],"tags":[],"class_list":["post-18165","post","type-post","status-publish","format-standard","hentry","category-c-78475","category-c-78461","category-c-72385"],"meta_key":{"_encloseme":["1"],"lt_post_id":["469089"]},"_links":{"self":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18165"}],"collection":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/comments?post=18165"}],"version-history":[{"count":0,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18165\/revisions"}],"wp:attachment":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/media?parent=18165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/categories?post=18165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/tags?post=18165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}