yahoo-eng-team team mailing list archive

[Balazs Gibizer <balazs.gibizer@xxxxxxxx>]

The below config forks for me in a fresh devstack:

[database]
connection = mysql+pymysql://root:admin@127.0.0.1/nova_cell0?charset=utf8

[api_database]
connection = mysql+pymysql://root:admin@127.0.0.1/nova_api?charset=utf8

Based on the SQLAlchemy documentation[1] this part of the URL specifies
which python package is used to connect to the DB. I guess in your
environment some dependency was missing to use pymysql.

[1] https://docs.sqlalchemy.org/en/13/core/engines.html#mysql

** Changed in: nova
       Status: New => Opinion

-- 
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):
  Opinion

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