ASTERISK PBX WITH DATABASE/API DRIVEN CALL CENTER SOLUTION

Name: ASTERISK PBX WITH DATABASE/API DRIVEN CALL CENTER SOLUTION
Rating: 4.1 (75 reviews)

BUILDING DATABASE/API DRIVEN CALL CENTER SOLUTION USING ASTERISK

Created byOluwaseyi Ogungbaigbe

Last updated 5/2026

English

English [Auto],

What you'll learn

In-depth Knowledge of Asterisk PBX.
Deploy a robust enterprise Call Center Solution with little or no cost(Configure Automatic Call Distribution (ACD) using Queue (Database Driven & Config File)
Build a working Interactive Voice Response (IVR) System
Make HTTP request (API call: Post & Get) to the external system to fetch data during call session (Active Channel)
Integrate Asterisk to MySQL Database, MSSQL, or any database of your choice
Basic Troubleshooting in Asterisk PBX
Build Private Branch Exchange (PBX) for organizations with little or no cost
Secure your Asterisk PBX

Course content

13 sections • 68 lectures • 9h 1m total length

Course Introduction10:28
Explore a database and API driven call center solution built on Asterisk PBX, with API calls, IVR, endpoints, trunks, and scalable VoIP deployments for an online medical consulting service.
Asterisk Intro1:23

Section Objective1:58
Download, install, and set up a two-VM environment (asterisk and database server), deploying via VMware Workstation, VirtualBox, or Azure, and clone API pages from Ghizo after testing with Audacity.
Dependencies Installation1:02
Deploy 2 Linux VMs (Asterisk and MySQL Database)15:21
Tasks: Deploy two VMs (Together we will deploy 1st VM(Asterisk). Kindly Go ahead to deploy the second VM (MySQL Database Server)
Download Asterisk Latest LTS & Install It's Dependencies7:40
Download the latest Asterisk LTS from the official site, install its dependencies, clone the API library, and compile Asterisk for a database/API driven call center setup.
Install Dial Plan API/JSON Manipulation Library From GitHub5:25
Install the dial plan api/json manipulation library from GitHub, review its documentation, and learn to implement and test API calls with the library.
Compile and Install Asterisk from Source using the Latest LTS Release8:08
Compile Asterisk from source using the latest LTS release, configure dependencies and libraries, connect to the database, enable features, build with make, and verify service status.

Section Objective0:40
Clarify the section objectives and learn the Asterisk busy fire structure in our state, emphasizing its importance for navigation and correct configuration to prevent lab issues.
Understanding Basic file Structure in Asterisk2:03
Best Practice when Working with Config files2:17
Explore best practices for working with config files in an Asterisk pbx setup, including renaming samples, organizing directories, and documenting changes with in-code comments for collaboration.
Directory and File Structure
Working with Chan PJSIP6:23
Explore PJSIP in Asterisk, configuring endpoints and transports, setting address of record and authentication, and understanding domain, registrations, and transport options for udp-based sip.
Implement 1st Lab23:09
•Enable Firewall
•22 (SSH)
•5060 -5061 (SIP)
•10,000 – 20,000 media
•80 Http, 443 Https

◦sudo ufw allow 5060:5061/udp
◦sudo ufw allow 10000:20000/udp
◦sudo ufw allow 3306/udp,
◦Sudo ufw allow 1433/tcp
sudo ufw allow 80,443/tcp
Working with Asterisk Dial Plan (extension.conf) & 1st Lab End to End Test19:30

Section Objective2:10
Install and Configure MySQL7:13
Create MySQL User(Service Account for Asterisk) with Right Privilege0:03
Connect to MySQL Database via MySQL Workbench1:51
Create Asterisk Tables using Alembic Approach12:12
Learn to create asterisk tables using an alembic approach by applying alembic scripts to initialize and modify database tables, configure connections, and validate installation.
Create Asterisk Tables using C# Entity Framework2:51
Create Asterisk Tables using SQL Script1:53
Create asterisk tables using SQL script to establish a database-driven call center, including setting up the connection and importing resources for practical integration.

Section Objective1:57
Postgres Installation1:56
Update the server and install Postgres, then log in as default user, connect to the database, and verify Postgres 14.8. Explore how to create the database and grant permissions.
Database and User Creation2:04
Create the database named Asterix and add a login user with a password. Grant all privileges to that user so they can connect remotely.
Remote Access Permission5:33
Enable remote access for the database by editing the configuration to listen on any IP, open port 6432 in the firewall, and verify connections to Asterisk via pgadmin.
Remote Connection to Postgres via via Native client from Asterisk Server3:03
Remote Connection to Postgres via PgAdmin4:31
Create Asterisk tables using Database Script2:02

Integrate Asterisk with Any Database of your Choice8:46
Integrate Asterisk with any database using the Asterix architecture via a common interface, using ODBC or native configuration for MySQL, Postgres, and SQLite, with data source name and mapping details.
Install and configure MySQL ODBC Connection Driver11:29
Install and configure the MySQL ODBC connection driver on Ubuntu, including adding the repo, downloading the driver, and setting up the database connection for the call center solution.
Integrate Asterisk with MySQL Database Part 218:37
Integrate Asterisk with MySQL database by configuring drivers, ETSI config files, and mapping database tables to Asterisk objects. Configure endpoints and address of record for a database-driven call center.
Migrate First Lab from conf file driven approach to database-driven -MySQL10:47
migrate a first lab from a conf file driven approach to a database driven model using MySQL, configuring authentication, address of record, and endpoints in database tables.
Integrate Asterisk with Postgres Database6:00
Learn to integrate a Postgres database with Asterisk using a native configuration file, mapping endpoints, authentication, and address of record, without installing odbc drivers.
Migrate First Lab from conf file driven approach to database-driven -Postgres9:28
Migrate your lab from configuration file to Postgres database, mirroring the MySQL workflow, by creating and verifying authentication, endpoints, and address records with SQL scripts and Azure CLI.

Section Objective0:28
Introduce quality record as the learning objective, configure RSA to CDO for stability and cost settings, and link it to the data plan, with a video overview of the CDO.
Intro to CDR2:39
Explore call detail records in telecoms, including origin, destination, duration, and time, and map cdr data to a database with customer id fields for an api-driven asterisk pbx call center.
Configure Asterisk to Log CDR in a database table8:44
Configure Asterisk to log CDR in a database table by adapting a sample configuration, linking to your database, and validating the connection and table fields.
How to Configure Custom Field in CDR table3:54

Section Objectives0:35
Outline section objectives on building costs and storage introduction for the platform. Address questions about recording with audacity and note upcoming topics discussed in the lecture.
Intro1:16
Explore building a database and API driven call center platform using Asterisk PBX, with distribution rules and hybrid options, laying the foundation for setting up the telecommunication solution.
Basic Queue Parameters3:16
Set and tune busy queue parameters, such as the max queue length and the number of available agents, and define timeouts, call routing, and recording for quality assurance.
Working with queues.conf Part 13:45
Working with queues.conf Part 210:51
Explore queues.conf Part 2 with a sample configuration, adjust timeouts, and reload services to validate the support queue; then enable database integration for data-driven call routing.
Setup Queue using database tables (queues, queue_members,queue_log) with ACD10:06
Configure a queue in asterisk using database tables (queues, queue_members, queue_log) with acd, set up the connection, name the queue, and add members to manage inbound calls effectively.
Prompt Recording using Audacity7:13
Learn how to record prompts with Audacity for an Asterisk PBX, convert to mono 8000 Hz WAV, and export ready IVR files for call center use.
Working with Musiconhold Using Config File17:32
Configure music on hold with a config file in a database driven asterisk pbx setup, managing default locations, playlists, and per-call hold music for a call center.
Working with Musiconhold Using Database Tables26:08

Trunk Setup Introduction1:02
Set up a trunk line to connect the mobile phone line with the PBX, establishing the foundation for protocol sessions.
Configure Trunk line using Configuration File10:52
Setup Trunk line Using Database Table11:39
Set up a central trunk line by configuring a database table and mapping bridge registrations, enabling the front-end app to write trunk settings directly to the database.
Link PJSIP Configuration With The Dial Plan (extension.conf)12:15
Link PJSIP configuration with the dial plan in extension.conf, configure trunk lines, and use database tables for call routing in a database-driven Asterisk PBX for a call center solution.

Understanding The LAB SETUP3:51
This lab demonstrates integrating asterisk pbx with a database API-driven call center, building an IVR for appointment booking and online consultations, linked to trunk lines and a backend database.
Algorithm & Flow Chat Explanation of our Use Case3:12
Explore the Asterisk PBX driven call center workflow, including menu navigation, timeouts, and retries, with API calls to validate customer IDs and booking flows.
Working with API6:31
Brief Explanation on C# code used for API9:55
Demonstrates a C# API call workflow for an asterisk pbx call center, showing how to configure database connection parameters and use appointment endpoints to book and notify customers.
Lab Environment Setup (API Hosting )15:05
Learn how to host a cross-platform .NET API on Windows or Linux by enabling IIS, configuring a website, compiling and publishing the app, and connecting to a database server.
Dial Plan implementation for our use case (extension.conf) Part 118:20
Dial Plan implementation for our use case (extension.conf) Part 246:43

Requirements

Asterisk Knowledge: Yes (Not a show-stopper with focus and follow the course as outlined )
Basic Knowledge on Network and Linux: Yes (Not a show-stopper with focus and and follow the course as outlined)

Description

The tutorial is about learning how to Build a Database/API-driven Call Center Solution/PBX using asterisk PBX. You will learn the following

In-depth Knowledge of Asterisk PBX.
How to setup Trunk to any provider of your choice using chan PJSIP (Config File & Database Table
How to work with Asterisk dial plan to implement different business scenarios
How to setup Interactive Voice Response (IVR) System with Time-based call routing
How to setup PBX for Organization using Asterisk
How to setup Automatic Call Distribution amount the Agents (Database and Configuration file driven approach)
Integrate Asterisk with Any Database of your Choice (MySQL, SQLite, PostgreSQL, MSSQL)
Setup MySQL Database in Linux environment and integrate it with Asterisk PBX
Working with Musiconhold (Config File & Database table)
Make API call in your dial plan to an external system in real-time
Secure Your PBX

After learning the basics of Asterisk, We are going to implement Call Center Solution for a fictitious Hospital(The Great Hospital) that has an Online Medical Consulting Service with the following requirements

Prompt
- 1 => Consulting
- 2=> Customer Service
- 3 => Self-Service ( 1 .Book Appointment 2.Cancel Appointment 3.Confirm Appointment 4.Check Outstanding Bill)

User Story (Implementation Requirement)
- Consulting Unit: Working Hours: 8 AM – 9 PM, Call Outside the working hours should be routed to the customer service unit
- Access to the Consultant is based on appointment and registered client (Validation via API call)
- Booking of Appointment should be logged in the database and email notification sent to Customer Service
- All calls (Inbound and outbound) must be recorded for Quality Assurance. Any missed call should trigger a mail to the supervisor/monitoring email group for quality assurance.

Who this course is for:

VoIP Engineers, System Administrator, Programmer and anyone Interest in learning Asterisk PBX

ASTERISK PBX WITH DATABASE/API DRIVEN CALL CENTER SOLUTION

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 12min

Download & Setup Course Prerequisites/Environment Setup6 lectures • 40min

Configuration6 lectures • 54min

Database Setup and Configuration7 lectures • 28min

Install and Configure Postgres Database7 lectures • 21min

Integrate Asterisk with Database6 lectures • 1hr 5min

Working with Call Detail Records (CDR)4 lectures • 16min

Building Call Center9 lectures • 1hr 21min

Trunk Setup4 lectures • 36min

LAB Implementation Scenario ( Database Driven IVR and Call Center Platform)7 lectures • 1hr 44min

Requirements

Description

Who this course is for: