similar to: problem compiling asterisk with cdr_odbc

Displaying 20 results from an estimated 2000 matches similar to: "problem compiling asterisk with cdr_odbc"

2004 May 18
2
problem with cdr_odbc
Hi, Has anyone made a successfull instalation of cdr_odbc?? I've install unixODBC-2.2.8 (made my own RPM) and then built the module. I'm trying to send the cdrs to a M$ SQL server. The sql connection works because I can do any query via isql. When I do the calls I get the following output on the asterisk console: -- Executing Hangup("SIP/test1-a5e1", "") in new
2010 May 05
3
CDR to MS-SQL via ODBC issue
Hi guys, Having issue with getting CDR to write to MS-SQL via ODBC. > cdr_odbc: Connected to freetds-connector > cdr_odbc: Error in PREPARE -1 > cdr_odbc: Query FAILED Call not logged! == Spawn extension (cisco, ##########, 2) exited non-zero on 'IAX2/astYYYY-507 Isql test: [xxx at YYYY asterisk]# isql freetds-connector XXXXXXX YYYYYYYYY
2018 Dec 07
2
cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.
Hi, is cdr logging using odbc buggy? I'im only getting an error "cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.". Connecting with isql to the datasource given in cdr_odbc.conf works just fine, and using the database for sippeers also works. The documentation[1] is confusing because it says freeTDS is required and that you must not use multiple
2004 Jul 28
4
MS SQL & Free TDS
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
2004 Jul 22
2
MSSQL ODBC CDR
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 --------------
2004 May 20
0
MSSQL2000 + cdr_odbc.c fix (WAS: problem with cdr_odbc)
http://asterisk.bkw.org/diff/cdr_odbc.diff Now this should fix it the proper way. bkw PS: Thanks for the info klasstek! > -----Original Message----- > From: asterisk-dev-admin@lists.digium.com [mailto:asterisk-dev- > admin@lists.digium.com] On Behalf Of Pablo Endres > Sent: Wednesday, May 19, 2004 3:30 PM > To: asterisk-dev@lists.digium.com > Subject: RE: [Asterisk-Dev]
2009 Feb 26
0
[cdr_odbc] error: Cannot insert the value NULL into column 'calldate'
Hi, I am trying to get * log to mssql server. I have odbc and freetds configured, but my insert query is missing calldate which is a NOT NULL field in database schema. cdr_adaptive_odbc: Insert failed on 'sqlserver:cdr'. CDR failed: INSERT INTO cdr (clid,src,dst,dcontext,channel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid) VALUES
2009 Nov 06
2
odbc to ms-sql server
Hi all, I'm trying to set up an odbc connection to a ms-sql server from an asterisk 1.6.1 install My problem is that I cannot get asterisk to build func_odbc & res_odbc.so I installed yum -y install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel And then went on to reconfigure / recompile asterisk after a ./configure --with-odbc=/usr/lib/ I get
2004 May 12
1
Asterisk not loading data into table using cdr_odbc
Hi I have problems trying to load asterisk call data into the cdr table using cdr_odbc config. My unixODBC is properly configured and it's working fine (able to connect, load data, query tables, etc.). unixodbc is configured to use easysoft Oracle ODBC library. Table cdr was created following instructions in asterisk wiki site. My /etc/asterisk/cdr_odbc.conf is configured as follow:
2008 Jan 30
2
func_odbc - trouble
Hello, we are migrating an Asterisk install from Trixbox/Asterisk 1.2 to Elastix 0.92 with asterisk-1.4.17 on CentOS 5. I need to migrate an funtion that consults a remote sybase database, using ODBC and freetds. On the new server I am able to connect to the database using isql without problems. When I try to connect from asterisk logs show: pbx.c: Function ODBC_SQL not registered Indeed I
2004 May 26
5
cdr_odbc with mysql on a remote server
I'm trying to add cdr_odbc.so to log my CDR data to a mysql DB. I've managed to compile everything, and seem to almost be ready to head home. I've added a small debug line to cdr_odbc.c as follows: if((ODBC_res != SQL_SUCCESS) && (ODBC_res != SQL_SUCCESS_WITH_INFO)) { if(option_verbose > 10) ast_verbose(
2005 Aug 26
0
cdr_odbc in CVS-HEAD gives connect error on reload
If I fire up asterisk it connects to my MSSQL server via ODBC just fine. However, if I issue a reload it unloads the ODBC.. then loads it again and I get an error... and keep getting it until I On a fresh start: Aug 26 15:43:14 WARNING[13818] cdr_odbc.c: cdr_odbc: table not specified. Assuming cdr Aug 26 15:43:14 VERBOSE[13818] logger.c: -- cdr_odbc: dsn is MSSQL-asterisk Aug 26 15:43:14
2004 Jun 22
1
Problems compiling cdr_odbc.so
I'm not really being too lucky in the last days. After trying to compile cdr_mysql with no success, I am switching to cdr_odbc. I have installed unixODBC, iODBC and MyODBC correctly, I am even able to make queries with isql. But when trying to "make" in the cdr directory of the latest CVS, that's what I get: # cd /usr/src/asterisk/cdr # make cc -o cdr_odbc.so cdr_odbc.o -lodbc
2004 Jan 17
3
cdr_odbc not logging integers eg duration
I've just noticed that since swapping from the direct mysql cdr driver to cdr_odbc, the call duration (and anything else that's an integer) isn't logged - anyone else seen this and know the reason. The cdr_odbc driver gives no error messages and records any string based fields correctly. Iain
2009 May 05
1
Asterisk cdr_odbc problems
I'm trying to get asterisk cdr_odbc configured, but it can't connect through my odbc driver. switchboard*CLI> module load cdr_odbc [May 4 20:06:04] ERROR[17758]: cdr_odbc.c:358 odbc_load_module: cdr_odbc: Unable to connect to datasource: asterisk /etc/odbcinst.ini: [MySQL] Description = MySQL driver Driver = /usr/lib/odbc/libmyodbc.so Setup =
2018 Dec 07
2
cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.
On 12/07/2018 02:25 PM, Joshua C. Colp wrote: > On Fri, Dec 7, 2018, at 9:19 AM, hw wrote: >> >> Hi, >> >> is cdr logging using odbc buggy? I'im only getting an error >> "cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.". >> >> Connecting with isql to the datasource given in cdr_odbc.conf works just >> fine,
2011 Jul 19
1
AsteriskNow install addons despite license conflict with FFA and G.729
Hello, We installed AsteriskNOW (Asterisk version 1.6.2.19) and purchased FFA and G.729 licenses and installed them successfully. When we tried to install asterisk addons (we need the CDRs), we get license conflict error messages. Searching google, we see that there's a way to force install the addons, but that "way" isn't properly detailed, so we didn't manage to do it.
2006 Mar 29
1
cdr_odbc appears to have fields missing
I'm currently using Asterisk running version 1.2.5 and trying to use cdr_odbc to connect to a Microsoft SQL database. I have everything running, but the insert statement being sent to database doesn't appear to have the "start, answer, end" information in it. Below is the insert statement that MS Profiler shows being sent. As you can see those fields are missing. INSERT INTO
2007 Jun 20
1
Res: Record CDR in a Oracle database
Hi All, Thank's for your hint Tim Panton I could connect my asterisk machine to my oracle machine. I used unixODBC-2.2.11.tar.gz, oracle-instantclient-basic-10.2.0.3-1.i386.rpm, oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm and the drive from www.oracle.com (odbc-oracle-3.1.0-linux-x86-glibc.tar) to configure my asterisk machine. I can connect to my oracle machine with isql and in
2008 Feb 23
2
MySQL Voicemail Storage Questions\Errors
I am running CentOS 5 with Asterisk 1.4.14. I am trying to setup storage of voicemail messages into MySQL. It is my understanding that I can only do this via ODBC. I installed per http://www.voip-info.org/wiki/view/CentOS+5+and+Asterisk+1.4.x+installation unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel and mysql-connector-odbc. I reconfigured and built Asterisk, using menuconfig to