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