[AsteriskBrasil] Configurando o CEL com Mysql via ODBC

[eassis em linuxmail.org]

Estou tentando configurar o CEL para usar o Mysql via ODBC, pois não tem nativamente.

 Como sempre configurei o cdr e queue via mysql nativamente, estou me perdendo.

 Com a ajuda do <DagMoller> no canal, consegui chegar proximo, mas não está registrando na tabela cel.

 Segue configurações:

 cat cel.conf
 [general]
 enable=yes
 apps=all
 events=all
 [manager]
 enabled=yes

 cat cel_odbc.conf
 [global]
 dsn=MySQL-asterisk
 loguniqueid=yes
 dispositionstring=yes
 username=root
 password=123456
 table=cel
 usegmtime=no
 hrtime=yes

 cat /etc/odbc.ini
 [MySQL-asterisk]
 Description = MySQL ODBC Driver Testing
 Driver = MySQL
 port = 3306
 Socket = /var/run/mysql/mysql.sock
 Server = localhost
 User = root
 Password = 123456
 Database = asterisk
 Option = 3

 cat /etc/odbcinst.ini
 [MySQL]
 Description = ODBC for MySQL
 Driver = /usr/local/lib/libmyodbc5.so
 Setup = /usr/local/lib/libmyodbc5.so
 FileUsage = 1

 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
 Estou usando Slack 13.37 64bits com asterisk 1.8.5

 Não me gera nenhum erro, simplesmente não grava na tabel cel no meu database asterisk.

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