<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.3790.2759" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=609184517-02112006>Hi,</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=609184517-02112006></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=609184517-02112006>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: </SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=609184517-02112006></SPAN></FONT></FONT> </DIV>
<DIV><FONT><FONT face=Arial size=2> -- Executing
NoOp("SIP/<SPAN class=609184517-02112006>11.11.11.11</SPAN>", "701") in new
stack<BR> -- Executing MYSQL("SIP/<SPAN
class=609184517-02112006>11.11.11.11</SPAN>", "Connect connid
localhost <SPAN class=609184517-02112006>username</SPAN> <SPAN
class=609184517-02112006>password</SPAN> <SPAN
class=609184517-02112006>database_name</SPAN>") in new stack<SPAN
class=609184517-02112006> ---(same input
works at other places)</SPAN><BR> -- Executing
MYSQL("SIP/<SPAN class=609184517-02112006>11.11.11.11</SPAN>", "Query resultid 1
SELECT redirection_data from redirections where accountcode=5<SPAN
class=609184517-02112006>145555555</SPAN> and exten=701 and active=true") in new
stack</FONT></FONT></DIV>
<DIV><FONT><FONT face=Arial size=2> -- Executing MYSQL("<SPAN
class=609184517-02112006>SIP/11.11.11.11</SPAN>", "Fetch fetchid 2
redirection_data") in new stack<BR>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<BR>Nov 2 12:51:30 WARNING[24892]:
app_addon_sql_mysql.c:330 aMYSQL_fetch: aMYSQL_fetch: Invalid result identifier
2 passed<BR> -- Executing MYSQL("SIP/<SPAN
class=609184517-02112006>11.11.11.11</SPAN>", "Clear 2") in new
stack<BR>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<BR>Nov 2 12:33:44 WARNING[24450]: app_addon_sql_mysql.c:348
aMYSQL_clear: Invalid result identifier 2 passed in
aMYSQL_clear<BR> -- Executing MYSQL("SIP/<SPAN
class=609184517-02112006>11.11.11.11</SPAN>", "Disconnect 1") in new
stack<BR> -- Executing NoOp("SIP/<SPAN
class=609184517-02112006>11.11.11.11</SPAN>", "") in new
stack</FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=609184517-02112006><FONT face=Arial size=2>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). </FONT></SPAN></DIV>
<DIV><SPAN class=609184517-02112006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609184517-02112006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609184517-02112006><FONT face=Arial size=2>Any help is
appreciated.</FONT></SPAN></DIV>
<DIV><SPAN class=609184517-02112006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609184517-02112006><FONT face=Arial size=2>Mike</DIV>
<DIV><BR></DIV></FONT></SPAN></BODY></HTML>