Hi Sebastián, It sounds like the following query is not returning any results. I think I got all of the values correct based on the information you have provided so far. Also, I haven't actually tried the query. So, it's possible there's a typo in it. Do you know SQL enough to try to work through what part of it may be causing you not to get any results?
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) AND
se.expires IS NULL OR se.expires < NOW())
ORDER BY RAM,
c.procspeed * c.procnumber),
network
Josh
On Thursday, May 21, 2020 4:16:33 PM EDT M. Sebastián Tobar wrote:
> Hi Josh,
> This is the output:
>
> dojo.byId('imgdesc').innerHTML = 'Image Description:
> Entorno para EDU-CIAA con placa EDU-CIAA-NXP
>
> '; dojo.addClass('admingrpnote', 'hidden');console.log('mapped computers:
> 1');console.log('computers available to user: 1');console.log('no computers
> with a matching schedule and platform, and in an available state, and
> available to the user, and mapped to the image, and matching image resource
> requirements');dojo.byId('suggestcont').value =
> '6owOjJbkDb3ylGkn5z4Nv5xLa7bAsves2gjT5N5z89zbwyd2G6U7T2fgAT%2FcAJBYDgqeyc5Y1
> VSU950SMpeP%2FlCtcbNpCo74JjQCQ6Ky0Ag%3D';if(dijit.byId('newResDlgBtn'))
> {if(dijit.byId('newResDlgBtn').get('label') != _('View Available Times'))
> resbtntxt = dijit.byId('newResDlgBtn').get('label');
> dijit.byId('newResDlgBtn').set('label', _('View Available
> Times'));}dojo.removeClass('deployerr',
> 'hidden');showSuggestedTimes();dojo.byId('deployerr').innerHTML =
> 'Selection not currently available';resizeRecenterDijitDialog('newResDlg');
>
> The response is the same without "&debug=1"...
>
> Best regards
> --
> M. Sebastián Tobar
>
>
> El jue., 21 may. 2020 a las 12:36, Josh Thompson (<josh_thomp...@ncsu.edu>)
>
> escribió:
> > 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 (<
> >
> > josh_thomp...@ncsu.edu>)
> >
> > > 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 (<
> > > >
> > > > 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-----
> >
> > --
> > -------------------------------
> > Josh Thompson
> > Systems Programmer
> > Virtual Computing Lab (VCL)
> > North Carolina State University
> >
> > josh_thomp...@ncsu.edu
> > 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.
--
-------------------------------
Josh Thompson
Systems Programmer
Virtual Computing Lab (VCL)
North Carolina State University
josh_thomp...@ncsu.edu
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.
