[asterisk-users] Mysql dialplan statement not executed

Sam Govind govoiper at gmail.com
Wed Sep 14 07:55:12 CDT 2011


I expect that your same query when executed directly on MySQL console
executes successfully ! Normally errors in DB queries are printed on CLI but
apparently there is nothing wrong.

On Wed, Sep 14, 2011 at 5:51 PM, Jonas Kellens <jonas.kellens at telenet.be>wrote:

> **
> 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 custDB SET 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.
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>               http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110914/d8e35e04/attachment.htm>


More information about the asterisk-users mailing list