FreePBX 15+ inbound route’s CallerID number length

leosoft[Leo Piagkos|https://community.freepbx.org/u/leosoft]
2
3d
 
Hello all,

Recently I decided to go to FreePBX 15 and Asterisk 16 and I found a very disturbing bug. As everyone knows here, in the Inbound routes there is a “CallerID Number” field you use to specify the incoming call CID with a pattern.

What I noticed (…unfortunately) in version 15 is that in this field you can write any pattern you want but when you save the route, your saved pattern is limited to 21 characters only!!! Witch is very short in many cases. Even if you manually check the /etc/asterisk/extensions_additional.conf the pattern string stored there cannot be longer than 21 characters.

In previous version 14 there was not this limitation. Does anyone knows if this is a known bug or there is somewhere a parameter that can extend this limit? (…i dont think so but lets hope)

Thanks for your time

-------------------------------------------------------------------------------
lgaetz[Lorne Gaetz|https://community.freepbx.org/u/lgaetz]FreePBX Project Lead
2d
 
The limitation is in SQL. I’m surprised to learn this changed between versions 14 and 15, but will accept the claim without verifying. From the maria prompt:
 MariaDB [asterisk]> describe incoming;-----------------------------------------------| Field | Type | Null | Key | Default | Extra |-----------------------------------------------| cidnum | varchar(20) | YES | | NULL | || extension | varchar(50) | NO | | NULL | |snip
You can manually alter the type to accpet 50 chars with the following:
 {{MariaDB [asterisk]> ALTER TABLE incoming MODIFY COLUMN cidnum varchar(50) NULL;
Query OK, 1 row affected (0.02 sec)
Records: 1 Duplicates: 0 Warnings: 0MariaDB [asterisk]> describe incoming;-----------------------------------------------| Field | Type | Null | Key | Default | Extra |-----------------------------------------------| cidnum | varchar(50) | YES | | NULL | || extension | varchar(50) | NO | | NULL | |snip}}
This is a work around, a feature request (or ideally a pull request) is the way to get it fixed for everyone. https://issues.freepbx.org/