Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying FreeSWITCH Cookbook
  • Table Of Contents Toc
  • Feedback & Rating feedback
FreeSWITCH Cookbook

FreeSWITCH Cookbook

4.5 (8)
Buy this Book
close
close
FreeSWITCH Cookbook

FreeSWITCH Cookbook

4.5 (8)
Buy this Book

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.
Table of Contents (12 chapters)
close
close
close
FreeSWITCH Cookbook
Icon
FreeSWITCH Cookbook
Credits
Icon
Credits
About the Authors
Icon
About the Authors
About the Reviewers
Icon
About the Reviewers
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Lock Free Chapter
1
Routing Calls
Icon
Routing Calls
Icon
Introduction
Icon
Internal calls
Icon
Incoming DID calls
Icon
Outgoing calls
Icon
Ringing multiple endpoints simultaneously
Icon
Ringing multiple endpoints sequentially (simple failover)
Icon
Advanced multiple endpoint calling with enterprise originate
Icon
Time of day routing
Icon
Manipulating To: headers on registered endpoints to reflect DID numbers
2
Connecting Telephones and Service Providers
Icon
Connecting Telephones and Service Providers
Icon
Introduction
Icon
Configuring a SIP phone to register with FreeSWITCH
Icon
Connecting audio devices with PortAudio
Icon
Using FreeSWITCH as a softphone
Icon
Configuring a SIP gateway
Icon
Configuring Google Voice
Icon
Codec configuration
3
Processing Call Detail Records
chevron up
Icon
Processing Call Detail Records
Icon
Introduction
Icon
Using CSV CDRs
Icon
Using XML CDRs
Icon
Inserting CDRs into a backend database
Icon
Using a web server to handle XML CDRs
Icon
Using the event socket to handle CDRs
4
External Control
Icon
External Control
Icon
Introduction
Icon
Getting familiar with the fs_cli interface
Icon
Setting up the event socket library
Icon
Establishing an inbound event socket connection
Icon
Establishing an outbound event socket connection
Icon
Using fs_ivrd to manage outbound connections
Icon
Filtering events
Icon
Launching a call with an inbound event socket connection
Icon
Using the ESL connection object for call control
Icon
Using the built-in web interface
5
PBX Functionality
Icon
PBX Functionality
Icon
Introduction
Icon
Creating users
Icon
Accessing voicemail
Icon
Company directory
Icon
Using phrase macros to build sound prompts
Icon
Creating XML IVR menus
Icon
Music on hold
Icon
Creating conferences
Icon
Sending faxes
Icon
Receiving faxes
Icon
Basic text-to-speech with mod_flite
Icon
Advanced text-to-speech with mod_tts_commandline
Icon
Listening to live calls with telecast
Icon
Recording calls
1
Index
Icon
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...
Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
FreeSWITCH Cookbook
End of Section 3
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon