*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!*
