----- Original Message ----- > From: "Steve Dainard" <sdain...@miovision.com> > To: "users" <users@ovirt.org> > Sent: Thursday, January 30, 2014 1:59:08 AM > Subject: [Users] engine-backup restore how to > > There doesn't seem to be any solid documentation on how to use the > engine-backup restore function, and I'm not able to restore a backup. > > The best I've come up with is: > 1. Install engine on new host > 2. Stop engine > 3. run engine-backup --mode=restore --file=filename --log=logfile > > Fail. > > Log shows: > psql: FATAL: password authentication failed for user "engine" > 2014-01-29 18:20:30 10285: FATAL: Can't connect to the database > > 4. engine-backup --mode=restore --file=engine.bak --log=logfile > --change-db-credentials --db-host=localhost --db-user=engine > --db-name=engine --db-password='newpassword' > > Fails with same error.
the --db-password must match the user's actual password within database, --change-db-credentials does not change the password in database but the host/port/user/password that are used by enigne. > > 5. change user to postgres, drop the old db, create a new db named engine, > set password for engine user same as 'newpassword' > > 6. engine-backup --mode=restore --file=engine.bak --log=logfile > --change-db-credentials --db-host=localhost --db-user=engine > --db-name=engine --db-password='newpassword' Ok, this is correct now. > Restoring... > Rewriting /etc/ovirt-engine/engine.conf.d/10-setup-database.conf > Note: you might need to manually fix: > - iptables/firewalld configuration > - autostart of ovirt-engine service > You can now start the engine service and then restart httpd > Done. > > 7. start ovirt-engine, restart httpd, browse to web ui > > Blank page, no content. > > 8. stop firewall, browse to web ui > > Blank page, no content > > 9. Engine log contains: > > 2014-01-29 18:35:56,973 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC > service > thread 1-40) Value of property "SENSITIVE_KEYS" is > ",ENGINE_DB_PASSWORD,ENGINE_PKI_TR > UST_STORE_PASSWORD,ENGINE_PKI_ENGINE_STORE_PASSWORD". > 2014-01-29 18:35:57,330 ERROR [org.ovirt.engine.core.bll.Backend] (MSC > service thread > 1-25) Error in getting DB connection. The database is inaccessible. Original > exception is: BadSqlGrammarException: CallableStatementCallback; bad SQL > grammar [{call checkdbconnection()}]; nested exception is > org.postgresql.util.PSQLException: ERROR: function checkdbconnection() does > not exist > Hint: No function matches the given name and argument types. You might need > to add explicit type casts. > Position: 15 > 2014-01-29 18:35:58,336 ERROR [org.ovirt.engine.core.bll.Backend] (MSC > service thread 1-25) Error in getting DB connection. The database is > inaccessible. Original exception is: UncategorizedSQLException: > CallableStatementCallback; uncategorized SQLException for SQL [{call > checkdbconnection()}]; SQL state [25P02]; error code [0]; ERROR: current > transaction is aborted, commands ignored until end of transaction block; > nested exception is org.postgresql.util.PSQLException: ERROR: current > transaction is aborted, commands ignored until end of transaction block > It looks like the database is empty... are you sure the engine.bak is intact? does you see CheckDBConnection there? Thanks, Alon _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users