<span style="font-family: courier new,monospace;">Segue:</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">yum install wget elinks gcc-c++ gmp kernel-devel libtool libtool-ltdl libtool-ltdl-devel libxml2 libxml2-devel make ncurses-devel net-snmp-devel net-snmp-utils newt newt-devel openssl-devel spandsp spandsp-devel sqlite-devel subversion unixODBC unixODBC-devel vim-common vim-enhanced</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">wget <a href="http://downloads.asterisk.org/pub/telephony/asterisk/releases/asterisk-1.8.5.0.tar.gz">http://downloads.asterisk.org/pub/telephony/asterisk/releases/asterisk-1.8.5.0.tar.gz</a></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">tar xfz asterisk-1.8.5.0.tar.gz</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">cd asterisk-1.8.5.0</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">./configure; make ; make install ; <b><span style="color: rgb(204, 0, 0);">make samples; </span></b>make config</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Se não quiser sobreescrever o seu /etc/asterisk, remova o make samples.</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Neimar.</span><br><br><br><div class="gmail_quote">2011/8/24 Telesurf Multimidia <span dir="ltr"><<a href="mailto:tele-surf@hotmail.com">tele-surf@hotmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><div dir="ltr">
Ola Neimar, poderia passar a sequecia de instalacao do asterisk 1.8 no Centos, porque instalei no Centos 6, mas ele nao entra no cli , so mente se eu der asterisk -g antes, no log all , nao aparece erros. Qual a dica?<br>
<br><div><hr>Date: Tue, 23 Aug 2011 18:02:07 -0300<br>From: <a href="mailto:neimar.avila@gmail.com" target="_blank">neimar.avila@gmail.com</a><br>To: <a href="mailto:asteriskbrasil@listas.asteriskbrasil.org" target="_blank">asteriskbrasil@listas.asteriskbrasil.org</a><br>
Subject: Re: [AsteriskBrasil] Configurando o CEL com Mysql via ODBC<div><div></div><div class="h5"><br><br><span style="font-family:courier new,monospace">Segue como uso no CentOS x86_64 com Asterisk 1.8.5.0</span><br style="font-family:courier new,monospace">
<b style="font-family:courier new,monospace"><br><span style="color:rgb(0, 0, 0)">cat cel.conf</span><br>
</b><span style="font-family:courier new,monospace">[general]</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">enable=yes</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">apps=all</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">events=all</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">dateformat = %F %T</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">[manager]</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">enabled=yes</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">[radius]</span><br style="font-family:courier new,monospace">
<br><br style="font-family:courier new,monospace"><b style="font-family:courier new,monospace">cat cel_odbc.conf</b><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">[global]</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">connection=asterisk</span> <span style="font-family:courier new,monospace;color:rgb(255, 0, 0)">; repare que não há o MYSQL- que foi extinto no Asterisk 1.6.2 devendo aparecer somente no res_odbc.conf</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">table=cel</span><br style="font-family:courier new,monospace"><br style="font-family:courier new,monospace"><b style="font-family:courier new,monospace">cat res_odbc.conf</b><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">[ENV]</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">[asterisk]</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">dsn => MySQL-asterisk</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">pre-connect => yes</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">enabled => yes</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">pre-connect => yes</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">idlecheck => 3600</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">username => asterisk</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">password => asteriskpass</span><br style="font-family:courier new,monospace"><br style="font-family:courier new,monospace"><b style="font-family:courier new,monospace">cat /etc/odbcinst.ini</b><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">[MySQL]</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">Description = MySQL ODBC MyODBC Driver</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">Driver = /usr/lib64/libmyodbc3.so</span> <b style="color:rgb(255, 0, 0);font-family:courier new,monospace">; Confirme o caminho das suas libs</b><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">Setup = /usr/lib/libodbcmyS.so</span> <b style="color:rgb(255, 0, 0);font-family:courier new,monospace">; Confirme o caminho das suas libs</b><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">FileUsage = 1</span><br style="font-family:courier new,monospace"><b style="font-family:courier new,monospace"><br>cat /etc/odbc.ini</b><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">[MySQL-asterisk]</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">Description = MySQL ODBC Driver</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">Driver = MySQL</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">Socket = /var/lib/mysql/mysql.sock</span> <b style="color:rgb(255, 0, 0)"><span style="font-family:courier new,monospace">; confirme o caminho do socket do mysql</span></b><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">Server = localhost</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">User = asterisk</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">Password = asteriskpass</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">Database = asterisk</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">Option = 3</span><br><br><br><b><span style="font-family:courier new,monospace">asterisk*CLI> cel show status</span></b><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Logging: Enabled</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">CEL Tracking Event: ALL</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Tracking Event: CHAN_START</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">CEL Tracking Event: CHAN_END</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Tracking Event: HANGUP</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">CEL Tracking Event: ANSWER</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Tracking Event: APP_START</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">CEL Tracking Event: APP_END</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Tracking Event: BRIDGE_START</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">CEL Tracking Event: BRIDGE_END</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Tracking Event: CONF_START</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">CEL Tracking Event: CONF_END</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Tracking Event: PARK_START</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">CEL Tracking Event: PARK_END</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Tracking Event: BLINDTRANSFER</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">CEL Tracking Event: ATTENDEDTRANSFER</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Tracking Event: TRANSFER</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">CEL Tracking Event: HOOKFLASH</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Tracking Event: 3WAY_START</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">CEL Tracking Event: 3WAY_END</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Tracking Event: CONF_ENTER</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">CEL Tracking Event: CONF_EXIT</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Tracking Event: USER_DEFINED</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">CEL Tracking Event: LINKEDID_END</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Tracking Event: BRIDGE_UPDATE</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">CEL Tracking Event: PICKUP</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Tracking Event: FORWARD</span><br style="font-family:courier new,monospace"><span style="font-family:courier new,monospace">CEL Tracking Application: all</span><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Event Subscriber: Manager Event Logging</span><br style="font-family:courier new,monospace"><b><span style="font-family:courier new,monospace;color:rgb(255, 0, 0)">CEL Event Subscriber: ODBC CEL backend</span></b><br style="font-family:courier new,monospace">
<span style="font-family:courier new,monospace">CEL Event Subscriber: CEL Custom CSV Logging</span><br style="font-family:courier new,monospace"><br><br><div>2011/8/23 <span dir="ltr"><<a href="mailto:eassis@linuxmail.org" target="_blank">eassis@linuxmail.org</a>></span><br>
<blockquote style="border-left:1px #ccc solid;padding-left:1ex"><span style="font-family:Verdana"><span style="font-size:12px">Estou tentando configurar o CEL para usar o Mysql via ODBC, pois não tem nativamente.<br>
<br>
Como sempre configurei o cdr e queue via mysql nativamente, estou me perdendo.<br>
<br>
Com a ajuda do <DagMoller> no canal, consegui chegar proximo, mas não está registrando na tabela cel.<br>
<br>
Segue configurações:<br>
<br>
<div>
cat cel.conf</div>
<div>
[general]</div>
<div>
enable=yes</div>
<div>
apps=all</div>
<div>
events=all</div>
<div>
[manager]</div>
<div>
enabled=yes<br>
<br>
<div>
cat cel_odbc.conf</div>
<div>
[global]</div>
<div>
dsn=MySQL-asterisk</div>
<div>
loguniqueid=yes</div>
<div>
dispositionstring=yes</div>
<div>
username=root</div>
<div>
password=123456</div>
<div>
table=cel</div>
<div>
usegmtime=no</div>
<div>
hrtime=yes<br>
<br>
<div>
cat /etc/odbc.ini</div>
<div>
[MySQL-asterisk]</div>
<div>
Description = MySQL ODBC Driver Testing</div>
<div>
Driver = MySQL</div>
<div>
port = 3306</div>
<div>
Socket = /var/run/mysql/mysql.sock</div>
<div>
Server = localhost</div>
<div>
User = root</div>
<div>
Password = 123456</div>
<div>
Database = asterisk</div>
<div>
Option = 3<br>
<br>
<div>
cat /etc/odbcinst.ini</div>
<div>
[MySQL]</div>
<div>
Description = ODBC for MySQL</div>
<div>
Driver = /usr/local/lib/libmyodbc5.so</div>
<div>
Setup = /usr/local/lib/libmyodbc5.so</div>
<div>
FileUsage = 1<br>
<br>
<div>
CLI> cel show status</div>
<div>
CEL Logging: Enabled</div>
<div>
CEL Tracking Event: ALL</div>
<div>
CEL Tracking Event: CHAN_START</div>
<div>
CEL Tracking Event: CHAN_END</div>
<div>
CEL Tracking Event: HANGUP</div>
<div>
CEL Tracking Event: ANSWER</div>
<div>
CEL Tracking Event: APP_START</div>
<div>
CEL Tracking Event: APP_END</div>
<div>
CEL Tracking Event: BRIDGE_START</div>
<div>
CEL Tracking Event: BRIDGE_END</div>
<div>
CEL Tracking Event: CONF_START</div>
<div>
CEL Tracking Event: CONF_END</div>
<div>
CEL Tracking Event: PARK_START</div>
<div>
CEL Tracking Event: PARK_END</div>
<div>
CEL Tracking Event: BLINDTRANSFER</div>
<div>
CEL Tracking Event: ATTENDEDTRANSFER</div>
<div>
CEL Tracking Event: TRANSFER</div>
<div>
CEL Tracking Event: HOOKFLASH</div>
<div>
CEL Tracking Event: 3WAY_START</div>
<div>
CEL Tracking Event: 3WAY_END</div>
<div>
CEL Tracking Event: CONF_ENTER</div>
<div>
CEL Tracking Event: CONF_EXIT</div>
<div>
CEL Tracking Event: USER_DEFINED</div>
<div>
CEL Tracking Event: LINKEDID_END</div>
<div>
CEL Tracking Event: BRIDGE_UPDATE</div>
<div>
CEL Tracking Event: PICKUP</div>
<div>
CEL Tracking Event: FORWARD</div>
<div>
CEL Tracking Application: all</div>
<div>
CEL Event Subscriber: Manager Event Logging</div>
<div>
CEL Event Subscriber: ODBC CEL backend</div>
<div>
CEL Event Subscriber: CEL Custom CSV Logging</div>
<br>
Estou usando Slack 13.37 64bits com asterisk 1.8.5<br>
<br>
Não me gera nenhum erro, simplesmente não grava na tabel cel no meu database asterisk.<br>
<br>
Abraços.</div>
</div>
</div>
</div>
</span></span>
<br>_______________________________________________<br>
KHOMP: qualidade em placas de E1, GSM, FXS e FXO para Asterisk.<br>
- Hardware com alta disponibilidade de recursos e qualidade KHOMP<br>
- Suporte técnico local qualificado e gratuito<br>
Conheça a linha completa de produtos KHOMP em <a href="http://www.khomp.com.br" target="_blank">www.khomp.com.br</a><br>
_______________________________________________<br>
DIGIVOICE: Lider no mercado de placas para Asterisk<br>
Único fabricante com Centro de Treinamento especializado.<br>
LANÇAMENTO: Channel Bank TDMoE, até 64 canais FXS / FXO.<br>
<a href="http://www.digivoice.com.br" target="_blank">www.digivoice.com.br</a> ou (11)3016-5200.<br>
________<br>
LANÇAMENTO SHOPVOIP! Gateway Xibelis Lyric VoIP com 2,4 e 6 canais GSM.<br>
Arquitetura Escalável, Balanceamento de Carga, Portabilidade Numérica.<br>
Confira em <a href="http://www.yx.cl/landing/brasil/lyric_voip_asterisk.org" target="_blank">http://www.yx.cl/landing/brasil/lyric_voip_asterisk.org</a><br>
Mais informações: <a href="http://www.shopvoip.com.br" target="_blank">www.shopvoip.com.br</a> ou 0800-6021244<br>
______________________________________________<br>
Para remover seu email desta lista, basta enviar um email em branco para <a href="mailto:asteriskbrasil-unsubscribe@listas.asteriskbrasil.org" target="_blank">asteriskbrasil-unsubscribe@listas.asteriskbrasil.org</a><br></blockquote>
</div>
<br><br clear="all"><br>-- <br>Atenciosamente,<br><br>Neimar Lima de Ávila<br>Administrador Pratanet.com!<br><a href="mailto:neimar@pratanet.com" target="_blank">neimar@pratanet.com</a><br><a href="tel:%2B55%2031%208495-2402" value="+553184952402" target="_blank">+55 31 8495-2402</a><br>
<br>
<br></div></div>_______________________________________________
KHOMP: qualidade em placas de E1, GSM, FXS e FXO para Asterisk.
- Hardware com alta disponibilidade de recursos e qualidade KHOMP
- Suporte t�cnico local qualificado e gratuito
Conhe�a a linha completa de produtos KHOMP em <a href="http://www.khomp.com.br" target="_blank">www.khomp.com.br</a>
_______________________________________________
DIGIVOICE: Lider no mercado de placas para Asterisk
�nico fabricante com Centro de Treinamento especializado.
LAN�AMENTO: Channel Bank TDMoE, at� 64 canais FXS / FXO.
<a href="http://www.digivoice.com.br" target="_blank">www.digivoice.com.br</a> ou (11)3016-5200.
________
LAN�AMENTO SHOPVOIP! Gateway Xibelis Lyric VoIP com 2,4 e 6 canais GSM.
Arquitetura Escal�vel, Balanceamento de Carga, Portabilidade Num�rica.
Confira em <a href="http://www.yx.cl/landing/brasil/lyric_voip_asterisk.org" target="_blank">http://www.yx.cl/landing/brasil/lyric_voip_asterisk.org</a>
Mais informa��es: <a href="http://www.shopvoip.com.br" target="_blank">www.shopvoip.com.br</a> ou 0800-6021244
______________________________________________
Para remover seu email desta lista, basta enviar um email em branco para <a href="mailto:asteriskbrasil-unsubscribe@listas.asteriskbrasil.org" target="_blank">asteriskbrasil-unsubscribe@listas.asteriskbrasil.org</a></div>
</div></div>
<br>_______________________________________________<br>
KHOMP: qualidade em placas de E1, GSM, FXS e FXO para Asterisk.<br>
- Hardware com alta disponibilidade de recursos e qualidade KHOMP<br>
- Suporte técnico local qualificado e gratuito<br>
Conheça a linha completa de produtos KHOMP em <a href="http://www.khomp.com.br" target="_blank">www.khomp.com.br</a><br>
_______________________________________________<br>
DIGIVOICE: Lider no mercado de placas para Asterisk<br>
Único fabricante com Centro de Treinamento especializado.<br>
LANÇAMENTO: Channel Bank TDMoE, até 64 canais FXS / FXO.<br>
<a href="http://www.digivoice.com.br" target="_blank">www.digivoice.com.br</a> ou (11)3016-5200.<br>
________<br>
LANÇAMENTO SHOPVOIP! Gateway Xibelis Lyric VoIP com 2,4 e 6 canais GSM.<br>
Arquitetura Escalável, Balanceamento de Carga, Portabilidade Numérica.<br>
Confira em <a href="http://www.yx.cl/landing/brasil/lyric_voip_asterisk.org" target="_blank">http://www.yx.cl/landing/brasil/lyric_voip_asterisk.org</a><br>
Mais informações: <a href="http://www.shopvoip.com.br" target="_blank">www.shopvoip.com.br</a> ou 0800-6021244<br>
______________________________________________<br>
Para remover seu email desta lista, basta enviar um email em branco para <a href="mailto:asteriskbrasil-unsubscribe@listas.asteriskbrasil.org">asteriskbrasil-unsubscribe@listas.asteriskbrasil.org</a><br></blockquote></div>
<br><br clear="all"><br>-- <br>Atenciosamente,<br><br>Neimar Lima de Ávila<br>Administrador Pratanet.com!<br><a href="mailto:neimar@pratanet.com">neimar@pratanet.com</a><br>+55 31 8495-2402<br><br>