Thank you. I reviewed it late last night and caught the mistake you mentioned. I changed it to "localhost".
On Wed, Jun 19, 2013 at 3:25 AM, Pablo J. Rebollo Sosa < [email protected]> wrote: > Be sure your MySQL is accessible. Notice that you can't connect to the DB > from 192.168.128.136 if you create the database using "localhost". The > localhost option is used when both the management node and the MySQL are > installed on the same server. > > > GRANT SELECT,INSERT,UPDATE,DELETE,CREATE TEMPORARY TABLES ON vcl.* TO > 'vcluser'@'localhost' > IDENTIFIED BY 'vcluserpassword'; > > Pablo > > > On Jun 18, 2013, at 7:40 PM, Toan Trac <[email protected]> wrote: > > Hello, > > i am getting this error log. I have followed the instructions from the > guide. I disabled selinux. Any idea? Is it my hostname set to localhost? > > log: > > > |2338| ---- WARNING ---- > |2338| 2013-06-18 16:06:11|2338|utils.pm:database_select(3795)|unable to > obtain database handle, Host '192.168.128.136' is not allowed to connect to > this MySQL server > |2338| ( 0) utils.pm, database_select (line: 3795) > |2338| (-1) utils.pm, get_management_node_info (line: 5503) > |2338| (-3) vcld, main (line: 131) > > > |2338| ---- WARNING ---- > |2338| 2013-06-18 16:06:11|2338|utils.pm:get_management_node_info(5507)|zero > rows were returned from database select, management node identifier may be > invalid: 'localhost' > |2338| SELECT > |2338| managementnode.*, > |2338| resource.id AS resource_id, > |2338| predictivemodule.name AS predictive_name, > |2338| predictivemodule.prettyname AS predictive_prettyname, > |2338| predictivemodule.description AS predictive_description, > |2338| predictivemodule.perlpackage AS predictive_perlpackage, > |2338| state.name AS statename > |2338| FROM > |2338| managementnode, > |2338| module predictivemodule, > |2338| resource, > |2338| resourcetype, > |2338| state > |2338| WHERE > |2338| managementnode.predictivemoduleid = predictivemodule.id > |2338| AND managementnode.stateid = state.id > |2338| AND resource.resourcetypeid = resourcetype.id > |2338| AND resource.subid = managementnode.id > |2338| AND resourcetype.name = 'managementnode' > |2338| AND managementnode.hostname REGEXP '^localhost(\\.|$)' > |2338| ( 0) utils.pm, get_management_node_info (line: 5507) > |2338| (-2) vcld, main (line: 131) > > > |2338| ---- CRITICAL ---- > |2338| 2013-06-18 16:05:51|2338|vcld:main(131)|unable to retrieve > management node information from database > |2338| ( 0) vcld, main (line: 131) > > >
