Forums/Cloud Foundry Forums/Archived: CloudFoundry.org (OSS) Q&A
mysql node not starting
Preben Asmussen
asked this on December 13, 2011 01:40
I have successfully installed CF, but have a problem regarding mysql_node.
Mysql_gateway is started but the mysql_node is stopped.
I see an error in /tmp/vcap-run/mysql_node.log - see below
I guess the user or password is wrong.
Where is the user/password stored, and how can I set the correct user/password ?
INFO -- : MyaaS-Node: Initializing
E, [2011-12-08T15:07:34.764946 #32258] ERROR -- : MySQL connection attempt failed: [1045] Access denied for user 'root'@'localhost' (using password: YES)
E, [2011-12-08T15:07:39.765516 #32258] ERROR -- : MySQL connection attempt failed: [1045] Access denied for user 'root'@'localhost' (using password: YES)
E, [2011-12-08T15:07:44.766147 #32258] ERROR -- : MySQL connection attempt failed: [1045] Access denied for user 'root'@'localhost' (using password: YES)
E, [2011-12-08T15:07:49.766751 #32258] ERROR -- : MySQL connection attempt failed: [1045] Access denied for user 'root'@'localhost' (using password: YES)
E, [2011-12-08T15:07:54.767358 #32258] ERROR -- : MySQL connection attempt failed: [1045] Access denied for user 'root'@'localhost' (using password: YES)
F, [2011-12-08T15:07:59.767780 #32258] FATAL -- : MySQL connection unrecoverable
I, [2011-12-08T15:07:59.767941 #32258] INFO -- : MyaaS-Node: Shutting down
Comments
Hi Preben,
The username and password is stored in the mysql_node.yml config file. If you used the 'vcap_setup' script to install Cloud Foundry, this should be located under $HOME/cloudfoundry/vcap/services/mysql/config/.
Look for a section similar to:
You can change the password in MySQL using one of the methods here: http://www.cyberciti.biz/faq/mysql-change-root-password/
Glenn,
I changed the password to root using the link you provided just to be sure that it matches with mysql_node.yml but I still get the above logs.
Vyas,
Are you able to connect using the 'mysql' client from the the machine running the MySQL node?
What happens? And what method did you use to install Cloud Foundry? The Chef scripts under vcap/dev_setup or the script under vcap/setup?
I was able to connect using the mysql client.
I tried a lot of other things that I found online including giving privileges and changing password, going through logs and config. What worked is I uninstalled mysql and ran the vcap_dev_setup once again. Maybe mysql was not installed correctly or was installed manually
How did you manage to uninstall mysql ? Is there a vcap command ?
http://stuffthatspins.com/2011/01/08/ubuntu-10-x-completely-remove-and-clean-mysql-installation/