Mysql实例PureFTP借助MySQL实现用户身份验证的操作教程

MYSQL必读
tar zxvf pure-ftpd-1.0.20.tar.gz cd pure-ftpd-1.0.20
./configure --prefix=/usr/local/pureftpd \
--with-cookie \
--with-throttling \
--with-ratios \
--with-quotas \
--with-sysquotas \
--with-uploadscript \
--with-virtualhosts \
--with-virtualchroot \
--with-virtualchroot \
--with-diraliases \
--with-peruserlimits \
--with-language=simplified-chinese \
--with-mysql=/usr/local/mysql \
--with-paranoidmsg \
--with-altlog
make
make check
make install
mkdir -m 777 /usr/local/pureftpd/etc
cp pureftpd-mysql.conf  /usr/local/pureftpd/etc/pureftpd-mysql.conf
cp configuration-file /pure-ftpd.conf /usr/local/pureftpd/etc/pure-ftpd.conf
cp configuration-file/pure-config.pl  /usr/local/pureftpd/bin/pure-config.pl

MYSQL必读
# cp contrib/redhat.init /etc/init.d/pureftpd
# vi /etc/init.d/pureftpd

MYSQL必读
fullpath=/usr/local/sbin/$prog
pureftpwho=/usr/local/sbin/pure-ftpwho

MYSQL必读
fullpath=/usr/local/pureftpd/sbin/$prog
pureftpwho=/usr/local/pureftpd/sbin/pure-ftpwho

MYSQL必读
$fullpath /etc/pure-ftpd.conf --daemonize

MYSQL必读
$fullpath /usr/local/pureftpd/etc/pure-ftpd.conf --daemonize
# chmod 755 /etc/init.d/pureftpd
# chkconfig --add pureftpd
# chkconfig pureftpd on

MYSQL必读
# vi /usr/local/pureftpd/etc/pure-ftpd.conf

MYSQL必读
iptables -I INPUT -p tcp --dport 21 -j ACCEPT
iptables -I INPUT -p tcp --dport 30000:50000 -j ACCEPT

MYSQL必读
/etc/rc.d/init.d/iptables save

MYSQL必读
mysql>CREATE DATABASE pureftpd;
mysql>grant all on pureftpd.* to pureftpd@"localhost" identified by 'pureftpd';
mysql>use pureftpd;
mysql>CREATE TABLE `users` ( `id` int(32) unsigned NOT NULL auto_increment,
`User` varchar(16) NOT NULL default '',
`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 '',
`QuotaSize` smallint(5) NOT NULL default '0',
`QuotaFiles` int(11) NOT NULL default '0',
`ULBandwidth` smallint(5) NOT NULL default '0',
`DLBandwidth` smallint(5) NOT NULL default '0',
`ULRatio` smallint(6) NOT NULL default '0',
`DLRatio` smallint(6) NOT NULL default '0',
`comment` tinytext NOT NULL,
`ipaccess` varchar(15) NOT NULL default '*',
`status` enum('0','1') NOT NULL default '0',
`create_date` datetime NOT NULL default '0000-00-00 00:00:00',
`modify_date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`,`User`), UNIQUE KEY `User` (`User`) )
TYPE=MyISAM AUTO_INCREMENT=5 ;

MYSQL必读
groupadd download -g 2000
 useradd download -u 2000 -g download -s /sbin/nologin

MYSQL必读
groupadd upload -g 2001
 useradd upload -u 2001 -g download -s /sbin/nologin
mkdir /ftproot chown -R upload /ftproot      //让upload用户作为ftp根目录的属主
 chgrp -R download /ftproot   //让download用户为ftp根目录的属组
 chmod 750 /ftproot           //让upload用户拥用所有权限,让download用户只有读权限

MYSQL必读
vi /usr/local/pureftpd/etc/pure-ftpd.conf

MYSQL必读
ChrootEveryone         yes
BrokenClientsCompatibility   no
MaxClientsNumber        50
Daemonize           yes
MaxClientsPerIP        8
VerboseLog           yes
DisplayDotFiles        yes
AnonymousOnly         no
NoAnonymous          no
SyslogFacility        
DontResolve          yes
MaxIdleTime          15 #  在使用ls命令时显示的最多的文件个数,该选项有两个参数第一个是文件数,第二个是目录深度
LimitRecursion        10000 8
AnonymousCanCreateDirs    no
MaxLoad            4
PassivePortRange       30000 50000 使用被动模式,被动端口的范围是30000到50000
AntiWarez           yes
UserBandwidth         1000
Umask             133:022
MinUID            100
AllowUserFXP         no
AllowAnonymousFXP       no
ProhibitDotFilesWrite     no
ProhibitDotFilesRead     no
AutoRename          no
AnonymousCantUpload      yes 禁止匿名用户上传
CreateHomeDir         no 禁止登录用户自动创建家目录
PIDFile            /var/run/pure-ftpd.pid
MaxDiskUsage         99
CustomerProof         yes

MYSQL必读
vi /usr/local/pureftpd/etc/pureftpd-mysql.conf

MYSQL必读
MYSQLServer 127.0.0.1
MYSQLPort 3306
MYSQLUser pureftpd
MYSQLPassword pureftpd
MYSQLDatabase pureftpd
MYSQLCrypt cleartext 暗码在数据表中的存储方式,这里选择明文用cleartext、加密使用crypt
MYSQLGetPW SELECT Password FROM users WHERE User='\L'
MYSQLGetUID SELECT Uid FROM users WHERE User='\L'
MYSQLGetGID SELECT Gid FROM users WHERE User='\L'
MYSQLGetDir SELECT Dir FROM users WHERE User='\L'
MySQLGetBandwidthUL SELECT ULBandwidth FROM users WHERE User='\L'
MySQLGetBandwidthDL SELECT DLBandwidth FROM users WHERE User='\L'

MYSQL必读
INSERT INTO `users` VALUES (1, 'download','download', '2000', '2000', '/ftproot', 0, 0, 0, 0, 0, 0, '','*', '1', '2013-06-24 16:10:00', '2013-06-24 16:10:00');

MYSQL必读
INSERT INTO `users` VALUES (2, 'upload','upload', '2001', '2001', '/ftproot', 0, 0, 0, 0, 0, 0, '','*', '1', '2013-06-24 16:10:00', '2013-06-24 16:10:00');

MYSQL必读
/usr/local/pureftpd/bin/pure-config.pl /usr/local/pureftpd/etc/pure-ftpd.conf

MYSQL必读
chown -R upload:upload /ftproot
chomod 700  /ftproot
setfacl -R d:u:download:rx /ftproot 

MYSQL必读
setfacl -R u:download:rx  /frptoot  

MYSQL必读
CREATE TABLE IF NOT EXISTS `ftpd` (
`User` varchar(16) NOT NULL DEFAULT ” COMMENT ‘用户名',
`status` enum(‘0′,'1′) NOT NULL DEFAULT ‘0' COMMENT ‘可用状态：0 C 不可用；1 C 正在使用',
`Password` varchar(64) NOT NULL DEFAULT ” COMMENT ‘暗码',
`Uid` varchar(11) NOT NULL DEFAULT ‘-1′ COMMENT ‘用户ID',
`Gid` varchar(11) NOT NULL DEFAULT ‘-1′ COMMENT ‘组ID',
`Dir` varchar(128) NOT NULL DEFAULT ” COMMENT ‘拥有的权限路径',
`ULBandwidth` smallint(5) NOT NULL DEFAULT ‘0' COMMENT ‘上传带宽',
`DLBandwidth` smallint(5) NOT NULL DEFAULT ‘0' COMMENT ‘下载带宽',
`comment` tinytext NOT NULL COMMENT ‘备注',
`ipaccess` varchar(15) NOT NULL DEFAULT ‘*' COMMENT ‘IP地址',
`QuotaSize` smallint(5) NOT NULL DEFAULT ‘0' COMMENT ‘大小配额',
`QuotaFiles` int(11) NOT NULL DEFAULT ‘0' COMMENT ‘文件类型配额',
PRIMARY KEY (`User`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='ftp用户名暗码表';