openstack service db-relation failure

[Fatih Nar]

Various openstack service charms (nova-cloud-controller , cinder) fails with db-relation build up due to invalid db_host and db_password credentials.

Charm Release 17.02
Openstack Release: Mitaka

@Nova-cloud-controller:

2017-03-14 21:18:53 INFO update-status error: no relation id specified
2017-03-14 21:18:53 INFO juju-log Missing required data: database_password database_host
2017-03-14 21:18:53 INFO juju-log Missing required data: database_password database_host
2017-03-14 21:18:53 INFO juju-log Missing required data: database_password database_host

$ juju run --unit nova-cloud-controller/0 'relation-ids shared-db'
shared-db:64
$ juju run --unit nova-cloud-controller/1 'relation-ids shared-db'
shared-db:64
$ juju run --unit nova-cloud-controller/2 'relation-ids shared-db'
shared-db:64

$ juju run --unit nova-cloud-controller/1 'relation-get -r shared-db:64 - mysql/0'
private-address: 10.75.50.252
$ juju run --unit keystone/1 'relation-ids shared-db'
shared-db:22
$ juju run --unit keystone/1 'relation-get -r shared-db:22 - mysql/0'
access-network: 172.23.0.0/23
db_host: 172.23.0.204
password: yg5PZxzFkjsNBBxzTVRkqYPM6NZ9MXBS
private-address: 10.75.50.252

$ juju run --unit mysql/1 'relation-get -r shared-db:64 - nova-cloud-controller/0'
nova_database: nova
nova_hostname: 10.75.50.234
nova_username: nova
novaapi_database: nova_api
novaapi_hostname: 10.75.50.234
novaapi_username: nova
private-address: 10.75.50.234

Openstack Bundle Parts for nova-cloud-controller and mysql:
 nova-cloud-controller:
    charm: cs:xenial/nova-cloud-controller
    num_units: 3
    options:
      openstack-origin: cloud:xenial-mitaka
      network-manager: Neutron
      os-admin-network: '172.23.0.0/23'
      os-internal-network: '172.23.0.0/23'
      os-public-network: '10.75.50.128/25'
      ha-bindiface: eth2
      vip: 10.75.50.206 172.23.0.206
      use-internal-endpoints: true
      console-access-protocol: novnc
      single-nova-consoleauth: false
    to:
    - lxd:0
    - lxd:1
    - lxd:2

Logs attached in zip folder.

[Fatih Nar (fenar-e)]

Today (03/15/2017) we have faced same db-relation issue in openstack mitaka deployment, this time with neutron-api. David Ames was with us online to debug the issue. Logs ara attached.