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 n...@njcolledge.net<mailto:n...@njcolledge.net>
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users