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)
