You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@vcl.apache.org by Toan Trac <tr...@gmail.com> on 2013/06/19 01:40:11 UTC
vcld.log
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)
Re: vcld.log
Posted by Toan Trac <tr...@gmail.com>.
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 <
pablo.rebollo@upr.edu> 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 <tr...@gmail.com> 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)
>
>
>
Re: vcld.log
Posted by "Pablo J. Rebollo Sosa" <pa...@upr.edu>.
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 <tr...@gmail.com> 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)