配置数据库

# vim /etc/opensips/opensipsctlrcDBENGINE=DBTEXTDB_PATH="/etc/opensips/dbtext"ETCDIR="/etc/opensips"

创建数据库

# opensipsdbctl createINFO: creating DBTEXT tables at: /etc/opensips/dbtext ...Install presence related tables? (y/n): yINFO: creating DBTEXT presence tables at: /etc/opensips/dbtext ...Install tables for imc cpl siptrace domainpolicy carrierroute userblacklist? (y/n): yINFO: creating DBTEXT extra tables at: /etc/opensips/dbtext ...

# vim /etc/opensips/opensipsctlrc

SIP_DOMAIN=opensips.orgDBENGINE=MYSQLDBHOST=localhostDBNAME=opensipsDBRWUSER=opensipsDBRWPW="opensipsrw"USERCOL="username"ETCDIR="/etc/opensips"

创建数据库

# opensipsdbctl createMySQL password for root:INFO: test server charsetWARNING: Your current default mysql characters set cannot be used to create DB. Please choice another one from the following list:big5dec8cp850hp8koi8rlatin1latin2swe7asciiujissjishebrewtis620euckrkoi8ugb2312greekcp1250gbklatin5armscii8cp866keybcs2maccemacromancp852latin7cp1251utf16cp1256cp1257utf32binarygeostd8cp932eucjpmsEnter character set name:latin1INFO: creating database opensips ...INFO: Core OpenSIPS tables succesfully created.Install presence related tables? (y/n): yINFO: creating presence tables into opensips ...INFO: Presence tables succesfully created.Install tables for imc cpl siptrace domainpolicy carrierroute userblacklist registrant? (y/n): yINFO: creating extra tables into opensips ...INFO: Extra tables succesfully created.

提示 Enter character set name: 时输入latin1 其余选项输入‘y’

测试创建用户

# opensipsctl add 1001 123456new user '1001' added

# vim /etc/opensips/opensipsctlrc

SIP_DOMAIN=opensips.orgDBENGINE=PGSQLDBHOST=localhostDBNAME=opensipsDBRWUSER=opensipsDBRWPW="opensipsrw"USERCOL="username"ETCDIR="/etc/opensips"

# grep -v ^# opensipsctlrc | grep -v ^$SIP_DOMAIN=opensips.orgDBENGINE=DB_BERKELEYDB_PATH="/etc/opensips/bdb"USERCOL="username"ETCDIR="/etc/opensips"

# opensipsdbctl createwhich: no db4.4_dump in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin//:/usr/sbin//:/usr/sbin/:/usr/local/BerkeleyDB.4.6/bin)which: no db4.5_dump in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin//:/usr/sbin//:/usr/sbin/:/usr/local/BerkeleyDB.4.6/bin)which: no db4.6_dump in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin//:/usr/sbin//:/usr/sbin/:/usr/local/BerkeleyDB.4.6/bin)which: no db4.7_dump in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin//:/usr/sbin//:/usr/sbin/:/usr/local/BerkeleyDB.4.6/bin)which: no db4.8_dump in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin//:/usr/sbin//:/usr/sbin/:/usr/local/BerkeleyDB.4.6/bin)which: no db4.4_load in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin//:/usr/sbin//:/usr/sbin/:/usr/local/BerkeleyDB.4.6/bin)which: no db4.5_load in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin//:/usr/sbin//:/usr/sbin/:/usr/local/BerkeleyDB.4.6/bin)which: no db4.6_load in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin//:/usr/sbin//:/usr/sbin/:/usr/local/BerkeleyDB.4.6/bin)which: no db4.7_load in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin//:/usr/sbin//:/usr/sbin/:/usr/local/BerkeleyDB.4.6/bin)which: no db4.8_load in (/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/sbin//:/usr/sbin//:/usr/sbin/:/usr/local/BerkeleyDB.4.6/bin)INFO: creating Berkeley DB database at: [/etc/opensips/bdb]Install presence related tables? (y/n): yInstall tables for imc cpl siptrace domainpolicy carrierroute userblacklist registrant? (y/n): y