Ask Your Question

HTTP 500 error while installing the keystone identity service (Mitaka)

asked 2016-07-19 18:46:36 -0600

Vijayuppala gravatar image

I'm trying to install the Mitaka and struck at the keystone identity service ( )

Below is my configuration

i created the keystone DB in mysql

[root@controller keystone]# mysql -u root -p 
Enter password: 
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 63 Server version: 10.1.12-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | keystone | | mysql | | performance_schema | | test | +--------------------+ 5 rows in set (0.00 sec)

MariaDB [(none)]>

This is how my keystone.conf file looks like

[root@controller keystone]# grep ^[^#] /etc/keystone/keystone.conf 
[DEFAULT] admin_token = b9a95be763c7bf6cce1a 
connection = mysql+pymysql://keystone:keystone123@controller/keystone 
provider = fernet 

And finally these are the exported values

[root@controller ~]# echo $OS_TOKEN 
[root@controller ~]# more /etc/keystone/keystone.conf | grep admin_token
        None, the value is ignored and the admin_token log in mechanism is
        effectively disabled. To completely disable admin_token in production

        admin_token = b9a95be763c7bf6cce1a 
[root@controller ~]# echo $OS_URL 
[root@controller ~]# echo $OS_IDENTITY_API_VERSION 

Everything looks good in the keystone.conf file and the export values match as well but i still get the HTTP 500 error

[root@controller ~]# openstack service create \

    --name keystone --description "OpenStack Identity" identity An unexpected error prevented the server from fulfilling your request. (HTTP 500) (Request-ID: req-56b3b078-0978-4e69-886c-570ebb333ae0)

I dropped the keystone db and tried again several times but the same result. i just found out that the su -s /bin/sh -c "keystone-manage db_sync" keystone command is not populating the tables in the keystone db

MariaDB [keystone]> show tables; Empty set (0.00 sec)

MariaDB [keystone]>

Could this be the problem?

Thank You Vijay Uppala

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

answered 2016-07-19 23:50:51 -0600

The keystone-manage db_sync will populate the database. Your grant privileges failed to apply on the keystone database or did not have the same user password used in the keystone.conf connection value (in your case: keystone123). Reissue the grant commands on the keystone database:
grant all privileges on keystone.* to 'keystone'@'localhost' identified by 'keystone123';
grant all privileges on keystone.* to 'keystone'@'%' identified by 'keystone123';
Then try to populate the database;

edit flag offensive delete link more


today, I was also seeing the issue of no tables. Reissued the grant commands. Now the identity service creation went though fine.

Maruthi gravatar imageMaruthi ( 2016-07-20 02:23:11 -0600 )edit

Barry, thank you for the response. I issued the grant privileges commands multiple times and then tried to sync the db but it still doesnt work.

Vijayuppala gravatar imageVijayuppala ( 2016-07-20 11:55:13 -0600 )edit

MariaDB [(none)]> grant all privileges on keystone.* to 'keystone'@'localhost' identified by 'keystone123'; Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> grant all privileges on keystone.* to 'keystone'@'%' identified by 'keystone123';
Query OK, 0 rows affected (0.00 sec)
Vijayuppala gravatar imageVijayuppala ( 2016-07-20 11:57:50 -0600 )edit

[root@controller ~]# su -s /bin/sh -c "keystone-manage db_sync" keystone

MariaDB [(none)]> use keystone
Database changed
MariaDB [keystone]> show tables;
Empty set (0.00 sec)
Vijayuppala gravatar imageVijayuppala ( 2016-07-20 11:58:47 -0600 )edit

Is there something else i'm missing?

Vijayuppala gravatar imageVijayuppala ( 2016-07-20 12:01:48 -0600 )edit

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2016-07-19 18:46:36 -0600

Seen: 944 times

Last updated: Jul 19 '16