I did install CEL logging for Debian 6. Here's my notes, I hope it helps<div><br></div><div><div>How to cel logging in asterisk 1.8</div><div><br></div><div>1.)</div><div>apt-get remove unixODBC unixODBC-dev</div><div>
apt-get install libmyodbc</div><div><br></div><div>2.)</div><div>download and compile asterisk 1.8 and above.. with cel logging enabled</div><div><br></div><div>3.)</div><div>vim /etc/odbc.ini</div><div>[asterisk-connector]</div>
<div>Description = MySQL connection to 'asterisk' database</div><div>Driver = MySQL</div><div>Database = asteriskcdrdb</div><div>Server = localhost</div><div>UserName = asteriskuser</div>
<div>Password = intuit</div><div>Port = 3306</div><div>Socket = /var/run/mysqld/mysqld.sock</div><div><br></div><div><br></div><div>4.)</div><div>vim /etc/odbcinst.ini</div><div>
[MySQL]</div><div>Description = ODBC for MySQL</div><div>Driver = /usr/lib/odbc/libmyodbc.so</div><div>Setup = /usr/lib/odbc/libodbcmyS.so</div><div>FileUsage = 1</div><div><br></div><div>5.)</div><div>vim /etc/asterisk/cel.conf</div>
<div>[general]</div><div>enable=yes</div><div>apps=dial,queue</div><div>events=CHAN_START,CHAN_END, ANSWER,HANGUP</div><div>dateformat=%F %T</div><div><br></div><div>6.)</div><div>vim /etc/asterisk/res_odbc.conf</div><div>
[asterisk]</div><div>enabled => yes</div><div>dsn => asterisk-connector</div><div>username => asteriskuser</div><div>password => intuit</div><div>pooling => no</div><div>limit => 1</div><div>pre-connect => yes</div>
<div><br></div><div>7.)</div><div>vim /etc/asterisk/cel_odbc.conf</div><div>[mytable]</div><div>connection = asterisk</div><div>table = cel</div><div><br></div><div>8.)</div><div><br></div><div>CREATE TABLE `cel` (</div>
<div>
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,</div><div> `eventtype` VARCHAR(30) COLLATE utf8_unicode_ci NOT NULL,</div><div> `eventtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP</div><div> ON UPDATE CURRENT_TIMESTAMP,</div>
<div> `userdeftype` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,</div><div> `cid_name` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,</div><div> `cid_num` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,</div><div> `cid_ani` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,</div>
<div> `cid_rdnis` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,</div><div> `cid_dnid` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,</div><div> `exten` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,</div><div> `context` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,</div>
<div> `channame` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,</div><div> `appname` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,</div><div> `appdata` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,</div><div> `amaflags` INT(11) NOT NULL,</div>
<div> `accountcode` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,</div><div> `peeraccount` VARCHAR(20) COLLATE utf8_unicode_ci NOT NULL,</div><div> `uniqueid` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,</div><div> `linkedid` VARCHAR(150) COLLATE utf8_unicode_ci NOT NULL,</div>
<div> `userfield` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,</div><div> `peer` VARCHAR(80) COLLATE utf8_unicode_ci NOT NULL,</div><div> UNIQUE KEY `id` (`id`)</div><div>) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;</div>
<div><br></div><div>9.)</div><div>amportal kill</div><div>amportal start</div><div><br></div><div>10.) problem with libmyodbc package version, need to downgrade: <a href="http://forums.asterisk.org/viewtopic.php?p=161963">http://forums.asterisk.org/viewtopic.php?p=161963</a></div>
<div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>download from <a href="http://packages.debian.org/lenny/libmyodbc">http://packages.debian.org/lenny/libmyodbc</a> with dependencies:</div><div>
<br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>but before remove the existing packages:</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>apt-get remove unixODBC unixODBC-dev</div>
<div> apt-get remove libmyodbc</div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>remove the newer version</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>apt-get remove odbcinst1debian2</div>
<div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div> wget <a href="http://ftp.us.debian.org/debian/pool/main/libt/libtool/libltdl3_1.5.26-4+lenny1_i386.deb">http://ftp.us.debian.org/debian/pool/main/libt/libtool/libltdl3_1.5.26-4+lenny1_i386.deb</a></div>
<div> wget <a href="http://ftp.us.debian.org/debian/pool/main/u/unixodbc/odbcinst1debian1_2.2.11-16_i386.deb">http://ftp.us.debian.org/debian/pool/main/u/unixodbc/odbcinst1debian1_2.2.11-16_i386.deb</a></div><div> wget <a href="http://ftp.us.debian.org/debian/pool/main/m/myodbc/libmyodbc_3.51.15r409-4_i386.deb">http://ftp.us.debian.org/debian/pool/main/m/myodbc/libmyodbc_3.51.15r409-4_i386.deb</a></div>
<div> wget <a href="http://ftp.us.debian.org/debian/pool/main/m/mysql-dfsg-5.0/libmysqlclient15off_5.0.51a-24+lenny5_i386.deb">http://ftp.us.debian.org/debian/pool/main/m/mysql-dfsg-5.0/libmysqlclient15off_5.0.51a-24+lenny5_i386.deb</a></div>
<div> wget <a href="http://ftp.us.debian.org/debian/pool/main/u/unixodbc/unixodbc_2.2.11-16_i386.deb">http://ftp.us.debian.org/debian/pool/main/u/unixodbc/unixodbc_2.2.11-16_i386.deb</a></div><div> </div><div> dpkg -i unixodbc_2.2.11-16_i386.deb</div>
<div> dpkg -i odbcinst1debian1_2.2.11-16_i386.deb</div><div> dpkg -i libmysqlclient15off_5.0.51a-24+lenny5_i386.deb</div><div> dpkg -i libmyodbc_3.51.15r409-4_i386.deb</div><div> </div><div> NOTE: remember if asterisk make menuselect show that res_odbc cant find generic_odbc and other dependencies to install back the </div>
<div> unixODBC unixODBC-dev packages from apt and configure make make install and then remove those and install back the older ones.</div><div><br></div><div><br><br><div class="gmail_quote">On Sat, Feb 25, 2012 at 2:28 AM, cegadsl <span dir="ltr"><<a href="mailto:cegadsl@idecnet.com">cegadsl@idecnet.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">Looking for information</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">I've read that</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">it is a</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">datatype</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">problem</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">and that with a</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">simple</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> 'if' on cel_odbc.c it is solved, </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">but I use</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">the</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">asterisk</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> for</span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">debian</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">repositories</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">do not want to</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">compile anything.</span><br style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">
<br style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">
<span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">Also</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">wonder</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">therefore</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">that</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">there is no</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">documentation</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245);display:inline!important;float:none"><span> </span></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(245,245,245)">about this problem.<br>
<br>
I dont want to use pgsql only for cel, all my work with asterisk
is for MySQL.<br>
</span><br>
<br>
El 24/02/2012 18:22, Eric Wieling escribió:
<div><div class="h5"><blockquote type="cite">
<pre>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: <a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">asterisk-users-bounces@lists.digium.com</a> [<a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">mailto:asterisk-users-bounces@lists.digium.com</a>] On Behalf Of cegadsl
Sent: Friday, February 24, 2012 1:17 PM
To: <a href="mailto:asterisk-users@lists.digium.com" target="_blank">asterisk-users@lists.digium.com</a>
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:
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre></pre>
</blockquote>
</blockquote>
<pre>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 <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --
New to Asterisk? Join us for a live introductory webinar every Thurs:
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a>
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a>
</pre>
</blockquote>
<br>
</div></div></div>
<br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Regards,<br>
Arstan Jusupov<br>
</div></div>