因项目的需求，低版本的MySQL在性能上不能满足我们的需求，现在需要更换为高版本的MySQL 5.5.44.新版本的MySQL 5.5.44在性能上，比起CentOS 5.11自带的低版本的MySQL 5.0.95，至少要高一倍以上。
MySQL 5.5.44的安装，我们这边就不采用源码安装而是直接使用编译好的版本。
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
yum -y
install
gcc gcc-devel gcc-c++ gcc-c++-devel libaio-devel boost boost-devel autoconf* automake* zlib* libxml* ncurses-devel ncurses libgcrypt* libtool* cmake openssl openssl-devel bison bison-devel unzip
groupadd -g 10001 mysql
useradd
-u 10001 -s
/sbin/nologin
-d
/dev/null
-g mysql mysql
mkdir
/data
wget http:
//mirrors
.sohu.com
/mysql/MySQL-5
.5
/mysql-5
.5.44-linux2.6-x86_64.
tar
.gz
tar
zxf mysql-5.5.44-linux2.6-x86_64.
tar
.gz
mv
mysql-5.5.44-linux2.6-x86_64
/data/mysql5
.5.44
echo
"127.0.0.1 $HOSTNAME"
>>
/etc/hosts
chown
-R mysql.mysql
/data/mysql5
.5.44
/data
/data/mysql5
.5.44
/scripts/mysql_install_db
--user=mysql --group=mysql --basedir=
/data/mysql5
.5.44 --datadir=
/data/mysql5
.5.44
/data
cp
/data/mysql5
.5.44
/support-files/my-medium
.cnf
/etc/my
.cnf
cp
/data/mysql5
.5.44
/support-files/mysql
.server
/etc/init
.d
/mysqld
sed
-i
's#^basedir=$#basedir=/data/mysql5.5.44#g'
/etc/init
.d
/mysqld
sed
-i
's#^datadir=$#datadir=/data/mysql5.5.44/data#g'
/etc/init
.d
/mysqld
chmod
750
/etc/init
.d
/mysqld
service mysqld start
ln
-s
/data/mysql5
.5.44
/bin/
*
/usr/bin/
mysqladmin -uroot password 123456
mysql -uroot -p123456 -e
'delete from mysql.user where password=""'
mysql -uroot -p123456 -e
'drop database test'
|
以上MySQL就已经正常安装及使用。
源码安装请参阅:http://fengwan.blog.51cto.com/508652/1363566
现在编译安装OpenSIPS,你会发现无法编译
这个时候是因为OpenSIPS找不到MySQL的库，如果yum安装的话至少要安装mysql及mysql-devel.
我们这里就不yum安装了，因为已经安装了mysql。
|
1
2
3
4
5
6
7
|
ln
-s
/data/mysql5
.5.44
/bin/
*
/usr/bin/
ln
-s
/data/mysql5
.5.44
/include/
/usr/include/mysql
ln
-s
/data/mysql5
.5.44
/lib/
/usr/lib64/mysql
ln
-s
/data/mysql5
.5.44
/lib/
*
/usr/lib64/
|
将以上库及包含文件软链接即可正常。
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
yum -y
install
gcc
make
zlib-devel wget
yum -y
install
flex bison ncurses-devel openssl-devel
yum -y
install
lynx svn libxslt
wget http:
//opensips
.org
/pub/opensips/1
.11.5
/src/opensips-1
.11.5-latest_src.
tar
.gz
tar
zxf opensips-1.11.5-latest_src.
tar
.gz
cd
opensips-1.11.5-tls/
make
prefix=
/data/opensips1
.11.5 all include_modules=
"db_mysql"
make
prefix=
/data/opensips1
.11.5
install
include_modules=
"db_mysql"
cd
sed
-i
's/\# DBENGINE=MYSQL/DBENGINE=MYSQL/g'
/data/opensips1
.11.5
/etc/opensips/opensipsctlrc
sed
-i
's/\# DBHOST=localhost/DBHOST=localhost/g'
/data/opensips1
.11.5
/etc/opensips/opensipsctlrc
sed
-i
's/\# DBNAME=opensips/DBNAME=opensips/g'
/data/opensips1
.11.5
/etc/opensips/opensipsctlrc
sed
-i
's/\# DBRWUSER=opensips/DBRWUSER=opensips/g'
/data/opensips1
.11.5
/etc/opensips/opensipsctlrc
sed
-i
's/\# DBRWPW="opensipsrw"/DBRWPW="opensipsrw"/g'
/data/opensips1
.11.5
/etc/opensips/opensipsctlrc
sed
-i
's/\# DBROOTUSER="root"/DBROOTUSER="root"/g'
/data/opensips1
.11.5
/etc/opensips/opensipsctlrc
ln
-s
/data/opensips1
.11.5
/etc/opensips/
/etc/
echo
'export PATH=$PATH:/data/opensips1.11.5/sbin/'
>>
/etc/profile
source
/etc/profile
/data/opensips1
.11.5
/sbin/opensipsdbctl
create
/data/opensips1
.11.5
/sbin/osipsconfig
rm
-f
/data/opensips1
.11.5
/etc/opensips/opensips
.cfg
mv
/data/opensips1
.11.5
/etc/opensips/opensips_residential_
*.cfg
/data/opensips1
.11.5
/etc/opensips/opensips
.cfg
sed
-i
's/disable_tcp=no/disable_tcp=yes/g'
/data/opensips1
.11.5
/etc/opensips/opensips
.cfg
sed
-i
's/listen=udp:127.0.0.1:5060/listen=udp:eth0:5060/g'
/data/opensips1
.11.5
/etc/opensips/opensips
.cfg
sed
-i
's#mpath="/usr/local/lib/opensips/modules/"#mpath="/data/opensips1.11.5/lib64/opensips/modules/"#g'
/data/opensips1
.11.5
/etc/opensips/opensips
.cfg
sed
-i -e
'/modparam("uri", "use_uri_table", 0)/a\modparam("uri", "db_url","mysql://opensips:opensipsrw@localhost/opensips")'
/data/opensips1
.11.5
/etc/opensips/opensips
.cfg
echo
"local0.* /var/log/opensips.log"
>>
/etc/syslog
.conf
service syslog restart
mysql -uroot -p123456 -e
"insert into opensips.domain(domain) values('192.168.1.245')"
#192.168.1.245为你的sip域,可以为ip
cp
/root/opensips-1
.11.5-tls
/packaging/fedora/opensips
.init
/etc/init
.d
/opensips
sed
-i
's#cfgdir="/etc/$prog"#cfgdir="/data/opensips1.11.5/etc/$prog"#g'
/etc/init
.d
/opensips
sed
-i
's#opensips=/usr/sbin/$prog#opensips=/data/opensips1.11.5/sbin/$prog#g'
/etc/init
.d
/opensips
chmod
+x
/etc/init
.d
/opensips
groupadd opensips
useradd
-g opensips -s
/sbin/nologin
-d
/dev/null
opensips
service opensips start
|
若有不懂的，参阅http://fengwan.blog.51cto.com/508652/1655265
若启动OpenSIPS的时候出现
|
1
|
ERROR:core:sr_load_module: could not
open
module <
/data/opensips1
.11.5
/lib64/opensips/modules/db_mysql
.so>: libmysqlclient.so. 18: cannot
open
shared object
file
: No such
file
or directory
|
运行
|
1
|
ln
-s
/data/mysql5
.5.44
/lib/
*
/usr/lib64/
|
将库链接上即可
本文转自 rong341233 51CTO博客，原文链接:http://blog.51cto.com/fengwan/1669752
