zendmd on collector fails

[ignacio freyre]

ignacio freyre [http://community.zenoss.org/people/nachofw] created the discussion

"zendmd on collector fails"

To view the discussion, visit: http://community.zenoss.org/message/74657#74657

--------------------------------------------------------------
Running zenoss 4.2.4 + 2 collectors.
For zenrestore to work on main server i had to change the password for zenoss user in mysql because of the secure script.
Running zendmd on collector fails now:

2013-09-14 15:17:46 WARNING relstorage.adapters.mysql Unable to connect: (1045, "Access denied for user 'zenoss'@'zenag' (using password: YES)")
Traceback (most recent call last):
  File "/opt/zenoss/Products/ZenModel/zendmd.py", line 445, in <module>
    vars = _customStuff()
  File "/opt/zenoss/Products/ZenModel/zendmd.py", line 117, in _customStuff
    app = Zope2.app()
  File "/opt/zenoss/lib/python/Zope2/__init__.py", line 51, in app
    startup()
  File "/opt/zenoss/lib/python/Zope2/__init__.py", line 47, in startup
    _startup()
  File "/opt/zenoss/lib/python/Zope2/App/startup.py", line 81, in startup
    DB = dbtab.getDatabase('/', is_root=1)
  File "/opt/zenoss/lib/python/Zope2/Startup/datatypes.py", line 287, in getDatabase
    db = factory.open(name, self.databases)
  File "/opt/zenoss/lib/python/Zope2/Startup/datatypes.py", line 185, in open
    DB = self.createDB(database_name, databases)
  File "/opt/zenoss/lib/python/Zope2/Startup/datatypes.py", line 182, in createDB
    return ZODBDatabase.open(self, databases)
  File "/opt/zenoss/lib/python/ZODB/config.py", line 101, in open
    storage = section.storage.open()
  File "/opt/zenoss/lib/python/relstorage/config.py", line 33, in open
    return RelStorage(adapter, name=config.name, options=options)
  File "/opt/zenoss/lib/python/relstorage/storage.py", line 167, in __init__
    self._adapter.schema.prepare()
  File "/opt/zenoss/lib/python/relstorage/adapters/schema.py", line 856, in prepare
    self.connmanager.open_and_call(callback)
  File "/opt/zenoss/lib/python/relstorage/adapters/connmanager.py", line 73, in open_and_call
    conn, cursor = self.open()
  File "/opt/zenoss/lib/python/relstorage/adapters/mysql.py", line 231, in open
    conn = MySQLdb.connect(**self._params)
  File "/opt/zenoss/lib/python/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/opt/zenoss/lib/python/MySQLdb/connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'zenoss'@'zenag' (using password: YES)")


im sure i have to modify some credentials somewhere, not sure where. Please help.

regards
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/74657#74657]

Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[jmp242]

jmp242 [http://community.zenoss.org/people/jmp242] created the discussion

"Re: zendmd on collector fails"

To view the discussion, visit: http://community.zenoss.org/message/74650#74650

--------------------------------------------------------------
Look at the files
global.conf:zodb-password
global.conf:amqppassword
global.conf:zep-password
global.conf:hubpassword
zenjmx.conf:#  zenoss., default:
zenjmx.conf:#hubpassword
zenwinperf.conf:#  zenoss., default:
zenwinperf.conf:#hubpassword
zodb_db_main.conf:    passwd
zodb_db_session.conf:    passwd

and any other relevant ones and compare between hub and collector and set the passwords appropriately...


--
James Pulver
ZCA Member
CLASSE Computer Group
Cornell University
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/74650#74650]

Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[ignacio freyre]

ignacio freyre [http://community.zenoss.org/people/nachofw] created the discussion

"Re: zendmd on collector fails"

To view the discussion, visit: http://community.zenoss.org/message/74666#74666

--------------------------------------------------------------
Changing the password fields in *zodb_db_main.conf* and *zodb_db_session.conf* was enough for zendmd to work on collectors.
Thank you so much!
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/74666#74666]

Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]