Setup MySQL CallerID Lookup Source on FreePBX

  • 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