|
|
| Subject: | Microsoft Zenpack issue |
| Author: | [Not Specified] |
| Posted: | 2014-05-16 22:09 |
When using the Microsoft zenpack, winrm one. I added the SQL plugin to connect to my SQL servers.
The 2008 server connects properly and works 100% fine.
When modeling on a 2012 server without the user/pass, it will find the instance installed. When I put the sa user example sa:password, I receive the following error.
WARNING zen.PythonClient: Error in zenoss.winrm.WinMSSQL: need more than 1 value to unpack
I do see the connection in sql during model, has anyone seen this on a 2012 SQL server
Thank you!
| Subject: | Issue found |
| Author: | [Not Specified] |
| Posted: | 2014-05-30 19:34 |
Looks like when modeling, there is a query looking for the SQL jobs.
The user for my jobs is a domain\name, this breaks the code when parsing on the user info for the job. Anyone know a work around for having domain\name as the job owner
ZenPacks / zenoss / Microsoft / Windows / modeler / plugins / zenoss / winrm / WinMSSQL.py
# Get SQL Jobs information
jobsquery = "select s.name as jobname, s.job_id as jobid, " \
"s.enabled as enabled, s.date_created as datecreated, " \
"s.description as description, l.name as username from " \
"msdb..sysjobs s left join master.sys.syslogins l on s.owner_sid = l.sid"
| < |
Previous PySamba zenpack not installed... but it is |
Next issue getting windows monitoring with ZenPack working |
> |