open mysql_OpenSIPs 中mysql模块的安装

OpenSips来自于Openser！

===========================================

OpenSIPS安装说明     http://www.opensips.org/

===========================================

1、安装CentOs 4.5,选custom安装，开发包及Mysql要装全：

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

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

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

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

进入opensips-1.4.4-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")    去掉#

===========================================

安装结束!!      http://www.eippbx.com.cn/

===========================================