{"id":18164,"date":"2014-01-21T06:13:13","date_gmt":"2014-01-20T22:13:13","guid":{"rendered":"https:\/\/2blog.ilc.edu.tw\/25793\/2014\/01\/21\/pure-ftpd-ftp-server-%e4%bd%bf%e7%94%a8-mysql-%e8%99%9b%e6%93%ac%e5%b8%b3%e8%99%9f\/"},"modified":"2014-01-21T06:13:13","modified_gmt":"2014-01-20T22:13:13","slug":"pure-ftpd-ftp-server-%e4%bd%bf%e7%94%a8-mysql-%e8%99%9b%e6%93%ac%e5%b8%b3%e8%99%9f","status":"publish","type":"post","link":"https:\/\/2blog.ilc.edu.tw\/25793\/2014\/01\/21\/pure-ftpd-ftp-server-%e4%bd%bf%e7%94%a8-mysql-%e8%99%9b%e6%93%ac%e5%b8%b3%e8%99%9f\/","title":{"rendered":"Pure-FTPd FTP Server \u4f7f\u7528 MySQL \u865b\u64ec\u5e33\u865f"},"content":{"rendered":"

Pure-FTPd FTP Server\u00a0\u4e5f\u53ef\u4ee5\u642d\u914d MySQL\u00a0\u7684\u865b\u64ec\u5e33\u865f\u4f86\u767b\u5165
\u9996\u5148\u5b89\u88dd MySQL Server
# yum install mysql mysql-server<\/span><\/p>\n

\u555f\u52d5 MySQL Server
# service mysqld start<\/span><\/p>\n

\u8a2d\u5b9a MySQL Server
# \/usr\/bin\/mysql_secure_installation<\/span>[@more@]\u8a2d\u5b9a Pure-FTPd FTP Server
# vim \/etc\/pure-ftpd\/pure-ftpd.conf<\/span>
# MySQL configuration file (see README.MySQL)<\/span>
MySQLConfigFile\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/etc\/pure-ftpd\/pureftpd-mysql.conf<\/span><\/p>\n

\u8a2d\u5b9a Pure-FTPd FTP Server\u00a0\u7684 MySQL\u00a0\u8a2d\u5b9a\u6a94
# vim \/etc\/pure-ftpd\/pureftpd-mysql.conf<\/span>
# Optional : define the location of mysql.sock if the server runs on this host.<\/span>
# MySQL Socket\u00a0\u6a94\u8def\u5f91<\/span>
MYSQLSocket\u00a0\u00a0\u00a0\u00a0 \/var\/lib\/mysql\/mysql.sock<\/span><\/p>\n

# Mandatory : user to bind the server as.<\/span>
# MySQL\u00a0\u7ba1\u7406\u8005<\/span>
MYSQLUser\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 root<\/span><\/p>\n

# Mandatory : user password. You must have a password.<\/span>
# MySQL\u00a0\u7ba1\u7406\u8005\u5bc6\u78bc<\/span>
MYSQLPassword\u00a0\u00a0 rootpw<\/span><\/p>\n

# Mandatory : database to open.<\/span>
# Pure-FTPd\u00a0\u8981\u7528\u7684\u8cc7\u6599\u5eab\u6a94\u540d<\/span>
MYSQLDatabase\u00a0\u00a0 pureftpd<\/span><\/p>\n

# Mandatory : how passwords are stored<\/span>
# Valid values are : “cleartext”, “crypt”, “md5” and “password”<\/span>
# (“password” = MySQL password() function)<\/span>
# You can also use “any” to try “crypt”, “md5” *and* “password”<\/span>
#\u00a0\u5bc6\u78bc\u7de8\u78bc\u7684\u65b9\u5f0f\uff0c\u53ef\u4ee5\u4f7f\u7528 cleartext\u00a0\u660e\u78bc \/ md5 \u4f7f\u7528 MD5 \u7de8\u78bc\u52a0\u5bc6\u00a0 \/ crypt \u7528 DES \u7de8\u78bc\u52a0\u5bc6 \/ password MySQL \u7684\u7de8\u78bc\u52a0\u5bc6<\/span>
MYSQLCrypt\u00a0\u00a0\u00a0\u00a0\u00a0 cleartext<\/span><\/p>\n

# Query to execute in order to fetch the password<\/span>
# \u865b\u64ec\u5e33\u865f\u7b26\u5408 User \u6b04\u4f4d\u6642\uff0c\u9078\u53d6\u767b\u5165\u8005\u7684\u5bc6\u78bc\u6b04\u4f4d<\/span>
MYSQLGetPW\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT Password FROM users WHERE User=’L’<\/span><\/p>\n

# Query to execute in order to fetch the system user name or uid<\/span>
# \u7576\u865b\u64ec\u5e33\u865f\u7b26\u5408 User \u6b04\u4f4d\u6642\uff0c\u9078\u53d6\u767b\u5165\u8005\u7684\u4f7f\u7528\u8005 ID<\/span>
MYSQLGetUID\u00a0\u00a0\u00a0\u00a0 SELECT Uid FROM users WHERE User=’L’<\/span><\/p>\n

# Optional : default UID – if set this overrides MYSQLGetUID<\/span><\/p>\n

#MYSQLDefaultUID 500<\/span><\/p>\n

# Query to execute in order to fetch the system user group or gid<\/span>
# \u7576\u865b\u64ec\u5e33\u865f\u7b26\u5408 User \u6b04\u4f4d\u6642\uff0c\u9078\u53d6\u767b\u5165\u8005\u7684\u7fa4\u7d44 ID<\/span>
MYSQLGetGID\u00a0\u00a0\u00a0\u00a0 SELECT Gid FROM users WHERE User=’L’<\/span><\/p>\n

# Optional : default GID – if set this overrides MYSQLGetGID<\/span>
# \u5167\u5b9a\u7684\u7fa4\u7d44 GID<\/span>
#MYSQLDefaultGID 500<\/span><\/p>\n

# Query to execute in order to fetch the home directory<\/span>
# \u7576\u865b\u64ec\u5e33\u865f\u7b26\u5408 User \u6b04\u4f4d\u6642\uff0c\u9078\u53d6\u767b\u5165\u8005\u7684\u5bb6\u76ee\u9304<\/span>
MYSQLGetDir\u00a0\u00a0\u00a0\u00a0 SELECT Dir FROM users WHERE User=’L’<\/span><\/p>\n

\u91cd\u65b0\u555f\u52d5 Pure-FTPd FTP Server
# \/etc\/init.d\/pure-ftpd restart<\/span><\/p>\n

\u5efa\u7acb\u8cc7\u6599\u5eab
# vim\u00a0 \/root\/pureftpd.sql<\/span>
CREATE TABLE users (<\/span>
\u00a0 User VARCHAR(16) BINARY NOT NULL,<\/span>
\u00a0 Password VARCHAR(64) BINARY NOT NULL,<\/span>
\u00a0 Uid INT(11) NOT NULL default ‘-1’,<\/span>
\u00a0 Gid INT(11) NOT NULL default ‘-1’,<\/span>
\u00a0 Dir VARCHAR(128) BINARY NOT NULL,<\/span>
\u00a0 PRIMARY KEY\u00a0 (User)<\/span>
) ENGINE=MyISAM\u00a0 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;<\/span>
insert into users values (‘u0910001′,’abCxyZ’,’500′,’500′,’\/home\/virtualuser\/u0910001′);<\/span>
insert into users values (‘u0910002′,’QazXsw’,’500′,’500′,’\/home\/virtualuser\/u0910002′);<\/span><\/p>\n

# \/usr\/bin\/mysqladmin -u root -p create pureftpd<\/span>
# \/usr\/bin\/mysql -u root -p pureftpd < \/root\/pureftpd.sql<\/span><\/p>\n

\u6e2c\u8a66
# mkdir -p \/home\/virtualuser\/{u0910001,u0910002}<\/span>
# chown -R virtualuser:virtualgrp \/home\/virtualuser\/{<\/span>u0910001,<\/span>u0910002}<\/span><\/p>\n

# lftp -u u0910001 192.168.154.167<\/span>
\u5bc6\u78bc\uff1a<\/span>
lftp u0910001@192.168.154.167:~> ls -l<\/span>
drwxr-xr-x\u00a0\u00a0\u00a0 2 500\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 virtualgrp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4096 Jan\u00a0 2 10:17 .<\/span>
drwxr-xr-x\u00a0\u00a0\u00a0 2 500\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 virtualgrp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4096 Jan\u00a0 2 10:17 ..<\/span>
lftp u0910001@192.168.154.167:\/><\/span><\/p>\n

\u5982\u679c\u7cfb\u7d71\u6709\u4f7f\u7528 SELinux\uff0c\u8981\u8a18\u5f97\u628a\u5bb6\u76ee\u9304\u7684\u529f\u80fd\u6253\u958b
# setsebool -P ftp_home_dir 1<\/span>
# setsebool -P allow_ftpd_full_access=1<\/span><\/p>\n

\u66f4\u8907\u96dc\u7684\u8a2d\u5b9a
CREATE DATABASE pure-ftpd;<\/span>
CREATE TABLE `users` (<\/span>
`id` int(32) unsigned NOT NULL auto_increment,<\/span>
`User` varchar(16) NOT NULL default ”,<\/span>
`Password` varchar(64) NOT NULL default ”,<\/span>
`Uid` varchar(11) NOT NULL default ‘-1’,<\/span>
`Gid` varchar(11) NOT NULL default ‘-1’,<\/span>
`Dir` varchar(128) NOT NULL default ”,<\/span>
`QuotaSize` smallint(5) NOT NULL default ‘0’,<\/span>
`QuotaFiles` int(11) NOT NULL default ‘0’,<\/span>
`ULBandwidth` smallint(5) NOT NULL default ‘0’,<\/span>
`DLBandwidth` smallint(5) NOT NULL default ‘0’,<\/span>
`ULRatio` smallint(6) NOT NULL default ‘0’,<\/span>
`DLRatio` smallint(6) NOT NULL default ‘0’,<\/span>
`comment` tinytext NOT NULL,<\/span>
`ipaccess` varchar(15) NOT NULL default ‘*’,<\/span>
`status` enum(‘0′,’1’) NOT NULL default ‘0’,<\/span>
`create_date` datetime NOT NULL default ‘0000-00-00 00:00:00’,<\/span>
`modify_date` datetime NOT NULL default ‘0000-00-00 00:00:00’,<\/span>
PRIMARY KEY (`id`,`User`),<\/span>
UNIQUE KEY `User` (`User`)<\/span>
) TYPE=MyISAM AUTO_INCREMENT=5 ;<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Pure-FTPd FTP Server\u00a0\u4e5f\u53ef\u4ee5\u642d\u914d MySQL\u00a0\u7684\u865b\u64ec\u5e33\u865f\u4f86\u767b\u5165\u9996\u5148\u5b89\u88dd MySQL Ser … <\/p>\n

\u95b1\u8b80\u5168\u6587\u3008Pure-FTPd FTP Server \u4f7f\u7528 MySQL \u865b\u64ec\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-18164","post","type-post","status-publish","format-standard","hentry","category-c-78475","category-c-78461","category-c-72385"],"meta_key":{"_encloseme":["1"],"lt_post_id":["469077"]},"_links":{"self":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18164"}],"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=18164"}],"version-history":[{"count":0,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18164\/revisions"}],"wp:attachment":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/media?parent=18164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/categories?post=18164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/tags?post=18164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}