Book Image

Freeswitch 1.6 Cookbook

Book Image

Freeswitch 1.6 Cookbook

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Freeswitch 1.6 Cookbook
Jul, 2015 | 190 pages
No titles found
Table of Contents (14 chapters)
FreeSWITCH 1.6 Cookbook
FreeSWITCH 1.6 Cookbook
Credits
Credits
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Routing Calls
Routing Calls
Introduction
Internal calls
Incoming DID (also known as DDI) calls
Outgoing calls
Ringing multiple endpoints simultaneously
Ringing multiple endpoints sequentially (simple failover)
Advanced multiple endpoint calling with enterprise originate
Time-of-day routing
Manipulating SIP To: headers on registered endpoints to reflect DID numbers
2
Connecting Telephones and Service Providers
Connecting Telephones and Service Providers
Introduction
Configuring an SIP phone to register with FreeSWITCH
Connecting to Skype
Configuring an SIP gateway
Codec configuration
3
Processing Call Detail Records
Processing Call Detail Records
Introduction
Using CSV CDRs
Using XML CDRs
Inserting CDRs into a backend database
Using a web server to handle XML CDRs
Using the event socket to handle CDRs
Directly inputting CDRs into various databases in real time
4
External Control
External Control
Introduction
Getting familiar with the fs_cli interface
Setting up the event socket library
Establishing an inbound event socket connection
Establishing an outbound event socket connection
Using fs_ivrd to manage outbound connections
Filtering events
Launching a call with an inbound event socket connection
Using the ESL connection object for call control
Using the built-in web interface
5
PBX Functionality
PBX Functionality
Introduction
Creating users
Accessing voicemail
The company directory
Using phrase macros to build sound prompts
Creating XML IVR menus
Music on hold
Creating conferences
Sending faxes
Receiving faxes
Basic text-to-speech with mod_flite
Advanced text-to-speech with mod_tts_commandline
Recording calls
6
WebRTC and Mod_Verto
WebRTC and Mod_Verto
Introduction
Configuring FreeSWITCH for WebRTC
SIP signaling in JavaScript with SIP.js (WebRTC client)
Verto installation and setup
Verto signaling in JavaScript using Verto.js (Verto client)
7
Dialplan Scripting with Lua
Dialplan Scripting with Lua
Introduction
Creating a basic Lua script
User interaction and DTMF gathering
Using conditionals, loops, web calls, and regular expressions
Connecting to an external database
Index
Index

Inserting CDRs into a backend database

Frequently, it is necessary to put CDR information into a database such as PostgreSQL or other SQL and NoSQL databases. FreeSWITCH has various modules for writing CDRs directly to many databases, but the preferred architecture is writing CDRs to the disk or posting them to a web server, and then processing them so that they can be inserted into a database. Many engineering reasons lead to this architecture (for example, avoiding dependence on direct, real-time interaction with the database), and most of them relate it to integrity and resilience. This recipe discusses the recommended method of writing SQL-based CSV files and then using those to update a backend database.

Getting ready

Of course, you will need a database in which to store your CDRs. Any SQL-compliant database will work as long as you can use the command line to execute SQL statements. Create a database for your CDRs, and allow any necessary access. This is completely dependent upon the...

Previous Section
End of Section 5
Next Section