Ask Your Question

Vijayuppala's profile - activity

2016-07-27 05:00:43 -0500 received badge  Famous Question (source)
2016-07-20 14:20:37 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

I'm able to create the identity service now.... :). I will continue with my installation. I will post another question if i face issues later on. Thank You very much Barry for your support. Really appreciate it.

2016-07-20 14:15:57 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

Granting the privileges to keystone'@'controller' worked. I see the tables populated now. Let me see if I can create the identity service. Thank You

2016-07-20 14:12:55 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

yes..i did yum upgrade after i installed the centos-release-openstack-mitaka. i can grant privileges to 'keystone'@'controller' to see if it works.

2016-07-20 14:03:18 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

The bold names are included but commented out. When i pasted the output here it doesnt show the "#" before the names.

2016-07-20 13:55:29 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

block1

10.0.2.41 block1

object1

10.0.2.51 object1

object2

10.0.2.52 object2

2016-07-20 13:55:04 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

controller

192.168.56.102 controller

compute1

192.168.56.101 compute1

2016-07-20 13:48:16 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

I see a lot of errors and this looks like the main culprit

2016-07-20 11:45:57.171 16376 ERROR keystone OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'keystone'@'controller' (using password: YES)")
2016-07-20 13:38:24 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

I just restarted the mariadb (i'm using CentOS). I see it is bind to the controller IP (192.168.56.102) truncated output of

[root@controller keystone]# tail -f /var/log/mariadb/mariadb.log 
2016-07-20 11:33:42 139827824461952 [Note] Server socket created on IP: '192.168.56.102'.
2016-07-20 13:38:24 -0500 received badge  Commentator
2016-07-20 13:14:01 -0500 received badge  Notable Question (source)
2016-07-20 13:11:18 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

[root@controller keystone]# cat /etc/my.cnf.d/openstack.conf

[mysqld]
bind-address = 192.168.56.102
default-storage-engine = innodb
innodb_file_per_table
max_connections = 4096
collation-server = utf8_general_ci
character-set-server = utf8
2016-07-20 13:03:03 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

[root@controller keystone]# ss -tul | grep mysql tcp LISTEN 0 80 :::mysql :::*

2016-07-20 12:47:37 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

yes..i tried both mysql and also mysql+pymysql. the admin_token is on a new line under the [DEFAULT] section

[DEFAULT]
admin_token = b9a95be763c7bf6cce1a
2016-07-20 12:45:09 -0500 received badge  Popular Question (source)
2016-07-20 12:35:44 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

I even tried replacing the controller with the IP and it still doesnt work.

connection = mysql://keystone:keystone123@192.168.56.102/keystone

2016-07-20 12:34:37 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

Thats what puzzles me. Controller resolves to the correct IP [root@controller ~]# ping controller PING controller (192.168.56.102) 56(84) bytes of data. 64 bytes from controller (192.168.56.102): icmp_seq=1 ttl=64 time=0.043 ms

2016-07-20 12:01:48 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

Is there something else i'm missing?

2016-07-20 11:58:47 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

[root@controller ~]# su -s /bin/sh -c "keystone-manage db_sync" keystone

MariaDB [(none)]> use keystone
Database changed
MariaDB [keystone]> show tables;
Empty set (0.00 sec)
2016-07-20 11:57:50 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

MariaDB [(none)]> grant all privileges on keystone.* to 'keystone'@'localhost' identified by 'keystone123'; Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> grant all privileges on keystone.* to 'keystone'@'%' identified by 'keystone123';
Query OK, 0 rows affected (0.00 sec)
2016-07-20 11:55:13 -0500 commented answer HTTP 500 error while installing the keystone identity service (Mitaka)

Barry, thank you for the response. I issued the grant privileges commands multiple times and then tried to sync the db but it still doesnt work.

2016-07-19 23:51:10 -0500 received badge  Student (source)
2016-07-19 21:58:06 -0500 asked a question HTTP 500 error while installing the keystone identity service (Mitaka)

I'm trying to install the Mitaka and struck at the keystone identity service (http://docs.openstack.org/mitaka/inst... )

Below is my configuration

i created the keystone DB in mysql

[root@controller keystone]# mysql -u root -p 
Enter password: 
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 63 Server version: 10.1.12-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | keystone | | mysql | | performance_schema | | test | +--------------------+ 5 rows in set (0.00 sec)

MariaDB [(none)]>

This is how my keystone.conf file looks like

[root@controller keystone]# grep ^[^#] /etc/keystone/keystone.conf 
[DEFAULT] admin_token = b9a95be763c7bf6cce1a 
[assignment] 
[auth] 
[cache] 
[catalog] 
[cors]
[cors.subdomain] 
[credential] 
[database] 
connection = mysql+pymysql://keystone:keystone123@controller/keystone 
[domain_config] 
[endpoint_filter] 
[endpoint_policy] 
[eventlet_server] 
[eventlet_server_ssl] 
[federation] 
[fernet_tokens] 
[identity] 
[identity_mapping] 
[kvs] 
[ldap] 
[matchmaker_redis] 
[memcache] 
[oauth1] 
[os_inherit] 
[oslo_messaging_amqp] 
[oslo_messaging_notifications] 
[oslo_messaging_rabbit] 
[oslo_middleware] 
[oslo_policy] 
[paste_deploy] 
[policy] 
[resource] 
[revoke] 
[role] 
[saml] 
[shadow_users]
[signing] 
[ssl] 
[token] 
provider = fernet 
[tokenless_auth] 
[trust]

And finally these are the exported values

[root@controller ~]# echo $OS_TOKEN 
b9a95be763c7bf6cce1a 
[root@controller ~]# more /etc/keystone/keystone.conf | grep admin_token
        None, the value is ignored and the admin_token log in mechanism is
        effectively disabled. To completely disable admin_token in production

        admin_token = b9a95be763c7bf6cce1a 
[root@controller ~]# echo $OS_URL 
http://controller:35357/v3 
[root@controller ~]# echo $OS_IDENTITY_API_VERSION 
3

Everything looks good in the keystone.conf file and the export values match as well but i still get the HTTP 500 error

[root@controller ~]# openstack service create \

    --name keystone --description "OpenStack Identity" identity An unexpected error prevented the server from fulfilling your request. (HTTP 500) (Request-ID: req-56b3b078-0978-4e69-886c-570ebb333ae0)

I dropped the keystone db and tried again several times but the same result. i just found out that the su -s /bin/sh -c "keystone-manage db_sync" keystone command is not populating the tables in the keystone db

MariaDB [keystone]> show tables; Empty set (0.00 sec)

MariaDB [keystone]>

Could this be the problem?

Thank You Vijay Uppala

2016-07-19 21:58:04 -0500 answered a question Internal Server Error (HTTP 500) error during Service Create

Hi Barry,

Thank you for the response. I have the same issue as John. I'm trying to install the Mitaka and struck at the keystone identity service (http://docs.openstack.org/mitaka/install-guide-rdo/keystone-services.html (http://docs.openstack.org/mitaka/inst...) )

Below is my configuration

i created the keystone DB in mysql [root@controller keystone]# mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 63 Server version: 10.1.12-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | keystone | | mysql | | performance_schema | | test | +--------------------+ 5 rows in set (0.00 sec)

MariaDB [(none)]>

This is how my keystone.conf file looks like

[root@controller keystone]# grep ^[^#] /etc/keystone/keystone.conf [DEFAULT] admin_token = b9a95be763c7bf6cce1a [assignment] [auth] [cache] [catalog] [cors] [cors.subdomain] [credential] [database] connection = mysql+pymysql://keystone:keystone123@controller/keystone [domain_config] [endpoint_filter] [endpoint_policy] [eventlet_server] [eventlet_server_ssl] [federation] [fernet_tokens] [identity] [identity_mapping] [kvs] [ldap] [matchmaker_redis] [memcache] [oauth1] [os_inherit] [oslo_messaging_amqp] [oslo_messaging_notifications] [oslo_messaging_rabbit] [oslo_middleware] [oslo_policy] [paste_deploy] [policy] [resource] [revoke] [role] [saml] [shadow_users] [signing] [ssl] [token] provider = fernet [tokenless_auth] [trust]

And finally these are the exported values

[root@controller ~]# echo $OS_TOKEN b9a95be763c7bf6cce1a [root@controller ~]# more /etc/keystone/keystone.conf | grep admin_token

None, the value is ignored and the admin_token log in mechanism is

effectively disabled. To completely disable admin_token in production

admin_token = b9a95be763c7bf6cce1a [root@controller ~]# echo $OS_URL http://controller:35357/v3 [root@controller ~]# echo $OS_IDENTITY_API_VERSION 3

everything looks good in the keystone.conf file and the export values match as well but i still get the HTTP 500 error

[root@controller ~]# openstack service create \

--name keystone --description "OpenStack Identity" identity An unexpected error prevented the server from fulfilling your request. (HTTP 500) (Request-ID: req-56b3b078-0978-4e69-886c-570ebb333ae0)

i dropped the keystone db and tried again several times but the same result. i just found out that the su -s /bin/sh -c "keystone-manage db_sync" keystone command is not populating the tables in the keystone db MariaDB [keystone]> show tables; Empty set (0.00 sec)

MariaDB [keystone]>

Could this be the problem?

Thank You Vijay Uppala