I also see this error in engine.log which repeats every second if I am trying to access the web ui.
2014-01-29 18:59:47,531 ERROR [org.ovirt.engine.core.bll.Backend] (ajp--127.0.0.1-8702-4) 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 db inserted correctly, I took a quick look through some tables and can see the valid admin user, and snapshots. But I can't say for certain. The IP address of the new server does not match the IP of the old (backup file) server, would this have any impact? I would think not as its a local db. When I changed the password for the psql engine user, is there any config file this is referenced in that may not have been updated? Thanks, *Steve Dainard * IT Infrastructure Manager Miovision <http://miovision.com/> | *Rethink Traffic* 519-513-2407 ex.250 877-646-8476 (toll-free) *Blog <http://miovision.com/blog> | **LinkedIn <https://www.linkedin.com/company/miovision-technologies> | Twitter <https://twitter.com/miovision> | Facebook <https://www.facebook.com/miovision>* ------------------------------ Miovision Technologies Inc. | 148 Manitou Drive, Suite 101, Kitchener, ON, Canada | N2C 1L3 This e-mail may contain information that is privileged or confidential. If you are not the intended recipient, please delete the e-mail and any attachments and notify us immediately. On Wed, Jan 29, 2014 at 7:06 PM, Alon Bar-Lev <alo...@redhat.com> wrote: > > > ----- 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