need more complicated test than ping

Hi All,

Host: CentOS 5.5
guest: Windows 2003 R2, sp2, 32 bit, running Terminal Services
Virtual Machine: Virtual Box 3.2.12

Hi All,

I have a script that runs on my CentOS host machine that checks if
my guest Windows Server 2003 is running responding to commands.
If not, the script reboots the guest. (I shut the VM down every
night to do my dump backup.)

Problem: Windows do not always start up correctly and need to
be rebooted. (Windows has quality problems. Duh.)

I use the "ping" command in my check script to see if the guest
is up and running.

Problem 2: my frozen guest frequently still responds to the
ping command. Rats!

Does anyone know of a more "complicated" network command I
can throw at it to see if my guest is "actually" up?

The guest have M$SQL server runing on it. Any way to
say "Hi" to it?

I am able to run the "net rcp" shutdown command. Any other
"net rpc" commands I can throw at it that are "complicated"?

Many thanks,
-T

Todd wrote:
> Hi All,
>
> Host: CentOS 5.5
> guest: Windows 2003 R2, sp2, 32 bit, running Terminal Services
> Virtual Machine: Virtual Box 3.2.12
>
> Hi All,
>
> I have a script that runs on my CentOS host machine that checks if
> my guest Windows Server 2003 is running responding to commands.
> If not, the script reboots the guest. (I shut the VM down every
> night to do my dump backup.)
>
> Problem: Windows do not always start up correctly and need to
> be rebooted. (Windows has quality problems. Duh.)
>
> I use the "ping" command in my check script to see if the guest
> is up and running.
>
> Problem 2: my frozen guest frequently still responds to the
> ping command. Rats!
>
> Does anyone know of a more "complicated" network command I
> can throw at it to see if my guest is "actually" up?
>
> The guest have M$SQL server runing on it. Any way to
> say "Hi" to it?
>
> I am able to run the "net rcp" shutdown command. Any other
> "net rpc" commands I can throw at it that are "complicated"?
>
> Many thanks,
> -T

isql or DBI::Sybase to check the M$SQL server?
some smbclient stuff ?

j

On 2011-03-08, Todd <(E-Mail Removed)> wrote:
>
> Does anyone know of a more "complicated" network command I
> can throw at it to see if my guest is "actually" up?

Of course:

mysql -h dns-or-ip-of-guest $BLAH -e 'show processlist'

where $BLAH will be whatever other commandline parameters you might
need, like a username or password. You'd also need to grant connect
privileges for this user@host in the mysqld in the guest.

--keith

--
kkeller-(E-Mail Removed)
(try just my userid to email me)
AOLSFAQ=http://www.therockgarden.ca/aolsfaq.txt
see X- headers for PGP signature information

On 2011-03-08, Keith Keller <kkeller-(E-Mail Removed)> wrote:
>
> mysql -h dns-or-ip-of-guest $BLAH -e 'show processlist'

My apologies! I misread MSSQL as mysql. Jack had the right idea, to
connect using some mssql-compatible library on the host side.

--keith



--
kkeller-(E-Mail Removed)
(try just my userid to email me)
AOLSFAQ=http://www.therockgarden.ca/aolsfaq.txt
see X- headers for PGP signature information