problem with keystone-manage db_sync
Hi everyone , im deplying openstack with openstackbook for beginner. when i install keystone i have a problem like below installed mysql -> OK create database
Create a database named keystone. mysql -uroot -pmygreatsecret -e 'CREATE DATABASE keystone;' Create a user named keystonedbadmin. mysql -uroot -pmygreatsecret -e 'CREATE USER keystonedbadmin;' Grant all privileges for keystonedbadmin on the database "keystone". mysql -uroot -pmygreatsecret -e "GRANT ALL PRIVILEGES ON keystone.* TO 'keystonedbadmin'@ - '%';" Create a password for the user "keystonedbadmin". mysql -uroot -pmygreatsecret -e "SET PASSWORD FOR 'keystonedbadmin'@'%' = PASSWORD(' - keystonesecret');"
then Keystone is the identity service used by OpenStack. Install Keystone using the following command. apt-get install keystone python-keystone python-keystoneclient Open /etc/keystone/keystone.conf, uncomment and change the line #admin_token = ADMIN so that it looks like admin_token = admin (We have used ’admin’ as the token in this book.) Since MySQL database is used to store keystone configuration, edit the following line in /etc/keystone/keystone.conf from connection = sqlite:////var/lib/keystone/keystone.db to connection = mysql://keystonedbadmin:keystonesecret@10.51.177.149/keystone
then i fill out
keystone-manage db_sync
there was an error like this:
2014-12-02 10:59:24.235 6546 CRITICAL keystone [-] OperationalError: (OperationalError) (1045, "Access denied for user 'keystonedbadmin'@'10.51.177.149' (using password: YES)") None None
could you help me to fix that. thanks so much and waiting your answer.
The 'keystonedbadmin' user is being denied access for the admin action db_sync. You can source an admin user's credentials and then try to db_sync.
the root cause might be in your mysql database access side, check if you have granted the admin permission in your mysql db for both user credentials(username and password) and the remote host to access?
before do this command , i created and grandted all user like this: Create a database named keystone. mysql -uroot -pmygreatsecret -e 'CREATE DATABASE keystone;' Create a user named keystonedbadmin. mysql -uroot -pmygreatsecret -e 'CREATE USER keystonedbadmin;' Grant all privileges for keystonedbad
@djepnguyen the install document does not say to create a user "keystone or "keystonedbadmin" user? Is this a bug in the install document of juno but known to those who have it working?