yahoo-eng-team team mailing list archive

[John <1874951@xxxxxxxxxxxxxxxxxx>]

Public bug reported:


This bug tracker is for errors with the documentation, use the following
as a template and remove or add fields as you see fit. Convert [ ] into
[x] to check boxes:

- [X] This doc is inaccurate in this way:

Documentation for nova states: "connection =
mysql+pymysql://nova:NOVA_DBPASS@controller/nova_api", however this was
consistently failing with sql connection issues.  Numerous
troubleshooting efforts did not resolve it until I found a semi-
unrelated stackoverflow post suggesting to change it to "mysql://"
instead.  Once that was changed, everything magically worked.


Reproduce:
1) follow installation instructions
2) attempt to run `nova-manage api_db sync` and watch sql failures.
3) Update /etc/nova/nova.conf with "proper" "mysql://" protocol configuration.
4) run `nova-manage api_db sync` and watch database actions properly function.

-----------------------------------
Release:  on 2019-06-24 09:36:02
SHA: 118ee682571a4bd41c8009dbe2e47fdd1f85a630
Source: https://opendev.org/openstack/nova/src/doc/source/install/controller-install-obs.rst
URL: https://docs.openstack.org/nova/train/install/controller-install-obs.html

** Affects: nova
     Importance: Undecided
         Status: New


** Tags: doc

-- 
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/1874951

Title:
  Documentation for nova improperly configures mysql connections

Status in OpenStack Compute (nova):
  New

Bug description:

  This bug tracker is for errors with the documentation, use the
  following as a template and remove or add fields as you see fit.
  Convert [ ] into [x] to check boxes:

  - [X] This doc is inaccurate in this way:

  Documentation for nova states: "connection =
  mysql+pymysql://nova:NOVA_DBPASS@controller/nova_api", however this
  was consistently failing with sql connection issues.  Numerous
  troubleshooting efforts did not resolve it until I found a semi-
  unrelated stackoverflow post suggesting to change it to "mysql://"
  instead.  Once that was changed, everything magically worked.

  
  Reproduce:
  1) follow installation instructions
  2) attempt to run `nova-manage api_db sync` and watch sql failures.
  3) Update /etc/nova/nova.conf with "proper" "mysql://" protocol configuration.
  4) run `nova-manage api_db sync` and watch database actions properly function.

  -----------------------------------
  Release:  on 2019-06-24 09:36:02
  SHA: 118ee682571a4bd41c8009dbe2e47fdd1f85a630
  Source: https://opendev.org/openstack/nova/src/doc/source/install/controller-install-obs.rst
  URL: https://docs.openstack.org/nova/train/install/controller-install-obs.html

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1874951/+subscriptions