My environment (I normally wouldn't bother to mention this, but this setup isn't typical):
- Ubuntu 10.04.3
- Nginx 1.0.5
- PHP-FPM 5.3.2
- MySQL 5.1.41
MySQL resides on its own machine, accessible from the Web server at 10.0.0.255, while the Web server is at 10.0.0.254 (on the local network).
Going through the instructions at: http://community.aegirproject.org/node/389 I get to the
hostmaster-install step and the installation fails.
The only tweaky thing that had to be done was granting root permissions to the Web server for the database:
grant all privileges on *.* to 'root'@'10.0.0.254' with grant option;
Then the Drush command used to install hostmaster is:
drush hostmaster-install --http_service_type=nginx --aegir_db_host=10.0.0.255
This gets to installing the database and fails, see the attachments for details (they're huge walls of text, so thought it best not to paste them into the issue!):
aegirtrouble-web.txt - command line output from
aegirtrouble-db.txt - MySQL general query log;
Looking at the MySQL general log, it seems everything goes well but Aegir doesn't even attempt to create any database tables.
What is going wrong?