-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Sebastián,
The lab module assumes the VMs to which it is brokering access already have some sort of federated authentication such as kerberos or ldap set up so that users would use a federated account for logging in. VCL really just handles managing ssh and iptables when using the lab module. Josh On Friday, May 22, 2020 2:45:04 PM EDT M. Sebastián Tobar wrote: > 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_SUBSTITU > > TI> > > > 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----- - -- - ------------------------------- 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----- iF0EARECAB0WIQRMIdRtWXideTZDK31X8tBw1209AwUCXs05BwAKCRBX8tBw1209 A/m6AJ9KEXpodrQkfbSDncENSGL15L0EhwCeMsCtmeBvYKqNE+3BiItV/w+5EwE= =ZWKd -----END PGP SIGNATURE-----
