<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Arstan¡¡¡<br>
<br>
Great Job¡¡¡<br>
<br>
All perfect with this ODBC version.<br>
<br>
this is the first reference to this problem solved i found.<br>
<br>
Best Regards and Thanks<br>
<br>
<br>
<br>
El 27/02/2012 2:58, Arstan escribió:
<blockquote
cite="mid:CANyEDsSGm59MP-gMajwdZxsjXUfa2SuZg++Zft-qMDScV-_DqA@mail.gmail.com"
type="cite">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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true" href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">asterisk-users-bounces@lists.digium.com</a> [<a moz-do-not-send="true" 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 moz-do-not-send="true" 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"> </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 moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true" 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
moz-do-not-send="true" 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 moz-do-not-send="true"
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 moz-do-not-send="true"
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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by <a class="moz-txt-link-freetext" href="http://www.api-digital.com">http://www.api-digital.com</a> --
New to Asterisk? Join us for a live introductory webinar every Thurs:
<a class="moz-txt-link-freetext" href="http://www.asterisk.org/hello">http://www.asterisk.org/hello</a>
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
<a class="moz-txt-link-freetext" href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a></pre>
</blockquote>
<br>
</body>
</html>