Hi Sebastián, Here's something that may give some more information about what's not configured correctly.
* Go to the Reservations page * open the browser debugger to view the JavaScript console * add "&debug=1" to the URL (i.e. index.php?mode=viewRequests&debug=1) * click New Reservation * send us the output on the JavaScript console Josh On Wednesday, May 20, 2020 6:31:00 PM EDT M. Sebastián Tobar wrote: > Josh, > Indeed, there was a time zone issue. I've now configured the same time zone > for the three servers (mn, db, web) and .ht-inc/conf.php. > Unfortunately, "There are no available times that the selected image can be > used" message > > On Reporting->Dashboard I get (see attached picture) > > Best regards > -- > M. Sebastián Tobar > > > El mié., 20 may. 2020 a las 17:52, Josh Thompson (<[email protected]>) > > escribió: > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > Hi Sebastián, > > > > That's odd. I'm wondering if you have a time or timezone issue. Do you > > have > > all 3 VCL components (web, database, vcld) installed on the same system? > > If > > not, does the time match on all servers? What timezone did you set when > > installing VCL (you can look for date_default_timezone_set in the web code > > in > > .ht-inc/conf.php)? > > > > Josh > > > > On Wednesday, May 20, 2020 3:37:51 PM EDT M. Sebastián Tobar wrote: > > > Hi Josh, > > > > > > Under Reporting->Dashboard I get: > > > > > > Error encountered: > > > > > > Error: Invalid Input > > > You submitted expired data to this website. Please restart the steps you > > > were following without using your browser's Back button > > > > > > On management node: > > > > > > [root@vcl-mn ~]# cat /var/log/vcld.log > > > ... > > > 2020-05-20 18:04:54|393|||vcld|vcld:main|179|lastcheckin time updated > > > for > > > management node 1: 1589997894 > > > 2020-05-20 18:05:01|393|||vcld|vcld:main|179|lastcheckin time updated > > > for > > > management node 1: 1589997901 > > > > > > Best regards > > > -- > > > M. Sebastián Tobar > > > > > > > > > El mié., 20 may. 2020 a las 16:21, Josh Thompson (< > > > > [email protected]>) > > > > > escribió: > > > > -----BEGIN PGP SIGNED MESSAGE----- > > > > Hash: SHA1 > > > > > > > > Hi Sebastián, > > > > > > > > I'm glad to help! > > > > > > > > It sounds like you are really close. > > > > > > > > > - -you have an active management node (it is updating lastcheckin in > > > > the > > > > > > > management node table) (Where can I check this?) > > > > > > > > You can check this under Reporting->Dashboard. I'm hoping this is > > > > your > > > > problem since it sounds like everything else is set up correctly. > > > > > > > > > - -platform for image matches platform of computer (i386 vs x86, is > > > > this > > > > > > > ok?) > > > > > > > > The platform for both should be i386. The architecture for the image > > > > is > > > > > > x86. > > > > > > > > Josh > > > > > > > > On Wednesday, May 20, 2020 12:01:20 PM EDT M. Sebastián Tobar wrote: > > > > > Thanks again for your help Josh. I'm using mysql version 8.0.17 on > > > > > > > > Centos 7 > > > > > > > > > (I failed to install con Centos 8, many mysql/php/httpd issues) > > > > > > > > > > There is an available computer under Manage Computers->Edit > > > > > Computer->Computer Profiles: > > > > > > > > > > Name*: edu-ciaa-04 > > > > > Owner*: admin@Local > > > > > Type: Lab > > > > > Public IP Address*: 192.168.50.104 > > > > > Provisioning Engine: Computing Lab > > > > > State: available > > > > > Platform: i386 > > > > > Schedule: VCL 24x7 > > > > > Current Image: No Image > > > > > RAM (MB)*: 1024 > > > > > Cores*: 1 > > > > > Processor Speed (MHz)*: 2000 > > > > > Network: 100 > > > > > > > > > > I've also followed this checklist: > > > > > https://markmail.org/message/ny7f746sepk6cmjx > > > > > > > > > > - -image is in an image group OK > > > > > - -image group is mapped to a computer group OK > > > > > - -computer group contains computers in the "available" state OK > > > > > - -you have an active management node (it is updating lastcheckin in > > > > the > > > > > > > management node table) (Where can I check this?) > > > > > - -management node is in a management node group OK > > > > > - -management node group maps to a computer group containing > > > > specified > > > > > > > computer from above OK > > > > > - -schedule for computer is available during the selected time OK > > > > > - -platform for image matches platform of computer (i386 vs x86, is > > > > this > > > > > > > ok?) > > > > > - -privileges set up in Privileges section of site to allow you to > > > > > access > > > > > image and computer OK > > > > > - -specs of image (min RAM, min CPU speed, etc) are at or less than > > > > > specs > > > > > of computer OK > > > > > - -no other entries in the reservation table for the computer that > > > > > > > > overlap > > > > > > > > > with the selected time period OK > > > > > > > > > > Best regards > > > > > -- > > > > > M. Sebastián Tobar > > > > > > > > > > > > > > > El mié., 20 may. 2020 a las 12:06, Josh Thompson (< > > > > > > > > [email protected]>) > > > > > > > > > escribió: > > > > > > -----BEGIN PGP SIGNED MESSAGE----- > > > > > > Hash: SHA1 > > > > > > > > > > > > Hi Sebastián, > > > > > > > > > > > > Interesting, that's helpful to know. Thanks for passing it along. > > > > > > > > > > > > What computer information have you added under Manage > > > > Computers->Edit > > > > > > > > Computer > > > > > > Profiles? Is there a computer entry that is in the available > > > > state? > > > > > > > > Josh > > > > > > > > > > > > On Wednesday, May 20, 2020 10:48:41 AM EDT M. Sebastián Tobar > > > > wrote: > > > > > > > I've solved this problem changing the MySQL mode: > > > > > > > > > > > > > > SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); > > > > > > > > > > > > > > Now I'm getting "There are no available times that the selected > > > > > > > image > > > > > > > can > > > > > > > be used", I guess it's a configuration issue? > > > > > > > > > > > > > > Best regards > > > > > > > -- > > > > > > > M. Sebastián Tobar > > > > > > > > > > > > > > El mié., 20 may. 2020 a las 11:24, M. Sebastián Tobar (< > > > > > > > > > > > > > > [email protected]>) escribió: > > > > > > > > Hello, > > > > > > > > I've a fresh VCL install and I've managed to add a "Lab > > > > > > > > Machine > > > > > > > > image". > > > > > > > > Unfortunately, I can't make a reservation on this image. > > > > Following > > > > > > > > > > this > > > > > > > > > > guide: > > https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=47385093 > > > > > > > > > > I > > > > > > > > get this error: > > > > > > > > > > > > > > > > dojo.addClass('admingrpnote', 'hidden');Expression #1 of ORDER > > > > BY > > > > > > > > clause > > > > > > > > > > > > > > is not in SELECT list, references column 'vcl.c.RAM' which is > > > > not > > > > > > in > > > > > > > > > > > > SELECT > > > > > > > > list; this is incompatible with DISTINCT > > > > > > > > SELECT DISTINCT c.id, c.currentimageid, c.imagerevisionid FROM > > > > > > > > state > > > > > > > > > > s, > > > > > > > > > > > > > > image i LEFT JOIN OS o ON (o.id = i.OSid) LEFT JOIN > > > > OSinstalltype > > > > > > oi > > > > > > > > > > ON ( > > > > > > > > > > > > > > oi.name = o.installtype) LEFT JOIN provisioningOSinstalltype > > > > poi > > > > > > ON > > > > > > > > > > > > (poi.OSinstalltypeid = oi.id) LEFT JOIN computer c ON > > > > > > > > > > > > (poi.provisioningid > > > > > > > > > > > > > > = c.provisioningid) LEFT JOIN semaphore se ON (c.id = > > > > > > > > se.computerid) > > > > > > > > > > > > WHERE i.id = 8 AND c.scheduleid IN (1) AND c.platformid = 1 > > > > AND > > > > > > > > c.stateid > > > > > > > > > > > > > > = s.id AND s.name NOT IN > > > > > > > > ('maintenance','vmhostinuse','hpc','failed','timeout','inuse') > > > > AND > > > > > > > > c.RAM > > > > > > > > > > > > > > >= > > > > > > > > > > > > > > > > i.minram AND c.procnumber >= i.minprocnumber AND c.procspeed > > > > > > > > >= > > > > > > > > i.minprocspeed AND c.network >= i.minnetwork AND c.deleted = 0 > > > > AND > > > > > > > > (c.type > > > > > > > > > > > > > > != 'virtualmachine' OR c.vmhostid IS NOT NULL) AND c.id IN > > > > ('1') > > > > > > AND > > > > > > > > > > c.id > > > > > > > > > > > > > > IN (1,1) AND c.id NOT IN (0) AND (se.expires IS NULL OR > > > > > > > > se.expires < > > > > > > > > > > > > NOW()) ORDER BY RAM, (c.procspeed * c.procnumber), network > > > > > > > > ERROR(129): Failed to execute query 5 in isAvailable > > > > > > > > > > > > > > > > Backtrace: > > > > > > > > =-=-=-=-=-=-=-=-=-=-=-= > > > > > > > > Call#:1 => index.php:AJupdateWaitTime() (line#:99) > > > > > > > > Call#:2 => requests.php:isAvailable() (line#:1989) > > > > > > > > Call#:3 => utils.php:doQuery() (line#:4987) > > > > > > > > ... > > > > > > > > > > > > > > > > Any help will be appreciated > > > > > > > > -- > > > > > > > > M. Sebastián Tobar > > > > > > > > > > > > - -- > > > > > > - ------------------------------- > > > > > > Josh Thompson > > > > > > VCL Developer > > > > > > North Carolina State University > > > > > > > > > > > > my GPG/PGP key can be found on pool.sks-keyservers.net > > > > > > > > > > > > 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. > > > > > > -----BEGIN PGP SIGNATURE----- > > > > > > > > > > > > iF0EARECAB0WIQRMIdRtWXideTZDK31X8tBw1209AwUCXsVHXQAKCRBX8tBw1209 > > > > > > AxEKAJoCFL0Cy7g4bj3JCXywP0C5FZSOYACdFje1pGUrvB/v1zQvq4rYypE2nRc= > > > > > > =Cd3V > > > > > > -----END PGP SIGNATURE----- > > > > > > > > - -- > > > > - ------------------------------- > > > > Josh Thompson > > > > VCL Developer > > > > North Carolina State University > > > > > > > > my GPG/PGP key can be found on pool.sks-keyservers.net > > > > > > > > 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. > > > > -----BEGIN PGP SIGNATURE----- > > > > > > > > iF0EARECAB0WIQRMIdRtWXideTZDK31X8tBw1209AwUCXsWDGwAKCRBX8tBw1209 > > > > A13wAJ9Oi2agy57AeBTtXqzj5Lplu4sJ7QCeMgOHQhEdTN30Jr6qIg6dsAc23w4= > > > > =Abcx > > > > -----END PGP SIGNATURE----- > > > > - -- > > - ------------------------------- > > Josh Thompson > > VCL Developer > > North Carolina State University > > > > my GPG/PGP key can be found on pool.sks-keyservers.net > > > > 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. > > -----BEGIN PGP SIGNATURE----- > > > > iF0EARECAB0WIQRMIdRtWXideTZDK31X8tBw1209AwUCXsWYYQAKCRBX8tBw1209 > > A9zxAJwNAEpb+ekS+IzbwWQOPf73OxRFKACfUDNYYzKHxAu93kO0YpXB+HT7RFo= > > =ctqW > > -----END PGP SIGNATURE----- -- ------------------------------- Josh Thompson Systems Programmer Virtual Computing Lab (VCL) North Carolina State University [email protected] 919-515-5323 my GPG/PGP key can be found at www.keyserver.net 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.
