The HINTS_Solaris.txt file has the "right" MySQL credentials that are *really* necessary: we don't need full root access for aegir. We just need to be able to create users and databases, and we can even afford to do it under a certain prefix.

This should be fixed in the wizard.

Comments

Anonymous’s picture

Anonymous (not verified) commented 
GRANT ALL PRIVILEGES ON `site\_%`.* TO 'aegir_root'@'localhost';

This is in the Solaris HINTS, and I wonder if this breaks a migration of the hostmaster site itself (via drush hostmaster-migrate) as during the migration, the 'aegir' database is dropped and a new one created with a site_ prefix (per standard the standard migration system).

Would the limited grant above, prevent the 'aegir' database from being dropped in a hostmaster-migrate?

A quick fix would just be to add another GRANT ALL PRIVLEGES ON 'aegir' ... to the aegir_root user.

Thoughts? Am I wrong in my theory?

psycotic’s picture

psycotic commented

You are correct mig5, this indeed caused me problems in migrating my hostmaster platform to 6.x-0.4-alpha5.

adrian’s picture

adrian commented
Status: Active » Fixed

hooraaay

"This should be fixed in the wizard."

ding dong the .. wizard .. is dead.

moving right along.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.