similar to: FreeTDS (Microsoft MsSQL 2008) and CDR

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

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

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.)

On Fri, Jul 30, 2010 at 1:15 PM, Fred Posner <fred at teamforrest.com> wrote: > On Jul 30, 2010, at 5:04 AM, Andra=C5=BE wrote: > > > Ok, problem is another, when I run configure, it write this: > > checking for tds_version in -ltds... no > > configure: *** > > configure: *** The FreeTDS installation on this system appears to be > broken. > >

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, 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

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 --------------

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

I am trying to get * to write CDR records to an MS SQL table. I am used the freeTDS set up (not using UNIX ODBC), and it appears to be making the connection to the database, but I make a call, I get this error: WARNING[3369]: cdr_tds.c:180 tds_log: Reconnected to SQL database. ERROR[3369]: cdr_tds.c:191 tds_log: Failed to insert Call Data Records into SQL database. I've assigned all rights

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:

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

maybe someone here can help me understand why I am getting this strange behaivor. I am connecting to a MS SQL server from PHP by the ODBC module, I use unixODBC-2.2.9-1, freetds-0.63-1.2.el4.rf and php-4.3.9-3.9 all but the freetds package came with CentOS-4.2 + updates the problem is that I am getting -1 from the odbc_num_rows(); function, I search the net and it looks that this is a very

Sorry all, Did that and its going good now. Rgds Nic _____ From: Nic le Roux [mailto:nicl@i-procc.za.net] Sent: 20 January 2005 11:22 AM To: 'asterisk-users@lists.digium.com' Subject: Asterisk 1.0.3 startup Hi All, I've managed to compile make and make install asterisk on Mandrake 9.2. However on startup I get the following message: [cdr_tds.so]Jan 20 11:13:54

I''m having an error from Linux via freeTDS/ODBC to SQL Server with cod that runs fine against SQLite and MySQL. Here''s the code: def find_recipes_for_workorder_by_id @recipe_pages, @recipes = paginate_with_sort :recipes, :per_page => 10, \ :conditions => ["recipe.workorder_id = ?", params [:workorder]] render :template =>

Hello -- What repository, or other website, can I access in order to get the latest version of freetds? The version that comes with centos 6.2 is the 0.64 release, and it has a bug in it that is preventing me from running another application. The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the

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 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

I have a question for RODBC users out there. I have used the package with good results for some time. However, I have just switched from an OpenLink proprietary driver for MS SQL to the FreeTDS driver (I think it is MS SQL Server 2000 I'm connecting to if it matters). I was/am running them from unixODBC on a Linux Client. I think I have it set up fine since I can use "isql"

Hi all, I am testing with Asterisk 1.8.0 beta3 using realtime with a mssql server using freetds and unixodbc, which works with 1.6.1.20. With the same config in 1.8 I get an error when trying to start asterisk which says: [Aug 23 15:06:12] WARNING[7180]: loader.c:387 load_dynamic_module: Error loading module 'res_config_odbc.so': /usr/lib/asterisk/modules/res_config_odbc.so: undefined

Good afternoon gentlemen (and ladies). A costumer of mine has many servers and each one maps their SIP extensions to the others via DUNDi. It works like a charm. SIP extensions can only register at one server, the one they "belong" to. In case one extension wants to call other that is registered in another server, DUNDi takes care of that by calling the other server using IAX2 and G.729