I’ve recently upgraded my long time working FreePBX installation to version 15 and something has broken. If a call comes in and there is a number in the internal phonebook (a basic self hosted mysql database) all is well and the handsets show a name and number. Since the upgrade, if a call comes in and there is no entry in the mysql database, the phone displays are essentially blank. In other words, they don’t display any number or even “unknown” like they used to. I’m no expert, but I’ve had a look through the menus and googled fixes, but I can’t seem to narrow results down to this particular issue. It’s very possible I’m just not getting the terminology correct.
Can anyone shed any light onto this problem please? Or point me in the right direction. I’ve not made any other changes to the configuration that I am aware of. I do get calls occasionally that show something like PJ_SIP and then the IP address of the server and when picked up, I get a standard dial tone. These calls also show a blank screen now. I guess I have 2 gremlins in there somewhere I have old Snom 370’s and a Sangoma S500. The S500 doesn’t show anything either. The system has been running well and serving purpose for a good number of years. CallerID module under Admin is 15.0.27 if thats any help?
Thanks in advance
EDIT The upgrade was a few months ago and this problem has existed since.
Is it worth me removing the CallerID module and reinstalling it again? I’m trawling through google results and site searches here trying to find something similar.
I was thinking about removing the MySQL lookup entirely and seeing if incoming calls are then shown on the phones except I can’t remember the database password currently.
CDR Reports does show a number for all calls unless blocked.
Ok, so I’ve removed the callerID lookup to the mysql database and I’m now getting phone numbers showing for incoming calls. Was there a change in how mysql is used between versions 13 and 15? Nothing has changed other than the system upgrade module was used. the database is extremely basic (2 fields - name and number).
The lookup code in FreePBX was:
SELECT name FROM callerid WHERE number LIKE ‘[NUMBER]’
There was a change in this module. The asterisk mysql dialplan applications were deprecated, so the module move to an AGI script to do the lookup. It should work identically. Also the lookup module should have zero effect on cid number, only name.
The query looks off, do you have back tics around the number? They shoukd be quotes.
I had a very similar issue that was fixed, then there was either a regression in future updates or breaking changes. I’ve been NOT upgrading the callerID past version 15.0.25, since every version since that one has had issues for us. Here is a link to that original forum dialogs for the issues we were having.
FreePBX 15 is EOL. There where two versions released after 15.0.25 of this module and it hasn’t been updated in over a year after 15.0.27 was released. If you’re going to want future support for anything on this system you will need to update to a newer version.
Upgrading to FreePBX17 is much easier said than done for us. We have over 400+ digium phone enpoints across 39 locations and 5 different states. We are still running on the digium phones module, which is completely gone now in FreePBX17, so having to migrated to EPM, which requires manually factory resetting and reconfiguring every phone. Still have no idea how we are going to migrate yet. I have an unanswered forum post about running a FreePBX15 and FreePBX17 servers tied together to migrated the phones one by one, but that approach has so many other questions and concerns, not sure how we’d do that either.
Thanks for your reply, I’m not sure what AGI script is unfortunately, something for me to read up on when I have 5 minutes My background is hardware / software support rather than databases and coding so my bad! I run my business now in a completely unrelated field so things have no doubt progressed much further than my knowledge covers. I apologise for the following (probably simple) questions.
When you say it should have zero effect on CID number, only name, what do you mean?
As to the query looking off, I followed a guide on a website quite a number of years ago and the ticks i.e. ‘[NUMBER]’ where what worked at the time and it has worked flawlessly for a good number of years until I upgraded through 14 to 15. I’ll try reconfiguring using quotes at some point this week. I’m currently looking for my original documentation.
Once again, thanks for the reply and the insights.
Thanks for your reply. I did have a read through your linked issue when I noticed no numbers or names showing on the handsets. I think you said you were getting “unknown” through, I was getting a blank screen. I decided your database was more complicated than mine and I was also on a higher version than you had been at the time. Reading through your issue ticket, I noticed it had been “fixed” from a version below the version I was running and therefore I came to the conclusion that it must be something else in my case. Maybe I’ll try downgrading to 15.0.25 and testing again. Unfortunately I have remote handsets too so a simple “test” call has my dad answering / calling back! I’ll need to remember to remove them from the ring group first.
Thanks for replying, in my use case, I’ve been quite wary of breaking something that simply works. In my case, the system is not internet exposed, and remote handsets connect through a VPN provided at each address by an additional router, at present anyway. I wouldn’t mind sorting access on our company mobiles at some point however as a micro business, I wish to take the time to read and understand how best to do it before I risk the security of my servers. It took me quite a while to decide to upgrade to 15 and having read about FreePBX 17 no longer being a custom distro (I used the CentOS image download originally) I need to make sure I have the time to do the build. I guess a new seperate server may be the way to go and test at each stage.
Is there an idiot proof installation guide for 17? Not that I’m particularly an idiot, I’m just responsible for a lot of things within the business and my knowledge is patchy as a result.
I have old Snom 370’s and a Sangoma S500. The S500 doesn’t show anything either. The system has been running well and serving purpose for a good number of years. CallerID module under Admin is 15.0.27 if thats any help?
My background is hardware / software support rather than databases and coding so my bad! I run my business now in a completely unrelated field so things have no doubt progressed much further than my knowledge covers. I apologise for the following (probably simple) questions.