Para que tudo funcione corretamente devemos instalar tr\u00eas pacotes al\u00e9m do MySQL antes da compila\u00e7\u00e3o do Asterisk.
\nPara verificar se os m\u00f3dulos est\u00e3o compilados e carregados no Asterisk vamos a console:
\nasterisk \u2013rvvvvvvvvvvvvv<\/p>\n
CLI> module show like odbc
\nModule Description Use Count
\nres_config_odbc.so Realtime ODBC configuration 0
\nres_odbc.so ODBC resource 0
\nfunc_odbc.so ODBC lookups 0
\ncdr_adaptive_odbc.so Adaptive ODBC CDR backend 0
\ncdr_odbc.so ODBC CDR Backend 0
\n5 modules loaded<\/p>\n
Isto indica que temos os m\u00f3dulos no Asterisk. Se n\u00e3o aparecer algo parecido temos que seguir os seguintes passos:<\/p>\n
\u2022\tparar Asterisk
\n\/etc\/init.d\/asterisk stop<\/p>\n
\u2022\tInstalar unixODBC e o conector MySQL para ODBC
\nyum install mysql-connector-odbc unixODBC unixODBC-devel<\/p>\n
\u2022\tInstalar a library ltdl
\nyum install libtool-ltdl-devel libtool-ltdl<\/p>\n
\u2022\tvoltar a instalar o asterisk
\ncd \/usr\/src\/asterisk-versao
\nmake clean
\n.\/configure
\nmake menuselect e ir na quest\u00e3o do voicemail ODBC storage marcado-o<\/p>\n
\u2022\tter certeza que selecionou a op\u00e7\u00e3o ODBC_STORAGE<\/p>\n
\u2022\tPara sair pressione a tecla X para salvar as configura\u00e7\u00f5es
\nmake
\nmake install
\n\u2022\tIniciamos novamente o Asterisk e verificamos atrav\u00e9s da console se os m\u00f3dulos est\u00e3o ativos como fizemos acima
\nSafe_asterisk
\nAgora temos que criar a base de dados MySQL onde vamos criar uma tabela para armazenar os dados relacionados aos correios de voz. Primeiro um restart no servidor MySQL<\/p>\n
\/etc\/init.d\/mysqld restart
\nCriamos as base de dados:
\nBanco asterisk: Tabela voicemail_users
\n Tabela voicemail_messages<\/p>\n
voicemail_users
\nSET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;
\nSET time_zone = “+00:00″;
\nCREATE TABLE IF NOT EXISTS `voicemail_users` (
\n `uniqueid` int(4) NOT NULL AUTO_INCREMENT,
\n `customer_id` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `context` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
\n `mailbox` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
\n `password` int(4) NOT NULL,
\n `fullname` varchar(150) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `pager` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `tz` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT ‘central’,
\n `attach` enum(‘yes’,’no’) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘yes’,
\n `saycid` enum(‘yes’,’no’) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘yes’,
\n `dialout` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `callback` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `review` enum(‘yes’,’no’) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘no’,
\n `operator` enum(‘yes’,’no’) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘no’,
\n `envelope` enum(‘yes’,’no’) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘no’,
\n `sayduration` enum(‘yes’,’no’) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘no’,
\n `saydurationm` tinyint(4) NOT NULL DEFAULT ‘1’,
\n `sendvoicemail` enum(‘yes’,’no’) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘no’,
\n `delete` enum(‘yes’,’no’) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘no’,
\n `nextaftercmd` enum(‘yes’,’no’) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘yes’,
\n `forcename` enum(‘yes’,’no’) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘no’,
\n `forcegreetings` enum(‘yes’,’no’) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘no’,
\n `hidefromdir` enum(‘yes’,’no’) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘yes’,
\n `stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\n `attachfmt` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `searchcontexts` enum(‘yes’,’no’) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `cidinternalcontexts` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `exitcontext` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `volgain` varchar(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `tempgreetwarn` enum(‘yes’,’no’) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT ‘yes’,
\n `messagewrap` enum(‘yes’,’no’) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT ‘no’,
\n `minpassword` int(2) DEFAULT ‘4’,
\n `vm-password` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `vm-newpassword` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `vm-passchanged` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `vm-reenterpassword` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `vm-mismatch` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `vm-invalid-password` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `vm-pls-try-again` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `listen-control-forward-key` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `listen-control-reverse-key` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `listen-control-pause-key` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `listen-control-restart-key` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `listen-control-stop-key` varchar(13) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
\n `backupdeleted` varchar(3) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT ’25’,
\n PRIMARY KEY (`uniqueid`),
\n KEY `mailbox_context` (`mailbox`,`context`)
\n) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;<\/p>\n
voicemail_messages
\nSET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;
\nSET time_zone = “+00:00″;<\/p>\n
CREATE TABLE IF NOT EXISTS `voicemail_messages` (
\n `id` int(11) NOT NULL AUTO_INCREMENT,
\n `msgnum` int(11) NOT NULL DEFAULT ‘0’,
\n `dir` varchar(80) DEFAULT ”,
\n `context` varchar(80) DEFAULT ”,
\n `macrocontext` varchar(80) DEFAULT ”,
\n `callerid` varchar(40) DEFAULT ”,
\n `origtime` varchar(40) DEFAULT ”,
\n `duration` varchar(20) DEFAULT ”,
\n `mailboxuser` varchar(80) DEFAULT ”,
\n `mailboxcontext` varchar(80) DEFAULT ”,
\n `recording` longblob,
\n `flag` varchar(128) DEFAULT ”,
\n PRIMARY KEY (`id`),
\n KEY `dir` (`dir`)
\n) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;<\/p>\n
Criar um usu\u00e1rio ou dar permiss\u00e3o ao root All privileges<\/p>\n
Temos nossa base de dados e sua tabela com um usuario com total previlegio para manipula-la.
\nAgora temos que criar dois arquivos no diretorio \/etc para conectar a ODBC com o MySQL
\nvim \/etc\/odbcinst.ini
\ne adicionamos essas linhas
\n[MySQL]
\nDescription = ODBC for MySQL
\nDriver = \/usr\/lib\/libmyodbc5.so
\nSetup = \/usr\/lib\/libodbcmyS.so
\nDriver64 = \/usr\/lib64\/libmyodbc5.so
\nSetup64 = \/usr\/lib64\/libodbcmyS.so
\nFileUsage = 1
\nNo meu caso j\u00e1 existia esse diret\u00f3rio criado.<\/p>\n
Vim \/etc\/odbc.ini
\n[asterisk-connector]
\nDescription = MySQL connection to asterisk database
\nDriver = MySQL
\nDatabase = asterisk
\nServername = localhost
\nUserName = root
\nPassword = zoltrix90
\nPort = 3306
\nOption = 3<\/p>\n
Como pode perceber aqui est\u00e3o todos os dados do banco rec\u00e9m criado (base de dados, host, usuario e senha). Se atente a chave [asterisk-conector] pois vamos necessitar para configura\u00e7\u00e3o do arquivos res_odbc.conf
\nAgora modificamos o arquivo extconfig.conf para dizer ao Asterisk que agora os dados est\u00e3o em realtime.
\nvim \/etc\/asterisk\/extconfig.conf adicionamos na parte final do arquivos esta linha:
\nvoicemail => mysql,asterisk,voicemail_users
\nsalvamos o arquivo
\ne passamos para o voicemail
\nvim \/etc\/asterisk\/voicemail.conf
\nAdicionar:
\ndbuser=root
\ndbpass=senha
\ndbhost=localhost
\ndbname=asterisk<\/p>\n
procurar por esta duas linhas e descomenta-las retirando o ponto e virgula.
\nodbcstorage=asterisk
\nodbctable=voicemail_messages<\/p>\n
Como pode notar odbcstorage \u00e9 o que indicamos no extconfig.conf e voicemessages \u00e9 a tabela da base de dados voicemail
\nsalvamo o arquivos e passamos para o pr\u00f3ximo
\nnano \/etc\/asterisk\/res_odbc.conf
\nadicionar\/modificar estas linhas:
\n[asterisk]
\nenabled => yes
\ndsn => asterisk-connector
\nusername => root
\npassword => senha
\npre-connect => yes
\no dsn \u00e9 a chave que vimos acima
\nagora que temos tudo configurado vamos iniciar o Asterisk
\n\/etc\/init.d\/asterisk start
\ne verificar se tudo est\u00e1 funcionando
\nasterisk -rvvvvvvvvvvvvvvvv
\nCLI> odbc show
\nODBC DSN Settings
\n\u2014\u2014\u2014\u2014\u2014\u2013
\nName: asterisk
\nDSN: asterisk-connector
\nPooled: No
\nConnected: Yes
\nnos registros do Asterisk temos que encontrar estas linhas:
\n[Dec 5 14:01:59] NOTICE[18763] config.c: Registered Config Engine odbc
\n[Dec 5 14:02:00] NOTICE[18763] res_odbc.c: Connecting asterisk
\n[Dec 5 14:02:00] NOTICE[18763] res_odbc.c: res_odbc: Connected to asterisk [asterisk-connector]
\n[Dec 5 14:02:00] NOTICE[18763] res_odbc.c: Registered ODBC class \u2018asterisk\u2019 dsn->[asterisk-connector]
\n[Dec 5 14:02:00] NOTICE[18763] res_odbc.c: res_odbc loaded.
\nAgora para testar o sistema efetue alguma chamadas para alguns ramais e deixe um recado no correio de voz<\/p>\n
\u00d3timo!!!
\nCaso voc\u00ea utilize o webmin ou phpmysqladmin pode verificar que na tabela voicemessages j\u00e1 possui os registros dos recados deixados nos testes.
\nIsso \u00e9 tudo!<\/p>\n","protected":false},"excerpt":{"rendered":"
Para que tudo funcione corretamente devemos instalar tr\u00eas pacotes al\u00e9m do MySQL antes da compila\u00e7\u00e3o do Asterisk. Para verificar se os m\u00f3dulos est\u00e3o compilados e carregados no Asterisk vamos a console: asterisk \u2013rvvvvvvvvvvvvv CLI> module show like odbc Module Description Use Count res_config_odbc.so Realtime ODBC…<\/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\/370"}],"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=370"}],"version-history":[{"count":0,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/370\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=370"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}