Skip to Main Content
Asterisk: The Definitive Guide, 4th Edition
book

Asterisk: The Definitive Guide, 4th Edition

by Russell Bryant, Leif Madsen, Jim Van Meggelen
May 2013
Intermediate to advanced content levelIntermediate to advanced
843 pages
23h 50m
English
O'Reilly Media, Inc.
Content preview from Asterisk: The Definitive Guide, 4th Edition

Chapter 16. Relational Database Integration

Few things are harder to put up with than the annoyance of a good example.

Mark Twain

In this chapter, we are going to explore integrating some Asterisk features and functions into a database. There are several databases available for Linux, but we have chosen to limit our discussion to the two most popular: PostgreSQL and MySQL.

We will also explain how to configure Linux to connect to a Microsoft SQL database via ODBC; however, configuration of the Windows/Microsoft portion is beyond the scope of this book.

Regardless of which database you use, this chapter focuses primarily on the ODBC connector, so as long as you have some familiarity with getting your favorite database ODBC-ready, you shouldn’t have any problems with this chapter.

Integrating Asterisk with databases is one of the fundamental aspects of building a large clustered or distributed system. The power of the database will enable you to use dynamically changing data in your dialplans, for tasks such as sharing information across an array of Asterisk systems or integrating with web-based services. Our favorite dialplan function, which we will cover later in this chapter, is func_odbc.

While not all Asterisk deployments will require relational databases, understanding how to harness them opens a treasure chest full of new ways to design your telecom solution.

Installing and Configuring PostgreSQL and MySQL

In the following sections, we will show how to install and configure PostgreSQL ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Asterisk: The Definitive Guide, 3rd Edition

Asterisk: The Definitive Guide, 3rd Edition

Leif Madsen, Jim Van Meggelen, Russell Bryant
Asterisk: The Future of Telephony, 2nd Edition

Asterisk: The Future of Telephony, 2nd Edition

Jim Van Meggelen, Jared Smith, Leif Madsen
Asterisk: The Definitive Guide, 5th Edition

Asterisk: The Definitive Guide, 5th Edition

Jim Van Meggelen, Russell Bryant, Leif Madsen

Publisher Resources

ISBN: 9781449332433Errata Page