[asterisk-bugs] [Asterisk 0012583]: MYSQL() from dialplan appears to "eat" the first field retrieved from a MySQL Table
noreply at bugs.digium.com
noreply at bugs.digium.com
Thu May 8 10:25:36 CDT 2008
The following issue has been RESOLVED.
======================================================================
http://bugs.digium.com/view.php?id=12583
======================================================================
Reported By: albaker
Assigned To: qwell
======================================================================
Project: Asterisk
Issue ID: 12583
Category: Addons/app_addon_sql_mysql
Reproducibility: always
Severity: major
Priority: normal
Status: resolved
Asterisk Version: Addons 1.4.6
SVN Branch (only for SVN checkouts, not tarball releases): N/A
SVN Revision (number only!):
Disclaimer on File?: N/A
Request Review:
Resolution: won't fix
Fixed in Version:
======================================================================
Date Submitted: 05-05-2008 09:25 CDT
Last Modified: 05-08-2008 10:25 CDT
======================================================================
Summary: MYSQL() from dialplan appears to "eat" the first
field retrieved from a MySQL Table
Description:
Thier appears to be a BUG with the MySQL add-on for Asterisk .This is on
FEDORA 8 fully patched with Asterisk Addons 1-4-6 with the Asterisk
1.4.18.1
It appears that the interface “eats” the first field requested from a
table. If only One Field is Requested from the Table , that field is eaten
ENTIRELY by Asterisk. If several fields are requested, the First Field Is
Eaten and the remaining filed are returned, but place in the WRONG Variable
since the 1tst field data was eaten. In the DIALPLAN below I have tried 3
Different ways to approach this.
Extension 9999 – Get only ONE (1) field from Table
Extension 8888 – Get THREE(3) fields from the Table and Quote Them.
Extension 7777 - Get THREE(3) fields from the Table
I have show the Output from the Asterisk CLI for each, which clearly show
that SOMETHING is not
right. Maybe the Software, maybe the person using the software :) In any
event the First Field pulled from the table in not correctly returned to
the DialPlan
Here is the Table in the Database.
mysql> select * from agent;
+----------+---------+--------+------------+---------------------+
| id | cust_id | status | phone | tlce |
+----------+---------+--------+------------+---------------------+
| 00000001 | NAMB | free | 1234567890 | 2008-04-17 02:32:02 |
| 00000002 | NAMB | free | 2234567890 | 2008-04-17 02:32:02 |
| 00000003 | NAMB | free | 3234567890 | 2008-04-17 02:32:02 |
| 00000004 | NAMB | free | 4234567890 | 2008-04-17 02:32:02 |
+----------+---------+--------+------------+---------------------+
4 rows in set (0.00 sec)
Here is the DIALPLAN
exten => 7777,1,MYSQL(Connect connid localhost ivr ivrxxx dtc)
exten => 7777,n,MYSQL(Query resultid ${connid} SELECT\ cust_id\, \
status\,\ tlce\ from\ agent\ where\ phone=\'1234567890\')
exten => 7777,n,MYSQL(Fetch fetchid ${resultid} custid mystatus mytlce)
exten => 7777,n,NoOp(CUSTID is ${custid} MYSTATUS is ${mystatus} MYTLCE is
${mytlce})
exten => 7777,n,NoOp(FETCHID is ${fetchid} RESULUT ID is .. ${resultid}
CONNID is ${connid})
exten => 7777,n,MYSQL(Clear ${resultid})
exten => 7777,n,MYSQL(Disconnect ${connid})
exten => 7777,n,HANGUP
exten => 8888,1,MYSQL(Query resultid ${connid} SELECT\ 'cust_id'\, \
'status'\,\ 'tlce'\ from\ agent\ where\ phone=\'1234567890\')
exten => 8888,n,MYSQL(Fetch fetchid ${resultid} custid mystatus mytlce)
exten => 8888,n,NoOp(CUSTID is ${custid} MYSTATUS is ${mystatus} MYTLCE is
${mytlce})
exten => 8888,n,NoOp(FETCHID is ${fetchid} RESULUT ID is .. ${resultid}
CONNID is ${connid})
exten => 8888,n,MYSQL(Clear ${resultid})
exten => 8888,n,MYSQL(Disconnect ${connid})
exten => 8888,n,HANGUP
exten => 9999,1,MYSQL(Connect connid localhost ivr ivrxxx dtc)
exten => 9999,n,MYSQL(Query resultid ${connid} SELECT\ 'cust_id'\ from\
agent\ where\ phone=\'1234567890\')
exten => 9999,n,MYSQL(Fetch fetchid ${resultid} custid)
exten => 9999,n,NoOp(CUSTID is ${custid})
exten => 9999,n,NoOp(FETCHID is ${fetchid} RESULUT ID is .. ${resultid}
CONNID is ${connid})
exten => 9999,n,MYSQL(Clear ${resultid})
exten => 9999,n,MYSQL(Disconnect ${connid})
exten => 9999,n,HANGUP
Here is the Asterisk CLI Output
dial 9999
== Console is full duplex
*CLI> -- Executing [9999 at default:1] MYSQL("OSS/dsp", "Connect connid
localhost ivr ivrxxx dtc") in new stack
-- Executing [9999 at default:2] MYSQL("OSS/dsp", "Query resultid 5 SELECT
cust_id from agent where phone='1234567890'") in new stack
-- Executing [9999 at default:3] MYSQL("OSS/dsp", "Fetch fetchid 6 custid")
in new stack
-- Executing [9999 at default:4] NoOp("OSS/dsp", "CUSTID is ") in new stack
-- Executing [9999 at default:5] NoOp("OSS/dsp", "FETCHID is 1 RESULUT ID is
.. 6 CONNID is 5") in new stack
-- Executing [9999 at default:6] MYSQL("OSS/dsp", "Clear 6") in new stack
-- Executing [9999 at default:7] MYSQL("OSS/dsp", "Disconnect 5") in new
stack
-- Executing [9999 at default:8] Hangup("OSS/dsp", "") in new stack
== Spawn extension (default, 9999, 8) exited non-zero on 'OSS/dsp'
<< Hangup on console
*CLI> dial 8888
== Console is full duplex
*CLI> -- Executing [8888 at default:1] MYSQL("OSS/dsp", "Connect connid
localhost ivr ivrxxx dtc") in new stack
-- Executing [8888 at default:2] MYSQL("OSS/dsp", "Query resultid 5 SELECT
cust_id, status, tlce from agent where phone='1234567890'") in new stack
-- Executing [8888 at default:3] MYSQL("OSS/dsp", "Fetch fetchid 6 custid
mystatus mytlce") in new stack
-- Executing [8888 at default:4] NoOp("OSS/dsp", "CUSTID is free MYSTATUS is
2008-04-17 02:32:02 MYTLCE is ") in new stack
-- Executing [8888 at default:5] NoOp("OSS/dsp", "FETCHID is 1 RESULUT ID is
.. 6 CONNID is 5") in new stack
-- Executing [8888 at default:6] MYSQL("OSS/dsp", "Clear 6") in new stack
-- Executing [8888 at default:7] MYSQL("OSS/dsp", "Disconnect 5") in new
stack
-- Executing [8888 at default:8] Hangup("OSS/dsp", "") in new stack
== Spawn extension (default, 8888, 8) exited non-zero on 'OSS/dsp'
<< Hangup on console >
OK – Have I done something really dumb or is this a BUG ?
Thank VERY MUCH for any and ALL Help
======================================================================
----------------------------------------------------------------------
qwell - 05-08-08 10:25
----------------------------------------------------------------------
You have extra spaces in your Fetch (and potentially other) statements.
This is not an issue in Asterisk, and it is not something we plan on
changing.
Remove extra spaces, and please do not sanitize logs or dialplan in future
reports. This is something that could have been caught immediately if they
hadn't been cleaned.
Issue History
Date Modified Username Field Change
======================================================================
05-08-08 10:25 qwell Status feedback => resolved
05-08-08 10:25 qwell Resolution open => won't fix
05-08-08 10:25 qwell Assigned To => qwell
05-08-08 10:25 qwell Note Added: 0086602
======================================================================
More information about the asterisk-bugs
mailing list