[asterisk-users] Store CDR (call detail record) toOracledatabase

[Danny Nicholas]

I'd love to, but I have bigger trees to chop in Asterisk that messing with
DB CDR's, so I just use the flat file /var/log/asterisk/cdr-csv/Master.csv.
I'll defer this answer to a poster who has actually climbed that mountain.
Apologies for terse answer and top-post.

 

  _____  

From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Phuong Hoang
Sent: Wednesday, November 10, 2010 10:37 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] Store CDR (call detail record)
toOracledatabase

 

Thanks Danny.
Can you talk clearer about using ODBC to store cdr to oracle db because i
don`t want to synchronize oracle db with mysql db?
Thanks and best regards.

On Wed, Nov 10, 2010 at 9:15 PM, Danny Nicholas <danny at debsinc.com> wrote:

From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Phuong Hoang
Sent: Wednesday, November 10, 2010 3:07 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] Store CDR (call detail record) to
Oracledatabase

 

Thanks Danny.
I searched on internet and found a link :
http://forums.digium.com/viewtopic.php?f=1
<http://forums.digium.com/viewtopic.php?f=1&t=11135&start=0>
&t=11135&start=0 
This link guided to use ODBC to store cdr into Oracle database but not
successful . Can you help me ?
Thanks and best regards.

On Tue, Nov 9, 2010 at 9:27 PM, Danny Nicholas <danny at debsinc.com> wrote:

  _____  

ODBC is going to be your best bet.  At some point you might be able to use
the MYSQL stuff to talk from Asterisk to Oracle, but for now I'm pretty sure
it is only accessible through ODBC.

From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Phuong Hoang
Sent: Monday, November 08, 2010 8:31 PM
To: asterisk-users at lists.digium.com
Subject: [asterisk-users] Store CDR (call detail record) to Oracle database

Hi all,
Now i want to store cdr (call detail record) to Oracle database but i don't
know how to do .Can anyone help me ?
Thanks and best regards.

Just make your Oracle tables using the MYSQL guidelines and you should be
good to go.

If it proves to be too cumbersome using odbc, you could always make your
"live" cdr in flat file or MYSQL and do a quick-and-dirty daemon to
synchronize that to the Oracle DB.

 

 


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
              http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

 

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