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 <[email protected]> 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:* [email protected] [mailto: > [email protected]] *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 <[email protected]> wrote: > > *From:* [email protected] [mailto: > [email protected]] *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 <[email protected]> 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:* [email protected] [mailto: > [email protected]] *On Behalf Of *Phuong Hoang > *Sent:* Monday, November 08, 2010 8:31 PM > *To:* [email protected] > *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 >
-- _____________________________________________________________________ -- 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
