Ask Your Question

Change nova_cell0 from previous installation

asked 2018-11-15 05:25:20 -0600

najeh gravatar image

updated 2018-11-15 10:39:43 -0600

I change the management interface, so i change some steps in openstack deployment in the configuration of nova_cell0, i found some error with this command

/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) (1045, u"Access denied for user 'nova'@'x.x.x.x' (using password: YES)") (Background on this error at:

/bin/sh -c "nova-manage cell_v2 create_cell --name=cell1 --verbose" nova 109e1d4b-536a-40d0-83c6-5f121b82b650:

The specified transport_url and/or database_connection combination already exists for another cell with uuid 66e2c16a-788c-442a-b466-eb9069c94b99.

/bin/sh -c "nova-manage cell_v2 map_cell0" nova:

Cell0 is already setup

'nova'@'x.x.x.x' use the previous management interface .

I access to the dashboard and i see that the placement and identity services didn't change to the new managemebt_interface.

How can i change this ?

edit retag flag offensive close merge delete

2 answers

Sort by ยป oldest newest most voted

answered 2018-11-15 07:45:54 -0600

updated 2018-12-22 06:41:35 -0600

if you changed your management ip,

i)You need to change bind-ip in MySQL configuration

ii)if created an endpoint like this using management ip (, the endpoint should be changed and keystone database should be synced and apache service requires the restart.

iii)If you mentioned the management ip in OpenStack service's configuration files, that is also should be changed and service requires restart and databases also requires sync

iv)If you enabled memcahed in the horizon, the memcached.conf should be changed and Memcached service should be restarted

In nova api-database host mapping table will there,you can manually map your hosts in that table

edit flag offensive delete link more


i did all of that but i still have the error

najeh gravatar imagenajeh ( 2018-11-15 08:24:26 -0600 )edit

answered 2018-11-15 05:45:50 -0600

yasin lachiny gravatar image

in /etc/hosts you should change controller in /etc/nova/nova.conf in [database] enter the right ip for database

edit flag offensive delete link more


i did that but nothing changed

najeh gravatar imagenajeh ( 2018-11-15 05:51:10 -0600 )edit

can you access mysql by

mysql -u keystone -h management _ip -p

yasin lachiny gravatar imageyasin lachiny ( 2018-11-15 08:11:02 -0600 )edit

yes i can access using that command

najeh gravatar imagenajeh ( 2018-11-15 08:23:54 -0600 )edit

so your mysql is fine in mysql write show databases do you see nova?

yasin lachiny gravatar imageyasin lachiny ( 2018-11-15 08:42:21 -0600 )edit

do you set priviledges for nova?

yasin lachiny gravatar imageyasin lachiny ( 2018-11-15 08:42:55 -0600 )edit

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2018-11-15 05:25:20 -0600

Seen: 1,090 times

Last updated: Dec 22 '18