Git Product home page Git Product logo

habilitar-realtime-asterisk-para-registro-sip-2.0's Introduction

Segue o manual para ativar do realtime do Asterisk 16 para registro de ramal sip 2.0 via banco MySQL.

No PABX

  1. Editar o arquivo /etc/asterisk/res_config_mysql.conf, descomentando as linha dbuser e dbpass.

  2. Ajustar os campos dbuser e dbpass para as credencias para acessar o banco. conforme abaixo.
    dbuser = asterisk
    dbpass = senha123

  3. Ativar atualização dos dados de ramal via banco. editando o arquivo /etc/asterisk/extconfig.conf, descomentando a linha sipeers. Conforme abaixo.ABS
    sippeers => odbc,asterisk

No Banco

  1. Criar novo usuario.
CREATE USER 'asterisk'@'*' IDENTIFIED BY 'senha123';
SET PASSWORD FOR asterisk@'%'=PASSWORD('senha123');
GRANT ALL PRIVILEGES ON *.* TO 'asterisk'@'%';
FLUSH PRIVILEGES;
  1.  Criar tabela de cadastro de ramais.
DROP TABLE IF EXISTS asterisk.`sippeers`; 
CREATE TABLE asterisk.`sippeers` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    `ipaddr` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `port` int(5) DEFAULT NULL,
    `regseconds` int(11) DEFAULT NULL,
    `defaultuser` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `fullcontact` varchar(35) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `regserver` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `useragent` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `lastms` int(11) DEFAULT NULL,
    `host` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `type` enum('friend','user','peer') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `context` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `permit` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `deny` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `secret` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `md5secret` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `remotesecret` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `transport` enum('udp','tcp','udp,tcp','tcp,udp') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `dtmfmode` enum('rfc2833','info','shortinfo','inband','auto') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `directmedia` enum('yes','no','nonat','update') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `nat` enum('yes','no','never','route') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `callgroup` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `pickupgroup` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `language` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `allow` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `disallow` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `insecure` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `trustrpid` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `progressinband` enum('yes','no','never') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `promiscredir` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `useclientcode` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `accountcode` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `setvar` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `callerid` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `amaflags` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `callcounter` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `busylevel` int(11) DEFAULT NULL,
    `allowoverlap` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `allowsubscribe` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `videosupport` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `maxcallbitrate` int(11) DEFAULT NULL,
    `rfc2833compensate` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `mailbox` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `session-timers` enum('accept','refuse','originate') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `session-expires` int(11) DEFAULT NULL,
    `session-minse` int(11) DEFAULT NULL,
    `session-refresher` enum('uac','uas') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `t38pt_usertpsource` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `regexten` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `fromdomain` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `fromuser` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `qualify` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `defaultip` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `rtptimeout` int(11) DEFAULT NULL,
    `rtpholdtimeout` int(11) DEFAULT NULL,
    `sendrpid` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `outboundproxy` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `callbackextension` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `timert1` int(11) DEFAULT NULL,
    `timerb` int(11) DEFAULT NULL,
    `qualifyfreq` int(11) DEFAULT NULL,
    `constantssrc` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `contactpermit` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `contactdeny` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `usereqphone` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `textsupport` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `faxdetect` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `buggymwi` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `auth` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `fullname` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `trunkname` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `cid_number` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `callingpres` enum('allowed_not_screened','allowed_passed_screen','allowed_failed_screen','allowed','prohib_not_screened','prohib_passed_screen','prohib_failed_screen','prohib') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `mohinterpret` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `mohsuggest` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `parkinglot` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `hasvoicemail` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `subscribemwi` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `vmexten` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `autoframing` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `rtpkeepalive` int(11) DEFAULT NULL,
    `call-limit` int(11) DEFAULT NULL,
    `g726nonstandard` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `ignoresdpversion` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `allowtransfer` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `dynamic` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`),
    KEY `ipaddr` (`ipaddr`,`port`),
    KEY `host` (`host`,`port`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  1. Insert para criar um novo ramal.
INSERT INTO asterisk.sippeers
    (name, secret, host, context)
VALUES
    ('6001', '6001', 'dynamic', 'from-internal');

habilitar-realtime-asterisk-para-registro-sip-2.0's People

Contributors

felipemerenciooficial avatar

Watchers

avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.