asterisk users - Feb 2012 - cell mysql odbc support

Hi All

I am trying to log CEL Events to mysql throughodbc, but I getthe 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???


-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20120224/73a94bf8/attachment.htm>

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???