Hi, Ok this is how it goes 1) Check the vcld.conf file. You must have it installed at /etc/vcl/vcld.conf. This file has a field called as FQDN=localhost (This is basically the name of your management node which should be present in the management node table). 2) Connect to your mysql Database. mysql use vcl; select * from managementnode; (check the output of this mysql query, this will show you all the mangement node information. If this is empty you need to add one)
In order to add you can either use phpMyAdmin or using basic mysql query commands. Thanks Georgy On Wed, Oct 10, 2012 at 12:31 PM, <[email protected]> wrote: > 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 <[email protected]> > *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 ... >> >> - successfully included .ht-inc/conf.php >> >> Checking COOKIEDOMAIN setting in .ht-inc/conf.php ... >> >> - COOKIEDOMAIN (.lhu.pri) appears to be set correctly >> >> Checking that BASEURL in conf.php is set to use https ... >> >> - BASEURL correctly set to use https >> >> Checking that SCRIPT is set appropriately ... >> >> - SCRIPT appears to be set correctly >> >> Checking that .ht-inc/maintenance directory exists ... >> >> - /.ht-inc/maintenance directory exists >> >> Checking that .ht-inc/maintenance directory is writable ... >> >> - Maintenance directory is writable >> >> Testing for required php extensions ... >> >> - All required modules are installed >> >> Checking values in .ht-inc/secrets.php ... >> >> - all required values in .ht-inc/secrets.php appear to be set >> >> Testing mysql connection ... >> >> - Successfully connected to mysql on localhost >> - Successfully selected database (vcl) on localhost >> >> Testing phpseclib ... >> >> - Successfully encrypted test string >> - Successfully decrypted test string >> >> checking openssl encryption keys ... >> >> - successfully created private key from private key file >> - successfully created public key from public key file >> >> Testing openssl encryption ... >> >> - successfully encrypted test string >> - successfully decrypted test string >> >> Testing for existance of dojo directory ... >> >> - dojo directory exists >> - dojo directory is readable >> >> Checking value of PHP display_errors ... >> >> - display_errors: *disabled* >> - 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!* >> > >
