Josh,

The server version is:  5.1.52-log.

Thanks again.

 - Doug -

On 5/19/2011 3:53 PM, Josh Thompson wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Doug,

Thanks for the report back.  I created a bug report (VCL-474) for it so that
it will be fixed in the next release.  Do you know what version of mysql you
have installed?

Josh

On Thursday May 19, 2011, Douglas Dodson wrote:
Josh,

Thanks for the quick response.  Single quotes did it.  I made the
following change to utils.php:

4309,4310c4309,4310
<               .       "rq.start>  '$start' AND "
<               .       "rq.start<  '$end' "
---

  >               .       "rq.start>  \"$start\" AND "
  >               .       "rq.start<  \"$end\" "

Wow, great support!

   - Doug -

On 5/19/2011 1:20 PM, Josh Thompson wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Doug,

That's a strange one.  I don't see anything wrong with the SQL statement
it gives.  The only thing I can think of is that you have a more recent
version of mysql than I've ever used, and it doesn't like the double
quotes (").

Try running the sql statement from the mysql command line.  In case
you're also new to mysql, here are the steps to test it:

Run 'mysql' to start the command line interface.
Then, at the prompt, enter 'use vcl'.
Next, type

SELECT DISTINCT COUNT(rs.managementnodeid) AS count, rs.managementnodeid
AS mnid FROM reservation rs, request rq WHERE rs.managementnodeid IN (1)
AND rq.start>   "2011-05-19 09:45:00" AND rq.start<
"2011-05-19 10:45:00" GROUP BY rs.managementnodeid ORDER BY count;

If it gives you the same error, try it again, but replace the double
quotes (") with single quotes (').

As a side note, there is a bug in that SQL statement because there is no
conditional to join the two tables together.  However, it won't cause any
undesired results if you only have one management node.

Josh

On Thursday May 19, 2011, Douglas Dodson wrote:
Hello,

I'm a new VCL user/admin and am also a php rookie.  Any help is
appreciated.

I have deployed VCL on a single server as part of a proof of concept
evaluation.  I'm making steady progress, but have hit a wall with this
error.  I have VMware Server 2.0.2 deployed under CentOS 5.6 and VCL
2.2.1 with required components up and running.  I have created an image
named "VMwareCentOS56" and I believe that I have entered it and
associated computers into the VCL database correctly.

However, when I attempt to navigate to the "New Reservation" option of
the VCL web interface either as a normal user or and admin, I get the
following dump Emailed to me and I get an AJAX error in my browser.
This occurs immediately when I see the "New Reservation" page - I don't

even have a chance to make any selections or changes:
Unknown column '2011-05-19 09:45:00' in 'where clause'

SELECT DISTINCT COUNT(rs.managementnodeid) AS count,
rs.managementnodeid AS mnid FROM reservation rs, request rq WHERE
rs.managementnodeid IN (1) AND rq.start>    "2011-05-19 09:45:00" AND
rq.start<    "2011-05-19 10:45:00" GROUP BY rs.managementnodeid ORDER
BY count ERROR(101): General MySQL error
Logged in user was testxyz
Mode was AJupdateWaitTime


Backtrace:
=-=-=-=-=-=-=-=-=-=-=-=
Call#:1 =>    index.php:AJupdateWaitTime() (line#:86)
Call#:2 =>    requests.php:isAvailable() (line#:255)
Call#:3 =>    utils.php:allocComputer() (line#:3738)
Call#:4 =>    utils.php:findManagementNode() (line#:3828)
Call#:5 =>    utils.php:doQuery() (line#:4313)

Backtrace with Arguments:
=-=-=-=-=-=-=-=-=-=-=-=
Call#:1 =>    index.php:AJupdateWaitTime() (line#:86)
Arguments(none):
-----------------------
Call#:2 =>    requests.php:isAvailable() (line#:255)
Arguments(5)

Argument#: 1 =>    Array
(

       [4] =>    Array

           (

               [id] =>    4
               [name] =>    noimage
               [prettyname] =>    No Image
               [ownerid] =>    1
               [owner] =>    admin@Local
               [platformid] =>    1
               [platform] =>    i386
               [osid] =>    2
               [os] =>    sun4x_58
               [minram] =>    0
               [minprocnumber] =>    1
               [minprocspeed] =>    0
               [minnetwork] =>    10
               [maxconcurrent] =>
               [reloadtime] =>    0
               [deleted] =>    0
               [test] =>    0
               [resourceid] =>    4
               [lastupdate] =>
               [forcheckout] =>    0
               [maxinitialtime] =>    0
               [imagemetaid] =>
               [imagerevision] =>    Array

                   (

                       [4] =>    Array

                           (

                               [id] =>    4
                               [revision] =>    0
                               [userid] =>    1
                               [user] =>    admin@Local
                               [datecreated] =>    1980-01-01 00:00:00
                               [prettydate] =>    1/01/80 12:00 AM
                               [production] =>    1
                               [imagename] =>    noimage

                           )

                   )

           )

       [19] =>    Array

           (

               [id] =>    19
               [name] =>    vmwarelinux-VMwareCentOS5619-v0
               [prettyname] =>    VMwareCentOS56
               [ownerid] =>    1
               [owner] =>    admin@Local
               [platformid] =>    1
               [platform] =>    i386
               [osid] =>    36
               [os] =>    vmwarelinux
               [minram] =>    1024
               [minprocnumber] =>    1
               [minprocspeed] =>    1000
               [minnetwork] =>    100
               [maxconcurrent] =>
               [reloadtime] =>    10
               [deleted] =>    0
               [test] =>    0
               [resourceid] =>    32
               [lastupdate] =>    2011-05-16 14:55:13
               [forcheckout] =>    1
               [maxinitialtime] =>    0
               [imagemetaid] =>
               [imagerevision] =>    Array

                   (

                       [17] =>    Array

                           (

                               [id] =>    17
                               [revision] =>    0
                               [userid] =>    1
                               [user] =>    admin@Local
                               [datecreated] =>    2011-05-16 14:55:13
                               [prettydate] =>    5/16/11 2:55 PM
                               [production] =>    1
                               [imagename] =>
                               vmwarelinux-VMwareCentOS5619-v0

                           )

                   )

           )

)

Argument#: 2 =>    19
Argument#: 3 =>    17
Argument#: 4 =>    1305814500
Argument#: 5 =>    1305819000
-----------------------
Call#:3 =>    utils.php:allocComputer() (line#:3738)
Arguments(5)

Argument#: 1 =>     (empty array)
Argument#: 2 =>     (empty array)
Argument#: 3 =>    Array
(

       [0] =>    2
       [1] =>    3
       [2] =>    4
       [3] =>    5
       [4] =>    6
       [5] =>    7
       [6] =>    8
       [7] =>    9

)

Argument#: 4 =>    2011-05-19 10:15:00
Argument#: 5 =>    now
-----------------------
Call#:4 =>    utils.php:findManagementNode() (line#:3828)
Arguments(3)

Argument#: 1 =>    2
Argument#: 2 =>    2011-05-19 10:15:00
Argument#: 3 =>    now
-----------------------
Call#:5 =>    utils.php:doQuery() (line#:4313)
Arguments(2)

Argument#: 1 =>    SELECT DISTINCT COUNT(rs.managementnodeid) AS count,
rs.managementnodeid AS mnid FROM reservation rs, request rq WHERE
rs.managementnodeid IN (1) AND rq.start>    "2011-05-19 09:45:00" AND
rq.start<    "2011-05-19 10:45:00" GROUP BY rs.managementnodeid ORDER BY
count Argument#: 2 =>    101
-----------------------
I am guessing that I have something mis-configured, but it is not
obvious to me what it might be.  Please let me know what other
information might be needed to help get this sorted out.

Thanks.

    - Doug -
- --
- -------------------------------
Josh Thompson
VCL Developer
North Carolina State University

my GPG/PGP key can be found at pgp.mit.edu
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (GNU/Linux)

iEYEARECAAYFAk3VUXMACgkQV/LQcNdtPQNbCwCfSD4hcJlKfwEJYhFx3mFw5Twb
ImMAn0M2bsRB0E9AAs4Gfi3GXpuPHzQ7
=5/DP
-----END PGP SIGNATURE-----
- -- - -------------------------------
Josh Thompson
VCL Developer
North Carolina State University

my GPG/PGP key can be found at pgp.mit.edu
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (GNU/Linux)

iEYEARECAAYFAk3VdVEACgkQV/LQcNdtPQPviQCfXpjIkPFWTQGd7lOqQWnFouZR
Ms4An3OB3ddj2MeG9ZTfNg0z13FRHiKy
=afUp
-----END PGP SIGNATURE-----

--
*Douglas Dodson*
SRI International <http://www.sri.com>

Email: douglas.dod...@sri.com <mailto:douglas.dod...@sri.com>
Phone: (814) 278-6047
Fax: (814) 237-4034

1771 Pine Hall Road
State College, PA 16801

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

Reply via email to