similar to: cdr_odbc in CVS-HEAD gives connect error on reload

Displaying 20 results from an estimated 8000 matches similar to: "cdr_odbc in CVS-HEAD gives connect error on reload"

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
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,
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(
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
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
2004 Jun 18
0
Asterisk does not start when cdr_odbc ist configured
Hi, i want to load the cdr into oracle using unixODBC. I'm using RH 9 2.4.20-30.9smp, unixODBC 2.2.6, easysoft odbc driver for oracle 1.3.1. My unixODBC is working well. With isql i can connect to the database, do selects, inserts and so on. I created the table cdr as described on the asterisk wiki site. When i configure the cdr_odbc.conf with the needed values, then * does not start any
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:
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
2005 Mar 16
0
Realtime ODBC with cdr_odbc using the same database
I'm currently running a setup that's worked great with MySQL in the past, but we're migrating to ODBC for when we actually integrate the system into our current legacy/voip network. The database I'm trying to use is PostgreSQL, and I've got it working great for Realtime, and if I use cdr_pgsql for the cdr records. However, if I try to use cdr_odbc against the same
2007 Nov 24
3
MSSQL ODBC Connections
Hi all, The asterisk book states the following for using ODBC to connect to an MS database. ? The pooling and limit options are quite useful for MS SQL Server and Sybase databases. These permit you to establish multiple connections (up to limit connections) to a database while ensuring that each connection has only one statement executing at once (this is due to a limitation in the protocol
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]
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 --------------
2006 Mar 17
0
How to install the cdr_odbc module.
Hi. I want to the CDR detail to be logged to a database backend. For that I need the cdr_odbc module. Executing the CLI command "show modules" I realized I don't have the cdr_odbc module loaded. So, I tried to load it using "load cdr_odbc.so", but it didn't work because I don't have it. Where can I get this module and how do I install it? Thanks in advance.
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
2010 Apr 01
2
problem compiling asterisk with cdr_odbc
"make menuconfig" does not show cdr_odbc as a selectable compile option. I have compiled and installed both unixODBC and freetds from source and have verified both successfully connect to my sql server. Both were installed to standard locations (/usr/lib). I had no problem compiling cdr_odbc on my test server(CentOS 4.6), however following the same steps on my production server (CentOS
2005 Feb 23
0
cdr_odbc logging insane integer values
I'm having a problem with * (tried both HEAD and STABLE). When logging with cdr_odbc through unixODBC to MySQL, I get "insane" integer values in the duration, billsec, disposition and amaflags fields. I have enabled MySQL logging, and that's the query I get: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,dura
2010 Feb 02
0
Issue when reloading
Hello list! I?m having an issue when reloading Asterisk, I?ve had this problem in Asterisk 1.6.1.6 so I upgrade to 1.6.2.1 version, but I still have the same error. For example, I send a "reload" in Asterisk CLI and this is the output: isb152*CLI> reload == Parsing '/etc/asterisk/extconfig.conf': == Found == Parsing '/etc/asterisk/manager.conf': == Found
2018 Dec 07
2
how to use a database
On 12/06/2018 08:43 PM, Antony Stone wrote: > On Thursday 06 December 2018 at 17:49:25, hw wrote: >>>> How dynamic are changes made in the database? >>> >>> If by "dynamic" you mean "quickly used" then the answer is "immediately". >> >> There's a note in some configuration file saying that dynamic extensions >>
2006 Feb 22
1
FC4 and yum install; how to configure questions
I installed FC4, ran command, # yum install asterisk. A bunch of stuff happened, but can't locate .conf files. I have a list of files: /usr/share/doc/asterisk-1.2.4/configs/features.conf.sample /usr/share/doc/asterisk-1.2.4/configs/rtp.conf.sample /usr/share/doc/asterisk-1.2.4/configs/extensions.conf.sample /usr/share/doc/asterisk-1.2.4/configs/logger.conf.sample