(1)vim /etc/sysconfig/network-scripts/ifcfg-eth0
ONBOOT="yes"
IPADDR=192.168.10.198
BOOTPROTO=none
NETMASK=255.255.255.0
TYPE=Ethernet
GATEWAY=192.168.10.1
(2)service network restart
ifconfig
(3)关闭防火墙
service iptables stop
vim /etc/sysconfig/selinux
setenforce 0
(4)光驱挂到本地目录
mkdir -p /mnt/cdrom
mount /dev/cdrom /mnt/cdrom
把ISO挂载到 本地目录
mount -t iso9660 -o loop /root/rhel.iso /mnt/cdrom
(5)配置本地源
vim /etc/yum.repos.d/mycdrom.repo
[Server]
name=rhel6server
baseurl=file:///mnt/cdrom/Server
enable=1
gpcheck=1
gpgkey=file:///mnt/cdrom/RPM-GPG-KEY-redhat-release
(6)安装 httpd
yum install http* -y
(7)安装mysql
tar -zxf mysql-5.1.51-linux-i686-glibc23.tar.gz
mv /mysql-5.1.51-linux-i686-glibc23 /usr/local/mysql
cp /usr/loacal/mysql/support-files/my-large.cnf /etc/my.cnf
groupadd mysql
useradd mysql -g mysql
chown -R root.mysql /usr/local/mysql
cd /usr/local/mysql
./scripts/mysql_install_db --user=mysql
vim /etc/my.cnf 找到log-bin=mysql-bin这一行,将其注释:
#log-bin=mysql-bin
#binlog_format=mixed
在client下加入
default-character-set=utf8
在mysqld下加入
default-character-set=utf8
key_buffer_size = 256M
max_allowed_packet = 64M
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
启动mysql service mysql start
设置本地登录密码mysqladmin -u root password 123456
进入数据库 /usr/local/mysql/bin/mysql -uroot -p
远程登录权限设置grant all privileges on *.* to root@"%" identified by 'password' with grant option;
create database lb8844
退出数据库,导入sql文件
mysql -uroot -p123456 lb8844 < lb8844_2009.sql
(8)安装sphinx
yum install make gcc g++ gcc-c++ libtool make mysql-devel libxml2-devel expat-devel
tar xzvf coreseek-4.0.1-beta.tar.gz
cd coreseek-4.0.1-beta
##安装mmseg
cd mmseg-4.0.1-beta
./bootstrap #输出的warning信息可以忽略,如果出现error则需要解决
./configure --prefix=/usr/local/mmseg3
make && make install
cd ..
##安装coreseek
cd csft-4.0.1
sh buildconf.sh #输出的warning信息可以忽略,如果出现error则需要解决
./configure --prefix=/usr/local/coreseek --without-unixodbc --with-mmseg --with-mmseg-includes=/usr/local/mmseg3/include/mmseg/ --with-mmseg-libs=/usr/local/mmseg3/lib/ --with-mysql
make && make install
cd ..
##测试mmseg分词,coreseek搜索(需要预先设置好字符集为zh_CN.UTF-8,确保正确显示中文)
$ cd testpack
$ cat var/test/test.xml #此时应该正确显示中文
$ /usr/local/mmseg3/bin/mmseg -d /usr/local/mmseg3/etc var/test/test.xml
$ /usr/local/coreseek/bin/indexer -c etc/csft.conf --all
$ /usr/local/coreseek/bin/search -c etc/csft.conf 网络搜索
/usr/local/coreseek/bin/searchd -c /etc/question.conf 开启sphinx服务
DROP TABLE IF EXISTS `lb8844`.`adrt_counter`;
CREATE TABLE `lb8844`.`adrt_counter` (
`counter_id` int(5) NOT NULL,
`max_doc_id` int(20) NOT NULL,
`table_name` char(30) NOT NULL,
PRIMARY KEY (`counter_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `lb8844`.`asph_counter`;
CREATE TABLE `lb8844`.`asph_counter` (
`counter_id` int(5) NOT NULL,
`max_doc_id` int(20) NOT NULL,
`table_name` char(30) NOT NULL,
PRIMARY KEY (`counter_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
装监控
(1)yum install net-snmp
(2)vim /etc/snmp/snmpd.conf
rocommunity cacti 192.168.20.5
rocommunity cacti 172.16.101.44
rocommunity cacti 172.16.101.240
(3)chkconfig --level 345 snmpd on
(4)chkconfig --level 345 mysql on
(5)service snmpd start