Posted by Letharion on August 8, 2010 at 4:17pm
I'm trying to install 0.4a9, and after patching drush with the table.inc patch, the install gets to asking about the admin e-mail adress, but then it just freezes there. Mysql cpu % spikes, but nothing actually happens in the db, "show full processlist" returns a line like this:
89 | intntnllyInvalid | localhost:60780 | NULL | Sleep | 727 | | NULL
Any ideas on how I can proceed?
Comments
I had exactly the same
I had exactly the same problem, I traced it down to me trying to use 127.0.0.1 as the IP for the server (by entering a line in /etc/hosts).
Once I set the IP to be the actual IP that the server could be accessed from the install went ahead (albeit rather slowly, possibly due to the fact that I turned on the mysql general query log).
Thanks, that solved it for me
Thanks, that solved it for me too :)
I'm seeing a similar issue
I'm seeing a similar issue when creating sites, mysql goes into a high cpu usage and nothing seems happens. I have tried every combination I can think of IP address for localhost in aegir and in the /etc/hosts files and nothing seems to make a difference. I've turned on all the mysql logging I can find, but it doesn't seem to be queries that are consuming the CPU.
it seems to be
you have incredibly lenient permissions on mysql.
you are allowing any request from localhost with any username / password to connect.
Thanks adrian, the lax
Thanks adrian, the lax permissions looks to be the root cause in my case. This was installing on my dev environment, so had the mysql test database accessible by anonymous users. Think this is the default setup for installation on OSX from both the MySQL binaries and via macports (tried both).
Yes this issue seems to be
Yes this issue seems to be related to mysql permissions.
Seem unable to pin this down
I am encountering this problem as well, reinstalling aegir on one of our servers. No combination of /etc/host and /etc/my.cnf seems to help . Any suggestions where I should focus my attention? I presume a 127.0.0.1 localhost / x.x.x.x servername together with a bind-address of 127.0.0.1 (or 0.0.0.0, for that matter) should work just fine?
Permissions indeed
Our problem has been fixed by removing the anonymous mysql users (commandline empty users, phpMyAdmin ANY users, all representations of the same) that seem to be created by mysql by default & which apparently had never been neutralized on this server.