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¡¡¡
--
_____________________________________________________________________
-- 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
