Criar a tabela:
\nPor padr\u00e3o organizo tudo dentro de um banco chamadao asterisk
\nCREATE TABLE IF NOT EXISTS `sip_accounts` (
\n `id` int(11) NOT NULL AUTO_INCREMENT,
\n `name` varchar(80) NOT NULL DEFAULT ”,
\n `host` varchar(31) NOT NULL DEFAULT ‘dynamic’,
\n `nat` varchar(5) NOT NULL DEFAULT ‘route’,
\n `type` enum(‘user’,’peer’,’friend’) NOT NULL DEFAULT ‘friend’,
\n `accountcode` varchar(20) DEFAULT NULL,
\n `amaflags` varchar(13) DEFAULT NULL,
\n `callgroup` varchar(10) DEFAULT NULL,
\n `callerid` varchar(80) DEFAULT NULL,
\n `call-limit` int(11) NOT NULL DEFAULT ‘0’,
\n `cancallforward` char(3) DEFAULT ‘no’,
\n `canreinvite` char(3) DEFAULT ‘no’,
\n `context` varchar(80) DEFAULT ‘pre_outgoing’,
\n `defaultip` varchar(15) DEFAULT NULL,
\n `dtmfmode` varchar(7) DEFAULT NULL,
\n `fromuser` varchar(80) DEFAULT NULL,
\n `fromdomain` varchar(80) DEFAULT NULL,
\n `insecure` varchar(4) DEFAULT NULL,
\n `language` char(2) DEFAULT NULL,
\n `mailbox` varchar(50) DEFAULT NULL,
\n `md5secret` varchar(80) DEFAULT NULL,
\n `deny` varchar(95) DEFAULT NULL,
\n `permit` varchar(95) DEFAULT NULL,
\n `mask` varchar(95) DEFAULT NULL,
\n `musiconhold` varchar(100) DEFAULT NULL,
\n `pickupgroup` varchar(10) DEFAULT NULL,
\n `qualify` char(3) DEFAULT NULL,
\n `regexten` varchar(80) DEFAULT NULL,
\n `restrictcid` char(3) DEFAULT NULL,
\n `rtptimeout` char(3) DEFAULT NULL,
\n `rtpholdtimeout` char(3) DEFAULT NULL,
\n `secret` varchar(80) DEFAULT NULL,
\n `setvar` varchar(100) DEFAULT NULL,
\n `disallow` varchar(100) DEFAULT ‘all’,
\n `allow` varchar(100) DEFAULT ‘g729’,
\n `fullcontact` varchar(80) NOT NULL DEFAULT ”,
\n `ipaddr` varchar(15) NOT NULL DEFAULT ”,
\n `port` smallint(5) unsigned NOT NULL DEFAULT ‘0’,
\n `regserver` varchar(100) DEFAULT NULL,
\n `regseconds` int(11) NOT NULL DEFAULT ‘0’,
\n `username` varchar(80) NOT NULL DEFAULT ”,
\n `user` varchar(255) NOT NULL,
\n `placement` varchar(255) NOT NULL,
\n `description` varchar(255) NOT NULL,
\n `delay` int(4) NOT NULL DEFAULT ‘0’,
\n `sortorder` int(11) NOT NULL DEFAULT ‘1’,
\n `useragent` varchar(20) DEFAULT NULL,
\n `lastms` int(11) NOT NULL DEFAULT ‘0’,
\n PRIMARY KEY (`id`),
\n UNIQUE KEY `name` (`name`)
\n) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2357 ;<\/p>\n
Vim \/etc\/asterisk\/res_config_mysql.conf<\/p>\n
[asterisk]
\ndbhost = 127.0.0.1
\ndbname = asterisk
\ndbuser = root
\ndbpass =senha
\ndbport = 3306
\n;dbsock = \/tmp\/mysql.sock<\/p>\n
Vim \/etc\/asterisk\/extconfig.conf
\nsippeers => mysql,asterisk,sip_accounts<\/p>\n
Iniciar o asterisk. <\/p>\n
Aten\u00e7\u00e3o: Os peers n\u00e3o ir\u00e3o ser listados com o comando sip show peers.
\nAcrescente esses item no general do sip.conf para aparecer os ramais conectados em realtime:<\/p>\n
rtcachefriends=yes<\/p>\n","protected":false},"excerpt":{"rendered":"
Criar a tabela: Por padr\u00e3o organizo tudo dentro de um banco chamadao asterisk CREATE TABLE IF NOT EXISTS `sip_accounts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(80) NOT NULL DEFAULT ”, `host` varchar(31) NOT NULL DEFAULT ‘dynamic’, `nat` varchar(5) NOT NULL DEFAULT ‘route’, `type` enum(‘user’,’peer’,’friend’)…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/373"}],"collection":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=373"}],"version-history":[{"count":0,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/373\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}