New ODBC Datasource ZenPack - Open Source Network Monitoring and Systems Management

j053ph4

290 posts since
Dec 19, 2008

Currently Being Moderated

15. Jul 1, 2009 5:23 PM (in response to bigegor)

RE: New ODBC Datasource ZenPack

it doesn't appear that the status/size update is working....the normal "Mysql" template is working ok, and the databases show up in "software" like they should, but none of the dynamic info ever updates...i don't see anything in zencommand.log indicating it should.

Any ideas?

Thanks,
Joseph

Report Abuse
Like (0)

bigegor

208 posts since
Apr 23, 2009

Currently Being Moderated

16. Jul 2, 2009 11:17 AM (in response to j053ph4)

RE: New ODBC Datasource ZenPack

my zencommand.log.

2009-07-02 17:04:16 DEBUG zen.zencommand: Command: '/bin/sh -c exec echo "SELECT sum(data_length), sum(index_length), sum( data_length + index_length ) FROM TABLES WHERE table_schema=\'events\' GROUP BY table_schema" | isql -b -v -x0x7C "********************************" "******" "******"'
2009-07-02 17:04:16 DEBUG zen.zencommand: Output: '5980160|1982464|7962624\n'
2009-07-02 17:04:16 DEBUG zen.zencommand: Process echo "SELECT sum(data_length), sum(index_length), sum( data_length + index_length ) FROM TABLES WHERE table_schema='events' GROUP BY table_schema" | isql -b -v -x0x7C "********************************" "******" "******"  stopped (0), 0.35 seconds elapsed
2009-07-02 17:04:16 DEBUG zen.zencommand: The result of "echo "SELECT sum(data_length), sum(index_length), sum( data_length + index_length ) FROM TABLES WHERE table_schema='events' GROUP BY table_schema" | isql -b -v -x0x7C "********************************" "******" "******"" was "'5980160|1982464|7962624\n'"
2009-07-02 17:04:16 DEBUG zen.zencommand: Queueing event {'severity': 0, 'performanceData': 'dataSize=5980160 indexSize=1982464 sizeUsed=7962624 ', 'component': 'events', 'agent': 'zencommand', 'summary': 'OK', 'manager': 'localhost', 'eventKey': 'sizeUsed', 'device': 'localhost', 'message': 'OK', 'eventClass': '/DB/MySQL'}
2009-07-02 17:04:16 DEBUG zen.zencommand: Total of 13 queued events
2009-07-02 17:04:16 DEBUG zen.zencommand: Storing dataSize = 5980160 into Devices/localhost/os/softwaredatabases/events/sizeUsed_dataSize
2009-07-02 17:04:16 DEBUG zen.RRDUtil: /opt/zenoss/perf/Devices/localhost/os/softwaredatabases/events/sizeUsed_dataSize.rrd: 5980160.0
2009-07-02 17:04:16 DEBUG zen.zencommand: RRD save result: 5980160.0
2009-07-02 17:04:16 DEBUG zen.zencommand: Storing indexSize = 1982464 into Devices/localhost/os/softwaredatabases/events/sizeUsed_indexSize
2009-07-02 17:04:16 DEBUG zen.RRDUtil: /opt/zenoss/perf/Devices/localhost/os/softwaredatabases/events/sizeUsed_indexSize.rrd: 1982464.0
2009-07-02 17:04:16 DEBUG zen.zencommand: RRD save result: 1982464.0
2009-07-02 17:04:16 DEBUG zen.zencommand: Storing sizeUsed = 7962624 into Devices/localhost/os/softwaredatabases/events/sizeUsed_sizeUsed
2009-07-02 17:04:16 DEBUG zen.RRDUtil: /opt/zenoss/perf/Devices/localhost/os/softwaredatabases/events/sizeUsed_sizeUsed.rrd: 7962624.0
2009-07-02 17:04:16 DEBUG zen.zencommand: RRD save result: 7962624.0

Report Abuse
Like (0)

j053ph4

290 posts since
Dec 19, 2008

Currently Being Moderated

17. Jul 2, 2009 11:35 AM (in response to bigegor)

RE: New ODBC Datasource ZenPack

First, thanks again for helping me w/this, I know it's been a lot of back and forth...

I don't see any similar entries at all in my zencommand.log, it looks like zencommand doesn't know that it should be run at all.

I'm running 2.4.2 BTW (just checking that it's not some bug)...

Wait...just found this in zenhub.log:

2009-07-02 10:36:41 DEBUG zen.Relations: checking relation: os
2009-07-02 10:36:41 ERROR zen.CommandConfig: Could not load ZenPacks.community.ZenODBC.isql plugin
2009-07-02 10:36:41 DEBUG zen.Relations: checking relation: datasource
2009-07-02 10:36:41 DEBUG zen.Relations: checking relation: datasource
2009-07-02 10:36:41 DEBUG zen.Relations: checking relation: datasource

This is basically a fresh install of zenoss on a dev server...i'm gonna blow it away and start over to see what happens.

Report Abuse
Like (0)

bigegor

208 posts since
Apr 23, 2009

Currently Being Moderated

18. Jul 2, 2009 11:45 AM (in response to j053ph4)

RE: New ODBC Datasource ZenPack

I'm running 2.4.1

Report Abuse
Like (0)

j053ph4

290 posts since
Dec 19, 2008

Currently Being Moderated

19. Jul 2, 2009 12:02 PM (in response to bigegor)

RE: New ODBC Datasource ZenPack

ok i just reinstalled...getting the same issue:

2009-07-02 11:07:16 ERROR zen.CommandConfig: Could not load ZenPacks.community.ZenODBC.isql plugin

Not sure what the problem is...gonna reinstall 2.4.1 and see if that helps

Report Abuse
Like (0)

j053ph4

290 posts since
Dec 19, 2008

Currently Being Moderated

20. Jul 2, 2009 1:00 PM (in response to j053ph4)

RE: New ODBC Datasource ZenPack

OK...looks like it does work on 2.4.1 but not on 2.4.2. I dont think that 2.4.2 is recognizing the community.ZenODBC.isql.py data collector

Also, it looks like the MySqlODBC zenpack may be clobbering some part of the "official" mysql zenpack. I saw this on 2.4.2 as well, but it looks like the effect of it is that the regular one no longer works, and errors out if you try to create a local copy of the device template. i'm going to remove/replace the official zenpack and see if that clears it up (it did yesterday)

Report Abuse
Like (0)

j053ph4

290 posts since
Dec 19, 2008

Currently Being Moderated

21. Jul 2, 2009 1:02 PM (in response to j053ph4)

RE: New ODBC Datasource ZenPack

removing/reinstalling the official mysql zenpack seems to have done the trick...looks like both are working as described now...

Report Abuse
Like (0)

bigegor

208 posts since
Apr 23, 2009

Currently Being Moderated

22. Jul 2, 2009 2:39 PM (in response to j053ph4)

RE: New ODBC Datasource ZenPack

I solve this problem in another way.
Please try ZenODBC and MySQLMon_ODBC ZenPacks from SVN.
You don't need official MySQLMonitor ZenPack.

Report Abuse
Like (0)

punkarruso

2 posts since
Jul 3, 2009

Currently Being Moderated

23. Jul 6, 2009 10:43 AM (in response to bigegor)

RE: New ODBC Datasource ZenPack

actually your SVN version fails on my installation with the following error...

INFO:zen.ZPLoader:Loading /home/zenoss/build/ZenPacks.community.MySQLMon_ODBC/ZenPacks/community/MySQLMon_ODBC/objects/objects.xml
ERROR: zenpack command failed. Reason: No module named isql

I already installed the ZenODBC 1.1 with .../parsers/isql.py

What am I missing?

Report Abuse
Like (0)

bigegor

208 posts since
Apr 23, 2009

Currently Being Moderated

24. Jul 7, 2009 6:14 PM (in response to punkarruso)

RE: New ODBC Datasource ZenPack

punkarruso, thanks for pointing this out. Try last SVN version of ZenODBC ZenPack.

Report Abuse
Like (0)

Matt Ray

2,484 posts since
Apr 5, 2008

Currently Being Moderated

25. Jul 8, 2009 6:13 PM (in response to bigegor)

New ODBC Datasource ZenPack

If someone has this working and is confident in the steps, send me a
note and I'll update the instructions on the ZenPack pages. Also, do
I need to put the latest version from SVN out?

Thanks,
Matt Ray
Zenoss Community Manager
community.zenoss.com
mray@zenoss.com

_______________________________________________
zenoss-zenpacks mailing list
zenoss-zenpacks@zenoss.org
http://lists.zenoss.org/mailman/listinfo/zenoss-zenpacks

Report Abuse
Like (0)

punkarruso

2 posts since
Jul 3, 2009

Currently Being Moderated

26. Jul 13, 2009 7:23 AM (in response to Matt Ray)

RE: New ODBC Datasource ZenPack

Thanks, I supposed well about missing __init__.py, I did it myself.
I had to work out some other changes:

in datasources/OdbcDataSource.py:

"echo \"%s\" | isql

is replaced replaced by zenoss with:

"/usr/bin/echo \"%s\" | isql

this doesn't work since echo is a shell builtin, so I had to create /usr/bin/echo as:

#!/bin/bash
echo $@

kind regards

Report Abuse
Like (0)

bomek

29 posts since
Nov 10, 2009

Currently Being Moderated

27. Nov 19, 2009 4:03 AM (in response to bigegor)

Re: RE: New ODBC Datasource ZenPack

By the way, does anyone know how to compile pyodbc.so under debian lenny?

pyodbc.so compile succesfully, but when it try to load: undefined symbol: __gxx_personality_v0

I've tried compiling the module under debian etch, same problem...

Report Abuse
Like (0)

ressu

4 posts since
Aug 14, 2008

Currently Being Moderated

28. Nov 26, 2009 7:43 AM (in response to bomek)

Re: RE: New ODBC Datasource ZenPack

Right. I managed to build pyodbc so that it actually loads properly. Apparently there is a problem when compiling pyodbc and the library doesn't get all the required dependencies (do a search with the symbol name and get the whole story). The trick is to get pyodbc source and edit the setup.py. On the line where it says "libraries = []" add stdc++ as a library. so in the end it says "libraries = ['stdc++']".

Compile the package with "easy_install ." and the ZenODBC zenpack should now work.

Report Abuse
Like (0)

bigegor

208 posts since
Apr 23, 2009

Currently Being Moderated

29. Dec 3, 2009 10:49 AM (in response to ressu)

Re: RE: New ODBC Datasource ZenPack

I have updated the ZenODBC ZenPack on SVN . ZenODBC zenpack should now work also without pyodbc library. Suggestions and comments are welcome.

Egor

Report Abuse
Like (0)

Actions

More Like This