<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><br></div><div>Thanks,</div></div><div class="gmail_extra">
<br clear="all"><div><div dir="ltr"><span style="font-family:arial,sans-serif;font-size:16px"><strong>Steve Dainard </strong></span><span style="font-size:12px"></span><br>
<span style="font-family:arial,sans-serif;font-size:12px">IT Infrastructure Manager<br>
<a href="http://miovision.com/" target="_blank">Miovision</a> | <em>Rethink Traffic</em><br>
519-513-2407 ex.250<br>
877-646-8476 (toll-free)<br>
<br>
<strong style="font-family:arial,sans-serif;font-size:13px;color:#999999"><a href="http://miovision.com/blog" target="_blank">Blog</a> | </strong><font color="#999999" style="font-family:arial,sans-serif;font-size:13px"><strong><a href="https://www.linkedin.com/company/miovision-technologies" target="_blank">LinkedIn</a> | <a href="https://twitter.com/miovision" target="_blank">Twitter</a> | <a href="https://www.facebook.com/miovision" target="_blank">Facebook</a></strong></font> </span>
<hr style="font-family:arial,sans-serif;font-size:13px;color:#333333;clear:both">
<div style="color:#999999;font-family:arial,sans-serif;font-size:13px;padding-top:5px">
<span style="font-family:arial,sans-serif;font-size:12px">Miovision Technologies Inc. | 148 Manitou Drive, Suite 101, Kitchener, ON, Canada | N2C 1L3</span><br>
<span style="font-family:arial,sans-serif;font-size:12px">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.</span></div>
</div></div>
<br><br><div class="gmail_quote">On Wed, Jan 29, 2014 at 7:06 PM, Alon Bar-Lev <span dir="ltr"><<a href="mailto:alonbl@redhat.com" target="_blank">alonbl@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im"><br>
<br>
----- Original Message -----<br>
> From: "Steve Dainard" <<a href="mailto:sdainard@miovision.com">sdainard@miovision.com</a>><br>
> To: "users" <<a href="mailto:users@ovirt.org">users@ovirt.org</a>><br>
> Sent: Thursday, January 30, 2014 1:59:08 AM<br>
> Subject: [Users] engine-backup restore how to<br>
><br>
> There doesn't seem to be any solid documentation on how to use the<br>
> engine-backup restore function, and I'm not able to restore a backup.<br>
><br>
> The best I've come up with is:<br>
> 1. Install engine on new host<br>
> 2. Stop engine<br>
> 3. run engine-backup --mode=restore --file=filename --log=logfile<br>
><br>
> Fail.<br>
><br>
> Log shows:<br>
> psql: FATAL: password authentication failed for user "engine"<br>
> 2014-01-29 18:20:30 10285: FATAL: Can't connect to the database<br>
><br>
> 4. engine-backup --mode=restore --file=engine.bak --log=logfile<br>
> --change-db-credentials --db-host=localhost --db-user=engine<br>
> --db-name=engine --db-password='newpassword'<br>
><br>
> Fails with same error.<br>
<br>
</div>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.<br>
<div class="im"><br>
><br>
> 5. change user to postgres, drop the old db, create a new db named engine,<br>
> set password for engine user same as 'newpassword'<br>
><br>
> 6. engine-backup --mode=restore --file=engine.bak --log=logfile<br>
> --change-db-credentials --db-host=localhost --db-user=engine<br>
> --db-name=engine --db-password='newpassword'<br>
<br>
</div>Ok, this is correct now.<br>
<div><div class="h5"><br>
> Restoring...<br>
> Rewriting /etc/ovirt-engine/engine.conf.d/10-setup-database.conf<br>
> Note: you might need to manually fix:<br>
> - iptables/firewalld configuration<br>
> - autostart of ovirt-engine service<br>
> You can now start the engine service and then restart httpd<br>
> Done.<br>
><br>
> 7. start ovirt-engine, restart httpd, browse to web ui<br>
><br>
> Blank page, no content.<br>
><br>
> 8. stop firewall, browse to web ui<br>
><br>
> Blank page, no content<br>
><br>
> 9. Engine log contains:<br>
><br>
> 2014-01-29 18:35:56,973 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC<br>
> service<br>
> thread 1-40) Value of property "SENSITIVE_KEYS" is<br>
> ",ENGINE_DB_PASSWORD,ENGINE_PKI_TR<br>
> UST_STORE_PASSWORD,ENGINE_PKI_ENGINE_STORE_PASSWORD".<br>
> 2014-01-29 18:35:57,330 ERROR [org.ovirt.engine.core.bll.Backend] (MSC<br>
> service thread<br>
> 1-25) Error in getting DB connection. The database is inaccessible. Original<br>
> exception is: BadSqlGrammarException: CallableStatementCallback; bad SQL<br>
> grammar [{call checkdbconnection()}]; nested exception is<br>
> org.postgresql.util.PSQLException: ERROR: function checkdbconnection() does<br>
> not exist<br>
> Hint: No function matches the given name and argument types. You might need<br>
> to add explicit type casts.<br>
> Position: 15<br>
> 2014-01-29 18:35:58,336 ERROR [org.ovirt.engine.core.bll.Backend] (MSC<br>
> service thread 1-25) Error in getting DB connection. The database is<br>
> inaccessible. Original exception is: UncategorizedSQLException:<br>
> CallableStatementCallback; uncategorized SQLException for SQL [{call<br>
> checkdbconnection()}]; SQL state [25P02]; error code [0]; ERROR: current<br>
> transaction is aborted, commands ignored until end of transaction block;<br>
> nested exception is org.postgresql.util.PSQLException: ERROR: current<br>
> transaction is aborted, commands ignored until end of transaction block<br>
><br>
<br>
</div></div>It looks like the database is empty... are you sure the engine.bak is intact? does you see CheckDBConnection there?<br>
<br>
Thanks,<br>
Alon<br>
</blockquote></div><br></div>