- 论坛徽章:
- 0
|
回复 #1 wcxgo 的帖子
- 创建名为pureftpd的数据库
- CREATE TABLE IF NOT EXISTS `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`)
- ) ENGINE=MyISAM DEFAULT CHARSET=gbk;
- pw groupadd ftpusers –g 2000
- pw useradd ftpuser -u 2000 -g ftpusers -s /sbin/nologin
- ee /usr/local/etc/pure-ftpd.conf
- ChrootEveryone yes
- NoAnonymous yes
- MySQLConfigFile /usr/local/etc/pureftpd-mysql.conf
- CreateHomeDir yes
- ee /usr/local/etc/pureftpd-mysql.conf
- MYSQLServer localhost
- MYSQLPort 3306
- MYSQLUser pureftpd
- MYSQLPassword pureftpd0491
- 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")
- ee /etc/rc.conf
- pureftpd_enable="YES"
复制代码
例:
User status Password Uid Gid Dir UL DL comment ipaccess QuotaSize QuotaFiles
用户名 1 密码 2000 2000 /data/web/web1 0 0 * 50 0
可以结帖了哦 :wink: 还有最好把/data/web chmod -R 777 一下
[ 本帖最后由 lhm0491 于 2008-9-1 12:03 编辑 ] |
|