[AsteriskBrasil] Configurando o CEL com Mysql via ODBC

[eassis em linuxmail.org]

Neimar, agradeço sua resposta. Mas saberia me ajudar com isso: ?

 Configurei como vc me passou somente alterando no  */etc/odbcinst.ini e não colocando *Setup = /usr/lib/libodbcmyS.so pois no Slack não achei.

 *No /var/log/asterisk/messages ele somente aparece:*

 *[Aug 24 09:01:11] ERROR[3742] cel_odbc.c: Unable to query database columns on connection 'asterisk'. Skipping.*

 *Mas tenho um database chamado asterisk, com a tabela cel.*

 E no Asterisk está:

 *CLI>* *cel show status*
CEL Logging: Enabled
CEL Tracking Event: ALL
CEL Tracking Event: CHAN_START
CEL Tracking Event: CHAN_END
CEL Tracking Event: HANGUP
CEL Tracking Event: ANSWER
CEL Tracking Event: APP_START
CEL Tracking Event: APP_END
CEL Tracking Event: BRIDGE_START
CEL Tracking Event: BRIDGE_END
CEL Tracking Event: CONF_START
CEL Tracking Event: CONF_END
CEL Tracking Event: PARK_START
CEL Tracking Event: PARK_END
CEL Tracking Event: BLINDTRANSFER
CEL Tracking Event: ATTENDEDTRANSFER
CEL Tracking Event: TRANSFER
CEL Tracking Event: HOOKFLASH
CEL Tracking Event: 3WAY_START
CEL Tracking Event: 3WAY_END
CEL Tracking Event: CONF_ENTER
CEL Tracking Event: CONF_EXIT
CEL Tracking Event: USER_DEFINED
CEL Tracking Event: LINKEDID_END
CEL Tracking Event: BRIDGE_UPDATE
CEL Tracking Event: PICKUP
CEL Tracking Event: FORWARD
CEL Tracking Application: all
CEL Event Subscriber: Manager Event Logging
CEL Event Subscriber: ODBC CEL backend
CEL Event Subscriber: CEL Custom CSV Logging

CLI> odbc show

ODBC DSN Settings
-----------------

 Name: asterisk
 DSN: MySQL-asterisk
 Last connection attempt: 1969-12-31 21:00:00
 Pooled: No
 Connected: Yes

CLI> module show like odbc
Module Description Use Count
res_odbc.so ODBC resource 0
res_config_odbc.so Realtime ODBC configuration 0
cdr_adaptive_odbc.so Adaptive ODBC CDR backend 0
cel_odbc.so ODBC CEL backend 0
func_odbc.so ODBC lookups 0
cdr_odbc.so ODBC CDR Backend 0
6 modules loaded


-- Estrutura da tabela `cel`
--
CREATE TABLE IF NOT EXISTS `cel` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `eventtype` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `eventtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 `userdeftype` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `cid_name` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `cid_num` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `cid_ani` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `cid_rdnis` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `cid_dnid` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `exten` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `context` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `channame` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `appname` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `appdata` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `amaflags` int(11) NOT NULL,
 `accountcode` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `peeraccount` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `uniqueid` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `linkedid` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `userfield` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `peer` varchar(80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 *Abraços.*
-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: http://listas.asteriskbrasil.org/pipermail/asteriskbrasil/attachments/20110824/dd02fe1e/attachment-0001.htm