Create identity service: "An unexpected error prevented the server from fulfilling your request. (HTTP 500) (Request-ID: req-ed70ceef-c225-4f2e-a3cd-d7850f864df3)" about coa HOT 9 CLOSED

didn't comment reference to sqlite in /etc/keystone/keystone.conf

connection = sqlite:////var/lib/keystone/keystone.db

from coa.

Wrong controller hostname used in /etc/keystone/keystone.conf

[database]
connection = mysql+pymysql://keystone:openstack@controller/keystone

Mine is libcontroller

from coa.

Re-populate the identity service database after correcting the controller hostname in /etc/keystone/keystone.conf

su -s /bin/sh -c "keystone-manage db_sync" keystone

from coa.

Another issue with the same symptom:

tail /var/log/keystone/keystone-wsgi-admin.log

2016-11-09 00:53:31.757 2992 ERROR keystone.common.wsgi     engine_args, maker_args)
2016-11-09 00:53:31.757 2992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 362, in _setup_for_connection
2016-11-09 00:53:31.757 2992 ERROR keystone.common.wsgi     sql_connection=sql_connection, **engine_kwargs)
2016-11-09 00:53:31.757 2992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 152, in create_engine
2016-11-09 00:53:31.757 2992 ERROR keystone.common.wsgi     test_conn = _test_connection(engine, max_retries, retry_interval)
2016-11-09 00:53:31.757 2992 ERROR keystone.common.wsgi   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 334, in _test_connection
2016-11-09 00:53:31.757 2992 ERROR keystone.common.wsgi     six.reraise(type(de_ref), de_ref)
2016-11-09 00:53:31.757 2992 ERROR keystone.common.wsgi   File "<string>", line 2, in reraise
2016-11-09 00:53:31.757 2992 ERROR keystone.common.wsgi DBConnectionError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'controller' ([Errno -2] Name or service not known)")
2016-11-09 00:53:31.757 2992 ERROR keystone.common.wsgi 

from coa.

tail /var/log/keystone/keystone-wsgi-admin.log

2016-11-09 01:01:54.514 2990 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 826, in _read_packet
2016-11-09 01:01:54.514 2990 ERROR keystone.common.wsgi packet.check_error()
2016-11-09 01:01:54.514 2990 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 370, in check_error
2016-11-09 01:01:54.514 2990 ERROR keystone.common.wsgi raise_mysql_exception(self._data)
2016-11-09 01:01:54.514 2990 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 116, in raise_mysql_exception
2016-11-09 01:01:54.514 2990 ERROR keystone.common.wsgi _check_mysql_exception(errinfo)
2016-11-09 01:01:54.514 2990 ERROR keystone.common.wsgi File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 109, in _check_mysql_exception
2016-11-09 01:01:54.514 2990 ERROR keystone.common.wsgi raise errorclass(errno,errorvalue)
2016-11-09 01:01:54.514 2990 ERROR keystone.common.wsgi ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'keystone.service' doesn't exist") [SQL: u'INSERT INTO service (id, type, enabled, extra) VALUES (%s, %s, %s, %s)'] [parameters: ('37fd60101e904ba8a8d5861d964a375a', u'identity', 1, '{"description": "OpenStack Identity", "name": "keystone"}')]
2016-11-09 01:01:54.514 2990 ERROR keystone.common.wsgi

from coa.

i thought this time i'm gonna follow the Newton installation guide step by step but i got the same, gonna go ahead and comment that sqlite line in keystone.conf
(strange how one step is to delete the sqlite db file and never mention this step)
what about compute / neutron...et.conf?
you think they should be commented as well?

from coa.

Hi @eriksh7 , sorry for the late reply.
I think it doesn't harm to comment that line, as it refer to a not used db backend which apparently can create confusion.

from coa.

hi i have the same error but servername is coreect there is no line for sqlite connection in database field so dont need for comment and i did every thing step by step on openstack piko installition but i just get thiss error help pleaseeee !!! @AJNOURI

i checked keystone databse tables and populate didnt make any tables at all .

from coa.

connection = mysql+pymysql://keystone:[email protected]/keystone (example)
change ip according to your config

from coa.