Hi,
I am setting up a drupal/drush/aegir install.
Everything goes well, until I reach the 'Initialize the hosting system' portion of the hostmaster setup. PHP is obviously running, because it ..well it gets this far (creates db tables etc). Drush seems to be running well (drush status gives me drush info) , until I run this command:
php /usr/src/myserver/drush/drush.php hosting-setup fd --uri=http://myserver.com
Which prints out an HTML text string:
The site is currently not available due to technical problems. Please try again later. Thank you for your understanding.
If you are the maintainer of this site, please check your database settings in the
settings.phpfile and ensure that your hosting provider's database server is running. For more help, see the handbook, or contact your hosting provider.The mysql error was: Unable to use the MySQL database because the MySQL extension for PHP is not installed. Check your <code>php.ini</code> to see how you can enable it..
It can't be be a problem with mysql/php if the Drupal site is correctly connecting? We are not using localhost(I saw some discussion on this error being a result of localhost/vrs 127.0.0),. Database server on the same network... We have an Alpha version of this setup working fine, and we can't quite sort out what's different here. Can permissions have an effect? any suggestions appreciated!
Comments
php-cli?
Might be an issue with the different php.ini for mod_php (apache) and php-cli (command line, where Drush runs). In ubuntu you can look at the different php.ini's at /etc/php5/apache2 and /etc/php5/cli. But since they both appear to have a symlink to ../conf.d with all the php module configurations this might not actually be the problem. Worth checking anyway.
As for localhost vs 127.0.0.1. I'm running a single Ubuntu 9.10. host with apache and mysql and Aegir works for me. Here is my /etc/hosts file entry:
127.0.0.1 localhost
Mysql is listening only on 127.0.0.1.
My aegir_root user has global permissions in mysql.user table from host localhost.
Hope this helps.
-Tim
I'm wondering about my drush
I'm wondering about my drush connection - in general (thanks for the tips about php-cli that seemed as expected,.,,,I think)
drush sql-connect prints out the correct connection info.
When I run
drush sql query "SELECT * FROM {hosting_web_server}"
I get the same error as above(unable to use mysql database)...it seems like it can't connect.... I see a lot of comments on localhost, I wonder if the problem is the remote db - we haven't tested that before.