Hi Alexandr,<div><br></div><div>The key error to check:</div><div><br></div><div><font size="2"><span style="background-color:rgba(255,255,255,0)">2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi OperationalError: (_mysql_exceptions.OperationalError) (1045, "Access denied for user 'keystone'@'controller' (using password: YES)")</span></font></div><div><font size="2"><span style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.301961);"><br></span></font></div><div><font size="2"><span style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.301961);">You'll need to make sure you address and resolve this, your keystone is not able to authenticate with your MySQL server. </span></font></div><div><font size="2"><span style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.301961);"><br></span></font></div><div><font size="2"><span style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.301961);">Mohammed<span></span></span></font></div><div><br>On Wednesday, 24 February 2016, Alexandr Porunov <<a href="mailto:alexandr.porunov@gmail.com">alexandr.porunov@gmail.com</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Hello everyone,</div><div><br></div><div>I am trying to pass this tutorial:</div><div><a href="http://docs.openstack.org/liberty/install-guide-rdo/keystone-services.html" target="_blank">http://docs.openstack.org/liberty/install-guide-rdo/keystone-services.html</a></div><div>but without success.</div><div><br></div><div>It is my /etc/hosts file:</div><div>127.0.0.1 me</div><div>192.168.56.111 controller</div><div>192.168.56.131 compute1</div><div>192.168.56.141 block1</div><div>192.168.56.151 object1</div><div>192.168.56.152 object2</div><div>192.168.56.50 <a href="http://ns1.porunov.com" target="_blank">ns1.porunov.com</a> ns1</div><div><br></div><div>I am using CentOS 7 in all nodes.</div><div><br></div><div>When I try to create the service entity for the Identity service I always gets an error 500:</div><div>openstack service create --name keystone --description "OpenStack Identity" identity</div><div><br></div><div>An unexpected error prevent the server from fulfilling your request. (HTTP 500) (Request-ID: req-12dc5717-71b4-4311-87e9-b0cfd4e90837)</div><div><br></div><div>Request-ID always changes.</div><div><br></div><div>This is my /var/log/keystone/keystone.log:</div><div>2016-02-24 15:09:45.922 4518 INFO oslo_service.service [-] Caught SIGTERM, stopping children</div><div>2016-02-24 15:09:45.923 4518 INFO oslo_service.service [-] Waiting on 4 children to exit</div><div>2016-02-24 15:09:45.926 4528 INFO eventlet.wsgi.server [req-550473ac-acff-4581-af0f-1e02a66e4f66 - - - - -] (4528) wsgi exited, is_accepting=True</div><div>2016-02-24 15:09:45.931 4529 INFO eventlet.wsgi.server [-] (4529) wsgi exited, is_accepting=True</div><div>2016-02-24 15:09:45.933 4530 INFO eventlet.wsgi.server [-] (4530) wsgi exited, is_accepting=True</div><div>2016-02-24 15:09:45.936 4531 INFO eventlet.wsgi.server [-] (4531) wsgi exited, is_accepting=True</div><div>2016-02-24 15:09:45.942 4518 INFO oslo_service.service [-] Child 4528 exited with status 0</div><div>2016-02-24 15:09:45.943 4518 INFO oslo_service.service [-] Child 4529 exited with status 0</div><div>2016-02-24 15:09:45.943 4518 INFO oslo_service.service [-] Child 4530 exited with status 0</div><div>2016-02-24 15:09:45.944 4518 INFO oslo_service.service [-] Child 4531 exited with status 0</div><div>2016-02-24 15:09:45.947 4518 INFO oslo_service.service [-] Caught SIGTERM, stopping children</div><div>2016-02-24 15:18:29.074 1123 INFO keystone.common.wsgi [req-00fd181c-00ea-4b74-a16a-3ab8c1c38e24 - - - - -] POST <a href="http://controller:35357/v3/services" target="_blank">http://controller:35357/v3/services</a></div><div>2016-02-24 15:18:29.075 1123 WARNING keystone.common.controller [req-00fd181c-00ea-4b74-a16a-3ab8c1c38e24 - - - - -] RBAC: Bypassing authorization</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi [req-00fd181c-00ea-4b74-a16a-3ab8c1c38e24 - - - - -] (_mysql_exceptions.OperationalError) (1045, "Access denied for user 'keystone'@'controller' (using password: YES)")</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi Traceback (most recent call last):</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/common/wsgi.py", line 248, in __call__</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi result = method(context, **params)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/common/controller.py", line 163, in inner</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi return f(self, context, *args, **kwargs)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/common/validation/__init__.py", line 71, in wrapper</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi return func(*args, **kwargs)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/catalog/controllers.py", line 272, in create_service</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi ref = self.catalog_api.create_service(ref['id'], ref, initiator)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/catalog/core.py", line 187, in create_service</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi ref = self.driver.create_service(service_id, service_ref)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/catalog/backends/sql.py", line 205, in create_service</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi session = sql.get_session()</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/common/sql/core.py", line 192, in get_session</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi return _get_engine_facade().get_session(expire_on_commit=expire_on_commit)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/keystone/common/sql/core.py", line 176, in _get_engine_facade</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi _engine_facade = db_session.EngineFacade.from_config(CONF)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 1015, in from_config</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi expire_on_commit=expire_on_commit, _conf=conf)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 943, in __init__</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi slave_connection=slave_connection)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 338, in _start</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi engine_args, maker_args)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 362, in _setup_for_connection</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi sql_connection=sql_connection, **engine_kwargs)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 152, in create_engine</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi test_conn = _test_connection(engine, max_retries, retry_interval)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 326, in _test_connection</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi return engine.connect()</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2018, in connect</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi return self._connection_cls(self, **kwargs)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 72, in __init__</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi if connection is not None else engine.raw_connection()</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi self.pool.unique_connection, _connection)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi e, dialect, self)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1401, in _handle_dbapi_exception_noconnection</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi util.raise_from_cause(newraise, exc_info)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi reraise(type(exception), exception, tb=exc_tb)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi return fn()</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 318, in unique_connection</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi return _ConnectionFairy._checkout(self)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 713, in _checkout</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi fairy = _ConnectionRecord.checkout(pool)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 480, in checkout</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi rec = pool._do_get()</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1060, in _do_get</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi self._dec_overflow()</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi compat.reraise(exc_type, exc_value, exc_tb)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1057, in _do_get</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi return self._create_connection()</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 323, in _create_connection</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi return _ConnectionRecord(self)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 449, in __init__</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi self.connection = self.__connect()</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 607, in __connect</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi connection = self.__pool._invoke_creator(self)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 97, in connect</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi return dialect.connect(*cargs, **cparams)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 385, in connect</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi return self.dbapi.connect(*cargs, **cparams)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi return Connection(*args, **kwargs)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 187, in __init__</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi super(Connection, self).__init__(*args, **kwargs2)</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi OperationalError: (_mysql_exceptions.OperationalError) (1045, "Access denied for user 'keystone'@'controller' (using password: YES)")</div><div>2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi </div><div><br></div><div>Please, help me to figure out what is going on.</div><div><br></div><div>Sincerely, Alexandr Porunov</div></div>
</blockquote></div><br><br>-- <br><span style="font-family:Arial;font-size:8pt"><span style="color:rgb(70,130,180);font-size:10pt">Mohammed Naser</span> — <span style="font-weight:bold">vexxhost</span><br></span><div><span style="font-family:Arial;font-size:8pt"><span><span style="color:rgb(220,220,220)">-----------------------------------------------------</span></span></span></div><div><span style="font-family:Arial;font-size:11px;font-weight:bold">D. </span><span style="font-family:Arial;font-size:11px">514-316-8872</span></div><div><span style="font-family:Arial;font-size:11px"><span style="font-weight:bold">D.</span> 800-910-1726 ext. 200</span></div><div><span style="font-family:Arial;font-size:11px"><span style="font-weight:bold">E. </span><a href="mailto:mnaser@vexxhost.com" target="_blank">mnaser@vexxhost.com</a></span></div><div><span style="font-family:Arial;font-size:11px"><span style="font-weight:bold">W. </span><a href="http://vexxhost.com/" target="_blank">http://vexxhost.com</a></span></div><br>