Hello i have a problem with CallerID lookup sources.
In freepbx 2.5.1.1 in setup a mysql lookup source from a sugarcrm database.
it generates the extensions_additional.conf like this:
[cidlookup]
include => cidlookup-custom
exten => cidlookup_4,1,MYSQL(Connect connid sugardevel.domain.si test mytest sugardevel)
exten => cidlookup_4,n,MYSQL(Query resultid ${connid} SELECT\ first_name\ FROM\ contacts\ WHERE\ phone_work\ LIKE\ ‘%${CALLERID(num)}%’;
exten => cidlookup_4,n,MYSQL(Fetch fetchid ${resultid} CALLERID(name))
exten => cidlookup_4,n,MYSQL(Clear ${resultid})
exten => cidlookup_4,n,MYSQL(Disconnect ${connid})
exten => cidlookup_4,n,Return()
exten => cidlookup_return,1,LookupCIDName
exten => cidlookup_return,n,Return()
; end of [cidlookup]
This looks ok.
But no cidlookup doesn’t get executed during calls.
I only see this in log:
[Feb 23 09:46:18] VERBOSE[11586] logger.c: – Registered extension context ‘cidlookup’
[Feb 23 09:46:18] VERBOSE[11586] logger.c: – Including context ‘cidlookup-custom’ in context ‘cidlookup’
[Feb 23 09:46:18] VERBOSE[11586] logger.c: – Added extension ‘cidlookup_4’ priority 1 to cidlookup
[Feb 23 09:46:18] VERBOSE[11586] logger.c: – Added extension ‘cidlookup_4’ priority 2 to cidlookup
[Feb 23 09:46:18] VERBOSE[11586] logger.c: – Added extension ‘cidlookup_4’ priority 3 to cidlookup
[Feb 23 09:46:18] VERBOSE[11586] logger.c: – Added extension ‘cidlookup_4’ priority 4 to cidlookup
[Feb 23 09:46:18] VERBOSE[11586] logger.c: – Added extension ‘cidlookup_4’ priority 5 to cidlookup
[Feb 23 09:46:18] VERBOSE[11586] logger.c: – Added extension ‘cidlookup_4’ priority 6 to cidlookup
[Feb 23 09:46:18] VERBOSE[11586] logger.c: – Added extension ‘cidlookup_return’ priority 1 to cidlookup
[Feb 23 09:46:18] VERBOSE[11586] logger.c: – Added extension ‘cidlookup_return’ priority 2 to cidlookup
[Feb 23 09:46:18] WARNING[11586] pbx.c: Context ‘cidlookup’ tries to include nonexistent context ‘cidlookup-custom’
Is anythis messed up??
Thank you