[asterisk-users] Mysql dialplan statement not executed

Jonas Kellens jonas.kellens at telenet.be
Wed Sep 14 07:51:35 CDT 2011


Hello,

I do the following in a macro in the dialplan :

exten => s,n,MYSQL(Connect connid localhost user password AsteriskDB)
exten => s,n,MYSQL(Query resultid ${connid} UPDATE custDB SET active=1 
WHERE routeID=${ARG1} AND nr=1)
exten => s,n,MYSQL(Disconnect ${connid})

But nothing changes in my database...

This is the CLI :

[Sep 14 16:41:04]     -- Executing [s at macro-bal:15] 
MYSQL("SIP/vc5-0000000b", "Connect connid localhost user password 
AsteriskDB") in new stack
[Sep 14 16:41:04]     -- Executing [s at macro-bal:16] 
MYSQL("SIP/vc5-0000000b", "Query resultid 15 UPDATE custDBSET active=1 
WHERE routeID=195 AND nr=1") in new stack
[Sep 14 16:41:04]     -- Executing [s at macro-bal:17] 
MYSQL("SIP/vc5-0000000b", "Disconnect 15") in new stack

Seems OK, no warnings. But the update has not taken place.


Kind regards,
Jonas.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110914/a0666598/attachment.htm>


More information about the asterisk-users mailing list