[asterisk-users] cell mysql odbc support

cegadsl cegadsl at idecnet.com
Fri Feb 24 12:17:12 CST 2012


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>


More information about the asterisk-users mailing list