devstack

MySQL is accessed as Root

Asked by Adam Young

devstack uses root as the mysql database user

specifically for keystone, the sql connection string is

connection = mysql://root:badpass@localhost/keystone?charset=utf8

This should be the devstack user, not root.

In addition, devstack tries to do administrative operations as root:

 sudo mysqladmin -u root password keystone
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Which causes devstack to fail

Question information

Language:
English Edit question
Status:
Expired
For:
devstack Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:

This question was originally filed as bug #1118502.

Revision history for this message
Roman Gorodeckij (holms) said : 		#1

This not probably a bug. By nature devstack is written with shell script, so ofcourse performing the same setup on top will fail.
Devstack really should move to puppet.

Revision history for this message
Adam Young (ayoung) said : 		#2

No, Puppet is solving a different problem. Devstack is setting things up for development, and, as such, should not be doing things or system wide consumption. Since most of the services run on ports > 1000, this works at the web level. FOr postgres and Mysql, the system already provides access to developers using their user names. It is actually harder to log in as root that ans $USER. The reason it was done was, I think, naivete, and maybe it makes things a litte simpler when deducing the username for a mysql connection.

Revision history for this message
Launchpad Janitor (janitor) said : 		#3

This question was expired because it remained in the 'Open' state without activity for the last 15 days.