[asterisk-users] CEL ODBC problem in 1.8.0

[Nic Colledge]

Hi,

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.

Thanks,
Nic Colledge
nic at njcolledge.net<mailto:nic at njcolledge.net>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20101022/b34e3921/attachment.htm