-----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 (<josh_thomp...@ncsu.edu>) > > 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 (< > > > > josh_thomp...@ncsu.edu>) > > > > > 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 (< > > > > > > > > > > msebastian.to...@gmail.com>) 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-----
