Ask Your Question
0

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: http://sqlalche.me/e/e3q8)

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

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

novainfinite 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

Comments

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

novainfinite gravatar imagenovainfinite ( 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
1

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

novainfinite gravatar imagenovainfinite ( 2018-11-15 08:42:21 -0600 )edit

do you set priviledges for nova?

novainfinite gravatar imagenovainfinite ( 2018-11-15 08:42:55 -0600 )edit
0

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

updated 2018-11-19 09:08:34 -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 (http://192.168.2.119:8778), 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

If your not familiar with database queries install and use phpmysql and change endpoints tables in keystone database(https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-16-04).

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

edit flag offensive delete link more

Comments

i did all of that but i still have the error

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

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

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

Seen: 69 times

Last updated: Nov 19