trouble with check_mysql and USER macros

[Alex Moore]

On Thu, 1 Dec 2005 16:22:43 -0800
Aleksey Tsalolikhin <aleksey.tsalolikhin at gmail.com> wrote:

> My consideration was that then I'd only be able to check one database,
> the one that password fits.
> But I only HAVE one database right now, so this works; thank you.

By database, I assume that you meant SQL Server.  The script just
counts the login spids > 50.  It only connects to the default
database, master and just needs the ability to login.

I created a SQL Server login for the nagios daemon user on all SQL
Servers that I want to monitor.  With the default permissions of
nothing, the nagios user cannot connect to anything but master with
public permissions.

Did I miss something?

Alex


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
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