Displaying 20 results from an estimated 600 matches similar to: "CDR (cdr_odbc)"
2007 Aug 19
1
CDR Disposition Value with ODBC
It looks like when you use odbc for CDR storage, rather than getting a
Dispositon string like ANSWERED, CONGESTION etc, you'll get an integer
(1,2,4,8). Does anyone know where I can find what strings (ANSWERED etc)
these integers map to?
Doug.
2005 Jun 23
5
SpanDSP - Squished Faxes
Skipped content of type multipart/alternative-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 145 bytes
Desc: not available
Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20050623/3460cdea/attachment.gif
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 Aug 18
1
Choppiness/Ticking sounds over LAN
Skipped content of type multipart/alternative-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 145 bytes
Desc: not available
Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20040818/d0d64775/attachment.gif
2004 Sep 22
2
MS SQL
Skipped content of type multipart/alternative-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 145 bytes
Desc: not available
Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20040922/ae05773c/attachment.gif
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 =
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
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:
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
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
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(
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
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
2004 Aug 05
2
new bounty for modifying calling card application to mysql
Hi,
I've just initiated a new bounty for the above;
http://www.voip-info.org/wiki-Asterisk+bounty+callingcard+to+MySQL
Any takers or any contributors please respond to me privately. I do not know
exactly how the bounty process works, but I can coordinate on this ?
SW
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
2004 Aug 23
2
Hold the phone!
Just a little pun there!
I've been mostly lurking for a couple of weeks and realize how little I
know and understand about this PBX and phone stuff. I did a little
looking about and came across a glossary but they terms are -- for me --
kind of out of context. I'm wondering if there is (much as I hate the
term "Dummy") a "PBX for Dummy's" or similar.
I've
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 Aug 25
1
Problem of set up asterisk-1.0-RC2.tar.gz with asterisk-prepaid-0.3.1
Hi Hekuran
I have installed asterisk-1.0-RC2.tar.gz, asterisk-prepaid-0.3.1 and
postgresql. When I tried to call from any IAX client to another IAX client
and also sip client to sip client it worked fine. And also the cdr table
filled properly.
Now I tried to configure asterisk-prepaid-0.3.1 with asterisk. I have
compiled asterisk-prepaid-0.3.1 and also copy the configure file.
I
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