{"id":802,"date":"2008-07-26T16:16:42","date_gmt":"2008-07-26T08:16:42","guid":{"rendered":"http:\/\/blog.smallken.ink\/2008\/07\/26\/linux\/802.html"},"modified":"2008-07-26T16:33:59","modified_gmt":"2008-07-26T08:33:59","slug":"%e6%9e%b6%e8%a8%ad-pureftpd-with-mysql-%e8%99%9b%e6%93%acftp%e5%b8%b3%e8%99%9f-on-fedora-9","status":"publish","type":"post","link":"https:\/\/blog.smallken.site\/?p=802","title":{"rendered":"\u67b6\u8a2d PureFTPd With MySQL \u865b\u64ecFTP\u5e33\u865f On Fedora 9"},"content":{"rendered":"

\u9019\u7bc7\u8981\u793a\u7bc4\u7684\u662f\u67b6\u8a2d\u4e00\u500bFTP\u7ad9\uff0c\u9019\u500bFTP\u7ad9\u5e33\u865f\u8cc7\u6599\u4f7f\u7528MySQL\u8cc7\u6599\u5eab\u4f86\u7ba1\u7406\uff0c\u9019\u6a23\u4e00\u4f86\u6211\u5011\u53ef\u4ee5\u505a\u5f88\u5f48\u6027\u7684\u904b\u7528\uff0c\u6bd4\u5982\u8aaa\u5e33\u865f\u4eba\u6578\u53ef\u4ee5\u4e0a\u7121\u9650\u3001\u4e0a\u4e0b\u50b3\u6d41\u91cf\u63a7\u7ba1\u3001QUOTA\u7a7a\u9593\u9650\u5236\u7b49\u7b49\u3002<\/p>\n

\u5047\u8a2d\u60a8\u5df2\u7d93\u88dd\u597d\u4e86Fedora 9 \u4f5c\u696d\u7cfb\u7d71\uff0c\u53ef\u4ee5\u9023\u4e0a\u7db2\u8def\uff0cIP \u4f4d\u5740\u70ba 192.168.1.249<\/p>\n

1.\u5b89\u88dd httpd\u3001Mysql \u8207 phpMyAdmin<\/p>\n

# yum install mysql mysql-server phpMyAdmin httpd
.
.
Updated: php.i386 0:5.2.6-2.fc9 php-cli.i386 0:5.2.6-2.fc9 php-common.i386 0:5.2.6-2.fc9 php-ldap.i386 0:5.2.6-2.fc9 php-mysql.i386 0:5.2.6-2.fc9 php-pdo.i386 0:5.2.6-2.fc9
Complete!<\/p>\n

2.\u7de8\u8f2f \/etc\/httpd\/conf.d\/phpMyAdmin.conf\uff0c\u9810\u8a2d phpMyAdmin \u53ea\u51c6\u672c\u6a5fIP\u9023\u7dda\uff0c\u6211\u5011\u8981\u6539\u6210\u958b\u653e\u6240\u6709IP\u9023\u7dda\uff0c\u90e8\u5206\u8a2d\u5b9a\u8981\u8a3b\u89e3\u6389\u3002
# vi \/etc\/httpd\/conf.d\/phpMyAdmin.conf<\/p>\n

Alias \/phpMyAdmin \/usr\/share\/phpMyAdmin
Alias \/phpmyadmin \/usr\/share\/phpMyAdmin
#<\/font><Directory \/usr\/share\/phpMyAdmin\/>
#<\/font>   order deny,allow
#<\/font>   deny from all
#<\/font>   allow from 127.0.0.1
#<\/font><\/Directory> <\/p>\n

3.\u555f\u52d5 MySQL Server\uff0c\u4e26\u8a2d\u5b9a\u958b\u6a5f\u81ea\u52d5\u555f\u52d5
# service mysqld start
# chkconfig mysqld on<\/p>\n

4.\u555f\u52d5 httpd Server\uff0c\u4e26\u8a2d\u5b9a\u958b\u6a5f\u81ea\u52d5\u555f\u52d5
# service httpd start
# chkconfig httpd on<\/p>\n

5.\u767b\u5165MySQL Server\uff0c\u8a2d\u5b9a root \u5bc6\u78bc
# mysql mysql<\/p>\n

mysql> use mysql
Database changed
mysql> update user set password=password(“\u65b0\u5bc6\u78bc<\/font>“) where user=”root”;
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye <\/p>\n

6.\u5b89\u88dd PureFTPd
# yum install pure-ftpd
.
. <\/p>\n

Dependency Installed: postgresql-libs.i386 0:8.3.3-2.fc9
Complete! <\/p>\n

7.\u65b0\u589e\u4e00\u7d44ftpuser\u8ddfftpgroup\u7d66FTP\u767b\u5165\u6642\u7684\u7cfb\u7d71\u8eab\u4efd\u4f7f\u7528\u3002
# groupadd -g 2001 ftpgroup
# useradd -u 2001 -s \/bin\/false -d \/bin\/null -c “pureftpd user” -g ftpgroup ftpuser <\/p>\n

8.\u5728 MySQL \u4e2d\u5efa\u7acb pureftpd database\uff0c\u9019\u500b\u8cc7\u6599\u5eab\u6703\u5b58\u653e\u6240\u6709\u4f7f\u7528\u8005\u7684\u5e33\u865f\u3001\u5bc6\u78bc\u53ca\u5176\u4ed6\u63a7\u7ba1\u8cc7\u8a0a\uff0c\u9019\u88e1\u6703\u65b0\u589e\u4e00\u500b\u7ba1\u7406pureftpd database \u7684\u4f7f\u7528\u8005 pureftpd\uff0c\u4f7f\u7528\u8005 pureftpd \u7684\u5bc6\u78bc\u8a2d\u5b9a\u8acb\u81ea\u884c\u53d6\u4ee3 ftppassword<\/font>
# mysql -u root -p
Enter password: \u2190 \u8f38\u5165\u525b\u525b\u5efa\u7acb\u7684\u65b0\u5bc6\u78bc<\/font>
<\/font>mysql> CREATE DATABASE pureftpd;
<\/strong>Query OK, 1 row affected (0.07 sec) <\/p>\n

mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON pureftpd.* TO ‘pureftpd’@’localhost’ IDENTIFIED BY ‘ftppassword<\/font>‘;
<\/strong>Query OK, 0 rows affected (0.19 sec)<\/p>\n

mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON pureftpd.* TO ‘pureftpd’@’localhost.localdomain’ IDENTIFIED BY ‘ftppassword<\/font>‘;
<\/strong>Query OK, 0 rows affected (0.00 sec) <\/p>\n

mysql> FLUSH PRIVILEGES;
<\/strong>Query OK, 0 rows affected (0.00 sec) <\/p>\n

\/\/ \u63a5\u8457\u6211\u5011\u8981\u5728\u9019\u500b pureftpd database \u5efa\u7acb\u4e00\u500b ftpd table<\/font>
mysql> USE pureftpd;
<\/strong>Database changed <\/p>\n

mysql> CREATE TABLE ftpd (
    -> User varchar(16) NOT NULL default ”,
    -> status enum(‘0′,’1’) NOT NULL default ‘0’,
    -> Password varchar(64) NOT NULL default ”,
    -> Uid varchar(11) NOT NULL default ‘-1’,
    -> Gid varchar(11) NOT NULL default ‘-1’,
    -> Dir varchar(128) NOT NULL default ”,
    -> ULBandwidth smallint(5) NOT NULL default ‘0’,
    -> DLBandwidth smallint(5) NOT NULL default ‘0’,
    -> comment tinytext NOT NULL,
    -> ipaccess varchar(15) NOT NULL default ‘*’,
    -> QuotaSize smallint(5) NOT NULL default ‘0’,
    -> QuotaFiles int(11) NOT NULL default 0,
    -> PRIMARY KEY (User),
    -> UNIQUE KEY User (User)
    -> ) TYPE=MyISAM;
<\/strong>Query OK, 0 rows affected, 1 warning (0.20 sec) <\/p>\n

mysql> quit;
<\/strong>Bye <\/p>\n

9.\u63a5\u8457\u6211\u5011\u4f86\u6e2c\u8a66\u4e00\u4e0b phpMyAdmin \u7684\u7ba1\u7406\u9801\u9762
http:\/\/192.168.1.249\/phpMyAdmin\/
\u5982\u679c\u6c92\u6709\u6210\u529f\uff0c\u8acb\u95dc\u6389\u9632\u706b\u7246\uff0c\u6216\u8005\u958b\u555f port 80 \u9023\u7dda
# service iptable stop  \u2190 \u95dc\u9589\u9632\u706b\u7246<\/font>
\u6216
# vi \/etc\/sysconfig\/iptables
-A INPUT -m state –state NEW -m tcp -p tcp –dport 80 -j ACCEPT \u2190 \u65b0\u589e\u4e00\u884c
<\/font># service iptables restart<\/font><\/p>\n

\u6e2c\u8a66  <\/font>http:\/\/192.168.1.249\/phpMyAdmin\/<\/a><\/p>\n

<\/p>\n

\u5982\u679c\u8df3\u51fa\u4ee5\u4e0b\u767b\u5165\u8a0a\u606f\uff0c\u8acb\u8f38\u5165\u4f7f\u7528\u8005 pureftpd\uff0c\u4ee5\u53ca\u4e4b\u524d\u8a2d\u5b9a\u7684pureftpd \u5bc6\u78bcftppassword<\/font><\/p>\n

 \"image\" <\/p>\n

\u767b\u5165\u6210\u529f\u756b\u9762
\"image\"  <\/p>\n

10.\u8a2d\u5b9a PureFTPd
# vi \/etc\/pure-ftpd\/pure-ftpd.conf
\/\/ \u78ba\u8a8d\u4fee\u6539\u6210\u5982\u4ee5\u4e0b\u4e09\u884c\uff0cChrootEveryone \u9650\u5236\u767b\u5165\u4f7f\u7528\u8005\u4e0d\u6703\u5207\u63db\u76ee\u9304\u5230\u5225\u4eba\u5bb6\u88e1\u9762\u53bb\uff0cCreateHomeDir \u82e5\u662f\u65b0\u4e00\u6b21\u767b\u5165\u7684\u4f7f\u7528\u8005\u9019\u88e1\u6703\u81ea\u52d5\u5efa\u7acb\u4f7f\u7528\u8005\u7684\u5bb6\u76ee\u9304\uff0cMySQLConfigFile \u5c31\u91cd\u8981\u4e86\uff0c\u9019\u5c31\u662f\u628a PureFTPd \u8207 MySQL \u63a5\u8d77\u4f86\u7684\u8a2d\u5b9a\u6a94           
<\/font>ChrootEveryone              yes
MySQLConfigFile               \/etc\/pure-ftpd\/pureftpd-mysql.conf
CreateHomeDir               yes<\/p>\n

11.\u5148\u5099\u4efd pureftpd-mysql.conf \u8a2d\u5b9a\u6a94\uff0c\u518d\u7de8\u8f2f pureftpd-mysql.conf \u8a2d\u5b9a\u6a94
# cp \/etc\/pure-ftpd\/pureftpd-mysql.conf \/etc\/pure-ftpd\/pureftpd-mysql.conf_bk
# vi \/etc\/pure-ftpd\/pureftpd-mysql.conf
MYSQLSocket     \/var\/lib\/mysql\/mysql.sock
MYSQLUser       pureftpd
<\/font>MYSQLPassword   ftppassword  <\/font>\u2190 \u4e4b\u524d\u8a2d\u5b9a\u7684\u5bc6\u78bc<\/font>
MYSQLDatabase   pureftpd
MYSQLCrypt      md5<\/font><\/p>\n

MYSQLGetPW      SELECT Password FROM ftpd WHERE User=”\\L” AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\\R”)<\/font><\/p>\n

MYSQLGetUID     SELECT Uid FROM ftpd WHERE User=”\\L” AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\\R”)<\/font><\/p>\n

MYSQLGetGID     SELECT Gid FROM ftpd WHERE User=”\\L”AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\\R”)<\/font><\/p>\n

MYSQLGetDir     SELECT Dir FROM ftpd WHERE User=”\\L”AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\\R”)<\/font><\/p>\n

MySQLGetBandwidthUL SELECT ULBandwidth FROM ftpd WHERE User=”\\L”AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\\R”)<\/font><\/p>\n

MySQLGetBandwidthDL SELECT DLBandwidth FROM ftpd WHERE User=”\\L”AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\\R”)<\/font><\/p>\n

MySQLGetQTASZ  SELECT QuotaSize FROM ftpd WHERE User=”\\L”AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\\R”)<\/font><\/p>\n

MySQLGetQTAFS  SELECT QuotaFiles FROM ftpd WHERE User=”\\L”AND status=”1″ AND (ipaccess = “*” OR ipaccess LIKE “\\R”)<\/font><\/p>\n

 <\/p>\n

<\/p>\n

11.\u555f\u52d5 PureFTPd\uff0c\u4e26\u8a2d\u5b9a\u958b\u6a5f\u81ea\u52d5\u555f\u52d5
# service pure-ftpd start
# chkconfig pure-ftpd on<\/p>\n

12.\u63a5\u8457\u6211\u5011\u5148\u4f86\u5efa\u7acb\u4e00\u500b\u65b0\u7684\u4f7f\u7528\u8005\uff0c\u4f7f\u7528 phpMyAdmin
\u767b\u5165 http:\/\/192.168.1.249\/phpMyAdmin\/<\/a><\/p>\n

\"62\"<\/p>\n

\"63\"<\/p>\n

\"64\"   <\/p>\n

\"61\"<\/p>\n

\u4f9d\u4f9d\u4f86\u89e3\u91cb\u6bcf\u500bftpd Table \u6b04\u4f4d\u7684\u610f\u7fa9\uff1a
User\uff1a\u4f7f\u7528\u8005\u540d\u7a31\uff0c\u4e5f\u5c31\u662f\u767b\u5165\u8005\u7684\u4f7f\u7528\u8005\u540d\u7a31
status\uff1a1 \u8868\u793a\u5e33\u865f\u6b63\u5e38\uff0c0 \u8868\u793a\u5e33\u865f\u66ab\u6642\u5c01\u9396\u4e0d\u80fd\u767b\u5165\uff0c\u8a2d\u5b9a\u9019\u500b\u6b04\u4f4d\u53ef\u4ee5\u66ab\u6642\u5c01\u9396\u67d0\u4f4d\u4f7f\u7528\u8005\u7684\u767b\u5165\u3002
Password\uff1a\u4f7f\u7528\u8005\u7684\u767b\u5165\u5bc6\u78bc\uff0c\u6211\u5011\u662f\u9078\u7528 MD5 \u5bc6\u78bc\u7de8\u78bc\u3002
UID\uff1a\u767b\u5165\u7cfb\u7d71\u7684\u8eab\u4efd\uff0c\u524d\u9762\u8a2d 2001
GID\uff1a\u767b\u5165\u7cfb\u7d71\u7684\u8eab\u4efd\uff0c\u524d\u9762\u8a2d 2001
Dir\uff1a\u8a2d\u5b9a\u4f7f\u7528\u8005\u767b\u5165\u6642\u6240\u5728\u7684\u5be6\u969b\u76ee\u9304\uff0c\u6240\u4ee5\u8981\u5f9e\u7cfb\u7d71\u7684\u6839\u76ee\u9304\u8a2d\u8d77\uff0c\u4f8b\u5982\/home\/smallken
ULBandwidth: \u4e0a\u50b3\u983b\u5bec\u9650\u5236\uff0c\u55ae\u4f4d KB\/s\uff0c\u8a2d 0 \u8868\u793a\u4e0d\u9650\u5236
DLBandwidth: \u4e0a\u50b3\u983b\u5bec\u9650\u5236\uff0c\u55ae\u4f4d KB\/s\uff0c\u8a2d 0 \u8868\u793a\u4e0d\u9650\u5236
ipaccess: \u53ef\u63a5\u53d7\u4f86\u6e90IP\u7684\u9023\u7dda\uff0c* \u8868\u793a\u5168\u90e8\u90fd\u63a5\u53d7\u3002
QuotaSize: \u76ee\u9304\u4e2d\u7684\u7a7a\u9593\u9650\u5236\uff0c\u6700\u5927\u4e0d\u8d85\u904e\u591a\u5c11MB\uff0c\u55ae\u4f4d\u662f MB\uff0c\u8a2d 0 \u8868\u793a\u4e0d\u9650\u5236
QuotaFiles: \u76ee\u9304\u4e2d\u7684\u6a94\u6848\u6578\u91cf\u9650\u5236\uff0c\u6700\u5927\u4e0d\u8d85\u904e\u591a\u5c11\u500b\u6a94\u6848\u6578\uff0c\u8a2d 0 \u8868\u793a\u4e0d\u9650\u5236<\/p>\n

\u65b0\u589e\u597d\u4f7f\u7528\u8005\u4e4b\u5f8c\uff0c\u6211\u5011\u9023\u7dda\u6e2c\u8a66\u4e00\u4e0b\uff0c\u53ef\u4ee5\u7528\u4efb\u4f55\u7684FTP Client\u767b\u5165\uff0c\u6ce8\u610f\u4e00\u4e0b\u9632\u706b\u7246
# service iptables stop \u2190 \u95dc\u9589\u9632\u706b\u7246
<\/font>
\"image\"<\/a>
\u9023\u7dda\u6210\u529f!<\/p>\n","protected":false},"excerpt":{"rendered":"

\u9019\u7bc7\u8981\u793a\u7bc4\u7684\u662f\u67b6\u8a2d\u4e00\u500bFTP\u7ad9\uff0c\u9019\u500bFTP\u7ad9\u5e33\u865f\u8cc7\u6599\u4f7f\u7528MySQL\u8cc7\u6599\u5eab\u4f86\u7ba1\u7406\uff0c\u9019\u6a23\u4e00\u4f86\u6211\u5011\u53ef\u4ee5\u505a\u5f88\u5f48\u6027\u7684\u904b\u7528…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-802","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/posts\/802","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=802"}],"version-history":[{"count":0,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=\/wp\/v2\/posts\/802\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.smallken.site\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=802"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=802"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.smallken.site\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}