Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Checked the DB tables and found that is was not created so i droppped the DB and followed below commmands and it worked it worked immediately

The Identity Service uses a database to store information. Specify the location of the database in the configuration file. In this guide, we use a MySQL database on the controller node with the username keystone. Replace KEYSTONE_DBPASS with a suitable password for the database user.

# openstack-config --set /etc/keystone/keystone.conf \ database connection mysql://keystone:KEYSTONE_DBPASS@[you controller name]/keystone

Use the password that you set previously to log in as root. Create a keystone database user:

$ mysql -u root -p mysql> CREATE DATABASE keystone; mysql> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' \ IDENTIFIED BY 'KEYSTONE_DBPASS'; mysql> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' \ IDENTIFIED BY 'KEYSTONE_DBPASS'; mysql> exit

Create the database tables for the Identity Service:

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

After the above command login to mysql and check if tables are created and after that the user create command works fine