<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Pessoal,<br>
<br>
Aproveitando a deixa estou começando minha migração para o asterisk
1.8 porem ativei o CEL e deixei as opções padroes que vem nele. Fiz
algumas chamadas e nada.<br>
<br>
O CEL irá aparecer no CLI ou irá gerar algum tipo de arquivo?<br>
<br>
Valeu,<br>
Patrick<br>
<br>
Em 24-08-2011 19:30, <a class="moz-txt-link-abbreviated" href="mailto:eassis@linuxmail.org">eassis@linuxmail.org</a> escreveu:
<blockquote cite="mid:20110824223013.166450@gmx.com" type="cite"><span
style="font-family: Verdana;"><span style="font-size: 12px;"><span
style="font-family: Verdana;"><span style="font-size: 12px;">Neimar,
agradeço sua resposta. Mas saberia me ajudar com isso: ?<br>
<br>
Configurei como vc me passou somente alterando no <span
style="font-family: 'courier new',monospace;"><b>/etc/odbcinst.ini
e não colocando </b></span>Setup =
/usr/lib/libodbcmyS.so pois no Slack não achei.<br>
<br>
<span style="font-family: 'courier new',monospace;"><b>No /var/log/asterisk/messages
ele somente aparece:</b><br>
<br>
<b>[Aug 24 09:01:11] ERROR[3742] cel_odbc.c: Unable to
query database columns on connection 'asterisk'.
Skipping.</b><br>
<br>
<b>Mas tenho um database chamado asterisk, com a tabela
cel.</b><br>
<br>
E no Asterisk está:</span></span></span><br>
<br>
<div style="display: inline ! important;">
<div style="display: inline ! important;"> <span
style="font-family: Verdana;"><span style="font-size:
12px;"><span style="font-family: 'courier
new',monospace;"><b style="font-weight: bold;
font-family: 'courier new',monospace;">CLI></b><span
style="font-family: 'courier new',monospace;"> </span></span> </span></span></div>
</div>
<span style="font-family: Verdana;"><span style="font-size:
12px;"><span style="font-family: 'courier new',monospace;"><b>cel
show status</b></span></span></span>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Logging: Enabled</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: ALL</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: CHAN_START</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: CHAN_END</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: HANGUP</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: ANSWER</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: APP_START</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: APP_END</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: BRIDGE_START</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: BRIDGE_END</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: CONF_START</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: CONF_END</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: PARK_START</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: PARK_END</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: BLINDTRANSFER</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: ATTENDEDTRANSFER</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: TRANSFER</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: HOOKFLASH</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: 3WAY_START</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: 3WAY_END</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: CONF_ENTER</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: CONF_EXIT</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: USER_DEFINED</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: LINKEDID_END</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: BRIDGE_UPDATE</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: PICKUP</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Event: FORWARD</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Tracking Application: all</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Event Subscriber: Manager Event Logging</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Event Subscriber: ODBC CEL backend</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">CEL
Event Subscriber: CEL Custom CSV Logging</span></span></span></div>
<br>
<div style="font-weight: bold;"> <br>
<span style="font-family: Verdana;"><span style="font-size:
12px;"><span style="font-family: 'courier
new',monospace;">CLI> odbc show</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"> </span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">ODBC DSN
Settings</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">-----------------</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"> </span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;"> Name:
asterisk</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;"> DSN:
MySQL-asterisk</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;"> Last
connection attempt: 1969-12-31 21:00:00</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">
Pooled: No</span></span></span></div>
<div style="font-weight: bold;"> <span style="font-family:
Verdana;"><span style="font-size: 12px;"><span
style="font-family: 'courier new',monospace;">
Connected: Yes</span></span></span></div>
<br>
<div> <br>
<span style="font-family: Verdana;"><span style="font-size:
12px;"><span style="font-family: 'courier
new',monospace;">CLI> module show like odbc</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;">Module
Description Use Count</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;">res_odbc.so
ODBC resource 0</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;">res_config_odbc.so
Realtime ODBC configuration 0</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;">cdr_adaptive_odbc.so
Adaptive ODBC CDR backend 0</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;">cel_odbc.so
ODBC CEL backend 0</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;">func_odbc.so
ODBC lookups 0</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;">cdr_odbc.so
ODBC CDR Backend 0</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;">6 modules loaded</span></span></span></div>
<br>
<br>
<br>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;">-- Estrutura da tabela `cel`</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;">--</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;">CREATE TABLE IF NOT EXISTS
`cel` (</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `id` bigint(20) unsigned
NOT NULL AUTO_INCREMENT,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `eventtype` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `eventtime` timestamp NOT
NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `userdeftype` varchar(255)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `cid_name` varchar(80)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `cid_num` varchar(80)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `cid_ani` varchar(80)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `cid_rdnis` varchar(80)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `cid_dnid` varchar(80)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `exten` varchar(80)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `context` varchar(80)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `channame` varchar(80)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `appname` varchar(80)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `appdata` varchar(80)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `amaflags` int(11) NOT
NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `accountcode` varchar(20)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `peeraccount` varchar(20)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `uniqueid` varchar(150)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `linkedid` varchar(150)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `userfield` varchar(255)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> `peer` varchar(80)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;"> UNIQUE KEY `id` (`id`)</span></span></span></div>
<div> <span style="font-family: Verdana;"><span
style="font-size: 12px;"><span style="font-family:
'courier new',monospace;">) ENGINE=MyISAM DEFAULT
CHARSET=latin1 AUTO_INCREMENT=1 ;</span></span></span></div>
<br>
<br>
<span style="font-family: Verdana;"><span style="font-size:
12px;"><span style="font-family: 'courier new',monospace;"><b>Abraços.</b></span></span></span>
<p style="margin: 0px; padding: 0px;"> </p>
<br>
<span id="editor_signature"><span style="font-family: Verdana;
font-size: 12px;"> </span></span></span></span>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
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 class="moz-txt-link-abbreviated" href="http://www.khomp.com.br">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 class="moz-txt-link-abbreviated" href="http://www.digivoice.com.br">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 class="moz-txt-link-freetext" href="http://www.yx.cl/landing/brasil/lyric_voip_asterisk.org">http://www.yx.cl/landing/brasil/lyric_voip_asterisk.org</a>
Mais informações: <a class="moz-txt-link-abbreviated" href="http://www.shopvoip.com.br">www.shopvoip.com.br</a> ou 0800-6021244
______________________________________________
Para remover seu email desta lista, basta enviar um email em branco para <a class="moz-txt-link-abbreviated" href="mailto:asteriskbrasil-unsubscribe@listas.asteriskbrasil.org">asteriskbrasil-unsubscribe@listas.asteriskbrasil.org</a></pre>
</blockquote>
</body>
</html>