Ask Your Question
0

no tables in Keystone Identity service database(mariadb) while installing Ocata

asked 2017-06-06 05:53:13 -0500

amant gravatar image

Hi,

I am following Ocata install guide (https://docs.openstack.org/ocata/install-guide-rdo/InstallGuide.pdf (https://docs.openstack.org/ocata/inst...)). After executing "su -s /bin/sh -c "keystone-manage db_sync" keystone" . I don't see any table populated in keystone database.

MariaDB [(none)]> show GRANTS; +----------------------------------------------------------------------------------------------------------------------------------------+ | Grants for root@localhost | +----------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON . TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*EF5F9FF302CDAF962891C62XXXXXXXXXXXXXXD0A' WITH GRANT OPTION | | GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION | +----------------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec)

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

[root@controller2 ~]# cat /etc/keystone/keystone.conf | egrep 'provider = |connection = '|egrep -v ^# connection = mysql+pymysql://keystone:NextGen@controller2/keystone
provider = fernet

Above are modified under [database] and [token] sections respectively. Is this normal ?

I proceeded further and while executing

[root@controller2 conf.d]# openstack project create --domain default --description "Service Project" service An unexpected error prevented the server from fulfilling your request. (HTTP 500) (Request-ID: req-95e7e8bf-e069-48d4-b84a-dca4c1b1881e)


[root@controller2 conf.d]# openstack project list --log-file openstack.log --debug START with options: [u'project', u'list', u'--log-file', u'openstack.log', u'--debug'] options: Namespace(access_key='', access_secret='', access_token='', access_token_endpoint='', access_token_type='', auth_type='', auth_url='http://controller2:35357/v3', cacert=None, cert='', client_id='', client_secret='', cloud='', code='', consumer_key='', consumer_secret='', debug=True, default_domain='default', default_domain_id='', default_domain_name='', deferred_help=False, discovery_endpoint='', domain_id='', domain_name='', endpoint='', identity_provider='', insecure=None, interface='', key='', log_file=u'openstack.log', old_profile=None, openid_scope='', os_beta_command=False, os_compute_api_version='', os_identity_api_version='3', os_image_api_version='', os_network_api_version='', os_object_api_version='', os_project_id=None, os_project_name=None, os_volume_api_version='', passcode='', password='', profile=None, project_domain_id='', project_domain_name='Default', project_id='', project_name='admin', protocol='', redirect_uri='', region_name='', timing=False, token='', trust_id='', url='', user_domain_id='', user_domain_name='Default', user_id='', username='admin', verbose_level=3, verify=None) Auth plugin password selected auth_config_hook(): {'auth_type': 'password', 'beta_command': False, u'compute_api_version': u'2', 'key': None, u'database_api_version': u'1.0', 'cacert': None, 'auth_url': 'http://controller2:35357/v3', u'network_api_version': u'2', u'message': u'', u'image_format': u'qcow2', 'networks': [], u'image_api_version': u'2', 'verify': True, u'dns_api_version': u'2', u'object_store_api_version': u'1', 'username': 'admin', u'container_infra_api_version': u'1', 'verbose_level': 3, 'region_name': '', 'api_timeout': None, u'baremetal_api_version': u'1', 'auth': {'user_domain_name': 'Default', 'project_name': 'admin', 'project_domain_name': 'Default'}, 'default_domain': 'default', u'container_api_version': u'1', u'image_api_use_tasks': False, u'floating_ip_source': u'neutron', u'orchestration_api_version': u'1', 'timing': False, 'password': '', u'application_catalog_api_version': u'1', u'key_manager_api_version': u'v1', u'metering_api_version': u'2', 'deferred_help': False, u'identity_api_version': '3', u'volume_api_version': u'2', 'cert': None, u'secgroup_source': u'neutron', u'status': u'active', 'debug': True, 'log_file': u'openstack.log', u'interface': None, u'disable_vendor_agent': {}} defaults: {u'auth_type': 'password', u'status': u'active', u'compute_api_version': u'2', 'key': None, u'database_api_version': u'1.0', 'api_timeout': None, u'baremetal_api_version': u'1', u'image_api_version': u'2', u'container_infra_api_version': u'1', u'metering_api_version': u'2', u'image_api_use_tasks': False, u'floating_ip_source': u'neutron', u'orchestration_api_version': u'1', 'cacert': None, u'network_api_version': u'2', u'message': u'', u'image_format': u'qcow2', u'application_catalog_api_version': u'1', u'key_manager_api_version': u'v1', 'verify': True, u'identity_api_version': u'2.0', u'volume_api_version': u'2', 'cert': None, u'secgroup_source': u'neutron', u'container_api_version': u'1', u'dns_api_version': u'2', u ... (more)

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
0

answered 2017-06-07 03:23:49 -0500

amant gravatar image

I saw the following error

2017-06-07 01:52:15.886 17567 ERROR keystone OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'keystone'@'controller2' (using password: YES)") 2017-06-07 01:52:15.886 17567 ERROR keystone

I modified the /etc/hosts file and replaced localhost with controller in front of 127.0.0.1

After trying again , I saw that tables are populated. I am not sure now, what exactly should etc/hosts should be. Further comments are welcome.

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: 2017-06-06 05:28:30 -0500

Seen: 557 times

Last updated: Jun 07 '17