<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 class="gmail_quote">2011/8/23 <span dir="ltr"><<a href="mailto:eassis@linuxmail.org">eassis@linuxmail.org</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;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">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>