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