[Openstack] [keystone] Keystone service creation (HTTP 500)

Mohammed Naser mnaser at vexxhost.com
Wed Feb 24 15:17:53 UTC 2016


Alexandr,

That’s fine.  The suggested way of deploying Keystone is via Apache
now, so you should just let it live in a WSGI application as it should

M

On Wed, Feb 24, 2016 at 10:17 AM, Alexandr Porunov
<alexandr.porunov at gmail.com> wrote:
> Mohammed,
>
> 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
>
> On Wed, Feb 24, 2016 at 5:07 PM, Mohammed Naser <mnaser at vexxhost.com> wrote:
>>
>> Alexandr,
>>
>> You should make sure to hit “Reply all” so that it goes back to the
>> mailing list, but I’m not sure why it’s not connected.  I’d try
>> connecting from the mysql CLI client and see what happens
>>
>> Mohammed
>>
>> On Wed, Feb 24, 2016 at 10:04 AM, Alexandr Porunov
>> <alexandr.porunov at gmail.com> wrote:
>> > Hello Mohammed,
>> >
>> > I don't know why my keystone is not able to authenticate with the MySQL
>> > server. I have created a user like in the tutorial:
>> >
>> > GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' IDENTIFIED
>> > BY
>> > 'KEYSTONE_DBPASS';
>> > GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' IDENTIFIED BY
>> > 'KEYSTONE_DBPASS'
>> >
>> > But it doesn't work
>> >
>> > On Wed, Feb 24, 2016 at 4:26 PM, Mohammed Naser <mnaser at vexxhost.com>
>> > wrote:
>> >>
>> >> Hi Alexandr,
>> >>
>> >> The key error to check:
>> >>
>> >> 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)")
>> >>
>> >> You'll need to make sure you address and resolve this, your keystone is
>> >> not able to authenticate with your MySQL server.
>> >>
>> >> Mohammed
>> >>
>> >> On Wednesday, 24 February 2016, Alexandr Porunov
>> >> <alexandr.porunov at gmail.com> wrote:
>> >>>
>> >>> Hello everyone,
>> >>>
>> >>> I am trying to pass this tutorial:
>> >>>
>> >>>
>> >>> http://docs.openstack.org/liberty/install-guide-rdo/keystone-services.html
>> >>> but without success.
>> >>>
>> >>> It is my /etc/hosts file:
>> >>> 127.0.0.1 me
>> >>> 192.168.56.111 controller
>> >>> 192.168.56.131 compute1
>> >>> 192.168.56.141 block1
>> >>> 192.168.56.151 object1
>> >>> 192.168.56.152 object2
>> >>> 192.168.56.50 ns1.porunov.com ns1
>> >>>
>> >>> I am using CentOS 7 in all nodes.
>> >>>
>> >>> When I try to create the service entity for the Identity service I
>> >>> always
>> >>> gets an error 500:
>> >>> openstack service create  --name keystone --description "OpenStack
>> >>> Identity" identity
>> >>>
>> >>> An unexpected error prevent the server from fulfilling your request.
>> >>> (HTTP 500) (Request-ID: req-12dc5717-71b4-4311-87e9-b0cfd4e90837)
>> >>>
>> >>> Request-ID always changes.
>> >>>
>> >>> This is my /var/log/keystone/keystone.log:
>> >>> 2016-02-24 15:09:45.922 4518 INFO oslo_service.service [-] Caught
>> >>> SIGTERM, stopping children
>> >>> 2016-02-24 15:09:45.923 4518 INFO oslo_service.service [-] Waiting on
>> >>> 4
>> >>> children to exit
>> >>> 2016-02-24 15:09:45.926 4528 INFO eventlet.wsgi.server
>> >>> [req-550473ac-acff-4581-af0f-1e02a66e4f66 - - - - -] (4528) wsgi
>> >>> exited,
>> >>> is_accepting=True
>> >>> 2016-02-24 15:09:45.931 4529 INFO eventlet.wsgi.server [-] (4529) wsgi
>> >>> exited, is_accepting=True
>> >>> 2016-02-24 15:09:45.933 4530 INFO eventlet.wsgi.server [-] (4530) wsgi
>> >>> exited, is_accepting=True
>> >>> 2016-02-24 15:09:45.936 4531 INFO eventlet.wsgi.server [-] (4531) wsgi
>> >>> exited, is_accepting=True
>> >>> 2016-02-24 15:09:45.942 4518 INFO oslo_service.service [-] Child 4528
>> >>> exited with status 0
>> >>> 2016-02-24 15:09:45.943 4518 INFO oslo_service.service [-] Child 4529
>> >>> exited with status 0
>> >>> 2016-02-24 15:09:45.943 4518 INFO oslo_service.service [-] Child 4530
>> >>> exited with status 0
>> >>> 2016-02-24 15:09:45.944 4518 INFO oslo_service.service [-] Child 4531
>> >>> exited with status 0
>> >>> 2016-02-24 15:09:45.947 4518 INFO oslo_service.service [-] Caught
>> >>> SIGTERM, stopping children
>> >>> 2016-02-24 15:18:29.074 1123 INFO keystone.common.wsgi
>> >>> [req-00fd181c-00ea-4b74-a16a-3ab8c1c38e24 - - - - -] POST
>> >>> http://controller:35357/v3/services
>> >>> 2016-02-24 15:18:29.075 1123 WARNING keystone.common.controller
>> >>> [req-00fd181c-00ea-4b74-a16a-3ab8c1c38e24 - - - - -] RBAC: Bypassing
>> >>> authorization
>> >>> 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)")
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi Traceback
>> >>> (most
>> >>> recent call last):
>> >>> 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__
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     result =
>> >>> method(context, **params)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
>> >>> f(self, context, *args, **kwargs)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
>> >>> func(*args, **kwargs)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     ref =
>> >>> self.catalog_api.create_service(ref['id'], ref, initiator)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     ref =
>> >>> self.driver.create_service(service_id, service_ref)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     session =
>> >>> sql.get_session()
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
>> >>> _get_engine_facade().get_session(expire_on_commit=expire_on_commit)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
>> >>> _engine_facade = db_session.EngineFacade.from_config(CONF)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
>> >>> expire_on_commit=expire_on_commit, _conf=conf)
>> >>> 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__
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
>> >>> slave_connection=slave_connection)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
>> >>> engine_args,
>> >>> maker_args)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
>> >>> sql_connection=sql_connection, **engine_kwargs)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     test_conn
>> >>> =
>> >>> _test_connection(engine, max_retries, retry_interval)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
>> >>> engine.connect()
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
>> >>> self._connection_cls(self, **kwargs)
>> >>> 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__
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     if
>> >>> connection
>> >>> is not None else engine.raw_connection()
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
>> >>> self.pool.unique_connection, _connection)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     e,
>> >>> dialect,
>> >>> self)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
>> >>> util.raise_from_cause(newraise, exc_info)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
>> >>> reraise(type(exception), exception, tb=exc_tb)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
>> >>> fn()
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
>> >>> _ConnectionFairy._checkout(self)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     fairy =
>> >>> _ConnectionRecord.checkout(pool)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     rec =
>> >>> pool._do_get()
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
>> >>> self._dec_overflow()
>> >>> 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__
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
>> >>> compat.reraise(exc_type, exc_value, exc_tb)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
>> >>> self._create_connection()
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
>> >>> _ConnectionRecord(self)
>> >>> 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__
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
>> >>> self.connection = self.__connect()
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     connection
>> >>> =
>> >>> self.__pool._invoke_creator(self)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
>> >>> dialect.connect(*cargs, **cparams)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
>> >>> self.dbapi.connect(*cargs, **cparams)
>> >>> 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
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
>> >>> Connection(*args, **kwargs)
>> >>> 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__
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
>> >>> super(Connection, self).__init__(*args, **kwargs2)
>> >>> 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)")
>> >>> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
>> >>>
>> >>> Please, help me to figure out what is going on.
>> >>>
>> >>> Sincerely, Alexandr Porunov
>> >>
>> >>
>> >>
>> >> --
>> >> Mohammed Naser — vexxhost
>> >> -----------------------------------------------------
>> >> D. 514-316-8872
>> >> D. 800-910-1726 ext. 200
>> >> E. mnaser at vexxhost.com
>> >> W. http://vexxhost.com
>> >>
>> >
>>
>>
>>
>> --
>> Mohammed Naser — vexxhost
>> -----------------------------------------------------
>> D. 514-316-8872
>> D. 800-910-1726 ext. 200
>> E. mnaser at vexxhost.com
>> W. http://vexxhost.com
>
>



-- 
Mohammed Naser — vexxhost
-----------------------------------------------------
D. 514-316-8872
D. 800-910-1726 ext. 200
E. mnaser at vexxhost.com
W. http://vexxhost.com




More information about the Openstack mailing list