Ask Your Question
1

Error when creating administrative tenant Cento7 Juno

asked 2014-11-09 12:54:35 -0500

Chanaka gravatar image

updated 2014-11-10 00:47:35 -0500

dbaxps gravatar image

I get the bellow error when creating the administrative tenant in juno on cents 7 controller node. I have used the yum trunk guide up to this stage. Connection to mysql DB is fine and DNS is working.

Has anyone seen this before ?

--------------------------
[root@controller ~]# keystone tenant-create --name admin --description "Admin Tenant"
An unexpected error prevented the server from fulfilling your request. (HTTP 500)

[root@controller ~]# netstat -anutp|grep 35357
tcp        0      0 0.0.0.0:35357           0.0.0.0:*               LISTEN      1492/python         
[root@controller ~]# telnet controller 35357
Trying 10.0.0.11...
Connected to controller.
Escape character is '^]'.
get
<head>
<title>Error response</title>
</head>
<body>
<h1>Error response</h1>
<p>Error code 400.
<p>Message: Bad request syntax ('get').
<p>Error code explanation: 400 = Bad request syntax or unsupported method.
</body>
Connection closed by foreign host.
[root@controller ~]# 




Log under /var/log/keystone/keystone.log

2014-11-09 11:08:24.527 2541 ERROR keystone.common.wsgi [-] (OperationalError) (1045, "Access denied for user 'keystone'@'controller' (using password: YES)") None None
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi Traceback (most recent call last):
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/common/wsgi.py", line 223, in __call__
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi     result = method(context, **params)
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/assignment/controllers.py", line 117, in create_project
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi     self._normalize_domain_id(context, tenant_ref))
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/notifications.py", line 112, in wrapper
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi     result = f(*args, **kwargs)
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/assignment/core.py", line 88, in create_project
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi     ret = self.driver.create_project(tenant_id, tenant)
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/common/sql/core.py", line 393, in wrapper
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi     return method(*args, **kwargs)
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/assignment/backends/sql.py", line 443, in create_project
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi     with sql.transaction() as session:
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi   File "/usr/lib64/python2.7/contextlib.py", line 17, in __enter__
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi     return self.gen.next()
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi   File "/usr/lib/python2.7/site-packages/keystone/common/sql/core.py", line 198, in transaction
2014-11-09 11:08:24.527 2541 TRACE keystone.common.wsgi     session = get_session(expire_on_commit=expire_on_commit)
2014-11-09 11:08:24.527 2541 TRACE ...
(more)
edit retag flag offensive close merge delete

2 answers

Sort by ยป oldest newest most voted
1

answered 2014-11-10 01:06:47 -0500

"Access denied for user 'keystone'@'controller' (using password: YES"

Log is saying that unable to create connection with MySQL. Try the following:

mysql -ukeystone -p<yourkeystonepassword> -hcontroller

If that is also not working then verify the Grant Permissions on keystone mysql database.

You need to execute below two:

GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' \ IDENTIFIED BY '<your keystone="" dbpass="">'; mysql> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' \ IDENTIFIED BY 'your keystone dbpass';

edit flag offensive delete link more
0

answered 2014-11-30 00:22:14 -0500

Chanaka gravatar image

Thanks for the direction.

I actually had to give access to "controller" host to get this working.

GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@controller' \ IDENTIFIED BY 'your keystone dbpass'; Started working once that was done.

ariaDB [(none)]> select user,host from mysql.user;; +----------+------------+ | user | host | +----------+------------+ | glance | % | | keystone | % | | root | 127.0.0.1 | | root | ::1 | | | controller | | glance | controller | | keystone | controller | | root | controller | | | localhost | | glance | localhost | | keystone | localhost | | root | localhost | +----------+------------+

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2014-11-09 12:54:35 -0500

Seen: 1,692 times

Last updated: Nov 30 '14