problem with 'Zenoss' user (?), permission level

Archived community.zenoss.org | full text search

Skip navigation

Up to Discussions in zenoss-users

2526 Views 9 Replies Latest reply: Mar 28, 2012 4:10 PM by Shane Scott

T C

6 posts since
Mar 18, 2012

Currently Being Moderated

Mar 22, 2012 6:05 PM

I've just started testing NMS software, first was Nagios, now is Zenoss

have problem with configuring Zenoss - want to use Nagios plugin, which was tested and it's working (http://exchange.nagios.org/directory/Plugins/Databases/SQLServer/Check-MSSQL-Database-Stats/details; require pymssql)

according to this post docs/DOC-2514 I've configure new COMMAND

just after start it have warning in events - 'pymssql is required....'

script at beginning try to 'import pymssql' - if can't, send message like above

so I back to terminal and test this script as user - everything is ok, receive info from MSSQL Server

next do

su - zenoss

and try again check script, now received

pymssql is required...

what can I do to make 'zenoss' account 'see' pymssql library??

Like (0)

Tags: zenoss, nagios_plugins

jmp242
4,060 posts since
Mar 7, 2007

Currently Being Moderated

1. Mar 23, 2012 7:27 AM (in response to T C)
Re: problem with 'Zenoss' user (?), permission level

Is there a reason you don't want to use one of the Zenoss MSSQL Zenpacks?

--
James Pulver
ZCA Member
LEPP Computer Group
Cornell University

Report Abuse

Like (0)
T C
6 posts since
Mar 18, 2012

Currently Being Moderated

2. Mar 23, 2012 8:17 AM (in response to jmp242)
Re: problem with 'Zenoss' user (?), permission level

want to check db size of instances of SQL in my environment (2000, 2005, 2008 32and64 bit)
use one of these Zenpacks have this feature?

Report Abuse

Like (0)
Shane Scott
1,373 posts since
Jul 6, 2009

Currently Being Moderated

3. Mar 23, 2012 10:59 AM (in response to T C)
Re: problem with 'Zenoss' user (?), permission level

T C:

easy_install pymssql as zenoss user.

Best,
--Shane

Report Abuse

Like (0)
T C
6 posts since
Mar 18, 2012

Currently Being Moderated

4. Mar 26, 2012 10:18 AM (in response to Shane Scott)
Re: problem with 'Zenoss' user (?), permission level

still same, even after succesfull 'easy_install pymssql'

Report Abuse

Like (0)
Shane Scott
1,373 posts since
Jul 6, 2009

Currently Being Moderated

5. Mar 26, 2012 10:21 AM (in response to T C)
Re: problem with 'Zenoss' user (?), permission level

T C:

As the zenoss user on the zenmaster, try running the test by hand as documented on the plugins page. This will help narrow the issue down to either the plugin or zenoss.

Best,
--Shane (Hackman238)

Report Abuse

Like (0)
T C
6 posts since
Mar 18, 2012

Currently Being Moderated

6. Mar 26, 2012 10:27 AM (in response to Shane Scott)
Re: problem with 'Zenoss' user (?), permission level

testing plugin as 'root' - works fine
as 'zenoss' user - problem with pymssql

Report Abuse

Like (0)
Shane Scott
1,373 posts since
Jul 6, 2009

Currently Being Moderated

7. Mar 26, 2012 10:29 AM (in response to T C)
Re: problem with 'Zenoss' user (?), permission level

T C:
Zenoss can't run plugins as root. You'll have to test as the zenoss user. If you need to execute as root change the owner of the file to root, group zenoss then add the execute and suid bit.

Let me know how this tests.

Best,
--Shane

Report Abuse

Like (0)
T C
6 posts since
Mar 18, 2012

Currently Being Moderated

8. Mar 27, 2012 8:32 AM (in response to Shane Scott)
Re: problem with 'Zenoss' user (?), permission level

still problem with this plugin
for alternative - have query which in result will give me db_size, how can I use it in Zenoss?

Report Abuse

Like (0)
Shane Scott
1,373 posts since
Jul 6, 2009

Currently Being Moderated

9. Mar 28, 2012 4:10 PM (in response to T C)
Re: problem with 'Zenoss' user (?), permission level

T C:
What's the plugin?

--Shane

Report Abuse

Like (0)

Go to original post

Legend

Correct Answers - 4 points
Helpful Answers - 2 points

Mar 22, 2012 6:05 PM

problem with 'Zenoss' user (?), permission level

Actions

More Like This

Legend