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 <mna...@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.poru...@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 <mna...@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.poru...@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. mna...@vexxhost.com > >> W. http://vexxhost.com > >> > > > > > > -- > Mohammed Naser — vexxhost > ----------------------------------------------------- > D. 514-316-8872 > D. 800-910-1726 ext. 200 > E. mna...@vexxhost.com > W. http://vexxhost.com >
_______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : openstack@lists.openstack.org Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
