豆豆网 > 技术应用 > 操作系统 > FreeBSD > 正文

FreeBSD 6.1 入门级Web服务器配置手记

豆豆网技术应用频道 2007年04月13日【字号：小中大】收藏本文

关键字： OPIE 双网卡绑定 sysctl.conf FreeBSD 6.2 FreeBSD 6.0

本文详细介绍FreeBSD 6.1 入门级Web服务器配置手记

　　CODE:

CREATE DATABASE pureftpd;
USE pureftpd;
CREATE TABLE `users` (
`User` varchar(16) NOT NULL default '',
`Password` varchar(32) binary NOT NULL default '',
`Uid` int(11) NOT NULL default '14',
`Gid` int(11) NOT NULL default '5',
`Dir` varchar(128) NOT NULL default '',
`QuotaFiles` int(10) NOT NULL default '500',
`QuotaSize` int(10) NOT NULL default '30',
`ULBandwidth` int(10) NOT NULL default '80',
`DLBandwidth` int(10) NOT NULL default '80',
`ipaccess` varchar(15) NOT NULL default '*',
`Comment` tinytext,
`Status` enum('0','1') NOT NULL default '1',
`ULRatio` smallint(5) NOT NULL default '1',
`DLRatio` smallint(5) NOT NULL default '1',
PRIMARY KEY　(`User`),
UNIQUE KEY `User` (`User`)
) TYPE=MyISAM;

　　通过phpmyadmin新建一用户名为ftpadmin,密码adminpassword,并赋予其pureftpd数据库的Select,Insert,Update,Delete权限。

　　配置pure-ftp

　　QUOTE:

　　# cd /usr/local/etc

　　# cp pureftpd-mysql.conf.sample pureftpd-mysql.conf

　　# ee pureftpd-mysql.conf

　　CODE:

　　# 具体选项请参考http://download.pureftpd.org/pub/pure-ftpd/doc/README

MYSQLServer　　 localhost
MYSQLUser　　　ftpadmin
MYSQLPassword　 adminpassword
MYSQLDatabase　pureftpd
MYSQLCrypt　　　crypt
MYSQLGetPW　　　SELECT Password FROM users WHERE User="L" AND Status="1" AND (Ipaccess = "*" OR Ipaccess LIKE "R")
MYSQLGetUID　　 SELECT Uid FROM users WHERE User="L" AND Status="1" AND (Ipaccess = "*" OR Ipaccess LIKE "R")
MYSQLGetGID　　 SELECT Gid FROM users WHERE User="L" AND Status="1" AND (Ipaccess = "*" OR Ipaccess LIKE "R")
MYSQLGetDir　　 SELECT Dir FROM users WHERE User="L" AND Status="1" AND (Ipaccess = "*" OR Ipaccess LIKE "R")
MySQLGetQTAFS　SELECT QuotaFiles FROM users WHERE User="L" AND Status="1" AND (Ipaccess = "*" OR Ipaccess LIKE "R")
MySQLGetQTASZ　SELECT QuotaSize FROM users WHERE User="L" AND Status="1" AND (Ipaccess = "*" OR Ipaccess LIKE "R")
# MySQLGetRatioUL SELECT ULRatio FROM users WHERE User="L" AND Status="1" AND (Ipaccess = "*" OR Ipaccess LIKE "R")
# MySQLGetRatioDL SELECT DLRatio FROM users WHERE User="L" AND Status="1" AND (Ipaccess = "*" OR Ipaccess LIKE "R")
MySQLGetBandwidthUL SELECT ULBandwidth FROM users WHERE User="L" AND Status="1" AND (Ipaccess = "*" OR Ipaccess LIKE "R")
MySQLGetBandwidthDL SELECT DLBandwidth FROM users WHERE User="L" AND Status="1" AND (Ipaccess = "*" OR Ipaccess LIKE "R")

上一页 7 8 9 101112 13 14 15 16 下一页

责编：豆豆技术应用

正在加载评论...