<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<pre wrap=""><div class="moz-txt-sig"><div class="moz-txt-sig">> -----Original Message-----
> From: <a class="moz-txt-link-abbreviated"
href="mailto:asterisk-users-bounces@lists.digium.com">asterisk-users-bounces@lists.digium.com</a>
> [<a class="moz-txt-link-freetext"
href="mailto:asterisk-users-bounces@lists.digium.com">mailto:asterisk-users-bounces@lists.digium.com</a>] On Behalf Of Tim Panton
> Sent: 08 May 2007 09:28
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [asterisk-users] Asterisk to record CDR in DB Oracle
> On 7 May 2007, at 17:27, Florian Overkamp wrote:
</div></div></pre>
<blockquote type="cite">
<pre wrap=""><span class="moz-txt-citetags">> </span>Hi Everton,
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>Everton Goularth wrote:
</pre>
<blockquote type="cite">
<pre wrap=""><span class="moz-txt-citetags">>> </span>I had success to do my asterisk to record CDR in a databese MYSQL...
<span class="moz-txt-citetags">>> </span>Now, I need to do it to record CDR in Oracle...
<span class="moz-txt-citetags">>> </span>Does Anybody knows how to do this??
<span class="moz-txt-citetags">>> </span>Every hints are welcome....
</pre>
</blockquote>
<pre wrap=""><span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>There is no native Oracle driver available to my knowledge, but if
<span class="moz-txt-citetags">> </span>you can install an ODBC driver for Oracle, Asterisk will happily
<span class="moz-txt-citetags">> </span>use that.
<span class="moz-txt-citetags">></span>
</pre>
</blockquote>
<pre wrap=""><!---->
> If anyone gets this to work, especially against an oracle instance on
> a separate machine,
> I'd love to know how you did it. I spent a day or so failing to get
> it to work, then gave up
> and had a perl script written that regularly posts the new CDR
> records to oracle over http(s).
> Tim Panton
<a class="moz-txt-link-abbreviated" href="http://www.mexuar.net">> www.mexuar.net</a>
<a class="moz-txt-link-abbreviated" href="http://www.westhawk.co.uk/">> www.westhawk.co.uk/</a>
Hi all,
what about yada?
I installed it and tried to connect to a database oracle em other machine em my network but I can`t.
This are my configuration:
cdr_yada.conf
--------------------------------------------------------------------------------
[global]
dbstr=oracle:192.168.0.180::MY_ORACLE_USER
user=MY_ORACLE_USER
pass=MY_ORACLE_PASSWORD
queue_size=500
queue_file=/var/asterisk/cdr_yada.queue
file_playback=yes
table=cdr
query=insert into cdr (id,calldate, clid, src, dst, dcontext, channel, dstchannel, lastapp, lastdata, duration, billsec, disposition, amaflags, accountcode, uniqueid, userfield) values (cdrseq.nextval, to_date('?s','yyyy-mm-dd hh24:mi:ss'), ?v, ?v, ?v, ?v, ?v, ?v, ?v, ?v, ?d, ?d, ?v, ?d, ?v, ?v, ?v)
;[userfield_parse]
enabled=yes
; userfield columns ufc0 through ufc15
;[ufc0]
; name=col1
;[ufc1]
; name=col2
--------------------------------------------------------------------------------
But in the asterisk cli I see that it isn't connected...
asterisk*CLI> cdr yada status
cdr_yada build 005: $Date: 2006-04-06 22:38:22 -0500 (Thu, 06 Apr 2006) $
Not connected for 13642d16h21m8s.
0 of 500 records queued, 0 errors
queue_file is /var/asterisk/cdr_yada.queue
Somebody is working with yada?? Is my configuration wrong??
If somebody can help me I thank...
Everton Goularth
</pre>
</body>
</html>