Book Image

Freeswitch 1.6 Cookbook

Book Image

Freeswitch 1.6 Cookbook

Overview of this book

Table of Contents (14 chapters)
FreeSWITCH 1.6 Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Connecting to an external database


Connecting to databases can be done using ODBC bindings for Lua, or native Lua drivers for databases.

Another way to connect to databases—the preferred way—is to create HTTP queries from Lua and leave the HTTP server (or servers) the burden of managing connection pools, scalability, concurrence, and so on with tried and true well-known techniques.

Here, we'll see this preferred way.

Getting ready

Create a dialplan extension "12348" that will call our last Lua script. Edit the /usr/local/freeswitch/conf/dialplan/default/04_database.xml file:

<include>
  <extension name="Connect to DataBase">
    <condition field="destination_number" expression="^(12348)$">
        <action application="answer"/>
        <action application="sleep" data="1000"/>
        <action application="lua" data="database.lua"/>
    </condition>
  </extension>
</include>

Save the file and then, from fs_cli, reloadxml.

Also, we need our HTTP...