similar to: CDR_TDS tries to write to ends column instead of end

Hi all I'm trying to get Asterisk 1.8.11.0 to write to the ast_cdr table on an MSSQL instance. My problem is that the cdr_tds module insists on naming the end column as "ends" - it tries to write to this column, which does not exist. I get this in the CLI: [Dec 23 09:25:17] NOTICE[2545]: cdr_tds.c:476 tds_message_handler: Invalid column name 'ends'. [Dec 23 09:25:17]

Hi All I have an Asterisk 1.8.32.3 instance that will at random intervals stop logging CDR data to MSSQL via FreeTDS. On investigation I'll find that the FreeTDS module has been unloaded somehow. It is not listed in cdr show status or show module like. Trying module load cdr_tds results in module cdr_tds does not provide a license key and the module is not loaded. The only way to get

Hi all I have a strange issue with 1.8.11.0 on a production Asterisk machine at our head office, and the same issue with a production machine at a branch office. Every now and then, on the head office machine, ODBC CEL and CDR logging will stop working. On examination in the CLI, Asterisk behaves as if the config files for ODBC in the /etc directory are just gone. Repeated tests have then

I'm trying to use freetds/odbc to write CDR records to a MSSQL database but when I installed them and tried to compile asterisk again I get: _tds.c cdr_tds.c: In function `mssql_connect': cdr_tds.c:415: `TDSCONNECTINFO' undeclared (first use in this function) cdr_tds.c:415: (Each undeclared identifier is reported only once cdr_tds.c:415: for each function it appears in.)

I would like some Asterisk community input: It was requested of me to create an Asterisk FreeTDS (cdr_tds.c) module to allow Asterisk to populate MS SQL Server (and Sybase) with CDR records. unixODBC has been thrown around as a bright shiny button but it adds an additional layer of DB abstraction. That additional layer of abstraction can cause problems when it is not necessary for our TDS (MS

Hi Marie Thanks! I was just worried about thread safety if I had to use a global variable, e. g. it might be set to a value by one call (since I'm using the same global for every incoming call to transfer the accountcode gotten from my HTTP endpoint to the same macro, and there can be several calls simultaneously all inserting HTTP-sourced values at more or less the same instant) and then

Help! I've been using mysql for cdr storage, I need to switch to MS SQL. I must be stupid or something but I cannot figure out how to setup the cdr_tds. I have FreeTDS configured properly, but my unixodbc is not working properly either... I'd be happy with either solution, but I'm in need of assistance. Luke Catranis

Hi, I have Ubuntu server 10.04 64bit, and Asterisk 1.4.34, compiled from sources. I installed freetds-common,freetds-dev, libct4, libsybdb5, freetds-bin, but, when I run configure and then make menuconfig in section "Call Detail Recording" -> "cdr_tds" it's "disabled". It only writes that "Depends on: freetds(E)". On another server (same

If anyone is interested ... just in case! :-)... I have tried to write , based on the cdr_mysql.so module, an Sybase module. To compile you can use something like that: export SYBPLATFORM=linux export SYBASE=/opt/sybase cc -I$SYBASE/include -c -o cdr_sybase.o cdr_sybase.c cc -shared -Xlinker -x -o cdr_sybase.so cdr_sybase.o -lsybdb -lm -L$SYBASE/lib (anyone could write the corect Makefile

I have installed Asterisk with FreeTDS many times before (this same Asterisk and same TDS version)... but today when I did the make it gave me this error: ake[1]: Entering directory `/home/matth/asterisk126/asterisk-1.2.6/cdr' gcc -pipe -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -g3 -Iinclude -I../include -D_REENTRANT -D_GNU_SOURCE -O6 -march=i686

Hi! I have this errors compiling Asterisk 1.4.5 cdr_tds.c:86:2: warning: #warning "You have older TDS, you should upgrade!" cdr_tds.c: In function `tds_log': cdr_tds.c:213: error: too many arguments to function `tds_process_simple_query' cdr_tds.c: In function `mssql_connect': cdr_tds.c:326: error: `TDSCONNECTINFO' undeclared (first use in this function) cdr_tds.c:326:

Hello I am having trouble setting up the cdr_odbc with MSSQL server. Has anybody done this? I have followed what little documentation I can find. Asterisk errors on a connection error, but tcpdump doesn't even show an attempt. Does anybody have some examples for MSSQL ODBC CDR? I've downloaded unixODBC and the FreeTDS project, recompiled asterisk.... Thanks Duane Cox --------------

Hi all, I have a working 1.0.7 installation and it is recording CDR to mysql. I am using FreeTDS on the system currently to access our MS SQL 2000 server for account verification, we may use it to store CDR records there in the future. I have decided to update the installation to 1.0.9. However, during "make", I receive: make[1]: Entering directory `/usr/src/asterisk/cdr' gcc

Hi, I want to use the cdr to record the call log to my Microsoft SQL Server using unixodbc and freetds.... but when I compile, I've got this message.... Does anyone have the same problem and/or know how to solve it ? Thanks Baste regards David Masure make[1]: Entering directory `/usr/src/asterisk/bristuff-0.2.0-RC7k/asterisk-1.0.6/cdr' gcc -pipe -Wall -Wstrict-prototypes

Regarding this I've read the specs linked to in detail, but I can find no mention anywhere of any change that implies or states that no ring time will be recorded anymore in Asterisk 13 and that all times in start and answer columns will now be equal for all calls. Can this be because I nowhere use the Answer() application in my dialplan when dialing out? -----Original Message----- From:

Hi, I'm trying to install FreeTDS. I followed the instructions on http://www.voip-info.org/tiki-index.php?page=FreeTDS, but still can't get it to work. I serched around trying to find instructions on it, and it seems the same info (even wording) appear on all sites I found. I downloaded freetds-0.63, and followed the instructions step by step, and when I try to re-compile Asterisk (#make

Hi, do you have NAT between Asterisk and agent phones? S pozdravem Tomáš Holý Hi Tomas Thanks for replying. Yes, the phones are in one location in a LAN and are then NATed to enable them to contact the Asterisk which is hosted in the cloud. A typical sip.conf phone configuration on the remote server for the site is [general] session-timers=refuse disallow=all allow=g729:20 allow=ulaw

Hi Joshua HTTP is used on in our setup on 127.0.0.1/mxml?<command> to send commands to the server, such as http://127.0.0.1/mxml?action=login&username=myuser&secret=thesecret to log in and then http://127.0.0.1/mxml?ActionID=123&Action=BlindTransfer&Channel=Channel&Context=local&Exten=123&Priority=1 etc. to control transfers, for example. ARI is not being

Hi Guys I have an issue where a call is picked up from a queue. The caller asks the person who answered to attended transfer to extension 3082 (for argument's sake.) 3082 picks up the attended transfer and speaks with the outside caller picked up initially from the queue. A few seconds after 3082 has started speaking to the outside caller - 3082's call goes dead in their

Hi all I'm running an Asterisk on an Intel XEON E5-2660 virtual with Centos 7 - 32GB RAM. When I approach about 320 channels, I -sometimes- get thousands of these messages suddenly streamed in the CLI / Asterisk log: WARNING[60753][C-00022cb9] channel.c: Exceptionally long voice queue length queuing to Local/xxxxxxxxxx at local-0002dbea;2 WARNING[71993][C-00022dcc] channel.c: Exceptionally