<span style='font-family:Verdana'><span style='font-size:12px'><div> 
        <span style="font-family:Verdana"><span style="font-size:12px">Aplicando o Patch que consta nesse link:<br /> 
        <br /> 
        <a href="https://issues.asterisk.org/view.php?id=19058">https://issues.asterisk.org/view.php?id=19058</a><br /> 
        <br /> 
        Ele funcionou em mysql nativamente.<br /> 
        <br /> 
        gerando o cel_mysql.conf<br /> 
        <br /> 
        Irei fazer mais alguns testes.<br /> 
        <br /> 
        Abraços.<br /> 
        <br /> 
        <br /> 
        <br /> 
        <br /> 
        <br /> 
        <br /> 
        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&nbsp;&lt;DagMoller&gt; no canal, consegui chegar proximo, mas não está registrando na tabela cel.<br /> 
        <br /> 
        Segue configurações:</span></span><br /> 
        <br /> 
        <div> 
                <span style="font-family:Verdana"><span style="font-size:12px">cat cel.conf</span></span></div> 
        <div> 
                <span style="font-family:Verdana"><span style="font-size:12px">[general]</span></span></div> 
        <div> 
                <span style="font-family:Verdana"><span style="font-size:12px">enable=yes</span></span></div> 
        <div> 
                <span style="font-family:Verdana"><span style="font-size:12px">apps=all</span></span></div> 
        <div> 
                <span style="font-family:Verdana"><span style="font-size:12px">events=all</span></span></div> 
        <div> 
                <span style="font-family:Verdana"><span style="font-size:12px">[manager]</span></span></div> 
        <div> 
                <span style="font-family:Verdana"><span style="font-size:12px">enabled=yes</span></span><br /> 
                <br /> 
                <div> 
                        <span style="font-family:Verdana"><span style="font-size:12px">cat cel_odbc.conf</span></span></div> 
                <div> 
                        <span style="font-family:Verdana"><span style="font-size:12px">[global]</span></span></div> 
                <div> 
                        <span style="font-family:Verdana"><span style="font-size:12px">dsn=MySQL-asterisk</span></span></div> 
                <div> 
                        <span style="font-family:Verdana"><span style="font-size:12px">loguniqueid=yes</span></span></div> 
                <div> 
                        <span style="font-family:Verdana"><span style="font-size:12px">dispositionstring=yes</span></span></div> 
                <div> 
                        <span style="font-family:Verdana"><span style="font-size:12px">username=root</span></span></div> 
                <div> 
                        <span style="font-family:Verdana"><span style="font-size:12px">password=123456</span></span></div> 
                <div> 
                        <span style="font-family:Verdana"><span style="font-size:12px">table=cel</span></span></div> 
                <div> 
                        <span style="font-family:Verdana"><span style="font-size:12px">usegmtime=no</span></span></div> 
                <div> 
                        <span style="font-family:Verdana"><span style="font-size:12px">hrtime=yes</span></span><br /> 
                        <br /> 
                        <div> 
                                <span style="font-family:Verdana"><span style="font-size:12px">cat /etc/odbc.ini</span></span></div> 
                        <div> 
                                <span style="font-family:Verdana"><span style="font-size:12px">[MySQL-asterisk]</span></span></div> 
                        <div> 
                                <span style="font-family:Verdana"><span style="font-size:12px">Description &nbsp; &nbsp; = MySQL ODBC Driver Testing</span></span></div> 
                        <div> 
                                <span style="font-family:Verdana"><span style="font-size:12px">Driver &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= MySQL</span></span></div> 
                        <div> 
                                <span style="font-family:Verdana"><span style="font-size:12px">port &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= 3306</span></span></div> 
                        <div> 
                                <span style="font-family:Verdana"><span style="font-size:12px">Socket &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= /var/run/mysql/mysql.sock</span></span></div> 
                        <div> 
                                <span style="font-family:Verdana"><span style="font-size:12px">Server &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= localhost</span></span></div> 
                        <div> 
                                <span style="font-family:Verdana"><span style="font-size:12px">User &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= root</span></span></div> 
                        <div> 
                                <span style="font-family:Verdana"><span style="font-size:12px">Password &nbsp; &nbsp; &nbsp; &nbsp;= 123456</span></span></div> 
                        <div> 
                                <span style="font-family:Verdana"><span style="font-size:12px">Database &nbsp; &nbsp; &nbsp; &nbsp;= asterisk</span></span></div> 
                        <div> 
                                <span style="font-family:Verdana"><span style="font-size:12px">Option &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= 3</span></span><br /> 
                                <br /> 
                                <div> 
                                        <span style="font-family:Verdana"><span style="font-size:12px">cat /etc/odbcinst.ini</span></span></div> 
                                <div> 
                                        <span style="font-family:Verdana"><span style="font-size:12px">[MySQL]</span></span></div> 
                                <div> 
                                        <span style="font-family:Verdana"><span style="font-size:12px">Description &nbsp; &nbsp; = ODBC for MySQL</span></span></div> 
                                <div> 
                                        <span style="font-family:Verdana"><span style="font-size:12px">Driver &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= /usr/local/lib/libmyodbc5.so</span></span></div> 
                                <div> 
                                        <span style="font-family:Verdana"><span style="font-size:12px">Setup &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = /usr/local/lib/libmyodbc5.so</span></span></div> 
                                <div> 
                                        <span style="font-family:Verdana"><span style="font-size:12px">FileUsage &nbsp; &nbsp; &nbsp; = 1</span></span><br /> 
                                        <br /> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CLI&gt; cel show status</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Logging: Enabled</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: ALL</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: CHAN_START</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: CHAN_END</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: HANGUP</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: ANSWER</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: APP_START</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: APP_END</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: BRIDGE_START</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: BRIDGE_END</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: CONF_START</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: CONF_END</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: PARK_START</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: PARK_END</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: BLINDTRANSFER</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: ATTENDEDTRANSFER</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: TRANSFER</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: HOOKFLASH</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: 3WAY_START</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: 3WAY_END</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: CONF_ENTER</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: CONF_EXIT</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: USER_DEFINED</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: LINKEDID_END</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: BRIDGE_UPDATE</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: PICKUP</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Event: FORWARD</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Tracking Application: all</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Event Subscriber: Manager Event Logging</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Event Subscriber: ODBC CEL backend</span></span></div> 
                                        <div> 
                                                <span style="font-family:Verdana"><span style="font-size:12px">CEL Event Subscriber: CEL Custom CSV Logging</span></span></div> 
                                        <br /> 
                                        <span style="font-family:Verdana"><span style="font-size:12px">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.</span></span></div> 
                        </div> 
                </div> 
        </div> 
</div> 
</span></span>