[Asterisk-Users] MYSQL Dialplan Question

[Shaun Tierney]

I have already verified the permissions on the database.  I had granted all
permissions on this database to the username I am using in the dialplan.  I
used the statement GRANT ALL ON asteriskdb.* TO admin at localhost IDENTIFIED
BY 'abc123';. I have logged into the MySQL console and was able to run the
UPDATE query from there using the same username and password I am trying to
use from the dialplan, so it seems to be specifically a problem with the
MYSQL addon application not being able to write or something.  Could it be
that the MYSQL application is set up for read only?  Did I miss a compile
option or something?

Thanks,

Shaun

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com]On Behalf Of Kevin
Brennan
Sent: Wednesday, November 17, 2004 4:29 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] MYSQL Dialplan Question


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
>