Hi Nitin,
Just install odbc on you system, I used this one (http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/installing_configuring_odbc.html) but you can use FreeSWITCH's explanations as well (http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core)
Once you are done the configure should already know that you have odbc support, just hit regular configure or as FreeSWITCH docs says :
UnixODBC support will be autodetected by ./configure, and if found, will be compiled into FreeSWITCH.
<action application="set" data="var=${db(select/realm/key)}"/>
The documentation is actually pretty good so try to read it again it will make senseI understand that I will have to make changes in db.conf.xml -
<configuration name="db.conf" description="LIMIT DB Configuration">
<settings>
<!--<param name="odbc-dsn" value="dsn:user:pass"/>-->
</settings>
</configuration>
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.
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?
Is the realm mapped to a table in the database or something similar?
Thanks in advance
Nitin
From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Nitin Tomer
Sent: Thursday, November 15, 2012 3:30 PM
To: 'FreeSWITCH Users Help'
Subject: [Freeswitch-users] mod_db help needed
Hi,
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.
Regards
Nitin
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.
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.
_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com
FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org