[Freeswitch-users] mod_db help needed

Thu Nov 29 07:40:47 MSK 2012

Since site was down yesterday, I did some hit and trials myself, made the
following changes in db.conf.xml -

<configuration name="db.conf" description="LIMIT DB Configuration">
  <settings>
      <param name="freeswitch-connector"
value="freeswitch:root:system123#"/>
  </settings>
</configuration>

And added this entry in dialplan -

<action application="db" data="insert/testapp/newcall1/${res}" />

When I tried running it, I didn't get any error. But neither any entries
were made in the database.

Please tell me what I am doing wrong.

Regards

Nitin

From: freeswitch-users-bounces at lists.freeswitch.org
[mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Nitin
Tomer
Sent: Tuesday, November 27, 2012 3:52 PM
To: 'FreeSWITCH Users Help'
Subject: Re: [Freeswitch-users] mod_db help needed

Hi Yiftach,

Thanks for your reply. I have installed and configured ODBC on my server. 

/etc/odbc.ini has following entries -

[freesiwtch-connector]

Description           = MySQL connection to 'freeswitch' database

Driver                = MySQL

Database              = freeswitch

Server                = localhost

UserName              = root

Password              = system123

Port                  = 3306

Socket                = /var/run/mysqld/mysqld.sock

After this I did ./configure and "make && make install"

Now what all changes I need to make in Freeswitch so that I can make ODBC
work in it? Please help me out.

N.B. Today Freeswitch.org is down and therefore I am not able to look for
any help there

Regards

Nitin

From: freeswitch-users-bounces at lists.freeswitch.org
[mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Yiftach
Golan
Sent: Friday, November 16, 2012 3:03 AM
To: FreeSWITCH Users Help
Subject: Re: [Freeswitch-users] mod_db help needed

Hi Nitin,
Just install odbc on you system, I used this one
(http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/install
ing_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. 

_________________________________________________________________________
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

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121129/befe6757/attachment-0001.html 