asterisk users - May 2007 - Asterisk to record CDR in DB Oracle

Hi People,

I had success to do my asterisk to record CDR in a databese MYSQL...

Now, I need to do it to record CDR in Oracle...

Does Anybody knows how  to do this??

Every hints are welcome....

Thank`s all
Everton Goularth
Uberlandia - MG - Brazil

	

	
		
_______________________________________________________ 
Yahoo! Mail - Sempre a melhor op??o para voc?! 
Experimente j? e veja as novidades. 
http://br.yahoo.com/mailbeta/tudonovo/

Hi Everton,

Everton Goularth wrote:
> I had success to do my asterisk to record CDR in a databese MYSQL...
> 
> Now, I need to do it to record CDR in Oracle...
> 
> Does Anybody knows how  to do this??
> 
> Every hints are welcome....
There is no native Oracle driver available to my knowledge, but if you 
can install an ODBC driver for Oracle, Asterisk will happily use that.

Best regards,
Florian

> -----Original Message----- > From: 
asterisk-users-bounces@lists.digium.com > 
[mailto:asterisk-users-bounces@lists.digium.com] 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:
> > Hi Everton,
> >
> > Everton Goularth wrote:
>   
>> >> I had success to do my asterisk to record CDR in a databese
MYSQL...
>> >> Now, I need to do it to record CDR in Oracle...
>> >> Does Anybody knows how  to do this??
>> >> Every hints are welcome....
>>     
> >
> > There is no native Oracle driver available to my knowledge, but if  
> > you can install an ODBC driver for Oracle, Asterisk will happily  
> > use that.
> >
>   
> 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
> www.mexuar.net
> www.westhawk.co.uk/
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20070509/a1f2b35f/attachment.htm