mySQL CID Lookup Not Working

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 [[email protected]:2] Gosub("SIP/FlowRoute-0000017d", "cidlookup,cidlookup_1,1") in new stack
Oct 17 23:40:33	VERBOSE	[23744] pbx.c:	
-- Executing [[email protected]: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 [[email protected]: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 [[email protected]: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 [[email protected]: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_clear

And 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]

You need to provide more details.
What is the version of FreePBX?
What is the version of Asterisk?

The error is that you have ‘:’ in the connect string, depending on what version of FreePBX and/or Asterisk this is not a valid character. You need to use the standard port for MySQL for it to work.