I experienced a similar problem, asked here, and go NO response. I put CEL on the shelf until an Asterisk 1.8 release has working CEL.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of cegadsl Sent: Friday, February 24, 2012 1:17 PM To: [email protected] Subject: [asterisk-users] cell mysql odbc support Hi All I am trying to log CEL Events to mysql through odbc, but I get the message: >> Feb 24 18:03:08] WARNING[12915]: cel_odbc.c:699 odbc_log: Column type -9 (field 'odbcconnection:cel:cid_name') is unsupported at this time. << I think that is a datatype problem, but i cannot solve the problem. it only happens with char or varchar datatypes: My MySQL cel table structure: CREATE TABLE `cel` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `eventtype` VARCHAR(30) NOT NULL, `eventtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `userdeftype` VARCHAR(255) NOT NULL, `cid_name` VARCHAR(80) NOT NULL, `cid_num` VARCHAR(80) NOT NULL, `cid_ani` VARCHAR(80) NOT NULL, `cid_rdnis` VARCHAR(80) NOT NULL, `cid_dnid` VARCHAR(80) NOT NULL, `exten` VARCHAR(80) NOT NULL, `context` VARCHAR(80) NOT NULL, `channame` VARCHAR(80) NOT NULL, `appname` VARCHAR(80) NOT NULL, `appdata` VARCHAR(80) NOT NULL, `amaflags` INT(11) NOT NULL, `accountcode` VARCHAR(20) NOT NULL, `peeraccount` VARCHAR(20) NOT NULL, `uniqueid` VARCHAR(150) NOT NULL, `linkedid` VARCHAR(150) NOT NULL, `userfield` VARCHAR(255) NOT NULL, `peer` VARCHAR(80) NOT NULL, UNIQUE KEY `id` (`id`) ) Thanks in advance¡¡¡ -- _____________________________________________________________________ -- 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
