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
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20061102/0e7f2475/attachment.htm