PURE-FTP + MYSQL 安装（允许大于2G的文件）

一般也没什么太大问题，只是我遇到的是文件超过2G就不能上传，加一个参数 --with-largefile 

一、安装

下面是自的参数，一半也是贴贴过来的^_^

更详细可以参考

 1305  ./configure --prefix=/usr/local/pureftpd --with-ldap --with-mysql --with-puredb --with-paranoidmsg --with-sysquotas --with-altlog --with-throttling  --with-ratios --with-ftpwho --with-welcomemsg --with-uploadscript --with-largefile --with-virtualhosts --with-virtualchroot --with-diraliases --with-quotas --with-peruserlimits --with-language=simplified-chinese  --without-banner

 1306  make;make install
 1307  mkdir /usr/local/pureftpd/etc
 1308  cp pureftpd*.conf /usr/local/pureftpd/etc/
 1309  cp configuration-file/pure-config.pl /usr/local/pureftpd/sbin/
 1310  cp configuration-file/pure-ftpd.conf /usr/local/pureftpd/etc/

二、配置

 

pure-ftpd.conf

AllowAnonymousFXP no
AllowUserFXP no
AnonymousCanCreateDirs no
AnonymousCantUpload yes
AnonymousOnly no
AntiWarez yes
AutoRename yes
Bind *,21
BrokenClientsCompatibility no
ChrootEveryone yes
CreateHomeDir yes
CustomerProof yes
Daemonize yes
DisplayDotFiles no
DontResolve yes
IPV4Only yes
LimitRecursion 500 8
MaxClientsNumber 30
MaxClientsPerIP 5
MaxDiskUsage 99
MaxIdleTime 5
MaxLoad 4
MinUID 100
MySQLConfigFile /usr/local/pureftp/etc/pureftpd-mysql.conf
NoAnonymous yes
NoChmod yes
PIDFile /var/run/pure-ftpd.pid
ProhibitDotFilesRead yes
ProhibitDotFilesWrite yes
SyslogFacility ftp
Umask 133:022
VerboseLog yes

pureftpd-mysql

MYSQLCrypt      md5
MYSQLDatabase   pureftpd
MySQLGetBandwidthDL SELECT DLBandwidth FROM users WHERE User="\L"
MySQLGetBandwidthUL SELECT ULBandwidth FROM users WHERE User="\L"
MYSQLGetDir     SELECT Dir FROM users WHERE User="\L"
MYSQLGetGID     SELECT Gid FROM users WHERE User="\L"
MYSQLGetPW      SELECT Password FROM users WHERE User="\L"
MySQLGetQTAFS  SELECT QuotaFiles FROM users WHERE User="\L"
MySQLGetQTASZ  SELECT QuotaSize FROM users WHERE User="\L"
MySQLGetRatioDL SELECT DLRatio FROM users WHERE User="\L"
MySQLGetRatioUL SELECT ULRatio FROM users WHERE User="\L"
MYSQLGetUID     SELECT Uid FROM users WHERE User="\L"
MYSQLPassword   your pureftp userpass
MYSQLPort       3306
MYSQLServer     localhost
MYSQLSocket     /tmp/mysql.sock
MYSQLUser       your pureftp username

三、数据库

可以查看安装包下面的README.MySQL，其中简单的create table的语句

四、后记

之前我安装的包不支持2G上传文件，真正有影响的文件是sbin/pure-ftpd，我将之前的配置文件直接COPY过来使用的