[Asterisk-Users] MYSQL Dialplan Question

[Shaun Tierney]

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