Packstack

Error while installing packstack - "Access denied for user 'gnocchi'@'ControllerNode'

Bug #1697427 reported by Suresh Kumar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Packstack
New
Undecided
Unassigned

Bug Description

While installing packstack, I got the following error :
CRITICAL gnocchi [-] OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'gnocchi'@'ControllerNode' (using password: YES)")

Please check complete output :

Preparing Redis entries [ DONE ]
Preparing Ceilometer entries [ DONE ]
Preparing Aodh entries [ DONE ]
Preparing Nagios server entries [ DONE ]
Preparing Nagios host entries [ DONE ]
Preparing Puppet manifests [ DONE ]
Copying Puppet modules and manifests [ DONE ]
Applying 172.16.93.197_controller.pp
172.16.93.197_controller.pp: [ ERROR ] d
Applying Puppet manifests [ ERROR ]

ERROR : Error appeared during Puppet run: 172.16.93.197_controller.pp
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 CRITICAL gnocchi [-] OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'gnocchi'@'ControllerNode' (using password: YES)")
You will find full trace in log /var/tmp/packstack/20170612-160734-ruTcaT/manifests/172.16.93.197_controller.pp.log
Please check log file /var/tmp/packstack/20170612-160734-ruTcaT/openstack-setup.log for more information
Additional information:
 * Time synchronization installation was skipped. Please note that unsynchronized time on server instances might be problem for some OpenStack components.
 * File /root/keystonerc_admin has been created on OpenStack client host 172.16.93.197. To use the command line tools you need to source the file.
 * To access the OpenStack Dashboard browse to http://172.16.93.197/dashboard .
Please, find your login credentials stored in the keystonerc_admin in your home directory.
 * To use Nagios, browse to http://172.16.93.197/nagios username: nagiosadmin, password: ac08e2457a4744d3
[root@ControllerNode ~]#

Please check the error log, which I found in the log file :
Notice: /Stage[main]/Ceilometer::Agent::Notification/Ceilometer_config[notification/ack_on_event_error]/ensure: created
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 CRITICAL gnocchi [-] OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'gnocchi'@'ControllerNode' (using password: YES)")
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi Traceback (most recent call last):
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/bin/gnocchi-upgrade", line 10, in <module>
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi sys.exit(upgrade())
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/gnocchi/cli.py", line 59, in upgrade
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi create_legacy_resource_types=conf.create_legacy_resource_types)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/gnocchi/indexer/sqlalchemy.py", line 310, in upgrade
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi with self.facade.writer_connection() as connection:
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/contextlib.py", line 17, in __enter__
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi return self.gen.next()
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 874, in _transaction_scope
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi allow_async=self._allow_async) as resource:
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/contextlib.py", line 17, in __enter__
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi return self.gen.next()
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 488, in _connection
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi mode=self.mode)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 267, in _create_connection
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi self._start()
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 363, in _start
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi engine_args, maker_args)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 387, in _setup_for_connection
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi sql_connection=sql_connection, **engine_kwargs)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 155, in create_engine
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi test_conn = _test_connection(engine, max_retries, retry_interval)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 331, in _test_connection
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi return engine.connect()
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2018, in connect
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi return self._connection_cls(self, **kwargs)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 72, in __init__
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi if connection is not None else engine.raw_connection()
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi self.pool.unique_connection, _connection)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi e, dialect, self)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1401, in _handle_dbapi_exception_noconnection
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi util.raise_from_cause(newraise, exc_info)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi reraise(type(exception), exception, tb=exc_tb)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi return fn()
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 318, in unique_connection
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi return _ConnectionFairy._checkout(self)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 713, in _checkout
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi fairy = _ConnectionRecord.checkout(pool)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 480, in checkout
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi rec = pool._do_get()
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1060, in _do_get
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi self._dec_overflow()
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi compat.reraise(exc_type, exc_value, exc_tb)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1057, in _do_get
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi return self._create_connection()
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 323, in _create_connection
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi return _ConnectionRecord(self)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 449, in __init__
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi self.connection = self.__connect()
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 607, in __connect
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi connection = self.__pool._invoke_creator(self)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 97, in connect
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi return dialect.connect(*cargs, **cparams)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 385, in connect
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi return self.dbapi.connect(*cargs, **cparams)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/pymysql/__init__.py", line 90, in Connect
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi return Connection(*args, **kwargs)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 694, in __init__
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi self.connect()
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 916, in connect
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi self._request_authentication()
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1124, in _request_authentication
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi auth_packet = self._read_packet()
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 991, in _read_packet
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi packet.check_error()
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi err.raise_mysql_exception(self._data)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi raise errorclass(errno, errval)
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'gnocchi'@'ControllerNode' (using password: YES)")
Notice: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]/returns: 2017-06-12 16:22:21.606 18521 ERROR gnocchi
Error: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]: Failed to call refresh: gnocchi-upgrade --config-file /etc/gnocchi/gnocchi.conf --create-legacy-resource-types returned 1 instead of one of [0]
Error: /Stage[main]/Gnocchi::Db::Sync/Exec[gnocchi-db-sync]: gnocchi-upgrade --config-file /etc/gnocchi/gnocchi.conf --create-legacy-resource-types returned 1 instead of one of [0]

Revision history for this message
Suresh Kumar (suresh26k) wrote :

The changes which I made in the answer file are :

< CONFIG_COMPUTE_HOSTS=172.16.93.197,172.16.93.198
< CONFIG_NEUTRON_ML2_TYPE_DRIVERS=vxlan,flat
< CONFIG_NEUTRON_OVS_BRIDGE_MAPPINGS=ethernet:br-ex
< CONFIG_PROVISION_DEMO=n

Revision history for this message
Alfredo Moralejo (amoralej) wrote :

What repo and what version of packstack are you using?, could you past somewhere the entire 172.16.93.197_controller.pp.log file?

Revision history for this message
Suresh Kumar (suresh26k) wrote :

Please check the attached log file.

Revision history for this message
Suresh Kumar (suresh26k) wrote :

I have used the repo "centos-openstack-newton" (centos-release-openstack-newton).

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.