CEL ODBC problem in 1.8.0

Home » Asterisk Users » CEL ODBC problem in 1.8.0
Asterisk Users No Comments


I have been experimenting with CEL in a trunk version of asterisk for some time and have upgraded my test machine to 1.8.0 today.

Made a few calls and it looks like the eventtype field is missing in the CEL insert query when using ODBC. I see the following errors on the console:

[Oct 22 21:46:09] WARNING[952]: res_odbc.c:634 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 23502: ERROR: null value in column “eventtype” violates not-null constraint;
Error while executing the query (101)
[Oct 22 21:46:09] WARNING[952]: res_odbc.c:646 ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a reconnect…
[Oct 22 21:46:09] WARNING[952]: res_odbc.c:742 ast_odbc_sanity_check: Connection is down attempting to reconnect…
[Oct 22 21:46:09] NOTICE[952]: res_odbc.c:1472 odbc_obj_connect: Connecting PostgreSQL-asterisk
[Oct 22 21:46:09] NOTICE[952]: res_odbc.c:1502 odbc_obj_connect: res_odbc: Connected to PostgreSQL-asterisk [asterisk-connector]
[Oct 22 21:46:09] WARNING[952]: cel_odbc.c:733 odbc_log: Insert failed on ‘PostgreSQL-asterisk:celnew’. CEL failed: INSERT INTO celnew (uniqueid,linkedid,eventtime,userdeftype,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,accountcode,peeraccount,userfield,peer,amaflags) VALUES (‘co-1287780365.0′,’co-1287780365.0’,{ ts ‘2010-10-22 21:46:06′ },”,’135′,’441XXXXXXXXX’,’441XXXXXXXXX’,”,’136′,’136′,’internal’,’SIP/135-00000000′,”,”,’SIP/135′,’SIP/135′,”,”,3)

I have copied my old config files and am using the postgresql database which worked fine with the old (trunk) version from ages ago.

When I use the PGSQL native driver instead of ODBC with the same postgresql table it works fine.

Is this a bug?

P.s. great work on 1.8.0 by the way, thanks to all the developers, testers and everyone involved.

Nic Colledge