opensips mysql 版本_CentOS上安装OpenSIPs | 学步园

转自：http://blog.techippo.org/archives/361

1、安装CentOS release 5.3 (Final),选custom安装，开发包及Mysql要装全：

# rpm –qa | grep mysql 查看“mysql”、“mysql-devel”、 “mysql-server”三个是否完全安装否？

# /etc/init.d/mysqld start 起动Mysql

2、上传OpenSips稳定版,opensips-1.5.1-tls_src.tar

[/usr/src] # tar zxvf opensips-1.5.1-tls_src.tar.gz

进入opensips-1.5.1-tls_src目录中，删除Makefile中的exclude_modules 的db-mysql ，为了使opensips支持mysql。

3、编译安装：

# make all

# make install

默认安装路径为/usr/local/sbin /usr/local/share……

4、创建数据库

编缉：/usr/local/etc/opensips/opensipsctlrc

## database type: MYSQL, PGSQL, ORACLE, DB_BERKELEY, or DBTEXT, by default none is loaded

# If you want to setup a database with opensipsdbctl, you must at least specify

# this parameter.

DBENGINE=MYSQL

## database host

DBHOST=localhost

## database name (for ORACLE this is TNS name)

DBNAME=opensips

# database path used by dbtext or db_berkeley

DB_PATH=”/usr/local/etc/opensips/dbtext”

## database read/write user

DBRWUSER=opensips

## password for database read/write user

DBRWPW=”opensipsrw”

## database read only user

DBROUSER=opensipsro

## password for database read only user

DBROPW=opensipsro

## database super user (for ORACLE this is ’scheme-creator’ user)

DBROOTUSER=”root”

# user name column

USERCOL=”username”

修改完后，在/usr/local/sbin/目录下执行：

./opensipsdbctl create (生成opensips数据库)

[root@localhost sbin]# ./opensipsdbctl create

MySQL password for root:

INFO: test server charset

INFO: creating database opensips …

INFO: Core OpenSIPS tables succesfully created.

Install presence related tables? (y/n): y

INFO: creating presence tables into opensips …

INFO: Presence tables succesfully created.

Install tables for imc cpl siptrace domainpolicy carrierroute userblacklist? (y/n): y

INFO: creating extra tables into opensips …

INFO: Extra tables succesfully created.

5、运行opensips：

/usr/local/sbin/opensipsctl start 启动opensips

查看进程： ps –ef |grep opensips

/usr/local/sbin/opensipsctl stop 停止opensips

6、opensips配置文件：

vi /usr/local/etc/opensips/opensips.cfg

loadmodule “db_mysql.so” 去掉#打开mysql模块

loadmodule “auth.so” 去掉#

loadmodule “auth_db.so” 去掉#

loadmodule “alias_db.so”

modparam(”usrloc”, “db_mode”, 0) 0改为2

modparam(”auth_db”, “calculate_ha1″, yes) 去掉#

modparam(”auth_db”, “password_column”, “password”) 去掉#