[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