Hey everyone,
I have, what I hope is a simple question regarding databases user permissions for setting up a remote web and databases server.
Some background, I have two web servers. Sangreal and Sangreal-dev. They each are self contained LAMP servers and each are running about 6 drupal sites. I've got aegir running on my dev server and I'm trying to get the sites on the live server brought into aegir. I've successfully added my live server as a new web server in aegir but when I try to add the database user info I get an access denied error. The problem is, I don't know what web server is throwing the error. Here is the log from drush provision-verify
Load alias @server_master [notice]
Loading mysql driver for the db service [notice]
Loading apache driver for the http service [notice]
Loading mysql driver for the db service [notice]
Loading apache driver for the http service [notice]
Provision configuration path /var/aegir/config/server_sangrealarcadiaedu exists. [message]
Provision configuration ownership of /var/aegir/config/server_sangrealarcadiaedu has been changed to aegir. [message]
Provision configuration permissions of /var/aegir/config/server_sangrealarcadiaedu have been changed to 711. [message]
Provision configuration path /var/aegir/config/server_sangrealarcadiaedu is writable. [message]
Executing: rsync -e 'ssh ' -azv --exclude="*.svn*" --stats --progress --relative --omit-dir-times --delete '/var/aegir/config/includes' [notice]
'aegir@sangreal.arcadia.edu:/'
/var/aegir/config/includes has been synced to remote server sangreal.arcadia.edu. [notice]
SQLSTATE[28000] [1045] Access denied for user 'root'@'sangreal-dev.arcadia.edu' (using password: YES) [error]
Fatal error: Call to a member function quote() on a non-object in /var/aegir/.drush/provision/db/db.drush.inc on line 311
Drush command could not be completed. I hope I've given enough info. I've looked through provisions issue queue and didn't see anything so I figure it's simply a misconfiguration user@host settings on one of the servers.
Comments
I knew once I posted this I
I knew once I posted this I would figure it out! Sorry folks.
I had properly created the user tied to the right host, I just didn't give it all the permissions it needed to create user accounts. What I did may be a bit broad, so if anyone has any recommendations about tightening it up please chime in. All ran was, after logging into mysql was:
GRANT ALL ON . to <username>@<aegir-hostname> IDENTIFIED BY '<password I gave aegir>'All is well.