[asterisk-users] cell mysql odbc support

[Eric Wieling]

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: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of cegadsl
Sent: Friday, February 24, 2012 1:17 PM
To: asterisk-users at lists.digium.com
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¡¡¡