ZenPacks : ODBC Data Source : Comments

RE: ODBC Data Source

community@zenoss.org — Wed, 18 Aug 2010 06:50:37 GMT

I am unable to model a PostgreSQL and an MSSQL device on Zenoss v3 and with all the latest zenpacks required (ODBC Data source, RDBMS, SQL Data Source,...) and keep getting this:

ERROR zen.ZenModeler Unable to fill collection slots: [Failure instance: Traceback (failure with no frames): exceptions.ValueError: need more than 3 values to unpack ]

ODBC drivers are tested to work with isql.

I decided to uninstall SQL Data Source, ODBC Data Source, and PostgreSQL ODBC, then install the older versions of ODBC Data Source and PostgreSQL ODBC. Well, it's not 100% working, but at least I got further with this setup: I can see the databases under Components and there are charts under Graphs when binding the template. I'm getting some unhandled exception errors on zenhub and the database are incorrectly being reported as down, but at least I got past the modeling.

So I'm suspecting that switching to the SQL Data Source framework could have broken the PostgreSQL ODBC and MS SQL ODBC zenpacks?

RE: ODBC Data Source

community@zenoss.org — Wed, 18 Aug 2010 18:30:32 GMT

Hi bogart,

thanks for pointing that out. Fixed in ver.3.1.

Egor

RE: ODBC Data Source

community@zenoss.org — Fri, 20 Aug 2010 03:40:36 GMT

Thanks Egor, it's now working! Tested with pgsql, mysql, and mssql zenpacks.

Although there's a minor problem, I keep getting the error below for pgsql on template0. Any ideas how to get rid of it?

Could not fetch data from source (Received error (('00000', '[ISQL]ERROR: Could not SQLConnect')) from query: SELECT SUM(idx_scan) as idx_scan, SUM(idx_tup_fetch) as idx_tup_fetch, SUM(n_tup_ins) as n_tup_ins, SUM(n_tup_upd) as n_tup_upd, SUM(n_tup_del) as n_tup_del, SUM(seq_scan) as seq_scan, SUM(seq_tup_read) as seq_tup_read FROM pg_stat_user_tables;)

RE: ODBC Data Source

community@zenoss.org — Fri, 10 Dec 2010 03:58:14 GMT

When installing an error. Tell me how to fix?

/opt/zenoss/bin/zenpack install /srv/share/ZenPacks.community.SQLDataSource-1.4.egg

ERROR:zen.ZenPackCmd:zenpack command failed

Traceback (most recent call last):

File "/opt/zenoss//Products/ZenUtils/zenpack.py", line 405, in <module>

zp = ZenPackCmd()

File "/opt/zenoss/Products/ZenUtils/ZenScriptBase.py", line 36, in __init__

zcml.load_site()

File "/opt/zenoss/lib/python/Products/Five/zcml.py", line 51, in load_site

_context = xmlconfig.file(file)

File "/opt/zenoss/lib/python/zope/configuration/xmlconfig.py", line 647, in file

include(context, name, package)

File "/opt/zenoss/lib/python/zope/configuration/xmlconfig.py", line 546, in include

processxmlfile(f, context)

File "/opt/zenoss/lib/python/zope/configuration/xmlconfig.py", line 378, in processxmlfile

parser.parse(src)

File "/opt/zenoss/lib/python/_xmlplus/sax/expatreader.py", line 109, in parse

xmlreader.IncrementalParser.parse(self, source)

File "/opt/zenoss/lib/python/_xmlplus/sax/xmlreader.py", line 123, in parse

self.feed(buffer)

File "/opt/zenoss/lib/python/_xmlplus/sax/expatreader.py", line 216, in feed

self._parser.Parse(data, isFinal)

File "/opt/zenoss/lib/python/_xmlplus/sax/expatreader.py", line 364, in end_element_ns

self._cont_handler.endElementNS(pair, None)

File "/opt/zenoss/lib/python/zope/configuration/xmlconfig.py", line 357, in endElementNS

self.context.end()

File "/opt/zenoss/lib/python/zope/configuration/config.py", line 537, in end

self.stack.pop().finish()

File "/opt/zenoss/lib/python/zope/configuration/config.py", line 685, in finish

actions = self.handler(context, **args)

File "/opt/zenoss/lib/python/Products/Five/fiveconfigure.py", line 74, in loadProducts

handleBrokenProduct(product)

File "/opt/zenoss/lib/python/Products/Five/fiveconfigure.py", line 72, in loadProducts

xmlconfig.include(_context, zcml, package=product)

File "/opt/zenoss/lib/python/zope/configuration/xmlconfig.py", line 546, in include

processxmlfile(f, context)

File "/opt/zenoss/lib/python/zope/configuration/xmlconfig.py", line 378, in processxmlfile

parser.parse(src)

File "/opt/zenoss/lib/python/_xmlplus/sax/expatreader.py", line 109, in parse

xmlreader.IncrementalParser.parse(self, source)

File "/opt/zenoss/lib/python/_xmlplus/sax/xmlreader.py", line 123, in parse

self.feed(buffer)

File "/opt/zenoss/lib/python/_xmlplus/sax/expatreader.py", line 216, in feed

self._parser.Parse(data, isFinal)

File "/opt/zenoss/lib/python/_xmlplus/sax/expatreader.py", line 364, in end_element_ns

self._cont_handler.endElementNS(pair, None)

File "/opt/zenoss/lib/python/zope/configuration/xmlconfig.py", line 357, in endElementNS

self.context.end()

File "/opt/zenoss/lib/python/zope/configuration/config.py", line 537, in end

self.stack.pop().finish()

File "/opt/zenoss/lib/python/zope/configuration/config.py", line 684, in finish

args = toargs(context, *self.argdata)

File "/opt/zenoss/lib/python/zope/configuration/config.py", line 1376, in toargs

args[str(name)] = field.fromUnicode(s)

File "/opt/zenoss/lib/python/zope/configuration/fields.py", line 229, in fromUnicode

v = vt.fromUnicode(s)

File "/opt/zenoss/lib/python/zope/configuration/fields.py", line 139, in fromUnicode

value = self.context.resolve(name)

File "/opt/zenoss/lib/python/zope/configuration/config.py", line 180, in resolve

mod = __import__(mname, *_import_chickens)

File "/opt/zenoss/ZenPacks/ZenPacks.community.deviceAdvDetail-2.5.egg/ZenPacks/community/deviceAdvDetail/thresholds/StatusThreshold.py", line 19, in <module>

import rrdtool

ZopeXMLConfigurationError: File "/opt/zenoss/etc/site.zcml", line 16.2-16.23

ZopeXMLConfigurationError: File "/opt/zenoss/ZenPacks/ZenPacks.community.deviceAdvDetail-2.5.egg/ZenPacks/community/deviceAdvDetail/configure.zcml", line 8.8-11.19

ImportError: librrd.so.4: cannot open shared object file: No such file or directory

[root@localhost /]# ls /opt/zenoss/lib/libr*
/opt/zenoss/lib/librrd.la        /opt/zenoss/lib/librrd_th.la
/opt/zenoss/lib/librrd.so        /opt/zenoss/lib/librrd_th.so
/opt/zenoss/lib/librrd.so.4      /opt/zenoss/lib/librrd_th.so.4
/opt/zenoss/lib/librrd.so.4.0.8 /opt/zenoss/lib/librrd_th.so.4.0.8

Sorry, figured out. The problem was in the PATH

export ZENHOME="/opt/zenoss"

export PYTHONPATH="/opt/zenoss/lib/python"
export LD_LIBRARY_PATH="/opt/zenoss/lib"

RE: ODBC Data Source

community@zenoss.org — Mon, 23 Jan 2012 14:19:13 GMT

Hello there,

Can someone tell me how to run a T-SQL query on a specific instance?

I have tried

${here/zMsSqlConnectionString};DATABASE=master;Server=${here/manageIp}<\instance NAME>;UID=${here/zWinUser};PWD=${here/zWinPassword}

it works fine when you test the script but it is not logging any data in the graph I have created for it...