Asterisk with mysql always hangup

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 :

  1. dial using sip
  2. 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

Use “Hangup” and not “Hungup” to end the call.

Cheers.

Marco Bruni

ok thank you,
i’ve change Hungup to Hangup,
so in table extensions i have app field with hangup entry.
then i try it, it still doesn’t work and it’s still hangup when other client pickup the phone

this my extensioins table

i guess, is there possible datafield for simple voip call

thanks

Send your asterisk console output

That may help more … I’m using Realtime for the extension plans but keep my devices still in SIP.conf. Realtime works great to share configurations among asterisk servers.