A few days ago on our FreePBX 15 system I upgraded all of the modules that had pending updates. The module “CallerID Lookup” got upgraded from 15.0.20 to 15.0.24. After that upgrade, for any number that it didn’t find in the MySQL table we have that lookup configured to check in it would show as “unknown” instead of passing thru the default caller ID info coming from the carrier.
Once this was discovered we rolled back to version 15.0.20 of that module in question and everything is working like normal again. Anyone else running into this? Do I need to submit a bug report somewhere other than here?
The way SQL lookups are done in the cidlookup module has changed recently to remove reliance on a deprecated Asterisk module. Open a ticket with your findings pls. https://issues.freepbx.org/
I don’t have a file that matches the name you referenced or one like it. If you want me to try more things with the new module I’ll have to do it after hours when it’s not going to break CID functionality on our production system. We don’t have a test system.
I had a chance today after hours to try this module upgrade again. I upgraded it to 15.0.24 again, same issue is occurring as expected. I ran fwconsole dbug while I called from a number NOT in the “rhs_phones” table, it didn’t trigger anything to display / print in the debug file. Afterwards the only thing that showed in freepbx_dbug file is attached(unrelated I’m sure).
I rolled back to 15.0.20 and it’s working fine again now. Not sure what you’d like me to try to do next to give more details, but I won’t be able to upgrade this module until it’s fixed.
No, I can do that now. One other thing that might be worth mentioning is we are still running on Asterisk 16.17.0. We have some custom patches we apply to the voicemail part of asterisk that need some extra work when going to versions after 16.17.0, that’s why we’ve been putting off upgrading that.
I ran into this problem, too. After the recent callerID changes, my SNOM phones stopped displaying the calling number for numbers that were not in the database. I fixed it with this workaround, but I think there could be a better solution:
DELIMITER ;
DROP PROCEDURE IF EXISTS mylookup;
DELIMITER &&
CREATE PROCEDURE mylookup(IN num varchar(80))
BEGIN
SELECT IFNULL((SELECT name FROM freepbx WHERE number LIKE CONCAT(num, '%')), CONCAT('Unknown: ', num) ) as name;
END &&
DELIMITER ;
