<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#3333ff">
<font color="#000000"><span class="postbody">I would appreciate any and
all advice on what
appears to be a BUG (or a brainfart on my part) with the MySQL add-on
for Asterisk this is of FEDORA 8 fully patched with Asterisk Addons
1-4-6 with the Asterisk 1.4.18.1
<br>
<br>
It appears that the interface “<font color="#3366ff">eats”</font> the
first field requested from
a table. If <font color="#3366ff">only One Field</font> is Requested
from the Table , that field is
eaten ENTIRELY by Asterisk. If <font color="#3333ff">several fields</font>
are requested, the <font color="#3333ff">First
Field Is Eaten</font> and<font color="#3333ff"> the remaining filed are
returned</font>, but place in the
WRONG <font color="#3333ff">Variable</font> since the 1tst fileld data
was eaten. In the DIALPLAN
below I have tried 3 Different ways to approach this. <br>
<br>
Extension <font color="#3333ff">9999</font> – Get only ONE (<font
color="#3333ff">1</font>) field from Table
<br>
<br>
Extension <font color="#3333ff">8888</font> – Get THREE(3) fields from
the Table
</span></font><font color="#000000"><span class="postbody">and Quote
Them.<br>
<br>
</span></font><font color="#000000"><span class="postbody">Extension <font
color="#3333ff">7777</font> - Get THREE(3) fields from the Table <br>
<br>
I have show the Output from the Asterisk CL for each, which clearly
show that SOMETHING is not <br>
right. Maybe the Software, maybe the person using the software :)
<br>
<br>
Here is the <font color="#3333ff">Table</font> in the Database.
<br>
<br>
mysql> select * from agent;
<br>
<br>
+----------+---------+--------+------------+---------------------+
<br>
<br>
| id | cust_id | status | phone | tlce |
<br>
<br>
+----------+---------+--------+------------+---------------------+
<br>
| 00000001 | NAMB | free | 1234567890 | 2008-04-17 02:32:02 | <br>
<br>
| 00000002 | NAMB | free | 2234567890 | 2008-04-17 02:32:02 | <br>
<br>
| 00000003 | NAMB | free | 3234567890 | 2008-04-17 02:32:02 | <br>
<br>
| 00000004 | NAMB | free | 4234567890 | 2008-04-17 02:32:02 | <br>
+----------+---------+--------+------------+---------------------+
<br>
<br>
4 rows in set (0.00 sec)
<br>
<br>
<br>
Here is the <u><b><font color="#3333ff">DIALPLAN </font></b></u><br>
<br>
exten => 7777,1,MYSQL(Connect connid localhost ivr ivrxxx dtc)
<br>
<br>
exten => 7777,n,MYSQL(<font color="#3333ff">Query resultid ${connid}
<b><font color="#3333ff">SELECT\ cust_id\, \ status\,\ tlce\ from\
agent\ where\ phone=\'1234567890\'</font></b></font>)
<br>
<br>
exten => 7777,n,MYSQL(Fetch fetchid ${resultid} <font
color="#3333ff">custid mystatus mytlce</font>)
<br>
<br>
exten => 7777,n,NoOp(<font color="#3333ff">CUSTID is ${custid}
MYSTATUS is ${mystatus} MYTLCE is ${mytlce}</font>)
<br>
<br>
exten => 7777,n,NoOp(FETCHID is ${fetchid} RESULUT ID is ..
${resultid} CONNID is ${connid})
<br>
<br>
exten => 7777,n,MYSQL(Clear ${resultid})
<br>
<br>
exten => 7777,n,MYSQL(Disconnect ${connid})
<br>
<br>
exten => 7777,n,HANGUP
<br>
<br>
<br>
<br>
exten => 8888,1,MYSQL(Query resultid ${connid} SELECT\ 'cust_id'\, \
'status'\,\ 'tlce'\ from\ agent\ where\ phone=\'1234567890\')
<br>
<br>
exten => 8888,n,MYSQL(Fetch fetchid ${resultid} custid mystatus
mytlce)
<br>
<br>
exten => 8888,n,NoOp(CUSTID is ${custid} MYSTATUS is ${mystatus}
MYTLCE is ${mytlce})
<br>
<br>
exten => 8888,n,NoOp(FETCHID is ${fetchid} RESULUT ID is ..
${resultid} CONNID is ${connid})
<br>
<br>
exten => 8888,n,MYSQL(Clear ${resultid})
<br>
<br>
exten => 8888,n,MYSQL(Disconnect ${connid})
<br>
<br>
exten => 8888,n,HANGUP
<br>
<br>
<br>
exten => 9999,1,MYSQL(Connect connid localhost ivr ivrxxx dtc)
<br>
<br>
exten => 9999,n,MYSQL(<font color="#3333ff">Query resultid ${connid}
SELECT\ 'cust_id'\ from\ agent\ where\ phone=\'1234567890\'</font>)
<br>
<br>
exten => 9999,n,MYSQL(<font color="#3333ff">Fetch fetchid
${resultid} custid</font>)
<br>
<br>
exten => 9999,n,NoOp(<font color="#3333ff">CUSTID is ${custid}</font>)
<br>
<br>
exten => 9999,n,NoOp(FETCHID is ${fetchid} RESULUT ID is ..
${resultid} CONNID is ${connid})
<br>
<br>
exten => 9999,n,MYSQL(Clear ${resultid})
<br>
<br>
exten => 9999,n,MYSQL(Disconnect ${connid})
<br>
<br>
exten => 9999,n,HANGUP
<br>
<br>
<br>
<br>
<br>
Here is the <u><b><font color="#cc33cc">Asterisk CLI Output
</font></b></u><br>
<br>
dial 9999
<br>
<br>
== Console is full duplex
<br>
<br>
*CLI> -- Executing [9999@default:1] MYSQL("OSS/dsp", "Connect connid
localhost ivr ivrxxx dtc") in new stack
<br>
<br>
-- Executing [9999@default:2] MYSQL("OSS/dsp", <font color="#cc33cc">"Query
resultid 5
SELECT cust_id from agent where phone='1234567890'"</font>) in new
stack
<br>
<br>
-- Executing [9999@default:3] MYSQL("OSS/dsp", <font color="#cc33cc">"Fetch
fetchid 6 custid"</font>) in new stack
<br>
<br>
-- Executing [9999@default:4] NoOp(<font color="#cc33cc">"OSS/dsp",
"CUSTID is "</font>) in new stack
<br>
<br>
-- Executing [9999@default:5] NoOp("OSS/dsp", <font color="#cc33cc">"FETCHID
is 1 RESULUT ID is .. 6 CONNID is 5"</font>) in new stack
<br>
<br>
-- Executing [9999@default:6] MYSQL("OSS/dsp", "Clear 6") in new stack
<br>
<br>
-- Executing [9999@default:7] MYSQL("OSS/dsp", "Disconnect 5") in new
stack
<br>
<br>
-- Executing [9999@default:8] Hangup("OSS/dsp", "") in new stack
<br>
<br>
== Spawn extension (default, 9999, 8) exited non-zero on 'OSS/dsp'
<br>
<br>
<< Hangup on console <br>
<br>
*CLI> dial 8888
<br>
<br>
== Console is full duplex
<br>
<br>
*CLI> -- Executing [8888@default:1] MYSQL("OSS/dsp", "Connect connid
localhost ivr ivrxxx dtc") in new stack
<br>
<br>
-- Executing [8888@default:2] MYSQL("OSS/dsp", <font color="#cc33cc">"Query
resultid 5
SELECT cust_id, status, tlce from agent where phone='1234567890'"</font>)
in
new stack
<br>
<br>
-- Executing [8888@default:3] MYSQL("OSS/dsp",<font color="#cc33cc">
"Fetch fetchid 6 custid mystatus mytlce"</font>) in new stack
<br>
<br>
-- Executing [8888@default:4] NoOp("OSS/dsp", "<font color="#cc33cc">CUSTID
is <b><font color="#ff0000">free</font></b> MYSTATUS is <font
color="#ff0000">2008-04-17 02:32:02</font> MYTLCE is "</font>) in new
stack
<br>
<br>
-- Executing [8888@default:5] NoOp("OSS/dsp", "<font color="#993399">FETCHID
is 1 RESULUT ID is .. 6 CONNID is 5</font>") in new stack
<br>
<br>
-- Executing [8888@default:6] MYSQL("OSS/dsp", "Clear 6") in new stack
<br>
<br>
-- Executing [8888@default:7] MYSQL("OSS/dsp", "Disconnect 5") in new
stack
<br>
<br>
-- Executing [8888@default:8] Hangup("OSS/dsp", "") in new stack
<br>
<br>
== Spawn extension (default, 8888, 8) exited non-zero on 'OSS/dsp'
<br>
<br>
<< Hangup on console >
<br>
<br>
OK – Have I done something <b><font color="#3333ff">really dumb </font></b>or
is this a<font color="#3333ff"> BUG </font>?
<br>
Thank VERY MUCH for any and ALL Help</span></font>
</body>
</html>