[asterisk-users] Problem with MYSQL commands in dialplan

[Mike]

Hi,

 

I have been using MYSQL successfully from the dialplan in the past, but I am stumped this morning trying to use it for some other table.  I am basically cut and pasting from the wiki.  Here is my CLI output: 

 

    -- Executing NoOp("SIP/11.11.11.11", "701") in new stack
    -- Executing MYSQL("SIP/11.11.11.11", "Connect connid localhost username password database_name") in new stack      ---(same input works at other places)
    -- Executing MYSQL("SIP/11.11.11.11", "Query resultid 1 SELECT redirection_data from redirections where accountcode=5145555555 and exten=701 and active=true") in new stack

  -- Executing MYSQL("SIP/11.11.11.11", "Fetch fetchid 2 redirection_data") in new stack
Nov  2 12:51:30 WARNING[24892]: app_addon_sql_mysql.c:115 find_identifier: Identifier 2, identifier_type 2 not found in identifier list
Nov  2 12:51:30 WARNING[24892]: app_addon_sql_mysql.c:330 aMYSQL_fetch: aMYSQL_fetch: Invalid result identifier 2 passed
    -- Executing MYSQL("SIP/11.11.11.11", "Clear 2") in new stack
Nov  2 12:33:44 WARNING[24450]: app_addon_sql_mysql.c:115 find_identifier: Identifier 2, identifier_type 2 not found in identifier list
Nov  2 12:33:44 WARNING[24450]: app_addon_sql_mysql.c:348 aMYSQL_clear: Invalid result identifier 2 passed in aMYSQL_clear
    -- Executing MYSQL("SIP/11.11.11.11", "Disconnect 1") in new stack
    -- Executing NoOp("SIP/11.11.11.11", "") in new stack

 

I am running 1.2.4.  Not even sure what the warning means (WARNING[24892]: app_addon_sql_mysql.c:115 find_identifier: Identifier 2, identifier_type 2 not found in identifier list). 

 

 

Any help is appreciated.

 

Mike

_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users