##
################
http://www.solariz.de
http://www.solariz.de/Ffiledb/filedb.php?action=category&id=1
http://www.solariz.de/Ffiledb/download.php?id=1
#mysql 配置文件 。
#vi /usr/local/modules/support/pure-ftpd/etc/pureftpd-mysql.conf
#
# If you want to use the Socket connect methode comment out the
# Lines with MMYSQLServer and MYSQLPort.
# If you want to use the Port methode comment out the MYSQLSocket line
#MYSQLSocket /var/lib/mysql/mysql.sock
MYSQLServer localhost
MYSQLPort 3306
MYSQLUser pureftpd
MYSQLPassWord wahaha
MYSQLDatabase pureftpd
MYSQLCrypt cleartext
MYSQLGetPW SELECT Password FROM ftpd WHERE User="L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "R")
MYSQLGetUID SELECT Uid FROM ftpd WHERE User="L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "R")
MYSQLGetGID SELECT Gid FROM ftpd WHERE User="L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "R")
MYSQLGetDir SELECT Dir FROM ftpd WHERE User="L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "R")
MySQLGetBandwidthUL SELECT ULBandwidth FROM ftpd WHERE User="L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "R")
MySQLGetBandwidthDL SELECT DLBandwidth FROM ftpd WHERE User="L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "R")
MySQLGetQTASZ SELECT QuotaSize FROM ftpd WHERE User="L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "R")
MySQLGetQTAFS SELECT QuotaFiles FROM ftpd WHERE User="L"AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "R")
#end of mysql configure.
#####数据库初始化 ####用phpmyadmin 执行
use pureftpd;
DROP TABLE IF EXISTS ftpd;
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;
####
####
8.5.虚拟用户管理
#为匿名用户设置帐户,必须有一个系统帐户ftp ， 匿名ftp才会生效；
#ftp用户的主目录就是匿名ftp的根；
#匿名ftp是为ftp://ftp.anti-spamming.com这个匿名服务器服务的；
userdel ftp
groupdel ftp
groupadd ftp
useradd -g ftp ftp
#虚拟用户统一用这个帐号和组；
pw groupadd virtual
mkdir -p /data/home/virtual
pw useradd virtual -g virtual -d /data/home/virtual -s /sbin/nologin
chown -R virtual:virtual /data/home/virtual
#为了方便管理 ， clone一个可以登陆的virtual帐号:
#vipw
virtual:x:503:503::/data/home/virtual:/sbin/nologin
vvuser:x:503:503::/data/home/virtual:/bin/sh
#end
#end
修改密码
passwd vvuser
################为了使用 PureFTPD PHP User Management #####
###mysql 的设置是按照PureFTPD PHP User Management的readme作的 。
http://www.solariz.de
http://www.solariz.de/Ffiledb/filedb.php?action=category&id=1
http://www.solariz.de/Ffiledb/download.php?id=1
###
cd /usr/local/modules/support/apache/htdocs
fetch ftp://172.16.100.245/pub/distfiles/pureftpd_php_manager.tgz
tar xfz pureftpd_php_manager.tgz
rm -f pureftpd_php_manager.tgz
cd pureftpd_php_manager
#vi pureftp.config.php
######################
####### SETUP ########
######################
// Your exactly located mysql config file for pureftpd
//$PUREFTP_CONFIG_FILE = "/etc/pureftpd-mysql.conf";
$PUREFTP_CONFIG_FILE = "/usr/local/modules/support/pure-ftpd/etc/pureftpd-mysql.conf";
// The location where all the Forms directed to. (Mayby no change needed)
