I created a mySQL CID Lookup source, and added it to the Inbound route. I’m pretty sure that it’s connecting, because it throws an error when i supply the wrong password. Here’s the messages from the log.
host: mysql5.server314.com:3307
database: client_contact
query: SELECT display_name FROM phones WHERE number LIKE ‘%[NUMBER]%’ LIMIT 1
any idea what’s going on?
Thanks!!
Oct 17 23:40:33 VERBOSE [23744] pbx.c:
-- Executing [18884422568@from-trunk:2] Gosub("SIP/FlowRoute-0000017d", "cidlookup,cidlookup_1,1") in new stack
Oct 17 23:40:33 VERBOSE [23744] pbx.c:
-- Executing [cidlookup_1@cidlookup:1] MYSQL("SIP/FlowRoute-0000017d", "Connect connid mysql5.server314.com") in new stack
Oct 17 23:40:33 WARNING [23744] app_addon_sql_mysql.c:
[b]MYSQL_connect is missing some arguments[/b]
Oct 17 23:40:33 VERBOSE [23744] pbx.c:
-- Executing [cidlookup_1@cidlookup:2] MYSQL("SIP/FlowRoute-0000017d", "Query resultid SELECT display_name FROM `phones` WHERE `number` LIKE '%+[number redacted]%' LIMIT 1") in new stack
Oct 17 23:40:33 WARNING [23744] app_addon_sql_mysql.c:
[b]missing some arguments[/b]
Oct 17 23:40:33 VERBOSE [23744] pbx.c:
-- Executing [cidlookup_1@cidlookup:3] MYSQL("SIP/FlowRoute-0000017d", "Fetch fetchid CALLERID(name)") in new stack
Oct 17 23:40:33 WARNING [23744] app_addon_sql_mysql.c:
[b]aMYSQL_fetch: missing some arguments[/b]
Oct 17 23:40:33 VERBOSE [23744] pbx.c:
-- Executing [cidlookup_1@cidlookup:4] MYSQL("SIP/FlowRoute-0000017d", "Clear ") in new stack
Oct 17 23:40:33 WARNING [23744] app_addon_sql_mysql.c:
Identifier 0, identifier_type 2 not found in identifier list
Oct 17 23:40:33 WARNING [23744] app_addon_sql_mysql.c:
Invalid result identifier 0 passed in aMYSQL_clearAnd here is the cidlookup plan from extensions_additional.conf, to make sure everything seems in order.
[cidlookup]
include => cidlookup-custom
exten => cidlookup_1,1,MYSQL(Connect connid mysql5.server314.com:3307 [i]username[/i] [i]password[/i] client_contact)
exten => cidlookup_1,n,MYSQL(Query resultid ${connid} SELECT display_name FROM `phones` WHERE `number` LIKE '%${CALLERID(num)}%' LIMIT 1)
exten => cidlookup_1,n,MYSQL(Fetch fetchid ${resultid} CALLERID(name))
exten => cidlookup_1,n,MYSQL(Clear ${resultid})
exten => cidlookup_1,n,MYSQL(Disconnect ${connid})
exten => cidlookup_1,n,Return()
exten => cidlookup_return,1,ExecIf($["${DB(cidname/${CALLERID(num)})}" != ""]?Set(CALLERID(name)=${DB(cidname/${CALLERID(num)})}))
exten => cidlookup_return,n,Return()
; end of [cidlookup]