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
