keystone access denied with mysql on Red Hat

Asked by Don Mize

I've been working with OpenStack and Keystone for a while with Ubuntu successfully. Now I'm trying to install it on Red Hat 6.3. I'm getting the Openstack and Keystone stuff from the EPEL site. I do the install of mysql and openstack-keystone and reconfigure the keystone.conf file as I do with Ubuntu and I still get
sqlalchemy.exc.OperationalError: (OperationalError) (1045, "Access denied for user 'keystone'@'xnode9.lambda.net' (using password: YES)") None None

Any ideas?

Question information

Language:
English Edit question
Status:
Solved
For:
OpenStack Identity (keystone) Edit question
Assignee:
No assignee Edit question
Solved by:
Don Mize
Solved:
Last query:
Last reply:
Revision history for this message
Don Mize (donald-mize) said :
#1

I found the issue. When setting up the database on Ubuntu this works.

mysql -uroot -pnova -e "GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' IDENTIFIED BY 'nova';"

On Red Hat 6.3 this part 'keystone'@'%' is wrong. You must have keystone@machine/ipaddress. For example in this instance
this worked.

mysql -uroot -pnova -e "GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@172.17.86.9' IDENTIFIED BY 'nova';"

Problem solved! :-)