Thanks Danny.<br>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?<br>Thanks and best regards.<br><br><div class="gmail_quote">On Wed, Nov 10, 2010 at 9:15 PM, Danny Nicholas <span dir="ltr"><<a href="mailto:danny@debsinc.com">danny@debsinc.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div link="blue" vlink="blue" lang="EN-US">
<div>
<p class="MsoNormal"><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;">
<a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">asterisk-users-bounces@lists.digium.com</a>
[mailto:<a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">asterisk-users-bounces@lists.digium.com</a>] <b><span style="font-weight: bold;">On Behalf Of </span></b>Phuong Hoang<br>
<b><span style="font-weight: bold;">Sent:</span></b> Wednesday, November 10, 2010
3:07 AM<br>
<b><span style="font-weight: bold;">To:</span></b> Asterisk
Users Mailing List - Non-Commercial Discussion<br>
<b><span style="font-weight: bold;">Subject:</span></b> Re: [asterisk-users]
Store CDR (call detail record) to Oracledatabase</span></font></p><div class="im">
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Thanks Danny.<br>
I searched on internet and found a link : <font color="red"><span style="color: red;"><a href="http://forums.digium.com/viewtopic.php?f=1&t=11135&start=0" target="_blank">http://forums.digium.com/viewtopic.php?f=1&t=11135&start=0</a>
</span></font><br>
This link guided to use ODBC to store cdr into Oracle database but not
successful . Can you help me ?<br>
Thanks and best regards.</span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">On Tue, Nov 9, 2010 at 9:27 PM, Danny Nicholas <<a href="mailto:danny@debsinc.com" target="_blank">danny@debsinc.com</a>> wrote:</span></font></p>
<div class="MsoNormal" style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">
<hr width="100%" align="center" size="2">
</span></font></div>
</div><p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">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.</span></font></p><div class="im">
<p class="MsoNormal"><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;"> <a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">asterisk-users-bounces@lists.digium.com</a>
[mailto:<a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">asterisk-users-bounces@lists.digium.com</a>]
<b><span style="font-weight: bold;">On Behalf Of </span></b>Phuong Hoang<br>
<b><span style="font-weight: bold;">Sent:</span></b> Monday, November 08, 2010
8:31 PM<br>
<b><span style="font-weight: bold;">To:</span></b> <a href="mailto:asterisk-users@lists.digium.com" target="_blank">asterisk-users@lists.digium.com</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> [asterisk-users] Store
CDR (call detail record) to Oracle database</span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Hi all,<br>
Now i want to store cdr (call detail record) to Oracle database but i don't
know how to do .Can anyone help me ?<br>
Thanks and best regards.</span></font></p>
</div><p class="MsoNormal" style="margin-left: 0.5in;"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Just make your Oracle tables using the MYSQL
guidelines and you should be good to go.</span></font></p>
<p class="MsoNormal" style="margin-left: 0.5in;"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">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.</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
</div>
</div>
<br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br><div style="visibility: hidden; left: -5000px;" id="avg_ls_inline_popup">
</div><style type="text/css">#avg_ls_inline_popup{position: absolute;z-index: 9999;padding: 0px 0px;margin-left: 0px;margin-top: 0px;overflow: hidden;word-wrap: break-word;color: black;font-size: 10px;text-align: left;line-height: 130%;}</style>