SQL 2005

[Peter Edmonds]

Hi Matthew

Install the freetds package, then use bsqldb to query your SQL2005
from the command line using a bash script. I have this setup under
Groundwork Monitor Open Source and it works sensationally. I can query
a SQL 2005 database, dump the results to a text file in my htdocs
directory then use check_http to do a content check.

Peter Edmonds

On 8/3/07, Matthew Joyce <MJoyce at ccia.unsw.edu.au> wrote:
>
>
>
>
> Hi all,
>
> Does anyone have method of determining is a database is up and accessible ?
>
> At the moment we check the server is up and services are running, but my
> availability reports don't show if staff can't login to a db.
>
> I'm thinking nrpe+wmi might be useful, or old fashioned vbs.
>
> Or perhaps SQL2005 have some snmp OIDs I can query ?
>
> Any ideas ?
>
> Matthew Joyce
>  02 9382 0051 | IT Manager | Children's Cancer Institute Australia for
> Medical Research
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when reporting
> any issue.
> ::: Messages without supporting info will risk being sent to /dev/null
>

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null