Using MySQL to search for the caller's name

This option allows us to search for the caller's name in a database.

How to do it…

If we wanted to use a MySQL query to search for the caller name for an incoming caller ID, we must enter the Host, the Database, the Username, the Password, and the Query that will be executed to search for the name. Cache results options are checked in the image. This will allow the system to store results astDB in the cache, so that the system can perform lookups locally instead of remote lookups. This is shown in the next image:

How to do it…

The database query would be as follows: select name from users with an extension like %[NUMBER]% ...

Get Elastix Unified Communications Server Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.