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