On Nov 19, 2008, at 8:18 AM, Marc Powell wrote: > > On Nov 19, 2008, at 7:25 AM, Fernando Rocha wrote: > >> Hi Esteban, >> >> Try to run the command with "sh -x" before the check_mssql.sh and >> then send the result to us: >> >> [EMAIL PROTECTED] libexec]# sh -x check_mssql.sh server user pass 2000 > > And as the nagios user, not root.
*caveat*, I don't use this plugin nor do I know much about the internals of SQL2000. I tested it out and experienced the same error. It appears that the query is not qualified enough, at least for the username I was logging in with. Changing echo -e "select loginame from sysprocesses where spid > $spid order by loginame asc\ngo" > $tmpfile to echo -e "select loginame from sys.sysprocesses where spid > $spid order by loginame asc\ngo" > $tmpfile resulted in a successful check -- $ ./check_mssql.sh <redacted> <redacted> <redacted> 2000 OK - MS SQL Server 2000 has 1 user(s) connected: 1 <redacted>. -- Marc ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Nagios-users mailing list [email protected] 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
