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