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

[T C]

T C [http://community.zenoss.org/people/tomekc] created the discussion

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

To view the discussion, visit: http://community.zenoss.org/message/65399#65399

--------------------------------------------------------------
Hi
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 http://exchange.nagios.org/directory/Plugins/Databases/SQLServer/Check-MSSQL-Database-Stats/details; require pymssql)
according to this post http://community.zenoss.org/docs/DOC-2514 http://community.zenoss.org/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?? 
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/65399#65399]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[jmp242]

jmp242 [http://community.zenoss.org/people/jmp242] created the discussion

"Re: problem with 'Zenoss' user (?), permission level"

To view the discussion, visit: http://community.zenoss.org/message/65414#65414

--------------------------------------------------------------
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
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/65414#65414]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[T C]

T C [http://community.zenoss.org/people/tomekc] created the discussion

"Re: problem with 'Zenoss' user (?), permission level"

To view the discussion, visit: http://community.zenoss.org/message/65428#65428

--------------------------------------------------------------
want to check db size of instances of SQL in my environment (2000, 2005, 2008 32and64 bit)
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/65428#65428]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[Shane Scott]

Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: problem with 'Zenoss' user (?), permission level"

To view the discussion, visit: http://community.zenoss.org/message/65432#65432

--------------------------------------------------------------
T C:

easy_install pymssql as zenoss user.

Best,
--Shane
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/65432#65432]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[T C]

T C [http://community.zenoss.org/people/tomekc] created the discussion

"Re: problem with 'Zenoss' user (?), permission level"

To view the discussion, visit: http://community.zenoss.org/message/65479#65479

--------------------------------------------------------------
still same, even after succesfull 'easy_install pymssql'
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/65479#65479]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[Shane Scott]

Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: problem with 'Zenoss' user (?), permission level"

To view the discussion, visit: http://community.zenoss.org/message/65470#65470

--------------------------------------------------------------
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)
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/65470#65470]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[T C]

T C [http://community.zenoss.org/people/tomekc] created the discussion

"Re: problem with 'Zenoss' user (?), permission level"

To view the discussion, visit: http://community.zenoss.org/message/65480#65480

--------------------------------------------------------------
testing plugin as 'root' - works just fine
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/65480#65480]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[Shane Scott]

Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: problem with 'Zenoss' user (?), permission level"

To view the discussion, visit: http://community.zenoss.org/message/65486#65486

--------------------------------------------------------------
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
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/65486#65486]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[T C]

T C [http://community.zenoss.org/people/tomekc] created the discussion

"Re: problem with 'Zenoss' user (?), permission level"

To view the discussion, visit: http://community.zenoss.org/message/65536#65536

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

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/65536#65536]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[Shane Scott]

Shane Scott [http://community.zenoss.org/people/hackman238] created the discussion

"Re: problem with 'Zenoss' user (?), permission level"

To view the discussion, visit: http://community.zenoss.org/message/65593#65593

--------------------------------------------------------------
T C:
What's the plugin?

--Shane
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/65593#65593]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]