Hi Josh,
Thanks to your recommendation, the ssh connection is working correctly now.
VCL is reaching the  "begin acknowledge timeout (900 seconds)" status
according to computerloadlog table. /var/log/vcld.log shows:

2020-05-22 15:22:02|1895|31|27|reserved|reserved.pm:process|153|beginning
to check for user acknowledgement:
|1895|31|27|reserved|reserved.pm:process|153| acknowledge check start   :
15:22:02
|1895|31|27|reserved|reserved.pm:process|153| acknowledge timeout total : +
00:15:00
|1895|31|27|reserved|reserved.pm:process|153|
--------------------------------------
|1895|31|27|reserved|reserved.pm:process|153| acknowledge check end     : =
15:37:02
|1895|31|27|reserved|reserved.pm:process|153| current time              : -
15:22:02
|1895|31|27|reserved|reserved.pm:process|153|
--------------------------------------
|1895|31|27|reserved|reserved.pm:process|153| acknowledge timeout remaining
: = 00:15:00 (900 seconds)
2020-05-22
15:22:02|1895|31|27|reserved|Module.pm:code_loop_timeout|1564|waiting for
user acknowledgement, maximum of 900 seconds
2020-05-22
15:22:02|1895|31|27|reserved|Module.pm:code_loop_timeout|1586|attempt 1:
waiting for user acknowledgement (0/900 elapsed/remaining seconds)
2020-05-22 15:22:07|939|||vcld|vcld:main|179|lastcheckin time updated for
management node 1: 1590171727
2020-05-22
15:22:12|1895|31|27|reserved|Module.pm:code_loop_timeout|1586|attempt 11:
waiting for user acknowledgement (10/890 elapsed/remaining seconds)

Nevertheless, if I click on Connect! button (web bui) I get this
information:
Use the following information when you are ready to connect:
- Remote Computer: 192.168.50.104
- User ID: admin
- Password: (use your campus password)

What password should I use? The VCL password doesn't work. I see that
vclclientd launches an sshd listening on port 22, but I'm not sure how VCL
is handling users on Lab Computer.

Best regards, your help is greatly appreciated
--
M. Sebastián Tobar


El vie., 22 may. 2020 a las 12:23, Josh Thompson (<[email protected]>)
escribió:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA512
>
> Hi Sebastián,
>
> Good job figuring out the OSid issue.  I've updated that in the query to
> add
> the lab image on the documentation page you've been using.
>
> I know that originally, the lab code connected to ssh on port 24 instead
> of
> port 22 so that ssh on port 22 could be controlled separately for user
> connections.  Try configuring ssh on the computer to listen on port 24.
>
> For the ssh identity key, I'm not sure why it is not showing it on the
> command
> line.  I think adding it to /etc/ssh/ssh_config (not sshd_config) will
> make it
> always be included.
>
> Our production system is running MariaDB 5.5.65.  So, I at least know that
> version works okay.
>
> Josh
>
> On Friday, May 22, 2020 8:51:58 AM EDT M. Sebastián Tobar wrote:
> > Hello Josh,
> > After analyzing the query, I´ve changed the field OSid (image table) from
> > 15 to 22  (Fedora Core 5 (Kickstart) -> Red Hat Enterprise Linux 5 (Lab))
> > to get a match between provisioningOSinstalltype.provisioningid
> > and computer.provisioningid. After that, the "There are no available
> times
> > that the selected image can be used" message disappeared.
> > Unfortunately, this error came up:
> > console.log('mapped computers: 1');console.log('computers available to
> > user: 1');Incorrect datetime value: '0000-00-00 00:00:00' for column
> > 'lastcheck' at row 1
> > INSERT INTO reservation (requestid, computerid, imageid, imagerevisionid,
> > managementnodeid) SELECT 4, computerid, imageid, imagerevisionid,
> > managementnodeid FROM semaphore WHERE expires > NOW() AND procid =
> > '192.168.50.153-296-5ec74fa13881b'
> > ERROR(101): General MySQL error
> >
> > I've to change MySQL mode again, removing NO_ZERO_IN_DATE and
> NO_ZERO_DATE:
> >
> > /etc/my.cnf.d/mysql-server.cnf
> > [mysqld]
> >
> sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTI
> > ON
> >
> > (Which Mysql version should I be using?)
> >
> > Now I'm able to make a reservation but... the ssh connection to the lab
> > computer fails. After filling the "Private IP Address" field in the "Edit
> > Computer" dialog (maybe this parameter must be mandatory?) I get:
> >
> > /var/log/vcld.log:
> >
> > 2020-05-22
> > 03:15:13|948|20|16|new|utils.pm:
> determine_remote_connection_target|14333|pr
> > ivate IP address is set in database for edu-ciaa-04, it will be used as
> the
> > remote connection target: 192.168.50.104
> > 2020-05-22 03:15:13|948|20|16|new|utils.pm:nmap_port|2109|port 24 is
> open
> > on 192.168.50.104 (edu-ciaa-04)
> > 2020-05-22 03:15:13|948|20|16|new|utils.pm:
> run_ssh_command|4235|executing
> > SSH command on 192.168.50.104 (edu-ciaa-04): '/usr/bin/ssh  -o
> > StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -o
> > ConnectionAttempts=1 -o ConnectTimeout=30 -o BatchMode=no -o
> > PasswordAuthentication=no -l vclstaff -p 24 -x 192.168.50.104 'echo
> > "testing ssh on edu-ciaa-04"' 2>&1'
> > 2020-05-22 03:15:13|948|20|16|new|utils.pm:(eval)|4256|waiting up to 15
> > seconds for SSH process to finish
> >
> > |948|20|16|new|utils.pm:run_ssh_command|4374| ---- WARNING ----
> > |948|20|16|new|utils.pm:run_ssh_command|4374| 2020-05-22
> >
> > 03:15:13|948|20|16|new|utils.pm:run_ssh_command|4374|attempt 1/1:
> failed to
> > execute SSH command on 192.168.50.104 (edu-ciaa-04): 'echo "testing ssh
> on
> > edu-ciaa-04"', exit status: 255, SSH exits with the exit status of the
> >
> > remote command or with 255 if an error occurred, output 1:
> > |948|20|16|new|utils.pm:run_ssh_command|4374| ssh output (echo
> "test...):
> > Permission denied (publickey).
> >
> > I don't see the -i /etc/vlc/lab.key option in the ssh command line.
> >
> > Key location is stored in /etc/vcl/vcld.conf:
> > IDENTITY_solaris_lab=/etc/vcl/lab.key
> > IDENTITY_linux_lab=/etc/vcl/lab.key
> >
> > Best regards
> > --
> > M. Sebastián Tobar
> >
> >
> > El jue., 21 may. 2020 a las 17:48, Josh Thompson (<
> [email protected]>)
> >
> > escribió:
> > > 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%2FcAJBYDgqeyc5
> > > Y1>
> > > >
> 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 (<
> > >
> > > [email protected]>)
> > >
> > > > 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 (<
> > > > >
> > > > > [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.
> > >
> > > --
> > > -------------------------------
> > > 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.
>
> - --
> - -------------------------------
> Josh Thompson
> Systems Programmer
> Virtual Computing Lab (VCL)
> North Carolina State University
>
> 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.
> -----BEGIN PGP SIGNATURE-----
>
> iQEzBAEBCgAdFiEEfXmFTgP4yDR/y4dUHerxdzYBHVcFAl7H7oMACgkQHerxdzYB
> HVfduQgAz/OFKRJQx4v9zioAucanYOjPM67OwGR134fcHIoRmvCMR9YVCKpKnmEf
> 3d+3E6JVZzlUn2NiHJuYxMxSBIaeDd6wbGBCZFA/CQBSzdzmHFH4bGBHy+mynlX9
> Z6JT8JX91XiKsQPEQ3tT+33W6Uq1uVKmQnT/80Zi0V1wcQmpj6UCkGwDYaG2pxKZ
> 8o+wCN5L7FUFc70n7igq1iMYkBNKWW12qMrt7OqHha3nF6u8t8Dit0R5/nXLAWmA
> 0D2H05OQm57OBjWj2zGAZToBA69+7LSZLQ+Ma+o6CkLrXv+vhjhMdRoOrCjZxGGT
> /uBm1iISL6fQeEs7lF/YLCZ1BnXR7w==
> =3Nqc
> -----END PGP SIGNATURE-----
>
>
>
>

Reply via email to