[Users] engine-backup restore how to
Steve Dainard
sdainard at miovision.com
Thu Jan 30 19:04:35 UTC 2014
Is this file supposed to exist:
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.
I can't find it anywhere on the system.
*Steve Dainard *
IT Infrastructure Manager
Miovision <http://miovision.com/> | *Rethink Traffic*
519-513-2407 ex.250
877-646-8476 (toll-free)
*Blog <http://miovision.com/blog> | **LinkedIn
<https://www.linkedin.com/company/miovision-technologies> | Twitter
<https://twitter.com/miovision> | Facebook
<https://www.facebook.com/miovision>*
------------------------------
Miovision Technologies Inc. | 148 Manitou Drive, Suite 101, Kitchener, ON,
Canada | N2C 1L3
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.
On Thu, Jan 30, 2014 at 10:32 AM, Steve Dainard <sdainard at miovision.com>wrote:
> I can connect to the db with the 'engine' user.
>
> Initially 'engine' wasn't a member of any roles, I added it to 'postgres'.
> engine=> \du
> List of roles
> Role name | Attributes | Member of
> -----------+-------------+------------
> engine | | {postgres}
> postgres | Superuser | {}
> : Create role
> : Create DB
>
> If you meant file permissions they are:
> # ll
> total 24
> -rw-------. 1 ovirt ovirt 380 Jan 29 18:35 10-setup-database.conf
> -rw-------. 1 ovirt ovirt 378 Jan 15 15:58
> 10-setup-database.conf.20140129183539
> -rw-r--r--. 1 root root 33 Jan 15 15:58 10-setup-jboss.conf
> -rw-------. 1 ovirt ovirt 384 Jan 15 15:59 10-setup-pki.conf
> -rw-r--r--. 1 root root 259 Jan 15 15:58 10-setup-protocols.conf
> -rw-r--r--. 1 root root 204 Dec 13 03:22 README
>
>
> On ovirt-engine restart (engine.log):
> i
> 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".
> 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.
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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 "***".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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 "".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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"".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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 "***".
> 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".
> 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 "***".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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".
> 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
> Hint: No function matches the given name and argument types. You might
> need to add explicit type casts.
> Position: 15
> 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
> [last error repeats]
>
> Thanks,
>
> *Steve Dainard *
> IT Infrastructure Manager
> Miovision <http://miovision.com/> | *Rethink Traffic*
> 519-513-2407 ex.250
> 877-646-8476 (toll-free)
>
> *Blog <http://miovision.com/blog> | **LinkedIn
> <https://www.linkedin.com/company/miovision-technologies> | Twitter
> <https://twitter.com/miovision> | Facebook
> <https://www.facebook.com/miovision>*
> ------------------------------
> Miovision Technologies Inc. | 148 Manitou Drive, Suite 101, Kitchener,
> ON, Canada | N2C 1L3
> 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.
>
>
> On Thu, Jan 30, 2014 at 2:18 AM, Yedidyah Bar David <didi at redhat.com>wrote:
>
>> *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/6a31cd77/attachment-0001.html>
More information about the Users
mailing list