asterisk realtime 之动态SIP篇（1）

最新推荐文章于 2017-02-08 16:09:23 发布

zhangtuo

最新推荐文章于 2017-02-08 16:09:23 发布

阅读量2.8k

点赞数

分类专栏： asterisk 呼叫中心文章标签： null phpmyadmin mysql centos 测试数据库

本文链接：https://blog.csdn.net/zhangtuo/article/details/6601059

版权

asterisk 同时被 2 个专栏收录

80 篇文章 3 订阅

订阅专栏

呼叫中心

74 篇文章 1 订阅

订阅专栏

测试环境：

proxmox 1.7

centos 5.2 standard 5.2.1

asterisk 1.8.24

mysql

步骤：
1：vi sip.conf
[general]
context=internal
rtcachefriends=yes
disallow=all
allow=ulaw
allow=ilbc

2: vi extensions.conf
[default]
switch => Realtime/default@extensions ; edit by tolooney

3：vi extconfig.conf
[settings]
sipusers => mysql,general,ast_sipfriends ; edit by tolooney
sippeers => mysql,general,ast_sipfriends ; edit by tolooney
extensions => mysql,general,ast_extensions ; edit by tolooney

4:vi res_config_mysql.conf

[general]
dbhost = 192.168.1.62
dbname = asterisk
dbuser = asteriskuser
dbpass = yourpassword
dbport = 3306

5：执行如下SQL
# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# 主机: localhost
# 生成日期: 2011 年 07 月 12 日 15:00
# 服务器版本: 5.0.91
# PHP 版本: 5.2.16
#
# 数据库 : `asterisk`
#

# --------------------------------------------------------

#
# 表的结构 `ast_sipfriends`
#

CREATE TABLE `ast_sipfriends` (
`name` varchar(40) NOT NULL default '',
`type` varchar(10) NOT NULL default '',
`username` varchar(40) default NULL,
`fromuser` varchar(40) default NULL,
`fromdomain` varchar(40) default NULL,
`secret` varchar(40) default NULL,
`md5secret` varchar(40) default NULL,
`auth` varchar(10) default NULL,
`mailbox` varchar(20) default NULL,
`subscribemwi` varchar(10) default NULL,
`vmexten` varchar(20) default NULL,
`callerid` varchar(40) default NULL,
`cid_number` varchar(40) default NULL,
`callingpres` varchar(20) default NULL,
`usereqphone` varchar(10) default NULL,
`language` varchar(10) default NULL,
`incominglimit` varchar(10) default NULL,
`context` varchar(40) NOT NULL default '',
`subscribecontext` varchar(40) default NULL,
`amaflags` varchar(20) default NULL,
`accountcode` varchar(20) default NULL,
`musicclass` varchar(20) default NULL,
`mohsuggest` varchar(20) default NULL,
`allowtransfer` varchar(20) default NULL,
`callgroup` varchar(20) default NULL,
`pickupgroup` varchar(20) default NULL,
`autoframing` varchar(10) default NULL,
`disallow` varchar(20) default 'all',
`allow` varchar(20) default NULL,
`maxcallbitrate` varchar(15) default NULL,
`host` varchar(40) default 'dynamic',
`outboundproxy` varchar(40) default NULL,
`ipaddr` varchar(40) NOT NULL default '',
`defaultip` varchar(20) default NULL,
`port` int(6) NOT NULL default '0',
`fullcontact` varchar(40) default NULL,
`insecure` varchar(20) default NULL,
`qualify` varchar(15) default NULL,
`regseconds` int(11) NOT NULL default '0',
`defaultuser` varchar(128) default NULL,
`regexten` varchar(20) default NULL,
`regserver` varchar(20) default NULL,
`useragent` varchar(128) default NULL,
`rtptimeout` varchar(15) default NULL,
`rtpholdtimeout` varchar(15) default NULL,
`rtpkeepalive` varchar(15) default NULL,
`lastms` int(11) NOT NULL default '-1',
`setvar` varchar(200) default NULL,
PRIMARY KEY (`name`),
KEY `host` (`host`,`port`),
KEY `ipaddr` (`ipaddr`,`port`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# 导出表中的数据 `ast_sipfriends`
#

INSERT INTO `ast_sipfriends` VALUES ('801', 'friend', '801', NULL, NULL, '801', NULL, NULL, NULL, NULL, NULL, '801', NULL, NULL, NULL, NULL, NULL, 'internal', NULL, NULL,

NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'all', 'all', NULL, 'dynamic', NULL, '(null)', NULL, 0, '', 'port,invite', NULL, 1310468143, NULL, NULL, NULL, '', NULL, NULL,

NULL, 0, '');


6:注册801分机
outcall-ast1*CLI> sip show peers
Name/username Host Dyn Forcerport ACL Port Status Realtime
801/801 192.168.1.104 D 28118 Unmonitored Cached RT
1 sip peers [Monitored: 0 online, 0 offline Unmonitored: 1 online, 0 offline]

outcall-ast1*CLI> realtime load sippeers name 801
Column Name Column Value
-------------------- --------------------
name 801
type friend
username 801
fromuser
fromdomain
secret 801
md5secret
auth
mailbox
subscribemwi
vmexten
callerid 801
cid_number
callingpres
usereqphone
language
incominglimit
context internal
subscribecontext
amaflags
accountcode
musicclass
mohsuggest
allowtransfer
callgroup
pickupgroup
autoframing
disallow all
allow all
maxcallbitrate
host dynamic
outboundproxy
ipaddr 192.168.1.104
defaultip
port 28118
fullcontact sip:801@192.168.1.104:28118;rinstance=
insecure port,invite
qualify
regseconds 1310472100
defaultuser
regexten
regserver
useragent X-Lite release 1011a stamp 39982
rtptimeout
rtpholdtimeout
rtpkeepalive
lastms 0
setvar

注册成功，测试通过