Caller ID Source not populating to phone

leetv · June 28, 2012, 2:47am

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

leetv · June 28, 2012, 3:03pm

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

lgaetz · June 28, 2012, 1:33pm

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

lgaetz · June 28, 2012, 3:28pm

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?

leetv · June 28, 2012, 3:33pm

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.

albanyeye · September 29, 2012, 5:50am

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

lgaetz · September 29, 2012, 2:09pm

Try this query:

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

albanyeye · December 27, 2013, 4:18am

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

albanyeye · December 27, 2013, 4:49am

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

albanyeye · December 27, 2013, 5:09am

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=,

albanyeye · December 27, 2013, 5:47am

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