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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <[EMAIL PROTECTED]> 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 > _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
