How to restore Openstack mysql database and to sync the database?

asked 2017-05-08 04:19:59 -0500

Harsha gravatar image

Hello, I was running Openstack Newton on Ubuntu 16.04. Database is crashed because of some reason, I have mysql dump file now. I restored the mysql dump, but not able to sync mysql db. After restoring I tried to sync db using below commands for all services.

su -s /bin/sh -c "keystone-manage db_sync" keystone

su -s /bin/sh -c "glance-manage db_sync" glance

And same kind of commands for all other services. But I'm getting the error like

sh: 1: keystone-manage: not found

sh: 1: glance-manage: not found

What are the steps to restore, sync and to start all the services.

Please someone help me!!

edit retag flag offensive close merge delete

Comments

Something wrong with your path? Why don't you search your filesystem for keystone-manage.

If the manage commands are missing from your system, I guess that not only your DB crashed.

To start Keystone, run systemctl start apache2. For e.g. nova-api: systemctl start nova-api should do the trick.

Bernd Bausch gravatar imageBernd Bausch ( 2017-05-08 14:07:48 -0500 )edit

Thanks for the reply @Bernd Bausch. I tried restarting apache service, after that I'm getting this error An error occurred authenticating. Please try again later. After starting nova-api, I'm getting Failed to start nova-api.service: Unit nova-api.service is masked. this error, What may be issue

Harsha gravatar imageHarsha ( 2017-05-09 01:52:24 -0500 )edit

I don't know much about systemd; I can google for "unit is masked", but so can you.

an error occurred authenticatingseems to come from the dashboard. Others have had this error; look around on ask.openstack.org.

It seems your system is misconfigured. You need to check appropriate log files.

Bernd Bausch gravatar imageBernd Bausch ( 2017-05-09 05:01:27 -0500 )edit