Re: unable to retrieve management node information from database -- please help
Hi Josh,
I've inserted the print stmt. as suggested and it looped back to the login
screen without displaying the message.
You mentioned that this behavior would indicate a non-cookie problem?
Please advise on any next steps, if possible.
** All help is appreciated as we work to get this project into a demo-ready
state. Time is of the essence to us
** as our Deans want to see a functional, working demo by the end of August!
vcld log follows..
==
unable to retrieve management node information from database
Time: 2010-08-11 14:29:01
PID: 28088
Caller: vcld:main(130)
( 0) utils.pm, notify (line: 737)
(-1) vcld, main (line: 130)
RECENT LOG ENTRIES FOR THIS PROCESS:
2010-08-11 14:29:01|28088|vcld:main(116)|vcld environment variable set to 1 for
this process
2010-08-11 14:29:01|28088|utils.pm:rename_vcld_process(7901)|renamed process to
'vcld vcld'
|28088| WARNING
|28088| 2010-08-11 14:29:01|28088|utils.pm:getnewdbh(3452)|unable to connect to
database, (1045) Access denied for user 'vcluser'@'bester.lsit.ucsb.edu' (using
password: YES)
|28088| ( 0) utils.pm, notify (line: 737)
|28088| (-1) utils.pm, getnewdbh (line: 3452)
|28088| (-2) utils.pm, database_select (line: 4822)
|28088| (-3) utils.pm, get_management_node_info (line: 6733)
|28088| (-4) vcld, main (line: 126)
|28088| WARNING
|28088| 2010-08-11 14:29:01|28088|utils.pm:getnewdbh(3452)|unable to connect to
database, (1045) Access denied for user 'vcluser'@'bester.lsit.ucsb.edu' (using
password: YES)
|28088| ( 0) utils.pm, notify (line: 737)
|28088| (-1) utils.pm, getnewdbh (line: 3452)
|28088| (-2) utils.pm, database_select (line: 4824)
|28088| (-3) utils.pm, get_management_node_info (line: 6733)
|28088| (-4) vcld, main (line: 126)
|28088| WARNING
|28088| 2010-08-11 14:29:01|28088|utils.pm:database_select(4825)|unable to
obtain database handle, Access denied for user 'vcluser'@'bester.lsit.ucsb.edu'
(using password: YES)
|28088| ( 0) utils.pm, notify (line: 737)
|28088| (-1) utils.pm, database_select (line: 4825)
|28088| (-2) utils.pm, get_management_node_info (line: 6733)
|28088| (-3) vcld, main (line: 126)
|28088| WARNING
|28088| 2010-08-11 14:29:01|28088|utils.pm:get_management_node_info(6737)|zero
rows were returned from database select, management node identifier may be
invalid: 'bester.lsit.ucsb.edu'
|28088| SELECT
|28088| managementnode.*,
|28088| resource.id AS resource_id,
|28088| predictivemodule.name AS predictive_name,
|28088| predictivemodule.prettyname AS predictive_prettyname,
|28088| predictivemodule.description AS predictive_description,
|28088| predictivemodule.perlpackage AS predictive_perlpackage,
|28088| state.name AS statename
|28088| FROM
|28088| managementnode,
|28088| module predictivemodule,
|28088| resource,
|28088| resourcetype,
|28088| state
|28088| WHERE
|28088| managementnode.predictivemoduleid = predictivemodule.id
|28088| AND managementnode.stateid = state.id
|28088| AND resource.resourcetypeid = resourcetype.id
|28088| AND resource.subid = managementnode.id
|28088| AND resourcetype.name = 'managementnode'
|28088| AND managementnode.hostname like 'bester.lsit.ucsb.edu%'
|28088| ( 0) utils.pm, notify (line: 737)
|28088| (-1) utils.pm, get_management_node_info (line: 6737)
|28088| (-2) vcld, main (line: 126)
=
-Randy.
On Aug 11, 2010, at 12:09 PM, Josh Thompson wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Wednesday August 11, 2010, Randy Sprague wrote:
>> Josh,
>>
>> Thanks for that quick reply!
>>
>> I ran 'testsetup.php' as suggested and it came back clean, but am still
>> unable to login via the management node.
>>
>> Please see the 'testsetup.php' results below:
>> ---
>
>
>
>> Checking COOKIEDOMAIN setting in .ht-inc/conf.php ...
>> COOKIEDOMAIN (bester.lsit.ucsb.edu) appears to be set correctly
>>
>> Checking that BASEURL in conf.php is set to use https ...
>
>
>
> Randy,
>
> In the quoted empty line above, right after the line that starts with
> 'COOKIEDOMAIN' there should be an iframe that attempts to set a cookie.
> Either the copy/paste didn't include the content of the iframe, or it failed
> to set the cookie. When you log in, VCL sets a cookie named VCLAUTH. If it
> cannot set that, it will keep redirecting you to the login page.
>
> You can check that the actual authentication is working or not by modifying
> .ht-inc/authentication.php. Look for the localLogin function. Just after
> the
> '//set cookie' comment add
>
> print 'authentication ok';
>
> and then comment out the line starting with 'header("Location:'.
>
> Next, try logging in. If it prints "authentication ok", then it is a cookie
> issue. If you get the login page again, it is another issue.
>
> Jo
Re: unable to retrieve management node information from database -- please help
Hi David, After thinking about your question, I did follow the instructions in INSTALLATION, which said to change the admin password from what had been set by default to one's own choice via: ' ** NOTE: Replace vcluserpassword with your own password!', So, yes, I actually did change that password to one of our choosing, but not since then. We were able to login using that changed password (after following the multi-step creation + hash procedure..) only one time and I used that opportunity to do some basic configuration. But after logging out, I've been unable to log back in since. A colleague suggested dropping the user table or localauth table and recreating them, following vcl's instructions for db installation, but I haven't gone there yet. Any and all suggestions or hints are welcome! All the best, Randy. On Aug 11, 2010, at 11:24 AM, David Abdurachmanov wrote: > Hi Randy, > > After installing VLC and setting it up, have you changed the password of > "admin" account? > > David > > On 2010.08.11, at 21:11, Randy Sprague wrote: > >> Josh, >> >> Thanks for that quick reply! >> >> I ran 'testsetup.php' as suggested and it came back clean, but am still >> unable to login via the management node. >> >> Please see the 'testsetup.php' results below: >> - >> PHP version: 5.2.13-pl0-gentoo >> >> Including .ht-inc/conf.php ... >> successfully included .ht-inc/conf.php >> Checking COOKIEDOMAIN setting in .ht-inc/conf.php ... >> COOKIEDOMAIN (bester.lsit.ucsb.edu) 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 >> 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 mcrypt ... >> 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 and dojoAjax directories ... >> dojoAjax directory exists >> dojoAjax directory is readable >> dojo directory exists >> dojo directory is readable >> Testing for existance of jpgraph directory ... >> .ht-inc/jpgraph directory exists >> .ht-inc/jpgraphdirectory is readable >> Checking value of PHP display_errors ... >> display_errors: enabled >> 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 >> >> -Randy >> == >> Randy Sprague, >> Instructional SysAdmin >> College of Letters & Sciences >> UC Santa Barbara >> (805) 722-4996 >> rspra...@lsit.ucsb.edu >> >> >> On Aug 11, 2010, at 9:42 AM, Randy Sprague wrote: >> >>> I'm a vcl newbie, installed it fresh on a gentoo 2.6.24-26.64 x64 linux >>> host for UCSB's College of Letters & Sciences. >>> Every since completing the installation of the management node, I was only >>> able to login one time successfully and >>> get the program configured for basic operations. Since that time, any >>> attempt to login as "admin" with the proper >>> password, has been rejected. >>> >>> vcld.log follows below: >>> unable to retrieve management node information from database >>> >>> Time: 2010-08-11 09:29:31 >>> PID: 24997 >>> Caller: vcld:main(130) >>> >>> ( 0) utils.pm, notify (line: 737) >>> (-1) vcld, main (line: 130) >>> >>> RECENT LOG ENTRIES FOR THIS PROCESS: >>> 2010-08-11 09:29:31|24997|vcld:main(116)|vcld environment variable set to 1 >>> for this process >>> 2010-08-11 09:29:31|24997|utils.pm:rename_vcld_process(7901)|renamed >>> process to 'vcld vcld' >>> |24997| WARNING >>> |24997| 2010-08-11 09:29:31|24997|utils.pm:getnewdbh(3452)|unable to >>> connect to database, (1045) Access denied for user >>> 'vcluser'@'bester.lsit.ucsb.edu' (using password: YES) >>> |24997| ( 0) utils.pm, notify (line: 737) >>> |24997| (-1) utils.pm, getnewdbh (line: 3452) >>> |24997| (-2) utils.pm, database_select (line: 4822) >>> |24997| (-3) utils.pm, get_management_node_info (line: 6733) >>> |24997| (-4) vcld, main (line: 126) >>> |24997| WARNING >>> |24997| 2010-08-11 09:29:31|24997|utils.pm:getnewdbh(3452)|unable to >>> connect to database, (1045) Access denied for user >>> 'vcluser'@'bester.lsit.ucsb.edu' (using password: YES) >>
Re: unable to retrieve management node information from database -- please help
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday August 11, 2010, Randy Sprague wrote:
> Josh,
>
> Thanks for that quick reply!
>
> I ran 'testsetup.php' as suggested and it came back clean, but am still
> unable to login via the management node.
>
> Please see the 'testsetup.php' results below:
> ---
> Checking COOKIEDOMAIN setting in .ht-inc/conf.php ...
> COOKIEDOMAIN (bester.lsit.ucsb.edu) appears to be set correctly
>
> Checking that BASEURL in conf.php is set to use https ...
Randy,
In the quoted empty line above, right after the line that starts with
'COOKIEDOMAIN' there should be an iframe that attempts to set a cookie.
Either the copy/paste didn't include the content of the iframe, or it failed
to set the cookie. When you log in, VCL sets a cookie named VCLAUTH. If it
cannot set that, it will keep redirecting you to the login page.
You can check that the actual authentication is working or not by modifying
.ht-inc/authentication.php. Look for the localLogin function. Just after the
'//set cookie' comment add
print 'authentication ok';
and then comment out the line starting with 'header("Location:'.
Next, try logging in. If it prints "authentication ok", then it is a cookie
issue. If you get the login page again, it is another issue.
Josh
- --
- ---
Josh Thompson
Systems Programmer
Advanced Computing | VCL Developer
North Carolina State University
josh_thomp...@ncsu.edu
919-515-5323
my GPG/PGP key can be found at pgp.mit.edu
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.14 (GNU/Linux)
iEYEARECAAYFAkxi9XYACgkQV/LQcNdtPQMBLQCdEWoWHylWrcQkqPCO/jxZRp+e
/AgAnjseeyToJTTGlrROrLcwMgojEecf
=msQQ
-END PGP SIGNATURE-
Re: unable to retrieve management node information from database -- please help
David, No sir, I did not. My boss has asked me to get a VCL prototype up and running and linked to our already created vmware ESX 4.1 server's datastore of 'ready-to-roll' Windows XP Desktop images that have all of UCSB's licensed lab software pre-installed on them. I've tested those images and they are fully accessible via RDP from off-campus, so I was hoping this would be fairly straightforward, but it hasn't. How realistic is it to expect that I'd have a working prototype by 8/31? -Randy. On Aug 11, 2010, at 11:24 AM, David Abdurachmanov wrote: > Hi Randy, > > After installing VLC and setting it up, have you changed the password of > "admin" account? > > David > > On 2010.08.11, at 21:11, Randy Sprague wrote: > >> Josh, >> >> Thanks for that quick reply! >> >> I ran 'testsetup.php' as suggested and it came back clean, but am still >> unable to login via the management node. >> >> Please see the 'testsetup.php' results below: >> - >> PHP version: 5.2.13-pl0-gentoo >> >> Including .ht-inc/conf.php ... >> successfully included .ht-inc/conf.php >> Checking COOKIEDOMAIN setting in .ht-inc/conf.php ... >> COOKIEDOMAIN (bester.lsit.ucsb.edu) 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 >> 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 mcrypt ... >> 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 and dojoAjax directories ... >> dojoAjax directory exists >> dojoAjax directory is readable >> dojo directory exists >> dojo directory is readable >> Testing for existance of jpgraph directory ... >> .ht-inc/jpgraph directory exists >> .ht-inc/jpgraphdirectory is readable >> Checking value of PHP display_errors ... >> display_errors: enabled >> 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 >> >> -Randy >> == >> Randy Sprague, >> Instructional SysAdmin >> College of Letters & Sciences >> UC Santa Barbara >> (805) 722-4996 >> rspra...@lsit.ucsb.edu >> >> >> On Aug 11, 2010, at 9:42 AM, Randy Sprague wrote: >> >>> I'm a vcl newbie, installed it fresh on a gentoo 2.6.24-26.64 x64 linux >>> host for UCSB's College of Letters & Sciences. >>> Every since completing the installation of the management node, I was only >>> able to login one time successfully and >>> get the program configured for basic operations. Since that time, any >>> attempt to login as "admin" with the proper >>> password, has been rejected. >>> >>> vcld.log follows below: >>> unable to retrieve management node information from database >>> >>> Time: 2010-08-11 09:29:31 >>> PID: 24997 >>> Caller: vcld:main(130) >>> >>> ( 0) utils.pm, notify (line: 737) >>> (-1) vcld, main (line: 130) >>> >>> RECENT LOG ENTRIES FOR THIS PROCESS: >>> 2010-08-11 09:29:31|24997|vcld:main(116)|vcld environment variable set to 1 >>> for this process >>> 2010-08-11 09:29:31|24997|utils.pm:rename_vcld_process(7901)|renamed >>> process to 'vcld vcld' >>> |24997| WARNING >>> |24997| 2010-08-11 09:29:31|24997|utils.pm:getnewdbh(3452)|unable to >>> connect to database, (1045) Access denied for user >>> 'vcluser'@'bester.lsit.ucsb.edu' (using password: YES) >>> |24997| ( 0) utils.pm, notify (line: 737) >>> |24997| (-1) utils.pm, getnewdbh (line: 3452) >>> |24997| (-2) utils.pm, database_select (line: 4822) >>> |24997| (-3) utils.pm, get_management_node_info (line: 6733) >>> |24997| (-4) vcld, main (line: 126) >>> |24997| WARNING >>> |24997| 2010-08-11 09:29:31|24997|utils.pm:getnewdbh(3452)|unable to >>> connect to database, (1045) Access denied for user >>> 'vcluser'@'bester.lsit.ucsb.edu' (using password: YES) >>> |24997| ( 0) utils.pm, notify (line: 737) >>> |24997| (-1) utils.pm, getnewdbh (line: 3452) >>> |24997| (-2) utils.pm, database_select (line: 4824) >>> |24997| (-3) utils.pm, get_management_node_info (line: 6733) >>> |24997| (-4) vcld, main (line: 126) >>> |24997| WARNING >>> |24997| 2010-08-11 09:29:31|24997|uti
Re: unable to retrieve management node information from database -- please help
Hi Randy, After installing VLC and setting it up, have you changed the password of "admin" account? David On 2010.08.11, at 21:11, Randy Sprague wrote: > Josh, > > Thanks for that quick reply! > > I ran 'testsetup.php' as suggested and it came back clean, but am still > unable to login via the management node. > > Please see the 'testsetup.php' results below: > - > PHP version: 5.2.13-pl0-gentoo > > Including .ht-inc/conf.php ... > successfully included .ht-inc/conf.php > Checking COOKIEDOMAIN setting in .ht-inc/conf.php ... > COOKIEDOMAIN (bester.lsit.ucsb.edu) 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 > 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 mcrypt ... > 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 and dojoAjax directories ... > dojoAjax directory exists > dojoAjax directory is readable > dojo directory exists > dojo directory is readable > Testing for existance of jpgraph directory ... > .ht-inc/jpgraph directory exists > .ht-inc/jpgraphdirectory is readable > Checking value of PHP display_errors ... > display_errors: enabled > 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 > > -Randy > == > Randy Sprague, > Instructional SysAdmin > College of Letters & Sciences > UC Santa Barbara > (805) 722-4996 > rspra...@lsit.ucsb.edu > > > On Aug 11, 2010, at 9:42 AM, Randy Sprague wrote: > >> I'm a vcl newbie, installed it fresh on a gentoo 2.6.24-26.64 x64 linux host >> for UCSB's College of Letters & Sciences. >> Every since completing the installation of the management node, I was only >> able to login one time successfully and >> get the program configured for basic operations. Since that time, any >> attempt to login as "admin" with the proper >> password, has been rejected. >> >> vcld.log follows below: >> unable to retrieve management node information from database >> >> Time: 2010-08-11 09:29:31 >> PID: 24997 >> Caller: vcld:main(130) >> >> ( 0) utils.pm, notify (line: 737) >> (-1) vcld, main (line: 130) >> >> RECENT LOG ENTRIES FOR THIS PROCESS: >> 2010-08-11 09:29:31|24997|vcld:main(116)|vcld environment variable set to 1 >> for this process >> 2010-08-11 09:29:31|24997|utils.pm:rename_vcld_process(7901)|renamed process >> to 'vcld vcld' >> |24997| WARNING >> |24997| 2010-08-11 09:29:31|24997|utils.pm:getnewdbh(3452)|unable to connect >> to database, (1045) Access denied for user 'vcluser'@'bester.lsit.ucsb.edu' >> (using password: YES) >> |24997| ( 0) utils.pm, notify (line: 737) >> |24997| (-1) utils.pm, getnewdbh (line: 3452) >> |24997| (-2) utils.pm, database_select (line: 4822) >> |24997| (-3) utils.pm, get_management_node_info (line: 6733) >> |24997| (-4) vcld, main (line: 126) >> |24997| WARNING >> |24997| 2010-08-11 09:29:31|24997|utils.pm:getnewdbh(3452)|unable to connect >> to database, (1045) Access denied for user 'vcluser'@'bester.lsit.ucsb.edu' >> (using password: YES) >> |24997| ( 0) utils.pm, notify (line: 737) >> |24997| (-1) utils.pm, getnewdbh (line: 3452) >> |24997| (-2) utils.pm, database_select (line: 4824) >> |24997| (-3) utils.pm, get_management_node_info (line: 6733) >> |24997| (-4) vcld, main (line: 126) >> |24997| WARNING >> |24997| 2010-08-11 09:29:31|24997|utils.pm:database_select(4825)|unable to >> obtain database handle, Access denied for user >> 'vcluser'@'bester.lsit.ucsb.edu' (using password: YES) >> |24997| ( 0) utils.pm, notify (line: 737) >> |24997| (-1) utils.pm, database_select (line: 4825) >> |24997| (-2) utils.pm, get_management_node_info (line: 6733) >> |24997| (-3) vcld, main (line: 126) >> |24997| WARNING >> |24997| 2010-08-11 >> 09:29:31|24997|utils.pm:get_management_node_info(6737)|zero rows were >> returned from database select, management node identifier may be invalid: >> 'bester.lsit.ucsb.edu' >> |24997| SELECT >> |24997| managementnode.*, >> |24997| resource.id AS resource_id, >> |24997| predictivemod
Re: unable to retrieve management node information from database -- please help
Josh, Thanks for that quick reply! I ran 'testsetup.php' as suggested and it came back clean, but am still unable to login via the management node. Please see the 'testsetup.php' results below: - PHP version: 5.2.13-pl0-gentoo Including .ht-inc/conf.php ... successfully included .ht-inc/conf.php Checking COOKIEDOMAIN setting in .ht-inc/conf.php ... COOKIEDOMAIN (bester.lsit.ucsb.edu) 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 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 mcrypt ... 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 and dojoAjax directories ... dojoAjax directory exists dojoAjax directory is readable dojo directory exists dojo directory is readable Testing for existance of jpgraph directory ... .ht-inc/jpgraph directory exists .ht-inc/jpgraphdirectory is readable Checking value of PHP display_errors ... display_errors: enabled 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 -Randy == Randy Sprague, Instructional SysAdmin College of Letters & Sciences UC Santa Barbara (805) 722-4996 rspra...@lsit.ucsb.edu On Aug 11, 2010, at 9:42 AM, Randy Sprague wrote: > I'm a vcl newbie, installed it fresh on a gentoo 2.6.24-26.64 x64 linux host > for UCSB's College of Letters & Sciences. > Every since completing the installation of the management node, I was only > able to login one time successfully and > get the program configured for basic operations. Since that time, any > attempt to login as "admin" with the proper > password, has been rejected. > > vcld.log follows below: > unable to retrieve management node information from database > > Time: 2010-08-11 09:29:31 > PID: 24997 > Caller: vcld:main(130) > > ( 0) utils.pm, notify (line: 737) > (-1) vcld, main (line: 130) > > RECENT LOG ENTRIES FOR THIS PROCESS: > 2010-08-11 09:29:31|24997|vcld:main(116)|vcld environment variable set to 1 > for this process > 2010-08-11 09:29:31|24997|utils.pm:rename_vcld_process(7901)|renamed process > to 'vcld vcld' > |24997| WARNING > |24997| 2010-08-11 09:29:31|24997|utils.pm:getnewdbh(3452)|unable to connect > to database, (1045) Access denied for user 'vcluser'@'bester.lsit.ucsb.edu' > (using password: YES) > |24997| ( 0) utils.pm, notify (line: 737) > |24997| (-1) utils.pm, getnewdbh (line: 3452) > |24997| (-2) utils.pm, database_select (line: 4822) > |24997| (-3) utils.pm, get_management_node_info (line: 6733) > |24997| (-4) vcld, main (line: 126) > |24997| WARNING > |24997| 2010-08-11 09:29:31|24997|utils.pm:getnewdbh(3452)|unable to connect > to database, (1045) Access denied for user 'vcluser'@'bester.lsit.ucsb.edu' > (using password: YES) > |24997| ( 0) utils.pm, notify (line: 737) > |24997| (-1) utils.pm, getnewdbh (line: 3452) > |24997| (-2) utils.pm, database_select (line: 4824) > |24997| (-3) utils.pm, get_management_node_info (line: 6733) > |24997| (-4) vcld, main (line: 126) > |24997| WARNING > |24997| 2010-08-11 09:29:31|24997|utils.pm:database_select(4825)|unable to > obtain database handle, Access denied for user > 'vcluser'@'bester.lsit.ucsb.edu' (using password: YES) > |24997| ( 0) utils.pm, notify (line: 737) > |24997| (-1) utils.pm, database_select (line: 4825) > |24997| (-2) utils.pm, get_management_node_info (line: 6733) > |24997| (-3) vcld, main (line: 126) > |24997| WARNING > |24997| 2010-08-11 > 09:29:31|24997|utils.pm:get_management_node_info(6737)|zero rows were > returned from database select, management node identifier may be invalid: > 'bester.lsit.ucsb.edu' > |24997| SELECT > |24997| managementnode.*, > |24997| resource.id AS resource_id, > |24997| predictivemodule.name AS predictive_name, > |24997| predictivemodule.prettyname AS predictive_prettyname, > |24997| predictivemodule.description AS predictive_description, > |24997| predictivemodule.perlpackage AS predictive_perlpackage, > |24997| state.name AS statename > |24997| FROM > |24997| managementnode, > |24997| module predictivemodule, > |24
Uday K Cholleti is out of the office.
I will be out of the office starting 08/11/2010 and will not return until 08/12/2010. I will respond to your message when I return.
Re: unable to retrieve management node information from database -- please help
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday August 11, 2010, Randy Sprague wrote: > I'm a vcl newbie, installed it fresh on a gentoo 2.6.24-26.64 x64 linux > host for UCSB's College of Letters & Sciences. Every since completing the > installation of the management node, I was only able to login one time > successfully and get the program configured for basic operations. Since > that time, any attempt to login as "admin" with the proper password, has > been rejected. > > vcld.log follows below: Randy, Try loading the testsetup.php page. It should be in the same directory as the index.php page. Since you cannot log in and the management node cannot connect to the database, it sounds like you may have an issue with mysql. The testsetup.php page will attempt to connect to mysql and report any errors if it cannot. Josh - -- - --- Josh Thompson Systems Programmer Advanced Computing | VCL Developer North Carolina State University josh_thomp...@ncsu.edu 919-515-5323 my GPG/PGP key can be found at pgp.mit.edu -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.14 (GNU/Linux) iEYEARECAAYFAkxi2WsACgkQV/LQcNdtPQN4WwCcDy/wGH4VdKtk1xbeZyEHO0UJ 4LcAn3mbWASmHVbbUpPmCQr7qR1Yt7CN =PryI -END PGP SIGNATURE-
unable to retrieve management node information from database -- please help
I'm a vcl newbie, installed it fresh on a gentoo 2.6.24-26.64 x64 linux host for UCSB's College of Letters & Sciences. Every since completing the installation of the management node, I was only able to login one time successfully and get the program configured for basic operations. Since that time, any attempt to login as "admin" with the proper password, has been rejected. vcld.log follows below: unable to retrieve management node information from database Time: 2010-08-11 09:29:31 PID: 24997 Caller: vcld:main(130) ( 0) utils.pm, notify (line: 737) (-1) vcld, main (line: 130) RECENT LOG ENTRIES FOR THIS PROCESS: 2010-08-11 09:29:31|24997|vcld:main(116)|vcld environment variable set to 1 for this process 2010-08-11 09:29:31|24997|utils.pm:rename_vcld_process(7901)|renamed process to 'vcld vcld' |24997| WARNING |24997| 2010-08-11 09:29:31|24997|utils.pm:getnewdbh(3452)|unable to connect to database, (1045) Access denied for user 'vcluser'@'bester.lsit.ucsb.edu' (using password: YES) |24997| ( 0) utils.pm, notify (line: 737) |24997| (-1) utils.pm, getnewdbh (line: 3452) |24997| (-2) utils.pm, database_select (line: 4822) |24997| (-3) utils.pm, get_management_node_info (line: 6733) |24997| (-4) vcld, main (line: 126) |24997| WARNING |24997| 2010-08-11 09:29:31|24997|utils.pm:getnewdbh(3452)|unable to connect to database, (1045) Access denied for user 'vcluser'@'bester.lsit.ucsb.edu' (using password: YES) |24997| ( 0) utils.pm, notify (line: 737) |24997| (-1) utils.pm, getnewdbh (line: 3452) |24997| (-2) utils.pm, database_select (line: 4824) |24997| (-3) utils.pm, get_management_node_info (line: 6733) |24997| (-4) vcld, main (line: 126) |24997| WARNING |24997| 2010-08-11 09:29:31|24997|utils.pm:database_select(4825)|unable to obtain database handle, Access denied for user 'vcluser'@'bester.lsit.ucsb.edu' (using password: YES) |24997| ( 0) utils.pm, notify (line: 737) |24997| (-1) utils.pm, database_select (line: 4825) |24997| (-2) utils.pm, get_management_node_info (line: 6733) |24997| (-3) vcld, main (line: 126) |24997| WARNING |24997| 2010-08-11 09:29:31|24997|utils.pm:get_management_node_info(6737)|zero rows were returned from database select, management node identifier may be invalid: 'bester.lsit.ucsb.edu' |24997| SELECT |24997| managementnode.*, |24997| resource.id AS resource_id, |24997| predictivemodule.name AS predictive_name, |24997| predictivemodule.prettyname AS predictive_prettyname, |24997| predictivemodule.description AS predictive_description, |24997| predictivemodule.perlpackage AS predictive_perlpackage, |24997| state.name AS statename |24997| FROM |24997| managementnode, |24997| module predictivemodule, |24997| resource, |24997| resourcetype, |24997| state |24997| WHERE |24997| managementnode.predictivemoduleid = predictivemodule.id |24997| AND managementnode.stateid = state.id |24997| AND resource.resourcetypeid = resourcetype.id |24997| AND resource.subid = managementnode.id |24997| AND resourcetype.name = 'managementnode' |24997| AND managementnode.hostname like 'bester.lsit.ucsb.edu%' |24997| ( 0) utils.pm, notify (line: 737) |24997| (-1) utils.pm, get_management_node_info (line: 6737) |24997| (-2) vcld, main (line: 126)
