{"id":533,"date":"2011-07-13T12:10:38","date_gmt":"2011-07-13T04:10:38","guid":{"rendered":"http:\/\/nick.workao.org\/?p=533"},"modified":"2011-07-13T12:10:38","modified_gmt":"2011-07-13T04:10:38","slug":"debianubuntu%e5%ae%89%e8%a3%85-vsftpdmysql%e8%99%9a%e6%8b%9f%e7%94%a8%e6%88%b7","status":"publish","type":"post","link":"http:\/\/nick.txtcc.com\/index.php\/linux\/533","title":{"rendered":"debian\/ubuntu\u5b89\u88c5 vsftpd+mysql\u865a\u62df\u7528\u6237"},"content":{"rendered":"

1,\u9700\u8981\u7684\u8f6f\u4ef6\u5305<\/p>\n

1),vsftpd<\/p>\n

very secure FTP daemon<\/p>\n

2),mysql-server,mysql-client<\/p>\n

\u524d\u8005\u662fMySQL\u6570\u636e\u5e93\u670d\u52a1\u5668,\u7528\u4e8e\u5b58\u50a8\u865a\u62df\u7528\u6237\u4fe1\u606f,\u540e\u8005\u63d0\u4f9b\u4e00\u4e2a\u547d\u4ee4\u884c\u7684MySQL Client. \u7531\u4e8e\u6211\u4e4b\u524d\u914d\u7f6epostfix\u65f6,\u5df2\u7ecf\u5b89\u88c5\u8fc7\u4e86MySQL,\u6240\u4ee5\u6211\u4e0d\u5fc5\u5b89\u88c5\u8fd9\u4e2a\u5305\u4e86^_^<\/p>\n

3),libpam-mysql<\/p>\n

vsftpd\u662f\u901a\u8fc7PAM\u9a8c\u8bc1\u7528\u6237\u4fe1\u606f\u7684,\u8fd9\u4e2a\u5305\u53ef\u4ee5\u8ba9PAM\u53bb\u8bfb\u53d6MySQL\u5b8c\u6210\u9a8c\u8bc1.<\/p>\n

2,\u5b89\u88c5<\/p>\n

\u4ee5root\u767b\u5f55Debian,\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4,\u641e\u5b9a~<\/p>\n

\u4ee3\u7801:#apt-get install vsftpd,libpam-mysql<\/p>\n

3,\u521b\u5efa\u4e00\u4e2a\u5fc5\u8981\u7684\u672c\u5730\u7528\u6237<\/p>\n

\u867d\u8bf4\u662f\u865a\u62df\u7528\u6237,\u4e0d\u8fc7,\u7531\u4e8e\u865a\u62df\u7528\u6237\u7684\u4fe1\u606f\u5b58\u50a8\u5728MySQL\u6570\u636e\u5e93\u4e2d\uff0c\u6240\u4ee5\u8fd8\u662f\u9700\u8981\u4e00\u4e2a\u80fd\u591f\u8bfb\u53d6MySQL\u6570\u636e\u5e93\u7684\u672c\u5730\u7528\u6237.<\/p>\n

1),\u521b\u5efa\u672c\u5730\u7528\u6237\u7684\u5bb6\u76ee\u5f55,\u6b64\u76ee\u5f55\u4e5f\u662fFTP\u7684\u5bb6\u76ee\u5f55<\/p>\n

\u4ee3\u7801:#mkdir \/home\/ftp<\/p>\n

2),\u521b\u5efa\u540d\u4e3aftpguest\u7684\u672c\u5730\u7528\u6237<\/p>\n

\u4ee3\u7801:#useradd ftpguest -d \/home\/ftp<\/p>\n

3),\u4fee\u6539FTP\u5bb6\u76ee\u5f55\u7684\u6240\u6709\u8005\u548c\u7ec4<\/p>\n

\u4ee3\u7801:#chown ftpguest.nogroup \/home\/ftp<\/p>\n

4,\u914d\u7f6eMySQL\u6570\u636e\u5e93<\/p>\n

1),\u521b\u5efa\u7528\u4e8e\u5b58\u50a8\u865a\u62df\u7528\u6237\u4fe1\u606f\u7684\u6570\u636e\u5e93ftpvuser<\/p>\n

\u4ee3\u7801:#mysqladmin -u root -p create ftpvuser<\/p>\n

2),\u8fde\u63a5\u6570\u636e\u5e93<\/p>\n

\u4ee3\u7801:#mysql -u root -p<\/p>\n

3)\u521b\u5efa\u7528\u4e8e\u5b58\u50a8\u865a\u62df\u7528\u6237\u4fe1\u606f\u7684\u8868users<\/p>\n

\u4ee3\u7801:mysql>use ftpvuser;\nmysql>CREATE TABLE users (username varchar(20) NOT NULL,password varchar(40) NOT NULL,PRIMARY KEY (username)) TYPE=MyISAM;<\/p>\n

4)\u8ba9\u672c\u5730\u7528\u6237ftpguest\u80fd\u8bfb\u53d6ftpvuser\u6570\u636e\u5e93\u7684users\u8868\u7684\u5185\u5bb9<\/p>\n

\u6ce8:YourPassword\u7528\u4e8e\u8bbe\u5b9aftpguest\u8bbf\u95ee\u6570\u636e\u5e93\u7684\u5bc6\u7801.<\/p>\n

\u4ee3\u7801:mysql>grant select on ftpvuser.users to ftpguest@localhost identified by ‘YourPassword’;\nmysql>flush privileges;<\/p>\n

5),\u5efa\u7acb\u865a\u62df\u7528\u6237<\/p>\n

\u4ee3\u7801:mysql>insert into users (username,password) values (‘normal’,’555555′);\nmysql>insert into users (username,password) values (‘admin’,’666666′);\nmysql>insert into users (username,password) values (‘webmaster’,’777777′);<\/p>\n

6),\u5b8c\u6210MySQL\u7684\u914d\u7f6e<\/p>\n

\u4ee3\u7801:mysql>quit;<\/p>\n

5,\u914d\u7f6evsftpd\u7684PAM\u9a8c\u8bc1<\/p>\n

1),\u6253\u5f00PAM\u914d\u7f6e\u6587\u4ef6<\/p>\n

\u4ee3\u7801:#nano \/etc\/pam.d\/vsftpd<\/p>\n

2),\u5c06\u4ee5\u524d\u7684\u5185\u5bb9\u6ce8\u91ca\u6389\uff0c\u7136\u540e\u6dfb\u52a0\u4e0b\u97622\u884c\u5185\u5bb9<\/p>\n

\u6ce8:YourPassword\u5c31\u662f\u521a\u624d\u5728\u524d\u9762\u8bbe\u5b9a\u7684ftpguest\u8bbf\u95ee\u6570\u636e\u5e93\u7684\u5bc6\u7801.<\/p>\n

\u4ee3\u7801:auth required pam_mysql.so user=ftpguest passwd=YourPassword host=localhost db=ftpvuser table=users usercolumn=username passwdcolumn=password crypt=0\naccount required pam_mysql.so user=ftpguest passwd=YourPassword host=localhost db=ftpvuser table=users usercolumn=username passwdcolumn=password crypt=0<\/p>\n

6,\u914d\u7f6evsftpd<\/p>\n

1),\u6253\u5f00vsftpd\u7684\u914d\u7f6e\u6587\u4ef6<\/p>\n

\u4ee3\u7801:#nano \/etc\/vsftpd.conf\u6ce8\u610f:\u4e00\u65e6\u4fee\u6539\u4e86\/etc\/vsftpd.conf\u6587\u4ef6\u7684\u5185\u5bb9,\u5fc5\u987b\u91cd\u542fvsftpd\u624d\u80fd\u4f7f\u65b0\u7684\u8bbe\u7f6e\u751f\u6548,\u65b9\u6cd5\u662f:<\/p>\n

\u4ee3\u7801:#\/etc\/init.d\/vsftpd stop\n#\/etc\/init.d\/vsftpd start\u76f4\u63a5#\/etc\/init.d\/vsftpd restart,\u597d\u50cf\u4e0d\u8d77\u4f5c\u7528?<\/p>\n

2),\u4fee\u6539vsftpd.conf\u6587\u4ef6\u5982\u4e0b<\/p>\n

listen=YES<\/p>\n<h1>\u5173\u95ed\u533f\u540dFTP\u767b\u5f55<\/h1>\n<p>anonymous_enable=NO<\/p>\n<p>local_enable=YES<\/p>\n<p>write_enable=YES<\/p>\n<p>local_umask=022<\/p>\n<p>dirmessage_enable=YES<\/p>\n<p>use_localtime=YES<\/p>\n<p>xferlog_enable=YES<\/p>\n<p>connect_from_port_20=YES<\/p>\n<h1>\u7981\u6b62\u7528\u6237\u8df3\u51fa\u81ea\u5df1\u7684\u76ee\u5f55<\/h1>\n<p>chroot_local_user=YES<\/p>\n<p>secure_chroot_dir=\/var\/run\/vsftpd\/empty<\/p>\n<p>pam_service_name=vsftpd<\/p>\n<p>rsa_cert_file=\/etc\/ssl\/private\/vsftpd.pem<\/p>\n<h1>My config to add virtual users support.<\/h1>\n<p>guest_enable=YES<\/p>\n<p>guest_username=vuser<\/p>\n<p>local_root=\/home\/vuser\/$USER<\/p>\n<p>user_sub_token=$USER<\/p>\n<p>virtual_use_local_privs=YES<\/p>\n<p>user_config_dir=\/etc\/vsftpd_user_conf<\/code><\/p>\n

\u5efa\u7acb\u65b0\u7528\u6237<\/p>\n

    \n
  1. \u5728accounts\u8868\u4e2d\u52a0\u5165\u7528\u6237\u3002\u8fd0\u884cSQL<\/li>\n<\/ol>\n

    INSERT INTO accounts<\/code> (username<\/code>, pass<\/code>) VALUES (‘testuser’, ‘testpw’);<\/p>\n

      \n
    1. \n

      sudo mkdir \u2013p \/home\/vuser\/testuser<\/p>\n<\/li>\n

    2. \n

      sudo chown vuser:vuser \/home\/vuser\/testuser<\/p>\n<\/li>\n<\/ol>","protected":false},"excerpt":{"rendered":"

      1,\u9700\u8981\u7684\u8f6f\u4ef6\u5305 1),vsftpd very secure FTP daemon 2),mysql-server,mysql-client \u524d\u8005\u662fMySQL\u6570\u636e\u5e93\u670d\u52a1\u5668,\u7528\u4e8e\u5b58\u50a8\u865a\u62df\u7528\u6237\u4fe1\u606f,\u540e\u8005\u63d0...<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-533","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/533","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/comments?post=533"}],"version-history":[{"count":1,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/533\/revisions"}],"predecessor-version":[{"id":534,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/533\/revisions\/534"}],"wp:attachment":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/media?parent=533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/categories?post=533"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/tags?post=533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}