[asterisk-bugs] [Asterisk 0010752]: macro defined in realtime that uses cmd MYSQL fails to connect

[noreply at bugs.digium.com]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=10752 
====================================================================== 
Reported By:                bferrell
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   10752
Category:                   PBX/pbx_realtime
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.4.11  
SVN Branch (only for SVN checkouts, not tarball releases): N/A  
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             09-18-2007 00:18 CDT
Last Modified:              09-19-2007 12:45 CDT
====================================================================== 
Summary:                    macro defined in realtime that uses cmd MYSQL fails
to connect
Description: 
MYSQL(Connect connid hostid xxxxx '' asterisk)

works in a macro defined in extensions.conf.

When the macro is defined in realtime it fails to connect
====================================================================== 

---------------------------------------------------------------------- 
 bferrell - 09-19-07 12:45  
---------------------------------------------------------------------- 
[macro-set-out-cid-pbx]

exten => s,1,MYSQL(Connect connid hostid root '' asterisk)
exten => s,2,MYSQL(Query resultid ${connid} select\ did\ from\ call_xlatn\
where\ ext=\'${CHANNEL:4:17}\')
exten => s,3,MYSQL(Fetch fetchid ${resultid} datavar)
exten => s,4,MYSQL(Disconnect ${connid})
exten => s,5,Set(anin=${datavar})
exten => s,6,Set(CALLERID(all)=${anin})


select * from extensions_table where context like 'macro-set%';
+-------+-----------------------+-------+----------+-------+---------------------------------------------------------------------------------+
| id    | context               | exten | priority | app   | appdata      
                                                                  |
+-------+-----------------------+-------+----------+-------+---------------------------------------------------------------------------------+
| 14792 | macro-set-out-cid-pbx | s     | 1        | MYSQL | Connect
connid hostid root '' asterisk                            | 
| 14793 | macro-set-out-cid-pbx | s     | 2        | MYSQL | Query
resultid ${connid} select did from call_xlatn where ext='${CHANNEL:4:17}' |

| 14794 | macro-set-out-cid-pbx | s     | 3        | MYSQL | Fetch fetchid
${resultid} datavar                                               | 
| 14795 | macro-set-out-cid-pbx | s     | 4        | MYSQL | Disconnect
${connid}                                                            | 
| 14796 | macro-set-out-cid-pbx | s     | 5        | Set   | Disconnect
${connid}                                                            | 
| 14797 | macro-set-out-cid-pbx | s     | 6        | Set   |
(CALLERID(all)=${anin}                                                     
    | 
+-------+-----------------------+-------+----------+-------+---------------------------------------------------------------------------------+


Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
09-19-07 12:45  bferrell       Note Added: 0070802                          
======================================================================