Caller ID Source not populating to phone

Hello.

I’m trying to look up to mySQL db based on the following sql statement:

SELECT concat( ID_usr, ‘:’, Lname, ', ', fname ) AS name FROM web_users WHERE usr_phone_cell = ‘[number]’ LIMIT 1

I’ve tried without the ’ around [number] - no result.

I have 9480i phones all upgraded to the latest firmware.
running latest version of freepbx.

This has never worked.

I have the data source set up in CallerID data source “ECCDB” and i have the caller ID source set in the inbound routes : “ECCDB” (without quotes)

my log, below, seems like it finds a number, but it doesn’t display the name as desired in the SQL statement above, on the display of the 9480i. i.e. “WIRELESS CALLER” with the PHone number underneath it it what is still displayed.

I’ve googled for a help on this and nothing seems to help my situation.

I’m very new to FreePBX/Linux, etc… therefore it is likely that i’ll need slight step-by-step direction in your reply (i.e. if you need more logs, etc…).

Hope someone can help…

Thanks for reading.

Lee

below is my log… (IP, PhoneNumber, Username, Pwd all changed for security during this post).

[2012-06-27 22:27:47] VERBOSE[-1] sig_analog.c: – Starting simple switch on ‘DAHDI/1-1’
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] ExecIf(“DAHDI/1-1”, “1?Set(__FROM_DID=s)”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] Gosub(“DAHDI/1-1”, “cidlookup,cidlookup_1,1()”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] MYSQL(“DAHDI/1-1”, “Connect connid 999.999.999.999 myuname mypwd wtsql”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] MYSQL(“DAHDI/1-1”, “Query resultid 1 SELECT concat( ID_usr, ‘:’, Lname, ', ', fname ) AS name FROM web_users WHERE usr_phone_cell = ‘[number]’ LIMIT 1”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:3] MYSQL(“DAHDI/1-1”, “Fetch fetchid 2 CALLERID(name)”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:4] MYSQL(“DAHDI/1-1”, “Clear 2”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:5] MYSQL(“DAHDI/1-1”, “Disconnect 1”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:6] Return(“DAHDI/1-1”, “”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:3] Gosub(“DAHDI/1-1”, “app-blacklist-check,s,1()”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] GotoIf(“DAHDI/1-1”, “0?blacklisted”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] Set(“DAHDI/1-1”, “CALLED_BLACKLIST=1”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:3] Return(“DAHDI/1-1”, “”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:4] Set(“DAHDI/1-1”, “CDR(did)=s”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:5] ExecIf(“DAHDI/1-1”, “0 ?Set(CALLERID(name)=19999999999)”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:6] Set(“DAHDI/1-1”, “__CALLINGPRES_SV=allowed_not_screened”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:7] Set(“DAHDI/1-1”, “CALLERPRES()=allowed_not_screened”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:8] Set(“DAHDI/1-1”, “FAX_DEST=ext-group^601^1”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:9] Answer(“DAHDI/1-1”, “”) in new stack
[2012-06-27 22:27:49] VERBOSE[-1] pbx.c: – Executing [[email protected]:10] Wait(“DAHDI/1-1”, “4”) in new stack
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Executing [[email protected]:11] Goto(“DAHDI/1-1”, “timeconditions,1,1”) in new stack
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Goto (timeconditions,1,1)
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] GotoIfTime(“DAHDI/1-1”, “09:00-15:00,mon-fri,,?truestate”) in new stack
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] GotoIf(“DAHDI/1-1”, “0?truegoto”) in new stack
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Executing [[email protected]:3] ExecIf(“DAHDI/1-1”, “0?Set(DB(TC/1)=)”) in new stack
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Executing [[email protected]:4] GotoIf(“DAHDI/1-1”, “1?ivr-4,s,1”) in new stack
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Goto (ivr-4,s,1)
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] Set(“DAHDI/1-1”, “TIMEOUT_LOOPCOUNT=0”) in new stack
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] Set(“DAHDI/1-1”, “INVALID_LOOPCOUNT=0”) in new stack
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Executing [[email protected]:3] Set(“DAHDI/1-1”, “_IVR_CONTEXT_ivr-4=”) in new stack
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Executing [[email protected]:4] Set(“DAHDI/1-1”, “_IVR_CONTEXT=ivr-4”) in new stack
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Executing [[email protected]:5] Set(“DAHDI/1-1”, “__IVR_RETVM=”) in new stack
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Executing [[email protected]:6] GotoIf(“DAHDI/1-1”, “1?skip”) in new stack
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Goto (ivr-4,s,9)
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Executing [[email protected]:9] Set(“DAHDI/1-1”, “IVR_MSG=custom/biz_closed”) in new stack
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Executing [[email protected]:10] Set(“DAHDI/1-1”, “TIMEOUT(digit)=3”) in new stack
[2012-06-27 22:27:53] VERBOSE[-1] func_timeout.c: – Digit timeout set to 3.000
[2012-06-27 22:27:53] VERBOSE[-1] pbx.c: – Executing [[email protected]:11] ExecIf(“DAHDI/1-1”, “1?Background(custom/biz_closed)”) in new stack
[2012-06-27 22:27:53] VERBOSE[-1] file.c: – <DAHDI/1-1> Playing ‘custom/biz_closed.slin’ (language ‘en’)
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: == CDR updated on DAHDI/1-1
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] Macro(“DAHDI/1-1”, “blkvm-clr,”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] Set(“DAHDI/1-1”, “SHARED(BLKVM,)=”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] Set(“DAHDI/1-1”, “GOSUB_RETVAL=”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:3] MacroExit(“DAHDI/1-1”, “”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] Set(“DAHDI/1-1”, “__NODEST=”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:3] Goto(“DAHDI/1-1”, “from-did-direct,211,1”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Goto (from-did-direct,211,1)
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] Set(“DAHDI/1-1”, “__RINGTIMER=15”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] Macro(“DAHDI/1-1”, “exten-vm,211,211,0,0,0”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] Macro(“DAHDI/1-1”, “user-callerid,”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] Set(“DAHDI/1-1”, “AMPUSER=19999999999”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] GotoIf(“DAHDI/1-1”, “0?report”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:3] ExecIf(“DAHDI/1-1”, “1?Set(REALCALLERIDNUM=19999999999)”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:4] Set(“DAHDI/1-1”, “AMPUSER=”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:5] Set(“DAHDI/1-1”, “AMPUSERCIDNAME=”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:6] GotoIf(“DAHDI/1-1”, “1?report”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Goto (macro-user-callerid,s,13)
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:13] GotoIf(“DAHDI/1-1”, “0?continue”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:14] Set(“DAHDI/1-1”, “__TTL=64”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:15] GotoIf(“DAHDI/1-1”, “1?continue”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Goto (macro-user-callerid,s,26)
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:26] Set(“DAHDI/1-1”, “CALLERID(number)=19999999999”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:27] Set(“DAHDI/1-1”, “CALLERID(name)=WIRELESS CALLER”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:28] Set(“DAHDI/1-1”, “CHANNEL(language)=en”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] Set(“DAHDI/1-1”, “RingGroupMethod=none”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:3] Set(“DAHDI/1-1”, “__EXTTOCALL=211”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:4] Set(“DAHDI/1-1”, “__PICKUPMARK=211”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:5] Set(“DAHDI/1-1”, “RT=15”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:6] Gosub(“DAHDI/1-1”, “sub-record-check,s,1(exten,211,)”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] GotoIf(“DAHDI/1-1”, “1?check”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Goto (sub-record-check,s,6)
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:6] Set(“DAHDI/1-1”, “__MON_FMT=wav”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:7] GotoIf(“DAHDI/1-1”, “1?next”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Goto (sub-record-check,s,10)
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:10] ExecIf(“DAHDI/1-1”, “0?Return()”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:11] GotoIf(“DAHDI/1-1”, “0?exten,1”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:12] Set(“DAHDI/1-1”, “__REC_STATUS=INITIALIZED”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:13] ExecIf(“DAHDI/1-1”, “0?Set(__REC_POLICY_MODE=)”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:14] Set(“DAHDI/1-1”, “NOW=1340850476”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:15] Set(“DAHDI/1-1”, “__DAY=27”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:16] Set(“DAHDI/1-1”, “__MONTH=06”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:17] Set(“DAHDI/1-1”, “__YEAR=2012”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:18] Set(“DAHDI/1-1”, “__TIMESTR=20120627-222756”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:19] Set(“DAHDI/1-1”, “__FROMEXTEN=19999999999”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:20] Set(“DAHDI/1-1”, “__CALLFILENAME=exten-211-19999999999-20120627-222756-1340850467.32”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:21] Goto(“DAHDI/1-1”, “exten,1”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Goto (sub-record-check,exten,1)
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] GotoIf(“DAHDI/1-1”, “0?callee”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] Set(“DAHDI/1-1”, “__REC_POLICY_MODE=always”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:3] GotoIf(“DAHDI/1-1”, “0?caller”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:4] GotoIf(“DAHDI/1-1”, “1?callee”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Goto (sub-record-check,exten,8)
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:8] GosubIf(“DAHDI/1-1”, “1?record,1(exten,211,19999999999)”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] Set(“DAHDI/1-1”, “AUDIOHOOK_INHERIT(MixMonitor)=yes”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] MixMonitor(“DAHDI/1-1”, “2012/06/27/exten-211-19999999999-20120627-222756-1340850467.32.wav,”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:3] Set(“DAHDI/1-1”, “__REC_STATUS=RECORDING”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:4] Set(“DAHDI/1-1”, “CDR(recordingfile)=exten-211-19999999999-20120627-222756-1340850467.32.wav”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:5] Return(“DAHDI/1-1”, “”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:9] Return(“DAHDI/1-1”, “”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:7] GotoIf(“DAHDI/1-1”, “1?macrodial”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Goto (macro-exten-vm,s,13)
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:13] GosubIf(“DAHDI/1-1”, “0?clrheader,1()”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:14] Macro(“DAHDI/1-1”, “dial-one,15,tr,211”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] Set(“DAHDI/1-1”, “DEXTEN=211”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] Set(“DAHDI/1-1”, “DIALSTATUS_CW=”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:3] GosubIf(“DAHDI/1-1”, “0?screen,1()”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:4] GosubIf(“DAHDI/1-1”, “0?cf,1()”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:5] GotoIf(“DAHDI/1-1”, “1?skip1”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Goto (macro-dial-one,s,8)
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:8] GotoIf(“DAHDI/1-1”, “0?nodial”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:9] GotoIf(“DAHDI/1-1”, “0?continue”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:10] Set(“DAHDI/1-1”, “EXTHASCW=ENABLED”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:11] GotoIf(“DAHDI/1-1”, “0?next1:cwinusebusy”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Goto (macro-dial-one,s,23)
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:23] GotoIf(“DAHDI/1-1”, “1?next3:continue”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Goto (macro-dial-one,s,24)
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:24] ExecIf(“DAHDI/1-1”, “0?Set(DIALSTATUS_CW=BUSY)”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:25] GotoIf(“DAHDI/1-1”, “0?nodial”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:26] GosubIf(“DAHDI/1-1”, “1?dstring,1():dlocal,1()”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] Set(“DAHDI/1-1”, “DSTRING=”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] Set(“DAHDI/1-1”, “DEVICES=211”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:3] ExecIf(“DAHDI/1-1”, “0?Return()”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:4] ExecIf(“DAHDI/1-1”, “0?Set(DEVICES=11)”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:5] Set(“DAHDI/1-1”, “LOOPCNT=1”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:6] Set(“DAHDI/1-1”, “ITER=1”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:7] Set(“DAHDI/1-1”, “THISDIAL=SIP/211”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:8] GosubIf(“DAHDI/1-1”, “1?zap2dahdi,1()”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] ExecIf(“DAHDI/1-1”, “0?Return()”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] Set(“DAHDI/1-1”, “NEWDIAL=”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:3] Set(“DAHDI/1-1”, “LOOPCNT2=1”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:4] Set(“DAHDI/1-1”, “ITER2=1”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:5] Set(“DAHDI/1-1”, “THISPART2=SIP/211”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:6] ExecIf(“DAHDI/1-1”, “0?Set(THISPART2=DAHDI/211)”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:7] Set(“DAHDI/1-1”, “NEWDIAL=SIP/211&”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:8] Set(“DAHDI/1-1”, “ITER2=2”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:9] GotoIf(“DAHDI/1-1”, “0?begin2”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:10] Set(“DAHDI/1-1”, “THISDIAL=SIP/211”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:11] Return(“DAHDI/1-1”, “”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:9] Set(“DAHDI/1-1”, “DSTRING=SIP/211&”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:10] Set(“DAHDI/1-1”, “ITER=2”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:11] GotoIf(“DAHDI/1-1”, “0?begin”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:12] Set(“DAHDI/1-1”, “DSTRING=SIP/211”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:13] Return(“DAHDI/1-1”, “”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:27] GotoIf(“DAHDI/1-1”, “0?nodial”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:28] GotoIf(“DAHDI/1-1”, “0?skiptrace”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:29] GosubIf(“DAHDI/1-1”, “1?ctset,1():ctclear,1()”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] Set(“DAHDI/1-1”, “DB(CALLTRACE/211)=19999999999”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:2] Return(“DAHDI/1-1”, “”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:30] Set(“DAHDI/1-1”, “D_OPTIONS=tr”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:31] ExecIf(“DAHDI/1-1”, “0?SIPAddHeader(Alert-Info: )”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:32] ExecIf(“DAHDI/1-1”, “0?SIPAddHeader()”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] app_mixmonitor.c: == Begin MixMonitor Recording DAHDI/1-1
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:33] ExecIf(“DAHDI/1-1”, “0?Set(CHANNEL(musicclass)=)”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:34] GosubIf(“DAHDI/1-1”, “0?qwait,1()”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:35] Set(“DAHDI/1-1”, “__CWIGNORE=”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:36] Set(“DAHDI/1-1”, “__KEEPCID=TRUE”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:37] GotoIf(“DAHDI/1-1”, “0?usegoto,1”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:38] GotoIf(“DAHDI/1-1”, “1?godial”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Goto (macro-dial-one,s,42)
[2012-06-27 22:27:56] VERBOSE[-1] pbx.c: – Executing [[email protected]:42] Dial(“DAHDI/1-1”, “SIP/211,15,tr”) in new stack
[2012-06-27 22:27:56] VERBOSE[-1] netsock2.c: == Using SIP RTP TOS bits 184
[2012-06-27 22:27:56] VERBOSE[-1] netsock2.c: == Using SIP RTP CoS mark 5
[2012-06-27 22:27:56] VERBOSE[-1] app_dial.c: – Called SIP/211
[2012-06-27 22:27:56] VERBOSE[-1] app_dial.c: – SIP/211-00000010 is ringing
[2012-06-27 22:28:01] VERBOSE[-1] app_macro.c: == Spawn extension (macro-dial-one, s, 42) exited non-zero on ‘DAHDI/1-1’ in macro ‘dial-one’
[2012-06-27 22:28:01] VERBOSE[-1] app_macro.c: == Spawn extension (macro-exten-vm, s, 14) exited non-zero on ‘DAHDI/1-1’ in macro ‘exten-vm’
[2012-06-27 22:28:01] VERBOSE[-1] pbx.c: == Spawn extension (from-did-direct, 211, 2) exited non-zero on ‘DAHDI/1-1’
[2012-06-27 22:28:01] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] Macro(“DAHDI/1-1”, “hangupcall,”) in new stack
[2012-06-27 22:28:01] VERBOSE[-1] pbx.c: – Executing [[email protected]:1] GotoIf(“DAHDI/1-1”, “1?theend”) in new stack
[2012-06-27 22:28:01] VERBOSE[-1] pbx.c: – Goto (macro-hangupcall,s,3)
[2012-06-27 22:28:01] VERBOSE[-1] pbx.c: – Executing [[email protected]:3] ExecIf(“DAHDI/1-1”, “0?Set(CDR(recordingfile)=)”) in new stack
[2012-06-27 22:28:01] VERBOSE[-1] pbx.c: – Executing [[email protected]:4] Hangup(“DAHDI/1-1”, “”) in new stack
[2012-06-27 22:28:01] VERBOSE[-1] app_macro.c: == Spawn extension (macro-hangupcall, s, 4) exited non-zero on ‘DAHDI/1-1’ in macro ‘hangupcall’
[2012-06-27 22:28:01] VERBOSE[-1] pbx.c: == Spawn extension (from-did-direct, h, 1) exited non-zero on ‘DAHDI/1-1’
[2012-06-27 22:28:01] VERBOSE[-1] sig_analog.c: – Hanging up on ‘DAHDI/1-1’
[2012-06-27 22:28:01] VERBOSE[-1] chan_dahdi.c: – Hungup ‘DAHDI/1-1’
[2012-06-27 22:28:01] VERBOSE[-1] app_mixmonitor.c: == MixMonitor close filestream
[2012-06-27 22:28:01] VERBOSE[-1] app_mixmonitor.c: == End MixMonitor Recording DAHDI/1-1

thanks a ton… it worked! i had not clue that it would’ve been case related… again thanks!

Try the MySQL query with [NUMBER], i.e. all upper case letters.

As a dev on the CallerID Superfecta project, I am always on the lookout for a working query to a CNAM source. What database does the MySQL query above work with?

I actually tried obtaining the “superfecta” package, but the link was broken, so i tried with the built in freepbx.
the db that the mysql works with is my companies clients. it works great in the sense of knowing what ‘account number’ someone is calling from, along with their name and phone number.

my staff are already talking this up a storm that now they can locate a clients account as they answer the call.

I have tried to setup a MYSQL lookup source on my FreePBX 2.9 asterisk 1.8 with a Sangoma A200 card.

When the query in the FreePBX GUI is set to:
SELECT lname FROM patient_data WHERE phone_cell LIKE ‘%[NUMBER]%’

I get the first clients name as the callerID from the first match with ‘’. That is to say, I get the result of the first client with a blank entry in the phone_cell field.

When I issue the same in command line as a MYSQL query

mysql> SELECT lname FROM patient_data WHERE phone_cell LIKE ‘%1235551212%’;

I get the correct result. As apposed to the client with the empty phone_cell fieild.

±------+
| lname |
±------+
| Test |
±------+
1 row in set (0.10 sec)

As you can see from the logs, the callerid number is not being passed onto the query.
How do I correct this. thanks
Any insight is greatly appreciated.

==============================================================================
– Starting simple switch on ‘DAHDI/3-1’
– Executing [[email protected]:1] NoOp(“DAHDI/3-1”, "Entering from-dahdi with DID == ") in new stack
– Executing [[email protected]:2] Ringing(“DAHDI/3-1”, “”) in new stack
– Executing [[email protected]:3] Set(“DAHDI/3-1”, “DID=s”) in new stack
– Executing [[email protected]:4] NoOp(“DAHDI/3-1”, “DID is now s”) in new stack
– Executing [[email protected]:5] GotoIf(“DAHDI/3-1”, “1?dahdiok:checkzap”) in new stack
– Goto (from-zaptel,s,9)
– Executing [[email protected]:9] NoOp(“DAHDI/3-1”, “Is a DAHDi Channel”) in new stack
– Executing [[email protected]:10] Set(“DAHDI/3-1”, “CHAN=3-1”) in new stack
– Executing [[email protected]:11] Set(“DAHDI/3-1”, “CHAN=3”) in new stack
– Executing [[email protected]:12] Macro(“DAHDI/3-1”, “from-dahdi-3,s,1”) in new stack
– Executing [[email protected]:1] NoOp(“DAHDI/3-1”, “Entering macro-from-dahdi-3 with DID = s and setting to: 2295551212”) in new stack
– Executing [[email protected]:2] Set(“DAHDI/3-1”, “__FROM_DID=2295551212”) in new stack
– Executing [[email protected]:3] Goto(“DAHDI/3-1”, “from-trunk,2295551212,1”) in new stack
– Goto (from-trunk,2295551212,1)
== Channel ‘DAHDI/3-1’ jumping out of macro ‘from-dahdi-3’
– Executing [[email protected]:1] NoOp(“DAHDI/3-1”, “Catch-All DID Match - Found 2295551212 - You probably want a DID for this.”) in new stack
– Executing [[email protected]:2] Goto(“DAHDI/3-1”, “ext-did,s,1”) in new stack
– Goto (ext-did,s,1)
– Executing [[email protected]:1] ExecIf(“DAHDI/3-1”, “0?Set(__FROM_DID=s)”) in new stack
– Executing [[email protected]:2] Gosub(“DAHDI/3-1”, “app-blacklist-check,s,1”) in new stack
– Executing [[email protected]:1] GotoIf(“DAHDI/3-1”, “0?blacklisted”) in new stack
– Executing [[email protected]:2] Set(“DAHDI/3-1”, “CALLED_BLACKLIST=1”) in new stack
– Executing [[email protected]:3] Return(“DAHDI/3-1”, “”) in new stack
– Executing [[email protected]:3] Gosub(“DAHDI/3-1”, “cidlookup,cidlookup_4,1”) in new stack
– Executing [[email protected]:1] MYSQL(“DAHDI/3-1”, “Connect connid 193.168.1.1 emrdb user pass”) in new stack
– Executing [[email protected]:2] MYSQL(“DAHDI/3-1”, “Query resultid 1 SELECT lname FROM patient_data WHERE phone_cell LIKE ‘%%’”) in new stack
– Executing [[email protected]:3] MYSQL(“DAHDI/3-1”, “Fetch fetchid 2 CALLERID(name)”) in new stack
– Executing [[email protected]:4] MYSQL(“DAHDI/3-1”, “Clear 2”) in new stack
– Executing [[email protected]:5] MYSQL(“DAHDI/3-1”, “Disconnect 1”) in new stack
– Executing [[email protected]:6] Return(“DAHDI/3-1”, “”) in new stack
– Executing [[email protected]:4] ExecIf(“DAHDI/3-1”, “0 ?Set(CALLERID(name)=)”) in new stack
– Executing [[email protected]:5] Set(“DAHDI/3-1”, “__CALLINGPRES_SV=allowed_not_screened”) in new stack
– Executing [[email protected]:6] Set(“DAHDI/3-1”, “CALLERPRES()=allowed_not_screened”) in new stack
– Executing [[email protected]:7] Goto(“DAHDI/3-1”, “from-did-direct,777,1”) in new stack
– Goto (from-did-direct,777,1)
– Executing [[email protected]:1] ExecIf(“DAHDI/3-1”, “0?Set(__RINGTIMER=0)”) in new stack
– Executing [[email protected]m-did-direct:2] Macro(“DAHDI/3-1”, “exten-vm,novm,777,0,0,0”) in new stack
– Executing [[email protected]:1] Macro(“DAHDI/3-1”, “user-callerid,”) in new stack
– Executing [[email protected]:1] Set(“DAHDI/3-1”, “AMPUSER=”) in new stack
– Executing [[email protected]:2] GotoIf(“DAHDI/3-1”, “0?report”) in new stack
– Executing [[email protected]:3] ExecIf(“DAHDI/3-1”, “1?Set(REALCALLERIDNUM=)”) in new stack
– Executing [[email protected]:4] Set(“DAHDI/3-1”, “AMPUSER=”) in new stack
– Executing [[email protected]:5] Set(“DAHDI/3-1”, “AMPUSERCIDNAME=”) in new stack
– Executing [[email protected]:6] GotoIf(“DAHDI/3-1”, “1?report”) in new stack
– Goto (macro-user-callerid,s,13)
– Executing [[email protected]:13] GotoIf(“DAHDI/3-1”, “0?continue”) in new stack
– Executing [[email protected]:14] Set(“DAHDI/3-1”, “__TTL=64”) in new stack
– Executing [[email protected]:15] GotoIf(“DAHDI/3-1”, “1?continue”) in new stack
– Goto (macro-user-callerid,s,26)
– Executing [[email protected]:26] Set(“DAHDI/3-1”, “CALLERID(number)=”) in new stack
– Executing [[email protected]:27] Set(“DAHDI/3-1”, “CALLERID(name)=SMITH”) in new stack
– Executing [[email protected]:28] Set(“DAHDI/3-1”, “CHANNEL(language)=en”) in new stack
– Executing [[email protected]:2] Set(“DAHDI/3-1”, “RingGroupMethod=none”) in new stack
– Executing [[email protected]:3] Set(“DAHDI/3-1”, “__EXTTOCALL=777”) in new stack
– Executing [[email protected]:4] Set(“DAHDI/3-1”, “__PICKUPMARK=777”) in new stack
– Executing [[email protected]:5] Set(“DAHDI/3-1”, “RT=”) in new stack
– Executing [[email protected]:6] Macro(“DAHDI/3-1”, “record-enable,777,IN”) in new stack
– Executing [[email protected]:1] GotoIf(“DAHDI/3-1”, “1?check”) in new stack
– Goto (macro-record-enable,s,4)
– Executing [[email protected]:4] ExecIf(“DAHDI/3-1”, “0?MacroExit()”) in new stack
– Executing [[email protected]:5] GotoIf(“DAHDI/3-1”, “0?Group:OUT”) in new stack
– Goto (macro-record-enable,s,14)
– Executing [[email protected]:14] GotoIf(“DAHDI/3-1”, “1?IN”) in new stack
– Goto (macro-record-enable,s,18)
– Executing [[email protected]:18] ExecIf(“DAHDI/3-1”, “1?MacroExit()”) in new stack
– Executing [[email protected]:7] GotoIf(“DAHDI/3-1”, “1?macrodial”) in new stack
– Goto (macro-exten-vm,s,13)
– Executing [[email protected]:13] GosubIf(“DAHDI/3-1”, “0?clrheader,1”) in new stack
– Executing [[email protected]:14] Macro(“DAHDI/3-1”, “dial-one,tr,777”) in new stack
– Executing [[email protected]:1] Set(“DAHDI/3-1”, “DEXTEN=777”) in new stack
– Executing [[email protected]:2] Set(“DAHDI/3-1”, “DIALSTATUS_CW=”) in new stack
– Executing [[email protected]:3] GosubIf(“DAHDI/3-1”, “0?screen,1”) in new stack
– Executing [[email protected]:4] GosubIf(“DAHDI/3-1”, “0?cf,1”) in new stack
– Executing [[email protected]:5] GotoIf(“DAHDI/3-1”, “1?skip1”) in new stack
– Goto (macro-dial-one,s,8)
– Executing [[email protected]:8] GotoIf(“DAHDI/3-1”, “0?nodial”) in new stack
– Executing [[email protected]:9] GotoIf(“DAHDI/3-1”, “0?continue”) in new stack
– Executing [[email protected]:10] Set(“DAHDI/3-1”, “EXTHASCW=ENABLED”) in new stack
– Executing [[email protected]:11] GotoIf(“DAHDI/3-1”, “0?next1:cwinusebusy”) in new stack
– Goto (macro-dial-one,s,23)
– Executing [[email protected]:23] GotoIf(“DAHDI/3-1”, “1?next3:continue”) in new stack
– Goto (macro-dial-one,s,24)
– Executing [[email protected]:24] ExecIf(“DAHDI/3-1”, “0?Set(DIALSTATUS_CW=BUSY)”) in new stack
– Executing [[email protected]:25] GotoIf(“DAHDI/3-1”, “0?nodial”) in new stack
– Executing [[email protected]:26] GosubIf(“DAHDI/3-1”, “1?dstring,1:dlocal,1”) in new stack
– Executing [[email protected]:1] Set(“DAHDI/3-1”, “DSTRING=”) in new stack
– Executing [[email protected]:2] Set(“DAHDI/3-1”, “DEVICES=777”) in new stack
– Executing [[email protected]:3] ExecIf(“DAHDI/3-1”, “0?Return()”) in new stack
– Executing [[email protected]:4] ExecIf(“DAHDI/3-1”, “0?Set(DEVICES=77)”) in new stack
– Executing [[email protected]:5] Set(“DAHDI/3-1”, “LOOPCNT=1”) in new stack
– Executing [[email protected]:6] Set(“DAHDI/3-1”, “ITER=1”) in new stack
– Executing [[email protected]:7] Set(“DAHDI/3-1”, “THISDIAL=SIP/777”) in new stack
– Executing [[email protected]:8] GosubIf(“DAHDI/3-1”, “1?zap2dahdi,1”) in new stack
– Executing [[email protected]:1] ExecIf(“DAHDI/3-1”, “0?Return()”) in new stack
– Executing [[email protected]:2] Set(“DAHDI/3-1”, “NEWDIAL=”) in new stack
– Executing [[email protected]:3] Set(“DAHDI/3-1”, “LOOPCNT2=1”) in new stack
– Executing [[email protected]:4] Set(“DAHDI/3-1”, “ITER2=1”) in new stack
– Executing [[email protected]:5] Set(“DAHDI/3-1”, “THISPART2=SIP/777”) in new stack
– Executing [[email protected]:6] ExecIf(“DAHDI/3-1”, “0?Set(THISPART2=DAHDI/777)”) in new stack
– Executing [[email protected]:7] Set(“DAHDI/3-1”, “NEWDIAL=SIP/777&”) in new stack
– Executing [[email protected]:8] Set(“DAHDI/3-1”, “ITER2=2”) in new stack
– Executing [[email protected]:9] GotoIf(“DAHDI/3-1”, “0?begin2”) in new stack
– Executing [[email protected]:10] Set(“DAHDI/3-1”, “THISDIAL=SIP/777”) in new stack
– Executing [[email protected]:11] Return(“DAHDI/3-1”, “”) in new stack
– Executing [[email protected]:9] Set(“DAHDI/3-1”, “DSTRING=SIP/777&”) in new stack
– Executing [[email protected]:10] Set(“DAHDI/3-1”, “ITER=2”) in new stack
– Executing [[email protected]:11] GotoIf(“DAHDI/3-1”, “0?begin”) in new stack
– Executing [[email protected]:12] Set(“DAHDI/3-1”, “DSTRING=SIP/777”) in new stack
– Executing [[email protected]:13] Return(“DAHDI/3-1”, “”) in new stack
– Executing [[email protected]:27] GotoIf(“DAHDI/3-1”, “0?nodial”) in new stack
– Executing [[email protected]:28] GotoIf(“DAHDI/3-1”, “0?skiptrace”) in new stack
– Executing [[email protected]:29] GosubIf(“DAHDI/3-1”, “0?ctset,1:ctclear,1”) in new stack
– Executing [[email protected]:1] NoOp(“DAHDI/3-1”, "Deleting: CALLTRACE/777 ") in new stack
– Executing [[email protected]:2] Return(“DAHDI/3-1”, “”) in new stack
– Executing [[email protected]:30] Set(“DAHDI/3-1”, “D_OPTIONS=tr”) in new stack
– Executing [[email protected]:31] ExecIf(“DAHDI/3-1”, “0?SIPAddHeader(Alert-Info: )”) in new stack
– Executing [[email protected]:32] ExecIf(“DAHDI/3-1”, “0?SIPAddHeader()”) in new stack
– Executing [[email protected]:33] ExecIf(“DAHDI/3-1”, “0?Set(CHANNEL(musicclass)=)”) in new stack
– Executing [[email protected]:34] GosubIf(“DAHDI/3-1”, “0?qwait,1”) in new stack
– Executing [[email protected]:35] Set(“DAHDI/3-1”, “__CWIGNORE=”) in new stack
– Executing [[email protected]:36] Set(“DAHDI/3-1”, “__KEEPCID=TRUE”) in new stack
– Executing [[email protected]:37] GotoIf(“DAHDI/3-1”, “0?usegoto,1”) in new stack
– Executing [[email protected]:38] GotoIf(“DAHDI/3-1”, “1?godial”) in new stack
– Goto (macro-dial-one,s,42)
– Executing [[email protected]:42] Dial(“DAHDI/3-1”, “SIP/777,tr”) in new stack
== Using SIP RTP TOS bits 184
== Using SIP RTP CoS mark 5
– Called SIP/777
– SIP/777-00000015 is ringing
== Spawn extension (macro-dial-one, s, 42) exited non-zero on ‘DAHDI/3-1’ in macro ‘dial-one’
== Spawn extension (macro-exten-vm, s, 14) exited non-zero on ‘DAHDI/3-1’ in macro ‘exten-vm’
== Spawn extension (from-did-direct, 777, 2) exited non-zero on ‘DAHDI/3-1’
– Executing [[email protected]:1] Macro(“DAHDI/3-1”, “hangupcall,”) in new stack
– Executing [[email protected]:1] GotoIf(“DAHDI/3-1”, “1?theend”) in new stack
– Goto (macro-hangupcall,s,3)
– Executing [[email protected]:3] Hangup(“DAHDI/3-1”, “”) in new stack
== Spawn extension (macro-hangupcall, s, 3) exited non-zero on ‘DAHDI/3-1’ in macro ‘hangupcall’
== Spawn extension (from-did-direct, h, 1) exited non-zero on ‘DAHDI/3-1’
– Hanging up on ‘DAHDI/3-1’
– Hungup ‘DAHDI/3-1’

Try this query:

The module is expecting the returned data to be called name not lname

I switched to callerid superfecta 2.33 over the weekend and would like some help with the my sql query structure.

When I use
SELECT CONCAT (lname,fname) FROM patient_data WHERE phone_home = :thenumber
I get the desired results.
However, my database contains numbers inputed as 234-456-7890 and (234)456-7890. How can I have the query ignore the non numerical characters?
I have tired a few variation of the following regex but now luck. Please help
SELECT concat(lname,’ ',fname) FROM patient_data WHERE phone_home RLIKE ‘^[+]?[-() 0-9]+$’ = :theregex

this query works for number with hyphens. So 234-446-7890 works. How to modify it to ignore brackets in (234)456-7890
select concat(lname,’ ',fname) from patient_data where phone_home REGEXP ‘^[+]?[-() 0-9]+$’ : =theregex

I just found this in my log…not sure if this is anything.

404 Not Found

Not Found

The requested URL /admin/modules/superfecta/bin/callerid.php was not found on this server.


Apache/2.2.15 (CentOS) Server at localhost Port 80

When I do
when I
do
http://172.20.1.1/admin/modules/superfecta/includes/callerid.php?thenumber=123456789
I get a output as
YToxOntzOjc6Im1lc3NhZ2UiO3M6MjU6ImJhc2VfRGVmYXVsdDogIEFMQkFOWSwgR0EiO30=,

I just realized that I am not saving in the text box labelled sql query. I hit save button and a pop up appears confirming saved. However when I click on the database link again, the old query comes up. No query with ’ get saved.
Any thoughts?
I have ver 2.11.5