hi,
i try to make asterisk running with it’s user anda dial plan stored in mysql database. I make a database called katiamongVoip with two tables, sip_buddies and extensions.
[b]sip_buddies table[/b]
CREATE TABLE `sip_buddies` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(80) NOT NULL default '',
`accountcode` varchar(20) default NULL,
`amaflags` varchar(13) default NULL,
`callgroup` varchar(10) default NULL,
`callerid` varchar(80) default NULL,
`canreinvite` char(3) default 'yes',
`context` varchar(80) default NULL,
`defaultip` varchar(15) default NULL,
`dtmfmode` varchar(7) default NULL,
`fromuser` varchar(80) default NULL,
`fromdomain` varchar(80) default NULL,
`fullcontact` varchar(80) default NULL,
`host` varchar(31) NOT NULL default '',
`insecure` varchar(4) default NULL,
`language` char(2) default NULL,
`mailbox` varchar(50) default NULL,
`md5secret` varchar(80) default NULL,
`nat` varchar(5) NOT NULL default 'no',
`deny` varchar(95) default NULL,
`permit` varchar(95) default NULL,
`mask` varchar(95) default NULL,
`pickupgroup` varchar(10) default NULL,
`port` varchar(5) NOT NULL default '',
`qualify` char(3) default NULL,
`restrictcid` char(1) default NULL,
`rtptimeout` char(3) default NULL,
`rtpholdtimeout` char(3) default NULL,
`secret` varchar(80) default NULL,
`type` varchar(6) NOT NULL default 'friend',
`username` varchar(80) NOT NULL default '',
`disallow` varchar(100) default 'all',
`allow` varchar(100) default 'g729;ilbc;gsm;ulaw;alaw',
`musiconhold` varchar(100) default NULL,
`regseconds` int(11) NOT NULL default '0',
`ipaddr` varchar(15) NOT NULL default '',
`regexten` varchar(80) NOT NULL default '',
`cancallforward` char(3) default 'yes',
`setvar` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `name_2` (`name`)
) TYPE=MyISAM ROW_FORMAT=DYNAMIC;
[b]
Create table "extensions" using:[/b]
---------------------------------------
CREATE TABLE `asterisk`.`extensions` (
`id` int(11) NOT NULL auto_increment,
`context` varchar(20) NOT NULL default '',
`exten` varchar(20) NOT NULL default '',
`priority` tinyint(4) NOT NULL default '0',
`app` varchar(20) NOT NULL default '',
`appdata` varchar(128) NOT NULL default '',
PRIMARY KEY (`context`,`exten`,`priority`),
KEY `id` (`id`)
) ENGINE=MyISAM;
an then i create two user with 901 and 902. after that i input the dialplan on table extension. The diallan quite simple :
- dial using sip
- hang up
INSERT into extensions (id, context, exten, priority, app, appdata)
VALUES ('','default','901','1','Dial','SIP/901');
this is the second user
INSERT into extensions (id, context, exten, priority, app, appdata)
VALUES ('','default','902','1','Dial','SIP/902');
and then i create the second priority
INSERT into extensions (id, context, exten, priority, app, appdata)
VALUES ('','default','901','2','Hungup',' ');
the second extensions
INSERT into extensions (id, context, exten, priority, app, appdata)
VALUES ('','default','902','2','Hungup',' ');
mysql server is running well andi could register the user using the dabase. user 901 and 902 could register to hte server. When itry to call each other, it’s ringing but when get the call it’s suddenly Hang up
this the major configuration :
sip.conf, i let it default and only add
rtcachefriends=yes
the extensions.conf, i let it default and only add
switch => Realtime/default@extensions
is there somthing worng with my dial plan ?
thank you