Archived community.zenoss.org | full text search
Skip navigation
1 2 3 Previous Next 148498 Views 30 Replies Latest reply: Dec 8, 2009 10:50 PM by Matt Ray RSS Go to original post
  • j053ph4 Rank: Green Belt 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
  • bigegor ZenossMaster 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
    
  • j053ph4 Rank: Green Belt 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.
  • bigegor ZenossMaster 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
  • j053ph4 Rank: Green Belt 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
  • j053ph4 Rank: Green Belt 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)
  • j053ph4 Rank: Green Belt 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...
  • bigegor ZenossMaster 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.
  • punkarruso Newbie 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?
  • bigegor ZenossMaster 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.
  • punkarruso Newbie 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
  • bomek Rank: White Belt 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...

  • ressu Newbie 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.

  • bigegor ZenossMaster 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

More Like This

  • Retrieving data ...