<div dir="ltr">I can connect to the db with the 'engine' user.<div><br></div><div>Initially 'engine' wasn't a member of any roles, I added it to 'postgres'.</div><div><div>engine=> \du</div><div>
List of roles</div><div> Role name | Attributes | Member of </div><div>-----------+-------------+------------</div><div> engine | | {postgres}</div><div> postgres | Superuser | {}</div><div>
: Create role </div><div> : Create DB </div></div><div><br></div><div>If you meant file permissions they are:</div><div># ll</div><div>total 24</div><div>-rw-------. 1 ovirt ovirt 380 Jan 29 18:35 10-setup-database.conf</div>
<div>-rw-------. 1 ovirt ovirt 378 Jan 15 15:58 10-setup-database.conf.20140129183539</div><div>-rw-r--r--. 1 root root 33 Jan 15 15:58 10-setup-jboss.conf</div><div>-rw-------. 1 ovirt ovirt 384 Jan 15 15:59 10-setup-pki.conf</div>
<div>-rw-r--r--. 1 root root 259 Jan 15 15:58 10-setup-protocols.conf</div><div>-rw-r--r--. 1 root root 204 Dec 13 03:22 README</div><div><br></div><div><br></div><div>On ovirt-engine restart (engine.log):</div><div>i</div>
<div><div>2014-01-30 10:24:18,988 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Loaded file "/usr/share/ovirt-engine/services/ovirt-engine/ovirt-engine.conf".</div><div>2014-01-30 10:24:18,990 WARN [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) The file "/etc/ovirt-engine/engine.conf" doesn't exist or isn't readable. Will return an empty set of properties.</div>
<div>2014-01-30 10:24:18,991 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Loaded file "/etc/ovirt-engine/engine.conf.d/10-setup-database.conf".</div><div>2014-01-30 10:24:18,992 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Loaded file "/etc/ovirt-engine/engine.conf.d/10-setup-jboss.conf".</div>
<div>2014-01-30 10:24:18,994 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Loaded file "/etc/ovirt-engine/engine.conf.d/10-setup-pki.conf".</div><div>2014-01-30 10:24:18,994 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Loaded file "/etc/ovirt-engine/engine.conf.d/10-setup-protocols.conf".</div>
<div>2014-01-30 10:24:18,995 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_AJP_ENABLED" is "true".</div><div>2014-01-30 10:24:18,996 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_AJP_PORT" is "8702".</div>
<div>2014-01-30 10:24:18,997 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_APPS" is "engine.ear".</div><div>2014-01-30 10:24:18,997 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_CACHE" is "/var/cache/ovirt-engine".</div>
<div>2014-01-30 10:24:18,998 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DB_CHECK_INTERVAL" is "1000".</div><div>2014-01-30 10:24:18,998 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DB_CONNECTION_TIMEOUT" is "300000".</div>
<div>2014-01-30 10:24:18,999 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DB_DATABASE" is "engine".</div><div>2014-01-30 10:24:19,000 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DB_DRIVER" is "org.postgresql.Driver".</div>
<div>2014-01-30 10:24:19,000 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DB_HOST" is "localhost".</div><div>2014-01-30 10:24:19,001 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DB_MAX_CONNECTIONS" is "100".</div>
<div>2014-01-30 10:24:19,001 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DB_MIN_CONNECTIONS" is "1".</div><div>2014-01-30 10:24:19,002 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DB_PASSWORD" is "***".</div>
<div>2014-01-30 10:24:19,002 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DB_PORT" is "5432".</div><div>2014-01-30 10:24:19,003 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DB_SECURED" is "False".</div>
<div>2014-01-30 10:24:19,004 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DB_SECURED_VALIDATION" is "False".</div><div>2014-01-30 10:24:19,004 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DB_SSL" is "false".</div>
<div>2014-01-30 10:24:19,005 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DB_URL" is "jdbc:postgresql://localhost:5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory".</div>
<div>2014-01-30 10:24:19,006 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DB_USER" is "engine".</div><div>2014-01-30 10:24:19,006 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DEBUG_ADDRESS" is "".</div>
<div>2014-01-30 10:24:19,007 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DOC" is "/usr/share/doc/ovirt-engine".</div><div>2014-01-30 10:24:19,008 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_ETC" is "/etc/ovirt-engine".</div>
<div>2014-01-30 10:24:19,008 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_FQDN" is "ovirt001.miovision.corp".</div><div>2014-01-30 10:24:19,009 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_GROUP" is "ovirt".</div>
<div>2014-01-30 10:24:19,009 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_HEAP_MAX" is "1g".</div><div>2014-01-30 10:24:19,010 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_HEAP_MIN" is "1g".</div>
<div>2014-01-30 10:24:19,010 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_HTTPS_ENABLED" is "false".</div><div>2014-01-30 10:24:19,011 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_HTTPS_PORT" is "None".</div>
<div>2014-01-30 10:24:19,011 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_HTTPS_PROTOCOLS" is "SSLv3,TLSv1,TLSv1.1,TLSv1.2".</div><div>2014-01-30 10:24:19,012 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_HTTP_ENABLED" is "false".</div>
<div>2014-01-30 10:24:19,013 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_HTTP_PORT" is "None".</div><div>2014-01-30 10:24:19,013 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_JVM_ARGS" is " -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath="/var/log/ovirt-engine/dump"".</div>
<div>2014-01-30 10:24:19,014 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_LOG" is "/var/log/ovirt-engine".</div><div>2014-01-30 10:24:19,014 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_LOG_TO_CONSOLE" is "false".</div>
<div>2014-01-30 10:24:19,015 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_MANUAL" is "/usr/share/ovirt-engine/manual".</div><div>2014-01-30 10:24:19,016 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_PERM_MAX" is "256m".</div>
<div>2014-01-30 10:24:19,016 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_PERM_MIN" is "256m".</div><div>2014-01-30 10:24:19,017 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_PKI" is "/etc/pki/ovirt-engine".</div>
<div>2014-01-30 10:24:19,017 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_PKI_CA" is "/etc/pki/ovirt-engine/ca.pem".</div><div>2014-01-30 10:24:19,018 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_PKI_ENGINE_CERT" is "/etc/pki/ovirt-engine/certs/engine.cer".</div>
<div>2014-01-30 10:24:19,018 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_PKI_ENGINE_STORE" is "/etc/pki/ovirt-engine/keys/engine.p12".</div><div>
2014-01-30 10:24:19,019 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_PKI_ENGINE_STORE_ALIAS" is "1".</div><div>2014-01-30 10:24:19,019 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_PKI_ENGINE_STORE_PASSWORD" is "***".</div>
<div>2014-01-30 10:24:19,020 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_PKI_TRUST_STORE" is "/etc/pki/ovirt-engine/.truststore".</div><div>2014-01-30 10:24:19,021 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_PKI_TRUST_STORE_PASSWORD" is "***".</div>
<div>2014-01-30 10:24:19,021 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_PROPERTIES" is " jsse.enableSNIExtension=false".</div><div>2014-01-30 10:24:19,022 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_PROXY_ENABLED" is "true".</div>
<div>2014-01-30 10:24:19,022 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_PROXY_HTTPS_PORT" is "443".</div><div>2014-01-30 10:24:19,023 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_PROXY_HTTP_PORT" is "80".</div>
<div>2014-01-30 10:24:19,023 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_STOP_INTERVAL" is "1".</div><div>2014-01-30 10:24:19,024 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_STOP_TIME" is "10".</div>
<div>2014-01-30 10:24:19,024 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_TMP" is "/var/tmp/ovirt-engine".</div><div>2014-01-30 10:24:19,024 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_UP_MARK" is "/var/lib/ovirt-engine/engine.up".</div>
<div>2014-01-30 10:24:19,025 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_USER" is "ovirt".</div><div>2014-01-30 10:24:19,025 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_USR" is "/usr/share/ovirt-engine".</div>
<div>2014-01-30 10:24:19,026 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_VAR" is "/var/lib/ovirt-engine".</div><div>2014-01-30 10:24:19,026 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_VERBOSE_GC" is "false".</div>
<div>2014-01-30 10:24:19,027 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "JBOSS_HOME" is "/usr/share/jboss-as".</div><div>2014-01-30 10:24:19,027 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "SENSITIVE_KEYS" is ",ENGINE_DB_PASSWORD,ENGINE_PKI_TRUST_STORE_PASSWORD,ENGINE_PKI_ENGINE_STORE_PASSWORD".</div>
<div>2014-01-30 10:24:19,391 ERROR [org.ovirt.engine.core.bll.Backend] (MSC service thread 1-2) 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-30 10:24:20,398 ERROR [org.ovirt.engine.core.bll.Backend] (MSC service thread 1-2) 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>[last error repeats]</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 Thu, Jan 30, 2014 at 2:18 AM, Yedidyah Bar David <span dir="ltr"><<a href="mailto:didi@redhat.com" target="_blank">didi@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><div style="font-size:12pt;font-family:times new roman,new york,times,serif"><div></div><blockquote style="padding-left:5px;font-size:12pt;font-style:normal;margin-left:5px;font-family:Helvetica,Arial,sans-serif;text-decoration:none;font-weight:normal;border-left:2px solid #1010ff">
<b>From: </b>"Steve Dainard" <<a href="mailto:sdainard@miovision.com" target="_blank">sdainard@miovision.com</a>><br><b>To: </b>"Alon Bar-Lev" <<a href="mailto:alonbl@redhat.com" target="_blank">alonbl@redhat.com</a>><br>
<b>Cc: </b>"users" <<a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a>>, "Yedidyah Bar David" <<a href="mailto:didi@redhat.com" target="_blank">didi@redhat.com</a>>, "Eli Mesika" <<a href="mailto:emesika@redhat.com" target="_blank">emesika@redhat.com</a>><br>
<b>Sent: </b>Thursday, January 30, 2014 7:44:01 AM<br><b>Subject: </b>Re: [Users] engine-backup restore how to<div class="im"><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></div></blockquote><div><br></div><div>In principle, the only needed file is <span 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">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">using the credentials in this file? What are its permissions/owner?</span></div>
<div><span style="font-family:Helvetica,Arial,sans-serif"><br></span></div><div><span style="font-family:Helvetica,Arial,sans-serif">Thanks,</span></div><span class="HOEnZb"><font color="#888888"><div>-- <br></div><div><span name="x"></span>Didi<span name="x"></span><br>
</div><div><br></div></font></span></div></div></blockquote></div><br></div>