Hi Nitin,<br>Just install odbc on you system, I used this one (<a href="http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/installing_configuring_odbc.html">http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/installing_configuring_odbc.html</a>) but you can use FreeSWITCH's explanations as well (<a href="http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core">http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core</a>)<br>
Once you are done the configure should already know that you have odbc support, just hit regular configure or as FreeSWITCH docs says : <br><h2> <span class="mw-headline">Compile FreeSWITCH with ODBC support</span></h2>
<p>UnixODBC support will be autodetected by ./configure, and if found, will be compiled into FreeSWITCH. <br></p>As for the keys it is pretty easy just go to (<a href="http://wiki.freeswitch.org/wiki/Mod_db">http://wiki.freeswitch.org/wiki/Mod_db</a>) the query should be something like : <br>
<pre><action application="set" data="var=${db(select/realm/key)}"/><br><br></pre>The documentation is actually pretty good so try to read it again it will make sense<br>Thanks,<br>Yiftach.<br><br>
<div class="gmail_quote">On Thu, Nov 15, 2012 at 4:51 AM, Nitin Tomer <span dir="ltr"><<a href="mailto:ntomer@newgen.co.in" target="_blank">ntomer@newgen.co.in</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="color:#1f497d">I understand that I will have to
make changes in db.conf.xml -<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><configuration
name="db.conf" description="LIMIT DB Configuration"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <settings><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> <!--<param
name="odbc-dsn" value="dsn:user:pass"/>--><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"> </settings><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"></configuration><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">But the wiki also says this – “ODBC
must be configured to use ODBC resources (configure with
--enable-core-odbc-support).” What does this mean? I couldn’t find any more
references to it.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Wiki says – “Realm and key are
arbitrary strings. Consider realm as a container for keys.” Does this mean that
I can use a realm for a particular type of data e.g. “callerdata”, use caller
number as key and set the entered data against that key. But how would I be
able to access this data from outside FreeSwitch?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Is the realm mapped to a table
in the database or something similar?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Thanks in advance<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Nitin<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>
[mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>] <b>On Behalf Of </b>Nitin
Tomer<br>
<b>Sent:</b> Thursday, November 15, 2012 3:30 PM<br>
<b>To:</b> 'FreeSWITCH Users Help'<br>
<b>Subject:</b> [Freeswitch-users] mod_db help needed<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Hi,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I am trying to enter some data (entered by caller, received
by Play and Get Digits). But I am not able to get much information about it
from mod_db wiki. I want to enter data in an Oracle database. Please tell me
what all I need to do, in order to do this.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Regards<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Nitin<u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><u></u> <u></u></span></p>
<h6>Disclaimer :- This e-mail and any attachment may contain confidential,
proprietary or legally privileged information. If you are not the original
intended recipient and have erroneously received this message, you are
prohibited from using, copying, altering or disclosing the content of this
message. Please delete it immediately and notify the sender. Newgen Software
Technologies Ltd (NSTL) accepts no responsibilities for loss or damage arising
from the use of the information transmitted by this email including damages
from virus and further acknowledges that no binding nature of the message shall
be implied or assumed unless the sender does so expressly with due authority of
NSTL. <u></u><u></u></h6>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><u></u> <u></u></span></p>
</div>
<br>
<div><h6>Disclaimer :- This e-mail and any attachment may contain confidential, proprietary or legally privileged information. If you are not the original intended recipient and have erroneously received this message, you are prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd (NSTL) accepts no responsibilities for loss or damage arising from the use of the information transmitted by this email including damages from virus and further acknowledges that no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of NSTL.
</h6></div>
<br></div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br>