FREEBSD升级及优化全攻略(2)

ipfw add all from any to any

其它规则根据实际情况来做，如果您想系统每次启动都使用上一次的规则，可以把这些内容加到：
vi /etc/ipfw.rules
里面，语法规则同ipfw。

安装数据库MYSQL
安装mysql40-server和mysql40-client
进入/usr/ports/databases/mysql40-server
执行：
make clean
make deinstall
make WITH_OPENSSL=yes WITH_LINUXTHREADS=yes BUILD_OPTIMIZED=yes install
或者使用下面可参考的编译参数：BUILD_STATIC=yes
编译成静态执行版本
make clean

更改mysql的root密码：
mysqladmin –uroot –p password 123456

生成/etc/my.cnf，使用如下命令：
vi /etc/my.cnf
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock

[mysqld]
skip-innodb
skip-locking
skip-networking
set-variable = port=3306
set-variable = socket=/tmp/mysql.sock
set-variable = back_log=50
set-variable = connect_timeout=3
set-variable = key_buffer=128M
set-variable = max_connections=1000
set-variable = max_allowed_packet=1M
set-variable = net_buffer_length=8K
set-variable = wait_timeout=3
set-variable = read_buffer_size=1M
set-variable = sort_buffer_size=1M
set-variable = table_cache=256
set-variable = myisam_sort_buffer_size=32M
set-variable = log_slow_queries=/var/log/log_slow_queries.log
#log-bin
server-id = 1

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[mysqlhotcopy]
interactive-timeout

安装phpmyadmin
注意，此步骤需要在apache和php之后再执行
进入/usr/ports/databases/phpmyadmin
执行：
make clean
make deinstall
make install
make clean

新建立一个system的数据库备用。

安装FTP服务器
安装ftp软件(使用pure-ftpd/)
进入/usr/ports/ftp/pufe-ftpd
执行：
make clean
make deinstall
make WITH_MYSQL=1 install
或者使用下面可参考的编译参数：WITH_LANG=simplified-chinese
使用简体中文语言包
make clean
配置pure-ftpd，主要需要做以下的工作：
cp /usr/local/etc/pure-ftpd.conf.sample /usr/local/etc/pure-ftpd.conf
cp /usr/local/etc/pureftpd-mysql.conf.sample /usr/local/etc/pureftpd-mysql.conf

再修改/usr/local/etc/pure-ftpd.conf的如下部份为：
NoAnonymous yes
MySQLConfigFile /usr/local/etc/pureftpd-mysql.conf

再修改/usr/local/etc/pureftpd-mysql.conf的如下部份为您的设定值：
# Mandatory : user to bind the server as.
MYSQLUser demo
# Mandatory : user password. You must have a password.
MYSQLPassword demo
# Mandatory : database to open.
MYSQLDatabase demo

再进入使用mysql –uroot –p123456 进入mysql的文本方式﹔
使用如下命令建立新表：
use system;
DROP TABLE IF EXISTS users;
CREATE TABLE users (
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;

安装pureftpd_php_manager
下载pureftpd_php_manager.zip
解压并放到指定的目录里面，比如：
/usr/local/www/data
chmod –R 755 /usr/local/www/data/pureftpd_php_manager

再加入一个普通用户和一个群组，以供ftp使用：
pw groupadd ftpusers
pw useradd ftpuser –g ftpusers –s /sbin/nologin

记住他们的uid和gid号，备用！

进入并编辑pureftp.config.php文件
更改里面的如下行：
$PUREFTP_CONFIG_FILE = '/usr/local/etc/pureftpd-mysql.conf';^M

$DefaultUser = "ftpuser"; # Default User Logon^M
$DefaultPass = ""; # Default User Password^M
$DefaultUid = "1002"; # Default User ID ( must be a re
al user acct )^M
$DefaultGid = "1001"; # Default Group ID ( must be a r
eal group acct )^M
$DefaultDir = "/home"; # Default User Dir ( use
/./ at the end to chroot )^M
$DefaultUL = "0"; # Default Upload Throttl
e ( 0 disables it )^M
$DefaultDL = "0"; # Default Download Throt
tle ( 0 disables it )^M
$Defaultip = "*"; # Default IP restriction
s ( * = any IP )^M
$DefaultQS = "200"; # Default Quota Size ( 0 disable
s it )^M
$Defaultcmt = ""; # Default Comment for us
er^M
^M
// UA^M
$DefaultQF = "0"; # Default Quota Files ( 0 disabl

安装APACHE服务器
安装apache13-modssl
进入/usr/ports/www/apache13-modssl
执行：
make clean
make deinstall
make WITH_APACHE_SUEXEC=yes APACHE_HARD_SERVER_LIMIT=1024 APACHE_PERF_TUNING=yes install

标签：

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有