Book Image

FreeSWITCH 1.6 Cookbook

By : Giovanni Maruzzelli, Anthony Minessale II
Book Image

FreeSWITCH 1.6 Cookbook

By: Giovanni Maruzzelli, Anthony Minessale II

Overview of this book

Table of Contents (14 chapters)
FreeSWITCH 1.6 Cookbook
About the Authors
About the Reviewers

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:

  <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"/>

Save the file and then, from fs_cli, reloadxml.

Also, we need our HTTP...