[Freeswitch-users] mod_db help needed

[Yiftach Golan]

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 :
Compile FreeSWITCH with ODBC support

UnixODBC support will be autodetected by ./configure, and if found, will be
compiled into FreeSWITCH.
As for the keys it is pretty easy just go to (
http://wiki.freeswitch.org/wiki/Mod_db) the query should be something like
:

<action application="set" data="var=${db(select/realm/key)}"/>

The documentation is actually pretty good so try to read it again it will
make sense
Thanks,
Yiftach.

On Thu, Nov 15, 2012 at 4:51 AM, Nitin Tomer <ntomer at newgen.co.in> wrote:

>  I 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 at lists.freeswitch.org [mailto:
> freeswitch-users-bounces at 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 at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121115/391045a7/attachment.html