<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:clearspace="http://www.jivesoftware.com/xmlns/clearspace/rss" xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
  <channel>
    <title>ZenPacks : MySQL Database Monitor : Comments</title>
    <link>http://community.zenoss.org/docs/DOC-3388#comments</link>
    <description>Comments on : MySQL Database Monitor</description>
    <language>en</language>
    <pubDate>Wed, 20 Jan 2010 11:24:41 GMT</pubDate>
    <generator>Jive SBS 4.5.6.2  (http://jivesoftware.com/products/clearspace/)</generator>
    <dc:date>2010-01-20T11:24:41Z</dc:date>
    <dc:language>en</dc:language>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-1691</link>
      <description>&lt;!-- [DocumentBodyStart:a7a90900-4b82-4a7f-aa46-d0aaec9aa7d2] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;&lt;span id="comment-body-1675"&gt;&lt;div&gt;&lt;p&gt;Can we get some more detail on what this does over and above the standard Zenoss MYSQL core....&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;More docs please &lt;img height="16px" src="http://community.zenoss.org/4.5.6/images/emoticons/happy.gif" width="16px"/&gt;&lt;/p&gt;&lt;/div&gt;&lt;/span&gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:a7a90900-4b82-4a7f-aa46-d0aaec9aa7d2] --&gt;</description>
      <pubDate>Wed, 20 Jan 2010 11:24:41 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-1691</guid>
      <dc:date>2010-01-20T11:24:41Z</dc:date>
      <clearspace:dateToText>4 years, 1 month ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-1695</link>
      <description>&lt;!-- [DocumentBodyStart:19db3465-433b-4151-8b44-ffa1b19936ca] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;&lt;strong&gt;&lt;strong&gt;Regarding &lt;/strong&gt;MySqlDatabase&lt;/strong&gt; template that is available for binding. How do we add multiple instances of MySQL monitored which use different ports? Can you provide a procedure for this?&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:19db3465-433b-4151-8b44-ffa1b19936ca] --&gt;</description>
      <pubDate>Fri, 22 Jan 2010 17:37:40 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-1695</guid>
      <dc:date>2010-01-22T17:37:40Z</dc:date>
      <clearspace:dateToText>4 years, 1 month ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-1909</link>
      <description>&lt;!-- [DocumentBodyStart:9b3c4202-1067-4bdc-a226-2d3aabe33c29] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;If someone has an instance of MySQL that's binding another IP rather then the device.manageIp then I suggest the following change in ZenPacks/community/MySQLMon_ODBC/modeler/plugins/community/odbc/MySqlDatabaseMap.py:&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;47,50c47&lt;br/&gt;&amp;lt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; if self.cs.lower().__contains__('server'):&lt;br/&gt;&amp;lt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; self.cs = "%s;Database=information_schema" %(self.cs)&lt;br/&gt;&amp;lt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; else:&lt;br/&gt;&amp;lt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; self.cs = "%s;Database=information_schema;SERVER=%s" %(self.cs, str(device.manageIp))&lt;br/&gt;---&lt;br/&gt;&amp;gt;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; self.cs = "%s;Database=information_schema;SERVER=%s" %(self.cs, str(device.manageIp))&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;now it's possible to specify "SERVER=" in zMySqlConnectionString without problems.&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:9b3c4202-1067-4bdc-a226-2d3aabe33c29] --&gt;</description>
      <pubDate>Mon, 12 Apr 2010 08:49:20 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-1909</guid>
      <dc:date>2010-04-12T08:49:20Z</dc:date>
      <clearspace:dateToText>3 years, 11 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-2016</link>
      <description>&lt;!-- [DocumentBodyStart:aec14280-aa4f-4011-b382-a7e9971b057d] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;There is a problem with the ZenPack. There is a typo in a data source information_schema shows as informarion_schema. Can someone fix?&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;I manually fixed things on my end to get things to work.&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;Please note that this adds an entry in the /home/zenoss/.odbc.ini file. The typo needs to be updated in this file as well.&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:aec14280-aa4f-4011-b382-a7e9971b057d] --&gt;</description>
      <pubDate>Thu, 06 May 2010 19:20:02 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-2016</guid>
      <dc:date>2010-05-06T19:20:02Z</dc:date>
      <clearspace:dateToText>3 years, 10 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-2018</link>
      <description>&lt;!-- [DocumentBodyStart:2534c621-639c-43e0-ae5e-3c8681466c55] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;typo is fixed, thanks &lt;a class="jive-link-profile-small" href="http://community.zenoss.org/people/jenkinskj"&gt;jenkinskj&lt;/a&gt; for pointing this out.&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;Egor&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:2534c621-639c-43e0-ae5e-3c8681466c55] --&gt;</description>
      <pubDate>Sun, 09 May 2010 18:16:24 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-2018</guid>
      <dc:date>2010-05-09T18:16:24Z</dc:date>
      <clearspace:dateToText>3 years, 10 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-2780</link>
      <description>&lt;!-- [DocumentBodyStart:b4d5692c-a0b3-4270-8027-0b643817e2bd] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;There is a typo in line 45 in the file ZenPacks/community/MySQLMon_ODBC/modeler/plugins/community/odbc/MySqlDatabaseMap.py&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;pwd = getattr(device, 'zMySqlUsername', None)&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;It should be zMySqlPassword.&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:b4d5692c-a0b3-4270-8027-0b643817e2bd] --&gt;</description>
      <pubDate>Tue, 05 Oct 2010 14:08:09 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-2780</guid>
      <dc:date>2010-10-05T14:08:09Z</dc:date>
      <clearspace:dateToText>3 years, 5 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-2879</link>
      <description>&lt;!-- [DocumentBodyStart:b2d2eba5-4929-4fe5-817d-dacb7467093e] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hello, i have this kind of problem in Event console when modeling device&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;message&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160;&amp;#160; Unhandled exception in zenhub service ZenPacks.community.SQLDataSource.services.SqlPerfConfig.SqlPerfConfig: 'dbname'&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;localhost|ZenPacks.community.SQLDataSource.services.SqlPerfConfig.SqlPerfConfig|||5|Unhandled&amp;#160; exception in zenhub service&amp;#160; ZenPacks.community.SQLDataSource.services.SqlPerfConfig.SqlPerfConfig:&amp;#160; \'dbname\'&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;table&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td style=";"&gt;traceback&lt;/td&gt;&lt;td style=";"&gt;Traceback (most recent call last):&amp;#160;&amp;#160; File "/opt/zenoss/Products/ZenCollector/services/config.py", line 84, in _wrapFunction&amp;#160;&amp;#160;&amp;#160;&amp;#160; return functor(*args, **kwargs)&amp;#160;&amp;#160; File "/opt/zenoss/ZenPacks/ZenPacks.community.SQLDataSource-1.3.egg/ZenPacks/community/SQLDat&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td style=";"&gt;methodCall&lt;/td&gt;&lt;td style=";"&gt;_createDeviceProxy((,), {})&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;i'm trying to setup Mysql ODBC&amp;#160; and MSSQL ODBC monitoring but only thing that works is "DB Server Instances" component, Databases component throws error "&lt;span id="ext-gen337"&gt;ValueError cannot convert float NaN to integer"&lt;/span&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;for me it seems that there is no property ${here/dbname} used in all of those queries&lt;/p&gt;&lt;p&gt;And another thing in template MySqlDatabases -&amp;gt; sizeUsed there is syntax error query&lt;/p&gt;&lt;p&gt;"FROM TABLES GROUP BY table_schema WHERE table_schema='${here/dbname}' "&lt;/p&gt;&lt;p&gt;GROUP BY should be after the WHERE clause"&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:b2d2eba5-4929-4fe5-817d-dacb7467093e] --&gt;</description>
      <pubDate>Mon, 18 Oct 2010 12:33:24 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-2879</guid>
      <dc:date>2010-10-18T12:33:24Z</dc:date>
      <clearspace:dateToText>3 years, 4 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-3182</link>
      <description>&lt;!-- [DocumentBodyStart:cea1f355-4f47-4a1a-941c-2c49b46b8b90] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Having Trouble running the modeler, and I don't see the template when I go to bind the template.&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;div id="_mcePaste"&gt;I installed the pre-req's as described, I added the Modeler Plugin and then modeled the database server and received the following error. I manually verified using the mysql command line tool to remotely connect to the machine with the credentials and run SQL command SHOW VARIABLES and data was properly returned...&lt;/div&gt;&lt;div id="_mcePaste"&gt; &lt;/div&gt;&lt;div id="_mcePaste"&gt; &lt;/div&gt;&lt;div&gt;Although when I run the modeler I get:&lt;/div&gt;&lt;div&gt;--------------------------------------&lt;/div&gt;&lt;div&gt; &lt;/div&gt;&lt;div&gt;2010-12-28 11:29:29,979 INFO zen.ZenModeler: Connecting to localhost:8789&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:29,998 INFO zen.ZenModeler: Connected to ZenHub&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,075 INFO zen.ZenModeler: Collecting for device db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,265 INFO zen.ZenModeler: No WMI plugins found for db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,278 INFO zen.ZenModeler: Python collection device db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,278 INFO zen.ZenModeler: plugins: community.odbc.MySqlDatabaseMap&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,294 INFO zen.ZenModeler: No command plugins found for db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,299 INFO zen.ZenModeler: SNMP collection device db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,300 INFO zen.ZenModeler: plugins: DellCPUMap, DellDeviceMap, DellPCIMap, zenoss.snmp.NewDeviceMap, zenoss.snmp.InterfaceMap, zenoss.snmp.RouteMap, zenoss.snmp.IpServiceMap, zenoss.snmp.HRFileSystemMap, zenoss.snmp.HRSWRunMap&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,409 INFO zen.ZenModeler: No portscan plugins found for db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,409 INFO zen.ZenModeler: Running 2 clients&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,421 ERROR zen.SQLClient: Received error (list index out of range) from query: SHOW VARIABLES&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,451 INFO zen.PythonClient: Python client finished collection for db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,452 ERROR zen.ZenModeler: Received error (list index out of range) from query: SHOW VARIABLES&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,452 INFO zen.ZenModeler: processing community.odbc.MySqlDatabaseMap for device -db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,694 ERROR zen.ZenModeler: Traceback (most recent call last):&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/ZenHub/PBDaemon.py", line 75, in inner&lt;/div&gt;&lt;div id="_mcePaste"&gt;return callable(*args, **kw)&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/ZenHub/services/ModelerService.py", line 109, in remote_applyDataMaps&lt;/div&gt;&lt;div id="_mcePaste"&gt;if adm._applyDataMap(device, map):&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/DataCollector/ApplyDataMap.py", line 198, in _applyDataMap&lt;/div&gt;&lt;div id="_mcePaste"&gt;changed = self._updateRelationship(tobj, datamap)&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/DataCollector/ApplyDataMap.py", line 261, in _updateRelationship&lt;/div&gt;&lt;div id="_mcePaste"&gt;objchange, obj = self._createRelObject(device, objmap, rname)&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/DataCollector/ApplyDataMap.py", line 445, in _createRelObject&lt;/div&gt;&lt;div id="_mcePaste"&gt;return self._updateObject(remoteObj, objmap) or changed, remoteObj&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/DataCollector/ApplyDataMap.py", line 370, in _updateObject&lt;/div&gt;&lt;div id="_mcePaste"&gt;setter(*args)&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/ZenPacks/ZenPacks.community.RDBMS-2.1.egg/ZenPacks/community/RDBMS/Database.py", line 136, in setDBSrvInst&lt;/div&gt;&lt;div id="_mcePaste"&gt;else: log.warn("DB Server Instance:%s not found", instname)&lt;/div&gt;&lt;div id="_mcePaste"&gt;NameError: global name 'log' is not defined&lt;/div&gt;&lt;div id="_mcePaste"&gt;Traceback (most recent call last):&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/DataCollector/zenmodeler.py", line 658, in processClient&lt;/div&gt;&lt;div id="_mcePaste"&gt;if driver.next():&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/ZenUtils/Driver.py", line 64, in result&lt;/div&gt;&lt;div id="_mcePaste"&gt;raise ex&lt;/div&gt;&lt;div id="_mcePaste"&gt;RemoteException: Traceback (most recent call last):&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/ZenHub/PBDaemon.py", line 75, in inner&lt;/div&gt;&lt;div id="_mcePaste"&gt;return callable(*args, **kw)&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/ZenHub/services/ModelerService.py", line 109, in remote_applyDataMaps&lt;/div&gt;&lt;div id="_mcePaste"&gt;if adm._applyDataMap(device, map):&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/DataCollector/ApplyDataMap.py", line 198, in _applyDataMap&lt;/div&gt;&lt;div id="_mcePaste"&gt;changed = self._updateRelationship(tobj, datamap)&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/DataCollector/ApplyDataMap.py", line 261, in _updateRelationship&lt;/div&gt;&lt;div id="_mcePaste"&gt;objchange, obj = self._createRelObject(device, objmap, rname)&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/DataCollector/ApplyDataMap.py", line 445, in _createRelObject&lt;/div&gt;&lt;div id="_mcePaste"&gt;return self._updateObject(remoteObj, objmap) or changed, remoteObj&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/DataCollector/ApplyDataMap.py", line 370, in _updateObject&lt;/div&gt;&lt;div id="_mcePaste"&gt;setter(*args)&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/ZenPacks/ZenPacks.community.RDBMS-2.1.egg/ZenPacks/community/RDBMS/Database.py", line 136, in setDBSrvInst&lt;/div&gt;&lt;div id="_mcePaste"&gt;else: log.warn("DB Server Instance:%s not found", instname)&lt;/div&gt;&lt;div id="_mcePaste"&gt;NameError: global name 'log' is not defined&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,696 ERROR zen.ZenModeler: Client db2 finished with message: [Failure instance: Traceback (failure with no frames): : Traceback (most recent call last):&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/ZenHub/PBDaemon.py", line 75, in inner&lt;/div&gt;&lt;div id="_mcePaste"&gt;return callable(*args, **kw)&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/ZenHub/services/ModelerService.py", line 109, in remote_applyDataMaps&lt;/div&gt;&lt;div id="_mcePaste"&gt;if adm._applyDataMap(device, map):&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/DataCollector/ApplyDataMap.py", line 198, in _applyDataMap&lt;/div&gt;&lt;div id="_mcePaste"&gt;changed = self._updateRelationship(tobj, datamap)&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/DataCollector/ApplyDataMap.py", line 261, in _updateRelationship&lt;/div&gt;&lt;div id="_mcePaste"&gt;objchange, obj = self._createRelObject(device, objmap, rname)&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/DataCollector/ApplyDataMap.py", line 445, in _createRelObject&lt;/div&gt;&lt;div id="_mcePaste"&gt;return self._updateObject(remoteObj, objmap) or changed, remoteObj&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/Products/DataCollector/ApplyDataMap.py", line 370, in _updateObject&lt;/div&gt;&lt;div id="_mcePaste"&gt;setter(*args)&lt;/div&gt;&lt;div id="_mcePaste"&gt;File "/usr/local/zenoss/zenoss/ZenPacks/ZenPacks.community.RDBMS-2.1.egg/ZenPacks/community/RDBMS/Database.py", line 136, in setDBSrvInst&lt;/div&gt;&lt;div id="_mcePaste"&gt;else: log.warn("DB Server Instance:%s not found", instname)&lt;/div&gt;&lt;div id="_mcePaste"&gt;NameError: global name 'log' is not defined&lt;/div&gt;&lt;div id="_mcePaste"&gt;]&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,995 INFO zen.SnmpClient: snmp client finished collection for db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,996 INFO zen.ZenModeler: processing DellCPUMap for device db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,996 INFO zen.ZenModeler: processing DellPCIMap for device db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,997 INFO zen.ZenModeler: Processing zenoss.snmp.NewDeviceMap for device db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:30,998 INFO zen.ZenModeler: Modeler zenoss.snmp.InterfaceMap processing data for device db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:31,000 INFO zen.ZenModeler: processing zenoss.snmp.RouteMap for device db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:31,001 INFO zen.ZenModeler: processing zenoss.snmp.IpServiceMap for device db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:31,003 INFO zen.ZenModeler: Modeler zenoss.snmp.HRFileSystemMap processing data for device db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:31,004 INFO zen.ZenModeler: Skipping /proc/sys/fs/binfmt_misc. 0 total blocks.&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:31,004 INFO zen.ZenModeler: Skipping Memory Buffers (other) as it matches zFileSystemMapIgnoreTypes.&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:31,004 INFO zen.ZenModeler: Skipping Swap Space (virtualMemory) as it matches zFileSystemMapIgnoreTypes.&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:31,005 INFO zen.ZenModeler: Skipping Real Memory (ram) as it matches zFileSystemMapIgnoreTypes.&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:31,005 INFO zen.ZenModeler: Skipping /sys. 0 total blocks.&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:31,006 INFO zen.ZenModeler: Skipping /proc/bus/usb. 0 total blocks.&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:31,007 INFO zen.ZenModeler: Processing zenoss.snmp.HRSWRunMap for device db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:31,323 INFO zen.ZenModeler: Changes in configuration applied&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:31,380 INFO zen.ZenModeler: Scan time: 1.31 seconds&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 11:29:31,391 INFO zen.ZenModeler: Daemon ZenModeler shutting down&lt;/div&gt;&lt;div id="_mcePaste"&gt; &lt;/div&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:cea1f355-4f47-4a1a-941c-2c49b46b8b90] --&gt;</description>
      <pubDate>Tue, 28 Dec 2010 17:36:17 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-3182</guid>
      <dc:date>2010-12-28T17:36:17Z</dc:date>
      <clearspace:dateToText>3 years, 2 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-3195</link>
      <description>&lt;!-- [DocumentBodyStart:26d36245-a35e-4f2a-8c7d-5ddece9d0e6b] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi tharrer,&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;simply remove line 136 from (&lt;strong&gt;else: log.warn("DB Server Instance:%s not found", instname)&lt;/strong&gt;) file "/usr/local/zenoss/zenoss/ZenPacks/ZenPacks.community.RDBMS-2.1.egg/ZenPacks/community/RDBMS/Database.py" and restart zenoss.&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;Egor&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:26d36245-a35e-4f2a-8c7d-5ddece9d0e6b] --&gt;</description>
      <pubDate>Tue, 28 Dec 2010 18:02:48 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-3195</guid>
      <dc:date>2010-12-28T18:02:48Z</dc:date>
      <clearspace:dateToText>3 years, 2 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-3183</link>
      <description>&lt;!-- [DocumentBodyStart:85ec95be-c7d0-49d4-9ca7-a304afc2dacb] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Thanks for the super-fast response! I commented out as you suggested, restarted and now just get the following modeler error&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;div id="_mcePaste"&gt;2010-12-28 12:15:05,322 ERROR zen.SQLClient: Received error (list index out of range) from query: SHOW VARIABLES&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 12:15:05,351 INFO zen.PythonClient: Python client finished collection for db2&lt;/div&gt;&lt;div id="_mcePaste"&gt;2010-12-28 12:15:05,351 ERROR zen.ZenModeler: Received error (list index out of range) from query: SHOW VARIABLES&lt;/div&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;I don't see the template still. Here's the full output of the modeler&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;&lt;p&gt;2010-12-28 12:15:04,877 INFO zen.ZenModeler: Connecting to localhost:8789&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:04,897 INFO zen.ZenModeler: Connected to ZenHub&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:04,975 INFO zen.ZenModeler: Collecting for device db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,169 INFO zen.ZenModeler: No WMI plugins found for db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,181 INFO zen.ZenModeler: Python collection device db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,181 INFO zen.ZenModeler: plugins: community.odbc.MySqlDatabaseMap&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,197 INFO zen.ZenModeler: No command plugins found for db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,202 INFO zen.ZenModeler: SNMP collection device db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,202 INFO zen.ZenModeler: plugins: DellCPUMap, DellDeviceMap, DellPCIMap, zenoss.snmp.NewDeviceMap, zenoss.snmp.InterfaceMap, zenoss.snmp.RouteMap, zenoss.snmp.IpServiceMap, zenoss.snmp.HRFileSystemMap, zenoss.snmp.HRSWRunMap&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,311 INFO zen.ZenModeler: No portscan plugins found for db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,311 INFO zen.ZenModeler: Running 2 clients&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,322 ERROR zen.SQLClient: Received error (list index out of range) from query: SHOW VARIABLES&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,351 INFO zen.PythonClient: Python client finished collection for db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,351 ERROR zen.ZenModeler: Received error (list index out of range) from query: SHOW VARIABLES&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,351 INFO zen.ZenModeler: processing community.odbc.MySqlDatabaseMap for device db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,851 INFO zen.ZenModeler: Changes in configuration applied&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,911 INFO zen.SnmpClient: snmp client finished collection for db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,912 INFO zen.ZenModeler: processing DellCPUMap for device db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,913 INFO zen.ZenModeler: processing DellPCIMap for device db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,913 INFO zen.ZenModeler: Processing zenoss.snmp.NewDeviceMap for device db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,915 INFO zen.ZenModeler: Modeler zenoss.snmp.InterfaceMap processing data for device db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,916 INFO zen.ZenModeler: processing zenoss.snmp.RouteMap for device db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,918 INFO zen.ZenModeler: processing zenoss.snmp.IpServiceMap for device db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,920 INFO zen.ZenModeler: Modeler zenoss.snmp.HRFileSystemMap processing data for device db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,922 INFO zen.ZenModeler: Skipping /proc/sys/fs/binfmt_misc. 0 total blocks.&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,923 INFO zen.ZenModeler: Skipping Memory Buffers (other) as it matches zFileSystemMapIgnoreTypes.&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,923 INFO zen.ZenModeler: Skipping Swap Space (virtualMemory) as it matches zFileSystemMapIgnoreTypes.&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,924 INFO zen.ZenModeler: Skipping Real Memory (ram) as it matches zFileSystemMapIgnoreTypes.&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,924 INFO zen.ZenModeler: Skipping /sys. 0 total blocks.&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,925 INFO zen.ZenModeler: Skipping /proc/bus/usb. 0 total blocks.&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:05,926 INFO zen.ZenModeler: Processing zenoss.snmp.HRSWRunMap for device db2&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:06,238 INFO zen.ZenModeler: Changes in configuration applied&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:06,295 INFO zen.ZenModeler: Scan time: 1.32 seconds&lt;/p&gt;&lt;p&gt;2010-12-28 12:15:06,305 INFO zen.ZenModeler: Daemon ZenModeler shutting down&lt;/p&gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:85ec95be-c7d0-49d4-9ca7-a304afc2dacb] --&gt;</description>
      <pubDate>Tue, 28 Dec 2010 18:17:39 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-3183</guid>
      <dc:date>2010-12-28T18:17:39Z</dc:date>
      <clearspace:dateToText>3 years, 2 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-3212</link>
      <description>&lt;!-- [DocumentBodyStart:9818c143-50e0-48d6-84a0-86245ad7c5a6] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;pre&gt;display&amp;#160; conflicts in POSTGRESQL ODBC DATABASE MONITOR and MySQL ODBC Database Monitor.
&lt;/pre&gt;&lt;p&gt;&lt;a href="http://weizi888.appspot.com/media/agh3ZWl6aTg4OHINCxIFTWVkaWEYiY8IDA/%E6%9C%AA%E5%91%BD%E5%90%8D.JPG?a=download"&gt;&lt;img src="http://weizi888.appspot.com/media/agh3ZWl6aTg4OHINCxIFTWVkaWEYiY8IDA/%E6%9C%AA%E5%91%BD%E5%90%8D.JPG?a=download"/&gt;&lt;/a&gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:9818c143-50e0-48d6-84a0-86245ad7c5a6] --&gt;</description>
      <pubDate>Sun, 02 Jan 2011 06:50:39 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-3212</guid>
      <dc:date>2011-01-02T06:50:39Z</dc:date>
      <clearspace:dateToText>3 years, 2 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-3218</link>
      <description>&lt;!-- [DocumentBodyStart:4fe95860-d583-49dc-a840-3b635d2377b2] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;fixed&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;&lt;a class="jive-link-wiki-small" href="http://community.zenoss.org/docs/DOC-3497"&gt;http://community.zenoss.org/docs/DOC-3497&lt;/a&gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:4fe95860-d583-49dc-a840-3b635d2377b2] --&gt;</description>
      <pubDate>Mon, 03 Jan 2011 03:39:15 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-3218</guid>
      <dc:date>2011-01-03T03:39:15Z</dc:date>
      <clearspace:dateToText>3 years, 2 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-3314</link>
      <description>&lt;!-- [DocumentBodyStart:644d4cd1-f24b-4f37-be9b-9f1324cb232b] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I've tried installing this zenpack via zenoss gui and it does not show up. I also cannot find the plugin in the modeler plugin list when I click Add Fields &lt;img height="16px" src="http://community.zenoss.org/4.5.6/images/emoticons/sad.gif" width="16px"/&gt;&lt;/p&gt;&lt;p&gt;I've restarted zenoss and it still doesn't work. Can someone please step me through how to install and use this zenpack?&lt;/p&gt;&lt;p&gt;Thanks&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:644d4cd1-f24b-4f37-be9b-9f1324cb232b] --&gt;</description>
      <pubDate>Wed, 19 Jan 2011 15:59:45 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-3314</guid>
      <dc:date>2011-01-19T15:59:45Z</dc:date>
      <clearspace:dateToText>3 years, 1 month ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-4306</link>
      <description>&lt;!-- [DocumentBodyStart:7fd7cacd-e689-4a58-a149-1bad30da2b28] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi, Egor,&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160; i'm using SQL Datasource 1.96 in order to use the 2.83 Beta WMI Datasource...&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160; is there any problem using this version of SQL Datasource? I installed MySQL ODBC Database Monitor, configured zMysqlUsername and ZMysqlPassword, added the modeler, and when modelling the device (with zenmodeler run -v10 -d &amp;lt;host&amp;gt;) the result is:&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;2011-08-02 13:59:13,649 DEBUG zen.ZenModeler: Plugin community.odbc.MySqlDatabaseMap results = {'vr_0': [{'have': 'have_bdb'}, {'have': 'have_compress'}, {'have': 'have_crypt'}, {'have': 'have_dynamic_loading'}, {'have': 'have_geometry'}, {'have': 'have_innodb'}, {'have': 'have_merge_engine'}, {'have': 'have_query_cache'}, {'have': 'have_rtree_keys'}, {'have': 'have_symlink'}], 'db_0': [{'activeTime': DateTime('2011/06/22 14:11:08 GMT+2'), 'version': 10L, 'setDBSrvInst': 0L, 'collation': 'latin1_swedish_ci', 'type': 'InnoDB', 'dbname': 'events'}, {'activeTime': DateTime('2011/08/02 13:59:13 GMT+2'), 'version': 0L, 'setDBSrvInst': 0L, 'collation': 'utf8_general_ci', 'type': 'MEMORY', 'dbname': 'information_schema'}, {'activeTime': DateTime('2011/06/22 14:08:03 GMT+2'), 'version': 10L, 'setDBSrvInst': 0L, 'collation': 'utf8_bin', 'type': 'MyISAM', 'dbname': 'mysql'}], 'si_0': [{'port': 3306L, 'version': '5.0.77', 'hostname': '&amp;lt;host&amp;gt;', 'license': 'GPL', 'setProductKey': 'x86_64'}]}&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;The modeller is connecting and retreiving information... but there's no new Databases component.&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;Am I doing it wrong???&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:7fd7cacd-e689-4a58-a149-1bad30da2b28] --&gt;</description>
      <pubDate>Tue, 02 Aug 2011 12:04:25 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-4306</guid>
      <dc:date>2011-08-02T12:04:25Z</dc:date>
      <clearspace:dateToText>2 years, 7 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-4400</link>
      <description>&lt;!-- [DocumentBodyStart:2073cc14-afbd-4852-a746-44eb756f0295] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi luizzmizz,&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;do you see some 'DB Server Instances'?&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;Egor&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:2073cc14-afbd-4852-a746-44eb756f0295] --&gt;</description>
      <pubDate>Fri, 05 Aug 2011 22:07:43 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-4400</guid>
      <dc:date>2011-08-05T22:07:43Z</dc:date>
      <clearspace:dateToText>2 years, 7 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-4509</link>
      <description>&lt;!-- [DocumentBodyStart:872d91a8-3036-4164-a585-72d215ce39a9] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi Egor,&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;I had issues with the MySqlDatabase and MySqlSrvinst datasources which caused alerts like this:&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;Could not fetch data from source (Received error ((2005, "Unknown MySQL server host 'webdb1' (1)")) from query: SHOW GLOBAL STATUS)&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;Could not fetch data from source (Received error ((2005, "Unknown MySQL server host 'webdb1' (1)")) from query: SELECT sum(data_length) as dataSize, sum(index_length) as indexSize, sum( data_length + index_length ) as sizeUsed, table_schema FROM TABLES GROUP BY table_schema )&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;Zenoss is trying to use a short hostname when an FQDN is needed.&amp;#160; In $ZENHOME/ZenPacks/ZenPacks.community.MySQLMon_ODBC-3.1.egg/ZenPacks/community/MySQLMon_ODBC/objects/objects.xml, if you change ${here/hostname} to ${here/manageIp} the problems go away.&amp;#160; &lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:872d91a8-3036-4164-a585-72d215ce39a9] --&gt;</description>
      <pubDate>Wed, 24 Aug 2011 13:36:35 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-4509</guid>
      <dc:date>2011-08-24T13:36:35Z</dc:date>
      <clearspace:dateToText>2 years, 6 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-4511</link>
      <description>&lt;!-- [DocumentBodyStart:c7bb99d7-c91e-40a8-82f7-d47d0c36bd8a] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi Greg,&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;replacing &lt;span style="color: #2b2b2b; font-family: Arial; font-size: 12px; background-color: #ffffff;"&gt;${here/hostname}&lt;/span&gt; with &lt;span style="color: #2b2b2b; font-family: Arial; font-size: 12px; background-color: #ffffff;"&gt;${here/manageIp} will not helping, if you have multiple MySQL instances with different IP addresses working on single server. So, you must fix names resolution. You can check real FQDN name of you MySQL server with following query:&lt;/span&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;blockquote class="jive-quote"&gt;&lt;span style="color: #2b2b2b; font-family: Arial; font-size: 12px; background-color: #ffffff;"&gt;SHOW VARIABLES like 'hostname';&lt;/span&gt;&lt;/blockquote&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:c7bb99d7-c91e-40a8-82f7-d47d0c36bd8a] --&gt;</description>
      <pubDate>Wed, 24 Aug 2011 18:57:36 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-4511</guid>
      <dc:date>2011-08-24T18:57:36Z</dc:date>
      <clearspace:dateToText>2 years, 6 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-5595</link>
      <description>&lt;!-- [DocumentBodyStart:ec864429-2159-4559-960e-c570a32e4aea] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Egor,&lt;/p&gt;&lt;p&gt;I'm trying to install 3.2 (coming from 3.1, which I have uninstalled) and am running into an error during zenpack installation. I was able to successfully upgrade both dependencies to current, but this pack is giving issue.&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;2012-05-10 14:20:47,590 INFO zen.ZPLoader: Loading /usr/local/zenoss/zenoss/ZenPacks/ZenPacks.community.MySQLMon-3.2.egg/ZenPacks/community/MySQLMon/objects/objects.xml&lt;/p&gt;&lt;p&gt;2012-05-10 14:20:49,378 ERROR zen.ZenPackCmd: zenpack command failed&lt;/p&gt;&lt;p&gt;Traceback (most recent call last):&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/zenoss/Products/ZenUtils/zenpack.py", line 406, in &amp;lt;module&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; zp.run()&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/zenoss/Products/ZenUtils/zenpack.py", line 134, in run&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; previousVersion= self.options.previousVersion)&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/zenoss/Products/ZenUtils/ZenPackCmd.py", line 249, in InstallEggAndZenPack&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; forceRunExternal=forceRunExternal)&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/zenoss/Products/ZenUtils/ZenPackCmd.py", line 424, in InstallDistAsZenPack&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; zenPack.install(dmd)&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/zenoss/Products/ZenModel/ZenPack.py", line 251, in install&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; loader.load(self, app)&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/zenoss/Products/ZenModel/ZenPackLoader.py", line 99, in load&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; importer.loadObjectFromXML(xmlfile=f)&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/zenoss/Products/ZenRelations/ImportRM.py", line 458, in loadObjectFromXML&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; parser.parse(self.infile)&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/python/lib/python2.6/site-packages/_xmlplus/sax/expatreader.py", line 109, in parse&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; xmlreader.IncrementalParser.parse(self, source)&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/python/lib/python2.6/site-packages/_xmlplus/sax/xmlreader.py", line 123, in parse&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; self.feed(buffer)&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/python/lib/python2.6/site-packages/_xmlplus/sax/expatreader.py", line 216, in feed&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; self._parser.Parse(data, isFinal)&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/python/lib/python2.6/site-packages/_xmlplus/sax/expatreader.py", line 312, in start_element&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; self._cont_handler.startElement(name, AttributesImpl(attrs))&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/zenoss/Products/ZenRelations/ImportRM.py", line 145, in startElement&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; obj = self.createObject(attrs)&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/zenoss/Products/ZenRelations/ImportRM.py", line 287, in createObject&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; self.context()._setObject(obj.id, obj)&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/zenoss/Products/ZenRelations/ToManyContRelationship.py", line 125, in _setObject&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; self.addRelation(object)&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/zenoss/Products/ZenRelations/ToManyContRelationship.py", line 116, in addRelation&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; ToManyRelationshipBase.addRelation(self, obj)&lt;/p&gt;&lt;p&gt;&amp;#160; File "/usr/local/zenoss/zenoss/Products/ZenRelations/RelationshipBase.py", line 94, in addRelation&lt;/p&gt;&lt;p&gt;&amp;#160;&amp;#160;&amp;#160; obj.id, obj.__class__.__name__))&lt;/p&gt;&lt;p&gt;ZenSchemaError: rrdTemplates restricted to class RRDTemplate. Filemaker is class EventClass&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;Any suggestions?&lt;/p&gt;&lt;p&gt;~Thanks&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:ec864429-2159-4559-960e-c570a32e4aea] --&gt;</description>
      <pubDate>Thu, 10 May 2012 21:32:46 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-5595</guid>
      <dc:date>2012-05-10T21:32:46Z</dc:date>
      <clearspace:dateToText>1 year, 10 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>RE: MySQL Database Monitor</title>
      <link>http://community.zenoss.org/docs/DOC-3388#comments-5674</link>
      <description>&lt;!-- [DocumentBodyStart:347aa375-bfc4-4a17-9edb-47bff2a4f1e3] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi Tim,&lt;/p&gt;&lt;p style="min-height: 8pt; height: 8pt; padding: 0px;"&gt;&amp;#160;&lt;/p&gt;&lt;p&gt;solved in version 3.3&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:347aa375-bfc4-4a17-9edb-47bff2a4f1e3] --&gt;</description>
      <pubDate>Sun, 20 May 2012 17:54:22 GMT</pubDate>
      <author>community@zenoss.org</author>
      <guid>http://community.zenoss.org/docs/DOC-3388#comments-5674</guid>
      <dc:date>2012-05-20T17:54:22Z</dc:date>
      <clearspace:dateToText>1 year, 9 months ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
  </channel>
</rss>

