[Users] engine-backup restore how to

[Yedidyah Bar David]

> From: "Steve Dainard" <sdainard at miovision.com>
> To: "Alon Bar-Lev" <alonbl at redhat.com>
> Cc: "users" <users at ovirt.org>, "Yedidyah Bar David" <didi at redhat.com>, "Eli
> Mesika" <emesika at redhat.com>
> Sent: Thursday, January 30, 2014 7:44:01 AM
> Subject: Re: [Users] engine-backup restore how to

> 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?

In principle, the only needed file is /etc/ovirt-engine/engine.conf.d/10-setup-database.conf 
which was updated by restore. Can you please verify that you can connect to the database 
using the credentials in this file? What are its permissions/owner? 

Thanks, 
-- 
Didi 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20140130/56ac5a75/attachment-0001.html>