Realtime: asterisk en base de datos - Implementación : Tabla, sip_buddies

 asterisk desde base de datos MySql
 Ver video del proyecto a continuación.

 

Script tabla Sip_buddies

CREATE TABLE `sip_buddies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  `callerid` varchar(80) DEFAULT NULL,
  `defaultuser` varchar(80) NOT NULL,
  `regexten` varchar(80) NOT NULL,
  `secret` varchar(80) DEFAULT NULL,
  `mailbox` varchar(50) DEFAULT NULL,
  `accountcode` varchar(20) DEFAULT NULL,
  `context` varchar(80) DEFAULT NULL,
  `amaflags` varchar(7) DEFAULT NULL,
  `callgroup` varchar(10) DEFAULT NULL,
  `canreinvite` char(3) DEFAULT 'yes',
  `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,
  `insecure` varchar(4) DEFAULT NULL,
  `language` char(2) 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,
  `qualify` char(3) DEFAULT NULL,
  `restrictcid` char(1) DEFAULT NULL,
  `rtptimeout` char(3) DEFAULT NULL,
  `rtpholdtimeout` char(3) DEFAULT NULL,
  `type` varchar(6) NOT NULL DEFAULT 'friend',
  `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,
  `cancallforward` char(3) DEFAULT 'yes',
  `lastms` int(11) NOT NULL,
  `useragent` char(255) DEFAULT NULL,
  `regserver` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `name_2` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=894 DEFAULT CHARSET=latin1;

Registros para Sip_buddies

insert  into `sip_buddies`(`id`,`name`,`callerid`,`defaultuser`,`regexten`,`secret`,`mailbox`,`accountcode`,`context`,`amaflags`,`callgroup`,`canreinvite`,`defaultip`,`dtmfmode`,`fromuser`,`fromdomain`,`fullcontact`,`host`,`insecure`,`language`,`md5secret`,`nat`,`deny`,`permit`,`mask`,`pickupgroup`,`port`,`qualify`,`restrictcid`,`rtptimeout`,`rtpholdtimeout`,`type`,`disallow`,`allow`,`musiconhold`,`regseconds`,`ipaddr`,`cancallforward`,`lastms`,`useragent`,`regserver`) values (1,'3000',NULL,'3000','','1234',NULL,NULL,'my-sip',NULL,NULL,'yes',NULL,NULL,NULL,NULL,'','dynamic',NULL,NULL,NULL,'yes',NULL,NULL,NULL,NULL,'','no',NULL,NULL,NULL,'friend','all','g729;ilbc;gsm;ulaw;alaw',NULL,'','','yes',0,'','');


Script tabla extensions

 CREATE TABLE `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 (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=261 DEFAULT CHARSET=latin1;


Registros para extensions

insert  into `extensions`(`id`,`context`,`exten`,`priority`,`app`,`appdata`) values (1,'my-sip','_3XXX',1,'Dial','SIP/${EXTEN},30,Ttr'),(2,'my-sip','_3XXX',2,'hangup','');


Mas información en mi canal de youtube. https://www.youtube.com/@recursivoweb
 Visita la pagina de facebook: https://www.facebook.com/recursivoweb