# Cel logging to odbc

**URL:** <https://community.asterisk.org/t/cel-logging-to-odbc/47836>\
**Category:** Asterisk Support\
**Created:** [December 31, 2014, 3:41pm UTC](https://community.asterisk.org/t/cel-logging-to-odbc/47836 "2014-12-31T15:41:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![londonnet](https://avatars.discourse-cdn.com/v4/letter/l/c68b51/32.png) [@londonnet](https://community.asterisk.org/u/londonnet)\
**Post date:** [December 31, 2014, 3:41pm UTC](https://community.asterisk.org/t/cel-logging-to-odbc/47836/1 "2014-12-31T15:41:25Z")

</div>

I’m having trouble getting cel to log to mysql via odbc.

I am logging cdr via cdr\_adaptive\_odbc so I know the backend is working OK.

but when I issue the cel show status command I get the following output  
CEL Logging: Disabled

I have checked cel.conf and I have the following set:  
enable=yes

and i have added the following to cel\_odbc.conf which is similar to my cdr\_adaptive\_odbc config  
[asterisk]  
connection=asterisk-odbc  
table=ast\_cel  
username=yyyyy  
password=xxxxxx  
loguniqueid=yes

I have also checked in modules.conf that all of the cel modules are to be loaded and when I list the loaded moduals I get this

module show like cel  
Module Description Use Count Status Support Level  
app\_celgenuserevent.so Generate an User-Defined CEL event 0 Running core  
cel\_custom.so Customizable Comma Separated Values CEL 0 Running core  
cel\_manager.so Asterisk Manager Interface CEL Backend 0 Running core  
cel\_odbc.so ODBC CEL backend 0 Running core  
cel\_sqlite3\_custom.so SQLite3 Custom CEL Module 0 Not Running extended  
res\_format\_attr\_celt.so CELT Format Attribute Module 0 Running core  
6 modules loaded

So why is this not working? anything else to check?

Thanks

---

<div class="post-metadata">

**Author:** ![londonnet](https://avatars.discourse-cdn.com/v4/letter/l/c68b51/32.png) [@londonnet](https://community.asterisk.org/u/londonnet)\
**Post date:** [January 16, 2015, 8:28pm UTC](https://community.asterisk.org/t/cel-logging-to-odbc/47836/2 "2015-01-16T20:28:55Z")

</div>

Got this working by having to select all applications.

---

<div class="post-metadata">

**Author:** ![shika007](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@shika007](https://community.asterisk.org/u/shika007)\
**Post date:** [July 13, 2017, 8:40am UTC](https://community.asterisk.org/t/cel-logging-to-odbc/47836/3 "2017-07-13T08:40:52Z")

</div>

can know that how do you fix that…? i got same problem in here
