Yeah as suggested, these docs have some pointers: https://docs.openstack.org/nova/pike/user/cells.html#first-time-setup
Specifically: "If you don't specify --database_connection then nova-manage will use the [database]/connection value from your config file, and mangle the database name to have a _cell0 suffix." And: "If your databases are on separate hosts then you should specify --database_connection or make certain that the nova.conf being used has the [database]/connection value pointing to the same user/password/host that will work for the cell0 database. If the cell0 mapping was created incorrectly, it can be deleted using the nova-manage cell_v2 delete_cell command and then run map_cell0 again with the proper database connection value." So I think what probably happened is that when you ran map_cell0, it created a nova_api.cell_mappings record with the wrong database connection URL, because now db sync, which is relying on the cell_mappings table record to connect to the cell0 database, is failing because it's looking for nova_api_cell0 but you have nova_cell0. This is the exact code that is creating the default cell0 connection URL if you didn't specify --database-connection when running map_cell0: https://github.com/openstack/nova/blob/15.1.0/nova/cmd/manage.py#L1160 So I think you probably just want to (1) delete the cell0 mapping (2) run map_cell0 again and ensure it creates a cell0 entry with the correct database connection URL and then (3) run nova-manage db sync again. ** Changed in: nova Status: New => 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/1769635 Title: Error:Access denied for user 'nova'@'%' to database 'nova_api_cell0' Status in OpenStack Compute (nova): Invalid Bug description: Description =========== My Openstack controller and compute node are installed on centOS7. Everything is fine until I run "su -s /bin/sh -c "nova-manage db sync" nova" as indicated in the online Doc:https://docs.openstack.org/ocata/install-guide-rdo/nova-controller-install.html, I got the error below. ++++++++++++++++++++++++++++++++++++++++++ [root@server ~]# su -s /bin/sh -c "nova-manage db sync" nova ERROR: Could not access cell0. Has the nova_api database been created? Has the nova_cell0 database been created? Has "nova-manage api_db sync" been run? Has "nova-manage cell_v2 map_cell0" been run? Is [api_database]/connection set in nova.conf? Is the cell0 database connection URL correct? Error: (pymysql.err.OperationalError) (1044, u"Access denied for user 'nova'@'%' to database 'nova_api_cell0'") ++++++++++++++++++++++++++++++++++++++++++ I'm sure nova_api and nova_cell0 has been created, and "nova-manage api_db sync" and "nova-manage cell_v2 map_cell0" ran successfully. Also in nova.conf, [api_database]/connection is correctly set. But I logged into the mysql,show databases and there is no such database nova_api_cell0. I then moved on to next steps. All are fine until launching an instance. Error below. ++++++++++++++++++++++++++++++++++++++++++ [root@server ~]# openstack server list Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible. <class 'sqlalchemy.exc.OperationalError'> (HTTP 500) (Request-ID: req-3f7b8ee6-1939-442e-99a7-883cfc178cdd) ++++++++++++++++++++++++++++++++++++++++++ I also found the same error "Access denied for user 'nova'@'%' to database 'nova_api_cell0'" in nova.api.log Can someone tell me why I run into this error? Many thanks in advance. Environment =========== root@server ~]# rpm -qa | grep nova openstack-nova-common-15.1.0-1.el7.noarch openstack-nova-conductor-15.1.0-1.el7.noarch python-nova-15.1.0-1.el7.noarch openstack-nova-scheduler-15.1.0-1.el7.noarch openstack-nova-novncproxy-15.1.0-1.el7.noarch openstack-nova-api-15.1.0-1.el7.noarch openstack-nova-placement-api-15.1.0-1.el7.noarch openstack-nova-console-15.1.0-1.el7.noarch python2-novaclient-7.1.2-1.el7.noarch To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1769635/+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