Tran, Backing up a bit from what Georgy mentioned, I think the problem is with vcld accessing the database at all.
> *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)
This shows that the mysql username/password/host combination is not working to
log in to mysql.
>
> *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';
Here you granted access to vcluser, coming from localhost, with a password of
vclpass.
> 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
When you add your management node to the VCL web site under the "Management
Nodes" section, what you entered for Hostname there needs to match what you
enter for FQDN above.
> # database: name of MySQL database (required)
> database=vcl
>
> # server: IP address or FQDN of the database server (required)
> server=192.168.1.20
Here you are telling vcld to connect to the mysql database on 192.168.1.20.
I'm going to assume 192.168.1.20 is an address on your management node. Using
that address is going to make vcld use 192.168.1.20 as the address from which
it will connect to mysql. However, further up, in your GRANT statement, you
gave the vcluser access coming from the localhost address. So, changing
server= above to server=localhost should fix your problem.
Josh
--
-------------------------------
Josh Thompson
Systems Programmer
Advanced Computing | VCL Developer
North Carolina State University
[email protected]
919-515-5323
my GPG/PGP key can be found at pgp.mit.edu
All electronic mail messages in connection with State business which
are sent to or received by this account are subject to the NC Public
Records Law and may be disclosed to third parties.
signature.asc
Description: This is a digitally signed message part.
