CIDlookup problem results in unknow numbers

[pieterv (Pieter)]

Hi

Since a few days suddenly we are getting both on phone display as at CDR a label “Unknow” instead of the caller numer. We have a CIDLookup in inbound routes that sets caller id name from a mysql DB if it’s found. Numbers not found instead of keeping the number in the name field are translated to “Unknow”. I copy the console dump. If I disable lookup the number is keep in the name (but I don’t have the lookup for know numbers )

CIDLookup 15.0.27 (downgraded to 15.0.23 with same results)
FreePBX 15.0.37
Asterisk 16.30.0

    -- Executing [[email protected]:1] AGI("PJSIP/trunkid-00000076", "agi://127.0.0.1/cidlookup_mysql.agi,192.168.10.246,,username,password,tablename,,select CALLER_DESCRIPTION as nom from cc_caller where caller_id = '12341234'") in new stack
    -- <PJSIP/trunkid-00000076>AGI Script agi://127.0.0.1/cidlookup_mysql.agi completed, returning 0
    -- Executing [[email protected]:2] Return("PJSIP/trunkid-00000076", "") in new stack
    -- Executing [[email protected]:22] NoOp("PJSIP/trunkid-00000076", "CallerID Entry Point") in new stack
    -- Executing [[email protected]:23] Goto("PJSIP/trunkid-00000076", "ext-group,6264,1") in new stack
    -- Goto (ext-group,6264,1)
    -- Executing [[email protected]:1] GotoIf("PJSIP/trunkid-00000076", "0?cid") in new stack
    -- Executing [[email protected]:2] PlayTones("PJSIP/trunkid-00000076", "ring") in new stack
    -- Executing [[email protected]:3] Progress("PJSIP/trunkid-00000076", "") in new stack
    -- Executing [[email protected]:4] Macro("PJSIP/trunkid-00000076", "user-callerid,") in new stack
    -- Executing [[email protected]:1] Set("PJSIP/trunkid-00000076", "TOUCH_MONITOR=1680182426.238") in new stack
    -- Executing [[email protected]:2] Set("PJSIP/trunkid-00000076", "CHANCONTEXT=") in new stack
    -- Executing [[email protected]:3] Set("PJSIP/trunkid-00000076", "CHANCONTEXT=") in new stack
    -- Executing [[email protected]:4] Set("PJSIP/trunkid-00000076", "CHANEXTENCONTEXT=trunkid-00000076") in new stack
    -- Executing [[email protected]:5] Set("PJSIP/trunkid-00000076", "CHANEXTEN=trunkid-00000076") in new stack
    -- Executing [[email protected]:6] Set("PJSIP/trunkid-00000076", "CALLERID(number)=12341234") in new stack
    -- Executing [[email protected]:7] Set("PJSIP/trunkid-00000076", "AMPUSER=12341234") in new stack
    -- Executing [[email protected]:8] Set("PJSIP/trunkid-00000076", "HOTDESCKCHAN=trunkid-00000076") in new stack
    -- Executing [[email protected]:9] Set("PJSIP/trunkid-00000076", "HOTDESKEXTEN=trunkid") in new stack
    -- Executing [[email protected]:10] Set("PJSIP/trunkid-00000076", "HOTDESKCALL=0") in new stack
    -- Executing [[email protected]:11] ExecIf("PJSIP/trunkid-00000076", "0?Set(HOTDESKCALL=1)") in new stack
    -- Executing [[email protected]:12] ExecIf("PJSIP/trunkid-00000076", "0?Set(CALLERID(name)=)") in new stack
    -- Executing [[email protected]:13] GotoIf("PJSIP/trunkid-00000076", "0?report") in new stack
    -- Executing [[email protected]:14] ExecIf("PJSIP/trunkid-00000076", "1?Set(REALCALLERIDNUM=12341234)") in new stack
    -- Executing [[email protected]:15] Set("PJSIP/trunkid-00000076", "AMPUSER=") in new stack
    -- Executing [[email protected]:16] GotoIf("PJSIP/trunkid-00000076", "0?limit") in new stack
    -- Executing [[email protected]:17] Set("PJSIP/trunkid-00000076", "AMPUSERCIDNAME=") in new stack
    -- Executing [[email protected]:18] ExecIf("PJSIP/trunkid-00000076", "0?Set(__CIDMASQUERADING=TRUE)") in new stack
    -- Executing [[email protected]:19] GotoIf("PJSIP/trunkid-00000076", "1?report") in new stack
    -- Goto (macro-user-callerid,s,28)
    -- Executing [[email protected]:28] NoOp("PJSIP/trunkid-00000076", "Macro Depth is 1") in new stack
    -- Executing [[email protected]:29] GotoIf("PJSIP/trunkid-00000076", "1?report2:macroerror") in new stack
    -- Goto (macro-user-callerid,s,30)
    -- Executing [[email protected]:30] GotoIf("PJSIP/trunkid-00000076", "0?continue") in new stack
    -- Executing [[email protected]:31] ExecIf("PJSIP/trunkid-00000076", "1?Set(__CALLEE_ACCOUNCODE=)") in new stack
    -- Executing [[email protected]:32] Set("PJSIP/trunkid-00000076", "__TTL=64") in new stack
    -- Executing [[email protected]:33] GotoIf("PJSIP/trunkid-00000076", "1?continue") in new stack
    -- Goto (macro-user-callerid,s,49)
    -- Executing [[email protected]:49] Set("PJSIP/trunkid-00000076", "CALLERID(number)=12341234") in new stack
    -- Executing [[email protected]:50] Set("PJSIP/trunkid-00000076", "CALLERID(name)=Unknown") in new stack
    -- Executing [[email protected]:51] GotoIf("PJSIP/trunkid-00000076", "0?cnum") in new stack
    -- Executing [[email protected]:52] Set("PJSIP/trunkid-00000076", "CDR(cnam)=Unknown") in new stack
    -- Executing [[email protected]:53] Set("PJSIP/trunkid-00000076", "CDR(cnum)=12341234") in new stack
    -- Executing [[email protected]:54] Set("PJSIP/trunkid-00000076", "CHANNEL(language)=es") in new stack

Many thanks for your help,

[david55]

@pieterv

cidlookup_mysql.agi

The value is set by the AGI script. As far as I can tell, that has always been the case, although the FreePBX GIT repository started asking me to login - I guess I exceeded a limit on free views - so my checks for that were incomplete.

What was supposed to be setting it the same as the caller ID? The SIP default would be to not have the field at all, rather than duplicate any part of the URI.

[david55]

Looking further, this has changed in release 17:

FREEPBX-23578 CallerID Lookup Module No Longer Passing Default Caller ID Through

That refers to a bug report that is discussed here:

CallerID Lookup Module Update Issue, No Longer Passing Default Caller ID Through

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 l…

and seems to say that some versions of 15 and 16 have also been updated.

What I think was always there before was starting with a default of “unknown”, but I suspect the exact way it reacted to not finding it in the database may have changed.

[pieterv (Pieter)]

Thanks David,

I checked log and seems last year on july during some days it was giving unknow and later the same month it was self-fixed (autoupdate). It has been working ok until 27 march, when it broke again.

I downgraded to 15.0.20 and it works again, but upgrading to any other version reverses and we get the “Unknow”, which is displayed on the phone bigger than the number.

Thanks

[david55]

The code is actually setting it to “Unknown”, and that is what your log shows. If you are getting less, the phone is probably garbling it.

The claim is that it should be fixed from 15.0.25 and 16.0.12.

It is in those spot releases, but code to set the name back to “Unknown” is back in subsequent releases. The original bug fixL

https://issues.freepbx.org/browse/FREEPBX-23578

seems to have caused a regression elsewhere:

https://issues.freepbx.org/browse/FREEPBX-23954

I don’t know if too much has been reverted, or whether there is a deeper problem. All I can say with a quick look is that the first change made it impossible to set the name to Unknown, and the second one made it possible again. I’m not sure if the circumstances where this can happen are the same as before the first change.

I think you need to raise an issue pointing out that 23954 has caused a regression of 23578.

[pieterv (Pieter)]

Thanks david55 , sorry for the late reply, now I see that I forgot to answer. I already opened a issue, and meanwhile edited cidlookup_mysql.agi to bypass the Unknow callerid issue.

[jdennis]

I just updated all of our FreePBX modules over the weekend. We started running into the “UNKNOWN” caller ID issue today. I just rolled back the callerID module to 15.0.25 and it seems to be working again now.

I was the one that originally reported [FREEPBX-23578] CallerID Lookup Module No Longer Passing Default Caller ID Through - Sangoma Issue Tracker