sh install.sh.txt devhost.socialnicheguru.com
==> Aegir automated install script
==> MySQL is listening on 127.0.1.1.
==> This script makes the following assumptions:
* you have read INSTALL.txt and prepared the platform accordingly
* you are running as your "aegir" user
Do you want to proceed with the install? [Y/n] Y
==> Aegir will now generate a mysql super user password for you:
Username : aegir_root
Password : 30dbada85fdd4aca068ca75279da88bc
Hostname : ubuntu (127.0.1.1)
You will be asked to enter your mysql root user password now :
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
/usr/bin/drush
==> Drush is in the path, good
==> Drush seems to be functionning properly
==> Provision already seems to be installed
==> Installing the frontend
The external command could not be executed due to an application error. [error]
SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'ubuntu' (111) [error]
Drush command could not be completed. [error]
Output from failed command : [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
An error occurred at function : drush_provision_hostmaster_install
I keep getting this error:
SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'ubuntu' (111)
What am I supposed to enter in when it asks for a password?
Enter password:
The password that it gave me above or my aegir database password?
Comments
mysql root user password
You need to give it the MySQL root user password. The error that follows that (though it doesn't say so) is a MySQL error (the "ERROR 1045 (28000) ...").
So neither the password it generated, or your aegir db password. It needs to be the root db password.
when u have instaled
when u have instaled mysql-server in ubuntu, the setup script asked u to setup 2 passwords. one of them is for the root password. if mysql-server was instaled to the initial install of the ubuntu, then run "sudo dpkg-reconfigure mysql-server" and read the instructions in the terminal/vt to setup your root password.
then install aegir.
stuck
I am having the same difficulty setting up the front end.
ubuntu lucid - Aegir 0.4 alpha 11
The password was set at install.
I have tried "sudo dpkg-reconfigure mysql-server" to see if there is an error during install, but this is not working either.
http://coworkingflorida.com Coworking Florida is a community driven shared office space in Boynton Beach Florida
http://newtechcommunity.com Local Non Profit Tech Community In South Florida
http://barcamppalmbeach.com BarCamp Palm Beach is an ad-hoc unc
Must be a puddle of mud
Must be a puddle of mud coming this way. Anybody resolved their issues yet ?
I'm getting the same error and I'm running lucid - Aegir 0.4 alpha 11. I'm able to access mysql db through Mysql Administrator and everything looks fine, all logins and passwords work like they are suppossed to.
Somebody just give me a inch so I can go the next mile.
I had the same problem
You have to edit my.cnf to comment out the line that says:
bind-address=127.0.0.1
By default, aegir will use 127.0.1.1, which also points locally. I hope I helped!
I go by Josh The Geek.
Drupal.org
GitHub
That did it. Thanks!
That did it. Thanks!
Same thing drove me crazy
Clean install on RackSpaceCloud Ubuntu 10.04 following Mercury 1.1 install instruction and then Aegir instructions.
I had #bind-address=127.0.0.1 commented.
'netstat -lpnut' command even showed it was listening correctly
Turns out, for some reason the port wasn't open in the firewall.
The following worked for me:
//create a hole for mysql on port 3306
iptables -I INPUT 1 -p tcp --dport 3306 -j ACCEPT
//save the hole for later
iptables-save > /etc/iptables.rules
... and allow remote access for mysql root user
I had to
1. Make sure the Firewall was open
2. Comment out the bind-address line in my.cnf
3. Allow remote access for mysql root user
mysql -u root -pAt the mysql command
GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '<MySQL root password>' WITH GRANT OPTION;NOTE: make sure to change to your actual password.
FLUSH PRIVILEGES;exit;based on http://benrobb.com/2007/01/15/howto-remote-root-access-to-mysql/
Warning!! This is not a secure solution. It opens MySQL for anyone to connect to who is on the internet. As long as you have a strong password this should be ok.
problem whit acqui
i need hel with this massege
PDOException: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13) in lock_may_be_available() (line 164 of /hermes/bosweb/web091/b916/ipg.chileproscom/acquia-drupal/includes/lock.inc).
My problem was that I had a
My problem was that I had a special character in my mysql password.
Aegir did not (I don't know now) deal with it very well.
Anietie Ekanem
Social Niche Guru Inc.
http://SocialNicheGuru.com
http://facebook.com/SocialNicheGuru