<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>