<html><body><div style="font-family: times new roman, new york, times, serif; font-size: 12pt; color: #000000"><div></div><blockquote style="border-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>From: </b>"Steve Dainard" <sdainard@miovision.com><br><b>To: </b>"Alon Bar-Lev" <alonbl@redhat.com><br><b>Cc: </b>"users" <users@ovirt.org>, "Yedidyah Bar David" <didi@redhat.com>, "Eli Mesika" <emesika@redhat.com><br><b>Sent: </b>Thursday, January 30, 2014 7:44:01 AM<br><b>Subject: </b>Re: [Users] engine-backup restore how to<br><div><br></div><div dir="ltr">I also see this error in engine.log which repeats every second if I am trying to access the web ui.<div><br></div><div>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</div><div><br></div><div>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.</div><div><br></div><div>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.</div><div><br></div><div>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?</div></div></blockquote><div><br></div><div>In principle, the only needed file is <span style="font-family: Helvetica, Arial, sans-serif;" data-mce-style="font-family: Helvetica, Arial, sans-serif;">/etc/ovirt-engine/engine.conf.d/10-setup-database.conf</span></div><div><span style="font-family: Helvetica, Arial, sans-serif;" data-mce-style="font-family: Helvetica, Arial, sans-serif;">which was updated by restore. Can you please verify that you can connect to the database</span></div><div><span style="font-family: Helvetica, Arial, sans-serif;" data-mce-style="font-family: Helvetica, Arial, sans-serif;">using the credentials in this file? What are its permissions/owner?</span></div><div><span style="font-family: Helvetica, Arial, sans-serif;" data-mce-style="font-family: Helvetica, Arial, sans-serif;"><br></span></div><div><span style="font-family: Helvetica, Arial, sans-serif;" data-mce-style="font-family: Helvetica, Arial, sans-serif;">Thanks,</span></div><div>-- <br></div><div><span name="x"></span>Didi<span name="x"></span><br></div><div><br></div></div></body></html>