Ask Your Question
1

keystone user-create - An unexpected error prevented the server from fulfilling your request. (HTTP 500) [closed]

asked 2014-08-20 04:03:21 -0500

julienonline gravatar image

updated 2014-08-20 04:29:45 -0500

Hello, Trying to install keystone service, but cannot deal with keystone user-create command. Please find bellow some information Thank you for your help.

[root@dvopscontroller etc]# echo $OS_SERVICE_TOKEN
e1e26d356b408e65b46a
[root@dvopscontroller etc]#  echo $OS_SERVICE_ENDPOINT
http://dvopscontroller:35357/v2.0
[root@dvopscontroller etc]# keystone user-create --name=admin --pass=ADMIN_PASS --email=ADMIN_EMAIL
An unexpected error prevented the server from fulfilling your request. (HTTP 500)

[root@dvopscontroller etc]# vi keystone/keystone.conf
admin_token = e1e26d356b408e65b46a
connection = mysql://keystone:KEYSTONE_DBPASS@dvopscontroller/keystone

[root@dvopscontroller etc]# tail /var/log/keystone/keystone.log
2014-08-20 10:59:05.078 4262 TRACE keystone.common.wsgi OperationalError: (OperationalError) (1045, "Access denied for user 'keystone'@'dvopscontroller' (using password: YES)") None None
2014-08-20 10:59:05.078 4262 TRACE keystone.common.wsgi
2014-08-20 11:00:01.707 4451 CRITICAL keystone [-] OperationalError: (OperationalError) (1045, "Access denied for user 'keystone'@'dvopscontroller' (using password: YES)") None None

[root@dvopscontroller etc]# netstat -anutp|grep 35357
tcp        0      0 0.0.0.0:35357               0.0.0.0:*                   LISTEN      4262/python
[root@dvopscontroller etc]# telnet 0 35357
Trying 0.0.0.0...
Connected to 0.
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@dvopscontroller etc]#
edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by SamYaple
close date 2014-08-25 09:53:47.658210

Comments

NB : I am able to access database on CLI :

[root@dvopscontroller ~]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 41 Server version: 5.1.69 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | keystone | | mysql | +--------------------+ 3 rows in set (0.00 sec)

julienonline gravatar imagejulienonline ( 2014-08-20 04:35:42 -0500 )edit

By replacing a variable, in the keystone config file, it works fine... connection = mysql://keystone:KEYSTONE_DBPASS@dvopscontroller/keystone => connection = mysql://keystone:KEYSTONE_DBPASS@localhost/keystone

julienonline gravatar imagejulienonline ( 2014-08-20 07:43:07 -0500 )edit

3 answers

Sort by ยป oldest newest most voted
1

answered 2014-08-20 11:08:48 -0500

SamYaple gravatar image

Your perms might be wrong. You need to allow at both localhost and '%'. This can cause 1045

edit flag offensive delete link more
0

answered 2014-08-25 02:42:15 -0500

julienonline gravatar image

Thank you SamYaple

edit flag offensive delete link more
0

answered 2014-08-20 09:27:45 -0500

Check you mysql credetnials. Here you are logging as root, but in conf file , the user name is different

edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2014-08-20 04:03:21 -0500

Seen: 9,192 times

Last updated: Aug 25 '14