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

[Phuong Hoang]

Thanks for your reply.now i decide to read from flat file
/var/log/asterisk/cdr-csv/Master.csv
and then insert into oracle database. it has been to meet you.

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

>  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&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
>
>
>
> --
> _____________________________________________________________________
> -- 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/20101111/d9302755/attachment.htm