[Asterisk-Users] MYSQL Dialplan Question

[Kevin Brennan]

If you can't update with SQL commands from the CLI then you need to check
your permissions in database mysql.
Read Mysql docs.
>info mysql
MySQL Database Administration -> Privilage System
Br /Kev/

----- Original Message -----
From: "Shaun Tierney" <stierney at prairiestream.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
Sent: Tuesday, November 16, 2004 10:46 PM
Subject: RE: [Asterisk-Users] MYSQL Dialplan Question


> Thanks for the help.  Downloading and installing asterisk-addons fixed my
> problem with the MYSQL application error.  Now I am having another
> difficulty though.  I am unable to update fields in the database.  I even
> hardcoded the query rather than using Asterisk dialplan variables just to
> see if that was the problem.  I am able to update fields using the MySQL
> console logging in with the same username and password I use in the
> dialplan.  Reading data seems to work great from the dialplan, just can't
> write to the database.  I'm using the following syntax.
>
> MYSQL(Query resultid ${connid} "Update table set field=fieldvalue where
> where_expression")
>
> Any thoughts?
>
> Thanks,
>
> Shaun
>
> -----Original Message-----
> From: asterisk-users-bounces at lists.digium.com
> [mailto:asterisk-users-bounces at lists.digium.com]On Behalf Of Carlton
> O'Riley
> Sent: Monday, November 15, 2004 11:03 AM
> To: 'Asterisk Users Mailing List - Non-Commercial Discussion'
> Subject: RE: [Asterisk-Users] MYSQL Dialplan Question
>
>
> You need to download the asterisk-addons to have mysql support now.  It
was
> only moved to its own project due to licensing changes with MySQL.
>
> > -----Original Message-----
> > From: asterisk-users-bounces at lists.digium.com
> > [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of
> > Shaun Tierney
> > Sent: Monday, November 15, 2004 11:56 AM
> > To: Asterisk Users Mailing List - Non-Commercial Discussion
> > Subject: RE: [Asterisk-Users] MYSQL Dialplan Question
> >
> > Well, I looked at the makefile and I could not see any
> > options for SQL.  So I did a grep for SQL on the distribution
> > files and found that in version 0.7.0 support for MySQL was
> > removed, so I'm guessing I'm just going to have to switch to
> > Postgres or something.
> >
> > Thanks for the help,
> >
> > Shaun
> >
> > -----Original Message-----
> > From: asterisk-users-bounces at lists.digium.com
> > [mailto:asterisk-users-bounces at lists.digium.com]On Behalf Of
> > Steven Critchfield
> > Sent: Monday, November 15, 2004 10:11 AM
> > To: Asterisk Users Mailing List - Non-Commercial Discussion
> > Subject: Re: [Asterisk-Users] MYSQL Dialplan Question
> >
> >
> > On Mon, 2004-11-15 at 10:04 -0600, Shaun Tierney wrote:
> > > I am new to Asterisk, and I am having trouble connecting to
> > the MySQL
> > > database located on the same machine as my Asterisk box.  When the
> > dialplan
> > > tried to connect to MySQL database, I get the following
> > error message
> > > on
> > the
> > > Asterisk console.
> > >
> > > Nov 15 09:29:41 WARNING[111139760]: pbx.c:1279
> > pbx_extension_helper:
> > > No application 'MYSQL' for extension (default, s, 5)
> > >
> > > Here is the corresponding line in my dialplan.
> > >
> > > exten => s,5,MYSQL(Connect connid localhost admin abc123 asteriskdb)
> > >
> > > I am able to connect to the database with the same username and
> > > password using the MySQL console.  Am I missing something in my
> > > installation or configuration that would cause this?
> >
> > Yes you are missing something in your installation. From
> > reading the error message I can see you did not build the
> > mysql application. My guess would be that it is not enabled
> > in the makefile. Go edit it, compile, install, and try again.
> > --
> > Steven Critchfield <critch at basesys.com>
> >
> > _______________________________________________
> > Asterisk-Users mailing list
> > Asterisk-Users at lists.digium.com
> > http://lists.digium.com/mailman/listinfo/asterisk-users
> > To UNSUBSCRIBE or update options visit:
> >    http://lists.digium.com/mailman/listinfo/asterisk-users
> >
> > _______________________________________________
> > Asterisk-Users mailing list
> > Asterisk-Users at lists.digium.com
> > http://lists.digium.com/mailman/listinfo/asterisk-users
> > To UNSUBSCRIBE or update options visit:
> >    http://lists.digium.com/mailman/listinfo/asterisk-users
> >
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>