Hi! Thank you for your incredible fast reply. As I mentioned i ‘m totally new at this and since I just get started working with Linux system, could you please tell me or at least point me to a guide where I could “Make sure my managementnode table is not empty and has one management node information”
Thank you in advance! From: FNU Georgy Mathew Kallumkal Sent: Wednesday, October 10, 2012 11:25 PM To: [email protected] Subject: Re: unable to retrieve management node information from database Hi, when you start the vcld service, it does a mysql query into the vcl database (management node table). Make sure your managementnode table is not empty and has one management node information. This error is normally thrown when it cannot get information of the management node from the mysql database -Georgy On Wed, Oct 10, 2012 at 12:21 PM, Tran Vu <[email protected]> wrote: Hi! As my project is setting up an VCL for my school,I'm total newbie in VCL. Right now i'm stuck at the Install and Start the VCL Daemon (vcld) Service I've been researching, reinstalling the whole thing for serveral times with different values in the configuration file but it's still the same. I used the guide in the main page, everything is fine untill i run the tail -f /var/log/vcld.log i got [root@vcl ~]# tail -f /var/log/vcld.log |7965| AND resourcetype.name = 'managementnode' |7965| AND managementnode.hostname REGEXP '^vcl.lhu.pri(\\.|$)' |7965| ( 0) utils.pm, get_management_node_info (line: 5540) |7965| (-2) vcld, main (line: 131) |7965| ---- CRITICAL ---- |7965| 2012-10-09 16:08:06|7965|vcld:main(131)|unable to retrieve management node information from database |7965| ( 0) vcld, main (line: 131) the full log is: 2012-10-09 16:08:06|7962|utils.pm:get_management_node_info(5477)|initializing management node info hash reference 2012-10-09 16:08:06|7962|utils.pm:get_management_node_info(5493)|management node info for 'vcl.lhu.pri' is not stored in $ENV{management_node_info} |7962| ---- WARNING ---- |7962| 2012-10-09 16:08:06|7962|utils.pm:getnewdbh(2586)|unable to connect to database, (1045) Access denied for user 'vcluser'@'vcl.lhu.pri' (using password: YES) |7962| ( 0) utils.pm, getnewdbh (line: 2586) |7962| (-1) utils.pm, database_select (line: 3830) |7962| (-2) utils.pm, get_management_node_info (line: 5536) |7962| ---- WARNING ---- |7962| 2012-10-09 16:08:06|7962|utils.pm:getnewdbh(2586)|unable to connect to database, (1045) Access denied for user 'vcluser'@'vcl.lhu.pri' (using password: YES) |7962| ( 0) utils.pm, getnewdbh (line: 2586) |7962| (-1) utils.pm, database_select (line: 3832) |7962| (-2) utils.pm, get_management_node_info (line: 5536) |7962| ---- WARNING ---- |7962| 2012-10-09 16:08:06|7962|utils.pm:database_select(3833)|unable to obtain database handle, Access denied for user 'vcluser'@'vcl.lhu.pri' (using password: YES) |7962| ( 0) utils.pm, database_select (line: 3833) |7962| (-1) utils.pm, get_management_node_info (line: 5536) |7962| ---- WARNING ---- |7962| 2012-10-09 16:08:06|7962|utils.pm:get_management_node_info(5540)|zero rows were returned from database select, management node identifier may be invalid: 'vcl.lhu.pri' |7962| SELECT |7962| managementnode.*, |7962| resource.id AS resource_id, |7962| predictivemodule.name AS predictive_name, |7962| predictivemodule.prettyname AS predictive_prettyname, |7962| predictivemodule.description AS predictive_description, |7962| predictivemodule.perlpackage AS predictive_perlpackage, |7962| state.name AS statename |7962| FROM |7962| managementnode, |7962| module predictivemodule, |7962| resource, |7962| resourcetype, |7962| state |7962| WHERE |7962| managementnode.predictivemoduleid = predictivemodule.id |7962| AND managementnode.stateid = state.id |7962| AND resource.resourcetypeid = resourcetype.id |7962| AND resource.subid = managementnode.id |7962| AND resourcetype.name = 'managementnode' |7962| AND managementnode.hostname REGEXP '^vcl.lhu.pri(\\.|$)' |7962| ( 0) utils.pm, get_management_node_info (line: 5540) ============================================================================ VCL Management Node Daemon (vcld) | 2012-10-09 16:08:06 ============================================================================ bin path: /usr/local/vcl/bin config file: /etc/vcl/vcld.conf log file: /var/log/vcld.log pid file: /var/run/vcld.pid daemon mode: 1 setup mode: 0 verbose mode: 1 ============================================================================ ============================================================================ VCL Management Node Daemon (vcld) | 2012-10-09 16:08:06 ============================================================================ bin path: /usr/local/vcl/bin config file: /etc/vcl/vcld.conf log file: /var/log/vcld.log pid file: /var/run/vcld.pid daemon mode: 1 setup mode: 0 verbose mode: 1 ============================================================================ Created VCL daemon process: 7965 2012-10-09 16:08:06|7965|utils.pm:rename_vcld_process(6823)|renamed process to 'vcld' 2012-10-09 16:08:06|7965|vcld:main(120)|vcld environment variable set to 1 for this process 2012-10-09 16:08:06|7965|utils.pm:get_management_node_info(5493)|management node info for 'vcl.lhu.pri' is not stored in $ENV{management_node_info} |7965| ---- WARNING ---- |7965| 2012-10-09 16:08:06|7965|utils.pm:getnewdbh(2586)|unable to connect to database, (1045) Access denied for user 'vcluser'@'vcl.lhu.pri' (using password: YES) |7965| ( 0) utils.pm, getnewdbh (line: 2586) |7965| (-1) utils.pm, database_select (line: 3830) |7965| (-2) utils.pm, get_management_node_info (line: 5536) |7965| (-3) vcld, main (line: 127) |7965| ---- WARNING ---- |7965| 2012-10-09 16:08:06|7965|utils.pm:getnewdbh(2586)|unable to connect to database, (1045) Access denied for user 'vcluser'@'vcl.lhu.pri' (using password: YES) |7965| ( 0) utils.pm, getnewdbh (line: 2586) |7965| (-1) utils.pm, database_select (line: 3832) |7965| (-2) utils.pm, get_management_node_info (line: 5536) |7965| (-3) vcld, main (line: 127) |7965| ---- WARNING ---- |7965| 2012-10-09 16:08:06|7965|utils.pm:database_select(3833)|unable to obtain database handle, Access denied for user 'vcluser'@'vcl.lhu.pri' (using password: YES) |7965| ( 0) utils.pm, database_select (line: 3833) |7965| (-1) utils.pm, get_management_node_info (line: 5536) |7965| (-2) vcld, main (line: 127) |7965| ---- WARNING ---- |7965| 2012-10-09 16:08:06|7965|utils.pm:get_management_node_info(5540)|zero rows were returned from database select, management node identifier may be invalid: 'vcl.lhu.pri' |7965| SELECT |7965| managementnode.*, |7965| resource.id AS resource_id, |7965| predictivemodule.name AS predictive_name, |7965| predictivemodule.prettyname AS predictive_prettyname, |7965| predictivemodule.description AS predictive_description, |7965| predictivemodule.perlpackage AS predictive_perlpackage, |7965| state.name AS statename |7965| FROM |7965| managementnode, |7965| module predictivemodule, |7965| resource, |7965| resourcetype, |7965| state |7965| WHERE |7965| managementnode.predictivemoduleid = predictivemodule.id |7965| AND managementnode.stateid = state.id |7965| AND resource.resourcetypeid = resourcetype.id |7965| AND resource.subid = managementnode.id |7965| AND resourcetype.name = 'managementnode' |7965| AND managementnode.hostname REGEXP '^vcl.lhu.pri(\\.|$)' |7965| ( 0) utils.pm, get_management_node_info (line: 5540) |7965| (-1) vcld, main (line: 127) 2012-10-09 16:08:06|7965|utils.pm:get_management_node_info(5493)|management node info for 'vcl.lhu.pri' is not stored in $ENV{management_node_info} |7965| ---- WARNING ---- |7965| 2012-10-09 16:08:06|7965|utils.pm:getnewdbh(2586)|unable to connect to database, (1045) Access denied for user 'vcluser'@'vcl.lhu.pri' (using password: YES) |7965| ( 0) utils.pm, getnewdbh (line: 2586) |7965| (-1) utils.pm, database_select (line: 3830) |7965| (-2) utils.pm, get_management_node_info (line: 5536) |7965| (-4) vcld, main (line: 131) |7965| ---- WARNING ---- |7965| 2012-10-09 16:08:06|7965|utils.pm:getnewdbh(2586)|unable to connect to database, (1045) Access denied for user 'vcluser'@'vcl.lhu.pri' (using password: YES) |7965| ( 0) utils.pm, getnewdbh (line: 2586) |7965| (-1) utils.pm, database_select (line: 3832) |7965| (-2) utils.pm, get_management_node_info (line: 5536) |7965| (-4) vcld, main (line: 131) |7965| ---- WARNING ---- |7965| 2012-10-09 16:08:06|7965|utils.pm:database_select(3833)|unable to obtain database handle, Access denied for user 'vcluser'@'vcl.lhu.pri' (using password: YES) |7965| ( 0) utils.pm, database_select (line: 3833) |7965| (-1) utils.pm, get_management_node_info (line: 5536) |7965| (-3) vcld, main (line: 131) |7965| ---- WARNING ---- |7965| 2012-10-09 16:08:06|7965|utils.pm:get_management_node_info(5540)|zero rows were returned from database select, management node identifier may be invalid: 'vcl.lhu.pri' |7965| SELECT |7965| managementnode.*, |7965| resource.id AS resource_id, |7965| predictivemodule.name AS predictive_name, |7965| predictivemodule.prettyname AS predictive_prettyname, |7965| predictivemodule.description AS predictive_description, |7965| predictivemodule.perlpackage AS predictive_perlpackage, |7965| state.name AS statename |7965| FROM |7965| managementnode, |7965| module predictivemodule, |7965| resource, |7965| resourcetype, |7965| state |7965| WHERE |7965| managementnode.predictivemoduleid = predictivemodule.id |7965| AND managementnode.stateid = state.id |7965| AND resource.resourcetypeid = resourcetype.id |7965| AND resource.subid = managementnode.id |7965| AND resourcetype.name = 'managementnode' |7965| AND managementnode.hostname REGEXP '^vcl.lhu.pri(\\.|$)' |7965| ( 0) utils.pm, get_management_node_info (line: 5540) |7965| (-2) vcld, main (line: 131) |7965| ---- CRITICAL ---- |7965| 2012-10-09 16:08:06|7965|vcld:main(131)|unable to retrieve management node information from database |7965| ( 0) vcld, main (line: 131) This is what i set for the database creation CREATE DATABASE vcl; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE TEMPORARY TABLES ON vcl.* TO 'vcluser'@'localhost' IDENTIFIED BY 'vclpass'; This is what i set for the secrets file $vclhost = 'localhost'; # name of mysql server $vcldb = 'vcl'; # name of mysql database $vclusername = 'vcluser'; # username to access database $vclpassword = 'vclpass'; # password to access database $cryptkey = 'vcl'; # random password - won't ever have to type it so make it long $pemkey = 'vcl'; # random passphrase - same as given to genkeys.sh - should be long ?> This is what i set for the conf.php ################ Things in this section must be modified ##################### define("BASEURL", "https://vcl.lhu.pri/vcl";); // no trailing slash - all of the URL except /index.php define("SCRIPT", "/index.php"); // this should only be "/index.php" unless you rename index.php to something else define("HELPURL", "https://vcl.lhu.pri/help/";); // URL pointed to by the "Help" link in the navigation area define("HELPEMAIL", "[email protected]"); // if an unexpected error occurs, users will be prompted that they can email // this address for further assistance define("ERROREMAIL", "[email protected]"); // if an unexpected error occurs, the code will send an email about it to // to this address define("ENVELOPESENDER", "[email protected]"); // email address for envelope sender of mail messages // if a message gets bounced, it goes to this address define("COOKIEDOMAIN", ".lhu.pri"); // domain in which cookies are set define("HOMEURL", "http://vcl.lhu.pri/";); // url to go to when someone clicks HOME or Logout date_default_timezone_set('America/New_York'); // set this to your timezone; a list of available values can // be found at http://php.net/manual/en/timezones.php i ran the testphp came back clean every thing is green, i can access the web page and set up management node and change the password admin PHP version: 5.3.3 Including .ht-inc/conf.php ... a.. successfully included .ht-inc/conf.php Checking COOKIEDOMAIN setting in .ht-inc/conf.php ... a.. COOKIEDOMAIN (.lhu.pri) appears to be set correctly Checking that BASEURL in conf.php is set to use https ... a.. BASEURL correctly set to use https Checking that SCRIPT is set appropriately ... a.. SCRIPT appears to be set correctly Checking that .ht-inc/maintenance directory exists ... a.. /.ht-inc/maintenance directory exists Checking that .ht-inc/maintenance directory is writable ... a.. Maintenance directory is writable Testing for required php extensions ... a.. All required modules are installed Checking values in .ht-inc/secrets.php ... a.. all required values in .ht-inc/secrets.php appear to be set Testing mysql connection ... a.. Successfully connected to mysql on localhost b.. Successfully selected database (vcl) on localhost Testing phpseclib ... a.. Successfully encrypted test string b.. Successfully decrypted test string checking openssl encryption keys ... a.. successfully created private key from private key file b.. successfully created public key from public key file Testing openssl encryption ... a.. successfully encrypted test string b.. successfully decrypted test string Testing for existance of dojo directory ... a.. dojo directory exists b.. dojo directory is readable Checking value of PHP display_errors ... a.. display_errors: disabled b.. NOTE: Displaying errors in a production system is a security risk; however, while getting VCL up and running, having them displayed makes debugging a little easier. Edit your php.ini file to modify this setting. Done This is what i set for the vcld.conf ############# REQUIRED Configuration settings ################ # FQDN: DNS name of the management node # Example: mgtnode1.hpc.someschool.edu FQDN=vcl.lhu.pri # processname: name to call VCL daemon process # Default: vcld processname=vcld # log: log file location # Default: /var/log/vcld.log # If left undefined it will be named according to the above processname # i.e. /var/log/$PROCESSNAME.log log=/var/log/vcld.log # pidfile: process id file location # Default: /var/run/vcld.pid # If left undefined it will be named according to the above processname # i.e. /var/run/$PROCESSNAME.pid pidfile=/var/run/vcld.pid # Database connection information # database: name of MySQL database (required) database=vcl # server: IP address or FQDN of the database server (required) server=192.168.1.20 # LockerWrtUser: MySQL user account name with write privileges (required) LockerWrtUser=vcluser # wrtPass: MySQL password of the above LockerWrtUser (required) # Any length is supported by MySQL # Must be a string of characters: A-Z a-z 0-9 wrtPass=vclpass # xml-rpc username password and url information # Required for block reservation processing # xmlrpc_username must be the unityid field for a user in the user table # xmlrpc_pass is that user's password # the URL will be the URL of your VCL website with a few things on the end # for example, if you install the VCL web code at https://vcl.example.org/vcl/ # set xmlrpc_url to https://vcl.example.org/vcl/index.php?mode=xmlrpccall xmlrpc_username=vclsystem@Local xmlrpc_pass=insecureDefault xmlrpc_url=https://vcl.lhu.pri/vcl/index.php?mode=xmlrpccall ######### END REQUIRED Configuration settings ############## Thank you for taking time reading my email. Any sugguestion is really appriciated!
