![]() |
![]() |
Subject: | How to batch load device into Zenoss5 |
Author: | [Not Specified] |
Posted: | 2015-05-07 00:19 |
in Zenoss 4.2, zenbatchdump and zenbatchload worked fine, according to the Zenoss5 Admin Guide, it says to attach the Zenoss.core, then do the samething as previous version. Howerver, it doesn't work at all.
Errors below,
##############
[zenoss@bc0856780526 ~]$ zenbatchdump > mydevicelist.txt
2015-05-07 05:09:10,941 WARNING relstorage.adapters.mysql: Unable to connect: (2003, "Can't connect to MySQL server on '127.0.0.1' (111)")
Traceback (most recent call last):
File "/opt/zenoss/Products/ZenModel/BatchDeviceDumper.py", line 770, in
batchDumper = BatchDeviceDumper()
File "/opt/zenoss/Products/ZenModel/BatchDeviceDumper.py", line 96, in __init__
ZCmdBase.__init__(self, *args, **kwargs)
File "/opt/zenoss/Products/ZenUtils/ZCmdBase.py", line 96, in __init__
self.zodbConnect()
File "/opt/zenoss/Products/ZenUtils/ZCmdBase.py", line 104, in zodbConnect
self.db, self.storage = connectionFactory.getConnection(**self.options.__dict__)
File "/opt/zenoss/Products/ZenUtils/MySqlZodbFactory.py", line 165, in getConnection
storage = relstorage.storage.RelStorage(adapter, **relstoreParams)
File "/opt/zenoss/lib/python2.7/site-packages/relstorage/storage.py", line 167, in __init__
self._adapter.schema.prepare()
File "/opt/zenoss/lib/python2.7/site-packages/relstorage/adapters/schema.py", line 856, in prepare
self.connmanager.open_and_call(callback)
File "/opt/zenoss/lib/python2.7/site-packages/relstorage/adapters/connmanager.py", line 73, in open_and_call
conn, cursor = self.open()
File "/opt/zenoss/Products/ZenUtils/patches/mysqladaptermonkey.py", line 70, in open
conn, cursor = original(self, *args, **kwargs)
File "/opt/zenoss/lib/python2.7/site-packages/relstorage/adapters/mysql.py", line 231, in open
conn = MySQLdb.connect(**self._params)
File "/opt/zenoss/lib/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
return Connection(*args, **kwargs)
File "/opt/zenoss/lib/python2.7/site-packages/MySQLdb/connections.py", line 187, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on '127.0.0.1' (111)")
###################
To me, seems like the script is from the old version, as Zenoss5 is not using MySql.
I also tried to load device in.
########################
[zenoss@bc0856780526 ~]$ zenbatchload mydevicelist.txt
2015-05-07 05:18:07,668 WARNING relstorage.adapters.mysql: Unable to connect: (2003, "Can't connect to MySQL server on '127.0.0.1' (111)")
Traceback (most recent call last):
File "/opt/zenoss/Products/ZenModel/BatchDeviceLoader.py", line 768, in
batchLoader = BatchDeviceLoader()
File "/opt/zenoss/Products/ZenModel/BatchDeviceLoader.py", line 155, in __init__
ZCmdBase.__init__(self, *args, **kwargs)
File "/opt/zenoss/Products/ZenUtils/ZCmdBase.py", line 96, in __init__
self.zodbConnect()
File "/opt/zenoss/Products/ZenUtils/ZCmdBase.py", line 104, in zodbConnect
self.db, self.storage = connectionFactory.getConnection(**self.options.__dict__)
File "/opt/zenoss/Products/ZenUtils/MySqlZodbFactory.py", line 165, in getConnection
storage = relstorage.storage.RelStorage(adapter, **relstoreParams)
File "/opt/zenoss/lib/python2.7/site-packages/relstorage/storage.py", line 167, in __init__
self._adapter.schema.prepare()
File "/opt/zenoss/lib/python2.7/site-packages/relstorage/adapters/schema.py", line 856, in prepare
self.connmanager.open_and_call(callback)
File "/opt/zenoss/lib/python2.7/site-packages/relstorage/adapters/connmanager.py", line 73, in open_and_call
conn, cursor = self.open()
File "/opt/zenoss/Products/ZenUtils/patches/mysqladaptermonkey.py", line 70, in open
conn, cursor = original(self, *args, **kwargs)
File "/opt/zenoss/lib/python2.7/site-packages/relstorage/adapters/mysql.py", line 231, in open
conn = MySQLdb.connect(**self._params)
File "/opt/zenoss/lib/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
return Connection(*args, **kwargs)
File "/opt/zenoss/lib/python2.7/site-packages/MySQLdb/connections.py", line 187, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on '127.0.0.1' (111)")
########################
Did I do anything wrong here or I misunderstand the documentation
Thanks,
Hubery
Subject: | ok, just checked the wiki, a |
Author: | [Not Specified] |
Posted: | 2015-05-07 00:46 |
ok, just checked the wiki, a new release of admin guide was published, something wrong with the old document.
I should attach to zenhub rather than Zenoss.core.
serviced service attach zenhub
Problem solved.
thanks!
< |
Previous Collector |
Next Windows Servers are not being modeled correctly |
> |