Dev Kumar
2013-02-22 12:06:48 UTC
Dev Kumar [http://community.zenoss.org/people/davinderk] created the discussion
"WARNING relstorage.adapters.mysql: Unable to connect: (1045, "Access denied for user 'zenoss'@'localhost' (using password: YES)")"
To view the discussion, visit: http://community.zenoss.org/message/71647#71647
--------------------------------------------------------------
Hi,
I am getting the below mentioned error - whiel doing a zenrestore on the server.
Please help me out.
[***@Zen-Test ~]$ zenrestore -v 100 --zodb-password=zenoss --file=/opt/zenoss/backups/zenbackup_20130222.tgz
Unpacking backup file
tar: zenbackup/zodb.sql.gz: time stamp 2013-02-22 12:23:40 is 9516.686184726 s in the future
tar: zenbackup/backup.settings: time stamp 2013-02-22 12:23:01 is 9477.662798111s in the future
tar: zenbackup/bin.tar: time stamp 2013-02-22 12:23:46 is 9521.796351777 s in the future
tar: zenbackup/zodb_session.sql.gz: time stamp 2013-02-22 12:23:40 is 9515.796198957 s in the future
tar: zenbackup/zep.sql.gz: time stamp 2013-02-22 12:23:00 is 9475.790085836 s in the future
tar: zenbackup/etc.tar: time stamp 2013-02-22 12:23:40 is 9515.784107388 s in the future
tar: zenbackup/ZenPacks.tar: time stamp 2013-02-22 12:23:44 is 9511.797009018 s in the future
tar: zenbackup/perf.tar: time stamp 2013-02-22 12:24:00 is 9507.750965763 s in the future
tar: zenbackup: time stamp 2013-02-22 12:23:47 is 9494.750675495 s in the future
Flushing memcached cache.
Completed flushing memcached cache.
Restoring ZODB database.
Done Restoring ZODB database.
Restoring ZODB session database.
Done Restoring ZODB session database.
Restoring config files.
2013-02-22 09:50:41,712 WARNING relstorage.adapters.mysql: Unable to connect: (1045, "Access denied for user 'zenoss'@'localhost' (using password: YES)")
Traceback (most recent call last):
 File "/opt/zenoss/Products/ZenUtils/ZenRestore.py", line 430, in <module>
   if zb.doRestore():
 File "/opt/zenoss/Products/ZenUtils/ZenRestore.py", line 393, in doRestore
   self.restoreZenPackContents()
 File "/opt/zenoss/Products/ZenUtils/ZenRestore.py", line 319, in restoreZenPackContents
   dmd = ZCmdBase(noopts=True).dmd
 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 162, in getConnection
   storage = relstorage.storage.RelStorage(adapter, **relstoreParams)
 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'@'localhost' (using password: YES)").
Please help me out.
Regards.
D K
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/71647#71647]
Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
"WARNING relstorage.adapters.mysql: Unable to connect: (1045, "Access denied for user 'zenoss'@'localhost' (using password: YES)")"
To view the discussion, visit: http://community.zenoss.org/message/71647#71647
--------------------------------------------------------------
Hi,
I am getting the below mentioned error - whiel doing a zenrestore on the server.
Please help me out.
[***@Zen-Test ~]$ zenrestore -v 100 --zodb-password=zenoss --file=/opt/zenoss/backups/zenbackup_20130222.tgz
Unpacking backup file
tar: zenbackup/zodb.sql.gz: time stamp 2013-02-22 12:23:40 is 9516.686184726 s in the future
tar: zenbackup/backup.settings: time stamp 2013-02-22 12:23:01 is 9477.662798111s in the future
tar: zenbackup/bin.tar: time stamp 2013-02-22 12:23:46 is 9521.796351777 s in the future
tar: zenbackup/zodb_session.sql.gz: time stamp 2013-02-22 12:23:40 is 9515.796198957 s in the future
tar: zenbackup/zep.sql.gz: time stamp 2013-02-22 12:23:00 is 9475.790085836 s in the future
tar: zenbackup/etc.tar: time stamp 2013-02-22 12:23:40 is 9515.784107388 s in the future
tar: zenbackup/ZenPacks.tar: time stamp 2013-02-22 12:23:44 is 9511.797009018 s in the future
tar: zenbackup/perf.tar: time stamp 2013-02-22 12:24:00 is 9507.750965763 s in the future
tar: zenbackup: time stamp 2013-02-22 12:23:47 is 9494.750675495 s in the future
Flushing memcached cache.
Completed flushing memcached cache.
Restoring ZODB database.
Done Restoring ZODB database.
Restoring ZODB session database.
Done Restoring ZODB session database.
Restoring config files.
2013-02-22 09:50:41,712 WARNING relstorage.adapters.mysql: Unable to connect: (1045, "Access denied for user 'zenoss'@'localhost' (using password: YES)")
Traceback (most recent call last):
 File "/opt/zenoss/Products/ZenUtils/ZenRestore.py", line 430, in <module>
   if zb.doRestore():
 File "/opt/zenoss/Products/ZenUtils/ZenRestore.py", line 393, in doRestore
   self.restoreZenPackContents()
 File "/opt/zenoss/Products/ZenUtils/ZenRestore.py", line 319, in restoreZenPackContents
   dmd = ZCmdBase(noopts=True).dmd
 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 162, in getConnection
   storage = relstorage.storage.RelStorage(adapter, **relstoreParams)
 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'@'localhost' (using password: YES)").
Please help me out.
Regards.
D K
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/71647#71647]
Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]