[Yahoo-eng-team] [Bug 1837908] [NEW] Dashboard Hangs while trying to create and associate floating IP to instance at the same time
Public bug reported:
OS: Ubuntu 18.04
Horizon Installation: Manual via apt
Package repo: ubuntu cloud archive
Openstack release: Stein
Architecture: 3 node, controller, network, compute.
Services
controller: keystone, nova, glance, neutron-server/ml2-plugin, designate,
horizon, heat
Network: neutron-l3-agent neutron-metadata-agent neutron-dhcp-agent
neutron-linuxbridge-agent Compute: nova-compute, neutron-linuxbridge-agent
All services behind HA proxy with TLS.
Description:
I have tested this exact bug twice, and have the exact same issue on both
installations, one production, one test.
The UI does not allow the creation and association of a floating IP at
the same time.
However succeds using the CLI
create a floating IP manually using CLI and attaching to instance in one
command succeed
openstack floating ip create --dns-domain=stack.lon.example.com. --dns-
name=testy101 --fixed-ip-address=192.1.2.51 --port 59934e2e-6c6f-4c8f-
b0cf-933bcf3497c0 91217bab-6250-4ff5-ae61-0accd79a5d41
ability to ping host afterwards verified.
when using the UI the following was carried out.
Reproducible steps
log into UI and select ( associate floating IP on instance ), then select (
plus+ ) button, then select ( Allocate IP ) this is the part where a new
floating IP is created and attached to the instance I had this working in
ocata, but now it goes into a continuous loop with the working twirler never
stopping.
Refreshing the page, the floating IP is confirmed as being created but
never actually attached.
no errors in logs
tail -f -n1000 /var/log/apache2/horizon/error.log
[Thu Jul 25 13:47:44.477285 2019] [wsgi:error] [pid 11933:tid 140288635377408]
[remote 172.30.0.2:50814] DEBUG:stevedore.extension:found extension
EntryPoint.parse('http = oslo_policy._external:HttpCheck')
[Thu Jul 25 13:47:44.477908 2019] [wsgi:error] [pid 11933:tid 140288635377408]
[remote 172.30.0.2:50814] DEBUG:stevedore.extension:found extension
EntryPoint.parse('https = oslo_policy._external:HttpsCheck')
[Thu Jul 25 13:47:58.151732 2019] [wsgi:error] [pid 11932:tid 140288710911744]
[remote 172.30.0.2:51324] DEBUG:stevedore.extension:found extension
EntryPoint.parse('http = oslo_policy._external:HttpCheck')
[Thu Jul 25 13:47:58.152439 2019] [wsgi:error] [pid 11932:tid 140288710911744]
[remote 172.30.0.2:51324] DEBUG:stevedore.extension:found extension
EntryPoint.parse('https = oslo_policy._external:HttpsCheck')
tail -f -n1000 /var/log/apache2/horizon/access.log
172.30.0.2 - - [25/Jul/2019:14:47:22 +0100] "GET /horizon/project/instances/
HTTP/1.1" 200 8564 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:68.0)
Gecko/20100101 Firefox/68.0"
172.30.0.2 - - [25/Jul/2019:14:47:45 +0100] "GET
/horizon/static/dashboard/css/361cca58bb99.css HTTP/1.1" 200 4729
"https://openstack.lon.example.com/horizon/project/instances/; "Mozilla/5.0
(Windows NT 10.0; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0"
172.30.0.2 - - [25/Jul/2019:14:47:45 +0100] "GET
/horizon/i18n/js/horizon+openstack_dashboard/ HTTP/1.1" 200 3612
"https://openstack.lon.example.com/horizon/project/instances/; "Mozilla/5.0
(Windows NT 10.0; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0"
172.30.0.2 - - [25/Jul/2019:14:47:45 +0100] "GET
/horizon/static/dashboard/js/b2bb2963e6de.js HTTP/1.1" 200 37926
"https://openstack.lon.example.com/horizon/project/instances/; "Mozilla/5.0
(Windows NT 10.0; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0"
172.30.0.2 - - [25/Jul/2019:14:47:45 +0100] "GET
/horizon/static/dashboard/css/7b50ccce00d0.css HTTP/1.1" 200 60951
"https://openstack.lon.example.com/horizon/project/instances/; "Mozilla/5.0
(Windows NT 10.0; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0"
172.30.0.2 - - [25/Jul/2019:14:47:45 +0100] "GET
/horizon/static/dashboard/js/787a5a315d99.js HTTP/1.1" 200 122901
"https://openstack.lon.example.com/horizon/project/instances/; "Mozilla/5.0
(Windows NT 10.0; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0"
172.30.0.2 - - [25/Jul/2019:14:47:45 +0100] "GET
/horizon/static/dashboard/js/c927fd827a6d.js HTTP/1.1" 200 429891
"https://openstack.lon.example.com/horizon/project/instances/; "Mozilla/5.0
(Windows NT 10.0; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0"
172.30.0.2 - - [25/Jul/2019:14:47:45 +0100] "GET
/horizon/static/dashboard/img/logo.svg HTTP/1.1" 200 5972
"https://openstack.lon.example.com/horizon/project/instances/; "Mozilla/5.0
(Windows NT 10.0; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0"
172.30.0.2 - - [25/Jul/2019:14:47:45 +0100] "GET
/horizon/static/horizon/lib/font_awesome/fonts/fontawesome-webfont.woff2?v=4.7.0
HTTP/1.1" 200 77387
"https://openstack.lon.example.com/horizon/static/dashboard/css/7b50ccce00d0.css;
"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:68.0) Gecko/20100101
Firefox/68.0"
172.30.0.2 - - [25/Jul/2019:14:47:45 +0100] "GET
/horizon/static/dashboard/img/apple-touch-icon.png HTTP/1.1" 200 1171 "-"
"Mozilla/5.0 (Windows NT 10.0; Win64;
[Yahoo-eng-team] [Bug 1837455] Re: could not find requested endpoint in service catalog
configuration error. closing
** Changed in: neutron
Status: New => Invalid
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1837455
Title:
could not find requested endpoint in service catalog
Status in neutron:
Invalid
Bug description:
im trying to assign a DNS name to floating IP and put this in
designate but i get the following response back. Can someone please
tell me what I need to add to the service catalog. thanks
### NEUTRON LOG
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
[req-40c644eb-0dc2-4e3f-903c-2e8f869b0810 f6d220afc2ba40c59e43dcef3681c56f
07a8270a4ea6432cb985f291cb0a1aa4 - default default] create failed: No details.:
keystoneauth1.exceptions.catalog.EndpointNotFound: Could not find requested
endpoint in Service Catalog.
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource Traceback (most
recent call last):
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/neutron/api/v2/resource.py", line 98, in
resource
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource result =
method(request=request, **args)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/neutron/api/v2/base.py", line 436, in create
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource return
self._create(request, body, **kwargs)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/neutron_lib/db/api.py", line 139, in wrapped
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource setattr(e,
'_RETRY_EXCEEDED', True)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
self.force_reraise()
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_utils/excutils.py", line 196, in
force_reraise
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
six.reraise(self.type_, self.value, self.tb)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/six.py", line 693, in reraise
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource raise value
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/neutron_lib/db/api.py", line 135, in wrapped
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource return
f(*args, **kwargs)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_db/api.py", line 154, in wrapper
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource ectxt.value =
e.inner_exc
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
self.force_reraise()
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_utils/excutils.py", line 196, in
force_reraise
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
six.reraise(self.type_, self.value, self.tb)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/six.py", line 693, in reraise
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource raise value
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_db/api.py", line 142, in wrapper
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource return
f(*args, **kwargs)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/neutron_lib/db/api.py", line 183, in wrapped
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
LOG.debug("Retry wrapper got retriable exception: %s", e)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
self.force_reraise()
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_utils/excutils.py", line 196, in
force_reraise
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
six.reraise(self.type_, self.value, self.tb)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/six.py", line 693, in reraise
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource raise value
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
[Yahoo-eng-team] [Bug 1837455] [NEW] could not find requested endpoint in service catalog
Public bug reported:
im trying to assign a DNS name to floating IP and put this in designate
but i get the following response back. Can someone please tell me what I
need to add to the service catalog. thanks
### NEUTRON LOG
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
[req-40c644eb-0dc2-4e3f-903c-2e8f869b0810 f6d220afc2ba40c59e43dcef3681c56f
07a8270a4ea6432cb985f291cb0a1aa4 - default default] create failed: No details.:
keystoneauth1.exceptions.catalog.EndpointNotFound: Could not find requested
endpoint in Service Catalog.
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource Traceback (most
recent call last):
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/neutron/api/v2/resource.py", line 98, in
resource
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource result =
method(request=request, **args)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/neutron/api/v2/base.py", line 436, in create
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource return
self._create(request, body, **kwargs)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/neutron_lib/db/api.py", line 139, in wrapped
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource setattr(e,
'_RETRY_EXCEEDED', True)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
self.force_reraise()
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_utils/excutils.py", line 196, in
force_reraise
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
six.reraise(self.type_, self.value, self.tb)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/six.py", line 693, in reraise
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource raise value
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/neutron_lib/db/api.py", line 135, in wrapped
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource return f(*args,
**kwargs)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_db/api.py", line 154, in wrapper
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource ectxt.value =
e.inner_exc
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
self.force_reraise()
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_utils/excutils.py", line 196, in
force_reraise
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
six.reraise(self.type_, self.value, self.tb)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/six.py", line 693, in reraise
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource raise value
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_db/api.py", line 142, in wrapper
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource return f(*args,
**kwargs)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/neutron_lib/db/api.py", line 183, in wrapped
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
LOG.debug("Retry wrapper got retriable exception: %s", e)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
self.force_reraise()
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/oslo_utils/excutils.py", line 196, in
force_reraise
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource
six.reraise(self.type_, self.value, self.tb)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/six.py", line 693, in reraise
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource raise value
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/neutron_lib/db/api.py", line 179, in wrapped
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource return
f(*dup_args, **dup_kwargs)
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource File
"/usr/lib/python3/dist-packages/neutron/api/v2/base.py", line 555, in _create
2019-07-22 20:02:56.318 17768 ERROR neutron.api.v2.resource obj =
do_create(body)
2019-07-22 20:02:56.318 17768 ERROR
[Yahoo-eng-team] [Bug 1706362] Re: Cannot list hyper-visors or compute services
** Changed in: nova Status: Incomplete => Invalid -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to OpenStack Compute (nova). https://bugs.launchpad.net/bugs/1706362 Title: Cannot list hyper-visors or compute services Status in OpenStack Compute (nova): Invalid Bug description: Description === I have followed the docswhile making custom TLS modifications to the config files, i am now giving up on ocata and falling back to neutron for one last try with TLS. Please see logs for stack traces. Steps to reproduce === Unknown Expected result === be able to list hypervisors and compute servies Actual result = both commands to list hypervisor and compute services timeout, with both openstack and nova commands. Environment === Ocata Ubuntu cloud Archive nova-api 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - API frontend nova-common 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - common files nova-conductor 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - conductor service nova-consoleauth 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - Console Authenticator nova-novncproxy 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - NoVNC proxy nova-placement-api 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - placement API frontend nova-scheduler 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - virtual machine scheduler python-nova 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute Python libraries python-novaclient 2:7.1.0-0ubuntu1~cloud0 all client library for OpenStack Compute API - Python 2.7 OpenVSwitch KVM To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1706362/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
[Yahoo-eng-team] [Bug 1706362] [NEW] Cannot list hyper-visors or compute services
Public bug reported: Description === I have followed the docswhile making custom TLS modifications to the config files, i am now giving up on ocata and falling back to neutron for one last try with TLS. Please see logs for stack traces. Steps to reproduce === Unknown Expected result === be able to list hypervisors and compute servies Actual result = both commands to list hypervisor and compute services timeout, with both openstack and nova commands. Environment === Ocata Ubuntu cloud Archive nova-api 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - API frontend nova-common 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - common files nova-conductor 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - conductor service nova-consoleauth 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - Console Authenticator nova-novncproxy 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - NoVNC proxy nova-placement-api 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - placement API frontend nova-scheduler 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - virtual machine scheduler python-nova 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute Python libraries python-novaclient 2:7.1.0-0ubuntu1~cloud0 all client library for OpenStack Compute API - Python 2.7 OpenVSwitch KVM ** Affects: nova Importance: Undecided Status: New ** Attachment added: "combined logs from keystone compute and nova api" https://bugs.launchpad.net/bugs/1706362/+attachment/4921024/+files/combined-keystone-nova-api-compute.log -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to OpenStack Compute (nova). https://bugs.launchpad.net/bugs/1706362 Title: Cannot list hyper-visors or compute services Status in OpenStack Compute (nova): New Bug description: Description === I have followed the docswhile making custom TLS modifications to the config files, i am now giving up on ocata and falling back to neutron for one last try with TLS. Please see logs for stack traces. Steps to reproduce === Unknown Expected result === be able to list hypervisors and compute servies Actual result = both commands to list hypervisor and compute services timeout, with both openstack and nova commands. Environment === Ocata Ubuntu cloud Archive nova-api 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - API frontend nova-common 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - common files nova-conductor 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - conductor service nova-consoleauth 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - Console Authenticator nova-novncproxy 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - NoVNC proxy nova-placement-api 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - placement API frontend nova-scheduler 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - virtual machine scheduler python-nova 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute Python libraries python-novaclient 2:7.1.0-0ubuntu1~cloud0 all client library for OpenStack Compute API - Python 2.7 OpenVSwitch KVM To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1706362/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
[Yahoo-eng-team] [Bug 1706118] [NEW] Adding TLS Connection String To Database Connection Causes malformed URL in cell_mappings DB
Public bug reported: Description === Fresh Install Ubuntu 16.04 I followed Ubuntu install guide up to Install Nova on Controller, I configured Nova.conf and specified api_database and database connection string with SSL/TLS Parameters, then ran the DB commands. The following are successful. su -s /bin/sh -c "nova-manage api_db sync" nova su -s /bin/sh -c "nova-manage cell_v2 map_cell0" nova su -s /bin/sh -c "nova-manage cell_v2 create_cell --name=cell1 --verbose" nova The following command fails with error su -s /bin/sh -c "nova-manage db sync" nova ERROR: could not access cell mapping database - has api db been created? My connection string is as follows connection = mysql+pymysql://nova:my_password@my_IP/nova_api?charset=utf8_ca=/etc/nova/tls/mysql /ca-cert.pem_cert=/etc/nova/tls/mysql/server- cert.pem_key=/etc/nova/tls/mysql/server-key.pem The following connection string is what appears in the database table mysql+pymysql://nova:4f35d884c9960df0ac80@10.30.0.2/nova?charset=utf8_ca=/etc/nova/tls/mysql /ca-cert.pem_cert=/etc/nova/tls/mysql/server- cert.pem_key=/etc/nova/tls/mysql/server-key.pemnova_cell0 on #openstack-nova suggests that this is a string substitution bug. Steps to reproduce === 1. Install Ubuntu 16.04 2. Install Keystone 3. Configure Database connection string with TLS/SSL Parameters 4. Install Glance 5. Configure Database connection string with TLS/SSL Parameters 6. Install Nova 7. Configure Database connection string with TLS/SSL Parameters 8. Run the DB sync commands in order from the Docs Failure at > su -s /bin/sh -c "nova-manage db sync" nova Expected result === Nova database Populates without error Actual result = Nova database does not populate and following error thrown ERROR: could not access cell mapping database - has api db been created? Environment === Ocata Ubuntu cloud Archive nova-api 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - API frontend nova-common2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - common files nova-conductor 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - conductor service nova-consoleauth 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - Console Authenticator nova-novncproxy2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - NoVNC proxy nova-placement-api 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - placement API frontend nova-scheduler 2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute - virtual machine scheduler python-nova2:15.0.5-0ubuntu1~cloud0 all OpenStack Compute Python libraries python-novaclient 2:7.1.0-0ubuntu1~cloud0 all client library for OpenStack Compute API - Python 2.7 OpenVSwitch KVM Logs & Configs == [DEFAULT] #debug = true # #dhcpbridge_flagfile=/etc/nova/nova.conf #dhcpbridge=/usr/bin/nova-dhcpbridge #force_dhcp_release=true # my_ip = my_ip state_path = /var/lib/nova enabled_apis = osapi_compute,metadata enabled_ssl_apis = osapi_compute,metadata osapi_compute_listen = my_ip osapi_compute_listen_port = 8774 metadata_host = $my_ip metadata_listen = my_ip metadata_listen_port = 8775 metadata_port = 8775 # rootwrap_config = /etc/nova/rootwrap.conf api_paste_config = /etc/nova/api-paste.ini log_dir = /var/log/nova use_neutron = True firewall_driver = nova.virt.firewall.NoopFirewallDriver ## cert = /etc/nova/tls/server-cert.pem key = /etc/nova/tls/server-key.pem ssl_only = True transport_url = rabbit://controller01:my_password@my_ip compute_api_class=nova.compute.cells_api.ComputeCellsAPI [api] auth_strategy = keystone [api_database] connection = mysql+pymysql://nova:my_password@my_ip/nova_api?charset=utf8_ca=/etc/nova/tls/mysql/ca-cert.pem_cert=/etc/nova/tls/mysql/server-cert.pem_key=/etc/nova/tls/mysql/server-key.pem #connection_debug = 1 [barbican] [cache] [cells] enable=True cell_type = api [cinder] [cloudpipe] [conductor] [console] [consoleauth] [cors] [cors.subdomain] [crypto] ## cert_file = /etc/nova/tls/server-cert.pem key_file = /etc/nova/tls/server-key.pem ca_file = /etc/nova/tls/ca-cert.pem ## [database] connection = mysql+pymysql://nova:my_password@my_ip/nova?charset=utf8_ca=/etc/nova/tls/mysql/ca-cert.pem_cert=/etc/nova/tls/mysql/server-cert.pem_key=/etc/nova/tls/mysql/server-key.pem #connection_debug = 1 [ephemeral_storage_encryption] [filter_scheduler] [glance] api_servers = https://my_ip:9292 api_insecure = False [guestfs] [healthcheck] [hyperv] [image_file_url] [ironic] [key_manager]
