[asterisk-users] cell mysql odbc support

[cegadsl]

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

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