The below config forks for me in a fresh devstack: [database] connection = mysql+pymysql://root:[email protected]/nova_cell0?charset=utf8
[api_database] connection = mysql+pymysql://root:[email protected]/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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
