Looking for informationI've read thatit is adatatypeproblemand that with
asimple'if' on cel_odbc.c it is solved, but I
usetheasteriskfordebianrepositoriesdo not want tocompile anything.
Alsowonderthereforethatthere is nodocumentationabout this problem.
I dont want to use pgsql only for cel, all my work with asterisk is for
MySQL.
El 24/02/2012 18:22, Eric Wieling escribió:
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
--
_____________________________________________________________________
-- 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
