<div dir="ltr">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.<div><br></div><div>The best I've come up with is:</div><div>
1. Install engine on new host</div><div>2. Stop engine</div><div>3. run engine-backup --mode=restore --file=filename --log=logfile</div><div><br></div><div>Fail.</div><div><br></div><div>Log shows:</div><div><div>psql: FATAL: password authentication failed for user "engine"</div>
<div>2014-01-29 18:20:30 10285: FATAL: Can't connect to the database</div><div><br></div><div>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'</div>
<div><br></div><div>Fails with same error.</div><div><br></div><div>5. change user to postgres, drop the old db, create a new db named engine, set password for engine user same as 'newpassword'</div><div><br></div>
<div>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'</div><div><br></div><div><div>Restoring...</div>
<div>Rewriting /etc/ovirt-engine/engine.conf.d/10-setup-database.conf</div><div>Note: you might need to manually fix:</div><div>- iptables/firewalld configuration</div><div>- autostart of ovirt-engine service</div><div>You can now start the engine service and then restart httpd</div>
<div>Done.</div></div><div><br></div><div>7. start ovirt-engine, restart httpd, browse to web ui</div><div><br></div><div>Blank page, no content.</div><div><br></div><div>8. stop firewall, browse to web ui</div><div><br></div>
<div>Blank page, no content</div><div><br></div><div>9. Engine log contains:</div><div><br></div><div><div>2014-01-29 18:35:56,973 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service </div><div>thread 1-40) Value of property "SENSITIVE_KEYS" is ",ENGINE_DB_PASSWORD,ENGINE_PKI_TR</div>
<div>UST_STORE_PASSWORD,ENGINE_PKI_ENGINE_STORE_PASSWORD".</div><div>2014-01-29 18:35:57,330 ERROR [org.ovirt.engine.core.bll.Backend] (MSC service thread</div><div> 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</div>
<div> Hint: No function matches the given name and argument types. You might need to add explicit type casts.</div><div> Position: 15</div><div>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</div>
</div><div><br></div><div><br></div><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:rgb(153,153,153)"><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:rgb(51,51,51);clear:both">
<div style="color:rgb(153,153,153);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>
</div></div>