Book Image

FreeSWITCH Cookbook

Book Image

FreeSWITCH Cookbook

Overview of this book

FreeSWITCH is an open source telephony platform designed to facilitate the creation of voice, chat, and video applications. It can scale from a soft-phone to a PBX and even up to an enterprise-class softswitch.In the FreeSWITCH Cookbook, members of the FreeSWITCH development team share some of their hard-earned knowledge with you in the book's recipes. Use this knowledge to improve and expand your FreeSWITCH installations.The FreeSWITCH Cookbook is an essential addition to any VoIP administrator's library.The book starts with recipes on how to handle call routing and then discusses connecting your FreeSWITCH server to the outside world.It then teaches you more advanced topics like CDR handling, practical examples of controlling FreeSWITCH with the event socket, and configuring many features commonly associated with a PBX installation.

Related Content you might be interested in

Current Title:

Small book image
FreeSWITCH Cookbook
Feb, 2012 | 150 pages
No titles found
Table of Contents (12 chapters)
FreeSWITCH Cookbook
FreeSWITCH 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 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 To: headers on registered endpoints to reflect DID numbers
2
Connecting Telephones and Service Providers
Connecting Telephones and Service Providers
Introduction
Configuring a SIP phone to register with FreeSWITCH
Connecting audio devices with PortAudio
Using FreeSWITCH as a softphone
Configuring a SIP gateway
Configuring Google Voice
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
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
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
Listening to live calls with telecast
Recording calls
Index
Index

Inserting CDRs into a backend database

Frequently it is necessary to put CDR information into a database such as MySQL, PostgreSQL, or other SQL databases. FreeSWITCH does not support writing CDRs directly to a database (the decision not to write directly to a database is an engineering, not a technical limitation). This recipe discusses the simple 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 files. 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 type of database you have—consult your database documentation for specific instructions.

You will also need a table for the CDRs. The following CREATE TABLE syntax for a PostgreSQL database will work for the existing sql template in cdr_csv.conf.xml:

CREATE TABLE cdr (
  caller_id_name...
Previous Section
End of Section 5
Next Section