-
Create Database
-
mysqladmin -uroot -ppassword
create freepbxcidlookup
-
Create Table
-
mysql -uroot -ppassword -Dfreepbxcidlookup
-vv -e 'CREATE TABLE `callerid` (`number` VARCHAR(20) NOT NULL ,`name`
VARCHAR(50) NOT NULL ,PRIMARY KEY (`number` , `name`))'
-
Setup CallerID Lookup Source (Query=
SELECT name FROM callerid WHERE number LIKE '%[NUMBER]%'
)
-
-
Setup Inbound Route
-
|