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
"echo \"%s\" | isql
"/usr/bin/echo \"%s\" | isql
#!/bin/bash
echo $@
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...
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.
I have updated the ZenODBC ZenPack on SVN . ZenODBC zenpack should now work also without pyodbc library. Suggestions and comments are welcome.
Egor
Follow Us On Twitter »
|
Latest from the Zenoss Blog » | Community | Products | Services Resources | Customers Partners | About Us | ||
Copyright © 2005-2011 Zenoss, Inc.
|
||||||||