Open Stack

Wed Feb 24 15:17:01 UTC 2016

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20160224/fd62362e/attachment.html>

Open Stack

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

OpenStack

Community

Documentation

Branding & Legal