[asterisk-users] cell mysql odbc support
cegadsl
cegadsl at idecnet.com
Mon Feb 27 04:51:14 CST 2012
Hi Arstan¡¡¡
Great Job¡¡¡
All perfect with this ODBC version.
this is the first reference to this problem solved i found.
Best Regards and Thanks
El 27/02/2012 2:58, Arstan escribió:
> I did install CEL logging for Debian 6. Here's my notes, I hope it helps
>
> How to cel logging in asterisk 1.8
>
> 1.)
> apt-get remove unixODBC unixODBC-dev
> apt-get install libmyodbc
>
> 2.)
> download and compile asterisk 1.8 and above.. with cel logging enabled
>
> 3.)
> vim /etc/odbc.ini
> [asterisk-connector]
> Description = MySQL connection to 'asterisk' database
> Driver = MySQL
> Database = asteriskcdrdb
> Server = localhost
> UserName = asteriskuser
> Password = intuit
> Port = 3306
> Socket = /var/run/mysqld/mysqld.sock
>
>
> 4.)
> vim /etc/odbcinst.ini
> [MySQL]
> Description = ODBC for MySQL
> Driver = /usr/lib/odbc/libmyodbc.so
> Setup = /usr/lib/odbc/libodbcmyS.so
> FileUsage = 1
>
> 5.)
> vim /etc/asterisk/cel.conf
> [general]
> enable=yes
> apps=dial,queue
> events=CHAN_START,CHAN_END, ANSWER,HANGUP
> dateformat=%F %T
>
> 6.)
> vim /etc/asterisk/res_odbc.conf
> [asterisk]
> enabled => yes
> dsn => asterisk-connector
> username => asteriskuser
> password => intuit
> pooling => no
> limit => 1
> pre-connect => yes
>
> 7.)
> vim /etc/asterisk/cel_odbc.conf
> [mytable]
> connection = asterisk
> table = cel
>
> 8.)
>
> CREATE TABLE `cel` (
> `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
> `eventtype` VARCHAR(30) COLLATE utf8_unicode_ci NOT NULL,
> `eventtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
> ON UPDATE CURRENT_TIMESTAMP,
> `userdeftype` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
> `cid_name` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
> `cid_num` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
> `cid_ani` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
> `cid_rdnis` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
> `cid_dnid` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
> `exten` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
> `context` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
> `channame` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
> `appname` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
> `appdata` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
> `amaflags` INT(11) NOT NULL,
> `accountcode` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
> `peeraccount` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,
> `uniqueid` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,
> `linkedid` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,
> `userfield` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
> `peer` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,
> UNIQUE KEY `id` (`id`)
> ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>
> 9.)
> amportal kill
> amportal start
>
> 10.) problem with libmyodbc package version, need to downgrade:
> http://forums.asterisk.org/viewtopic.php?p=161963
>
> download from http://packages.debian.org/lenny/libmyodbc with
> dependencies:
>
> but before remove the existing packages:
> apt-get remove unixODBC unixODBC-dev
> apt-get remove libmyodbc
> remove the newer version
> apt-get remove odbcinst1debian2
>
> wget
> http://ftp.us.debian.org/debian/pool/main/libt/libtool/libltdl3_1.5.26-4+lenny1_i386.deb
> wget
> http://ftp.us.debian.org/debian/pool/main/u/unixodbc/odbcinst1debian1_2.2.11-16_i386.deb
> wget
> http://ftp.us.debian.org/debian/pool/main/m/myodbc/libmyodbc_3.51.15r409-4_i386.deb
> wget
> http://ftp.us.debian.org/debian/pool/main/m/mysql-dfsg-5.0/libmysqlclient15off_5.0.51a-24+lenny5_i386.deb
> wget
> http://ftp.us.debian.org/debian/pool/main/u/unixodbc/unixodbc_2.2.11-16_i386.deb
> dpkg -i unixodbc_2.2.11-16_i386.deb
> dpkg -i odbcinst1debian1_2.2.11-16_i386.deb
> dpkg -i libmysqlclient15off_5.0.51a-24+lenny5_i386.deb
> dpkg -i libmyodbc_3.51.15r409-4_i386.deb
> NOTE: remember if asterisk make menuselect show that res_odbc cant
> find generic_odbc and other dependencies to install back the
> unixODBC unixODBC-dev packages from apt and configure make make
> install and then remove those and install back the older ones.
>
>
>
> On Sat, Feb 25, 2012 at 2:28 AM, cegadsl <cegadsl at idecnet.com
> <mailto:cegadsl at idecnet.com>> wrote:
>
> 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> [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 <mailto: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 byhttp://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
>
>
>
>
> --
> Regards,
> Arstan Jusupov
>
>
> --
> _____________________________________________________________________
> -- 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/20120227/ef599f57/attachment.htm>
More information about the asterisk-users
mailing list