Re: unable to retrieve management node information from database -- please help
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Randy, I'd say at the point it would be a good idea to create a new database in mysql using the vcl.sql file. Then, modify secrets.php and vcld.conf to point to the new database. Also, make sure to grant the database account you've created (vcluser) access to the new database. If that works to get you logged in, you can change the password for the admin user under the User Preferences part of the site. Josh On Wednesday August 11, 2010, Randy Sprague wrote: 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: --- snip 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 ... snip 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
Re: unable to retrieve management node information from database -- please help
Once your VCL website is working you will need to load each image on a VM, install and configure Cygwin sshd, then save each as a VCL image. Rather than taking weeks to get this working via the list I could help you through this over phone then send a summary to the list. I'd like to use the new VMware code so it can be tested in another environment. Send me a note directly if you want to arrange a time next week. It will be helpful to know your existing datastore is structured. Do you have a directory for each set of vmdk files? Do you have the ability to create additional datastores? It may be wise to use separate space while you're getting things working to eliminate the possibility of affecting your existing images. -Andy Randy Sprague wrote: 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
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)
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, |24997| resource, |24997| resourcetype, |24997| state |24997| WHERE