OpenSIPs安裝上傳mysql模與創(chuàng)建數(shù)據(jù)庫
在向大家詳細(xì)介紹OpenSIPs安裝之前,首先讓大家了解下OpenSIPs安裝,然后全面介紹OpenSIPs安裝,希望對大家有用。OpenSIPs安裝 mysql模塊的安裝。
1、安裝CentOs 4.5,選custom安裝,開發(fā)包及Mysql要裝全:
- # rpm –qa | grep mysql 查看“mysql”、“mysql-devel”、 “mysql-server”三個是否完全安裝否?
- # /etc/init.d/mysqld start 起動Mysql
2、上傳OpenSIPs安裝穩(wěn)定版,opensips-1.4.4-tls_src.tar
[/usr/src] # tar zxvf opensips-1.4.4-tls_src.tar.gz
進(jìn)入opensips-1.4.4-tls_src目錄中,刪除Makefile中的exclude_modules 的db-mysql ,為了使OpenSIPs安裝支持mysql。
3、編譯安裝:
- # make all
- # make install
默認(rèn)安裝路徑為/usr/local/sbin /usr/local/share……
4、OpenSIPs安裝創(chuàng)建數(shù)據(jù)庫
編緝:/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"
OpenSIPs安裝修改完后,在/usr/local/sbin/目錄下執(zhí)行:./opensipsdbctl create (生成opensips數(shù)據(jù)庫)
- [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
- 查看進(jìn)程: 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") 去掉#
【編輯推薦】