[Users] engine-backup restore how to

Yedidyah Bar David didi at redhat.com
Thu Jan 30 22:23:42 UTC 2014 

It's supposed to exist, but by default it contains only comments. So the fact that it's missing 
does not in itself cause problems, but might indicate that there are some other problems. 

Sorry for not replying to your previous email - I really don't know how exactly to proceed. 

Some random notes/ideas/questions: 
1. Was the restore done on a new clean system? The same system that the backup was on? Something else? 
2. Was it done with the same version used for backup? Which version? 
3. In case it wasn't obvious: It does not create a database for you or manage postgres in any way. You already know that, just noting. 
4. In general you should run engine-setup after restore. It fixes almost all the things that restore does not do. See [1] for details. The only things it does not do (that I know about) are to enable postgres to start on reboot (which you should do anyway yourself, see previous point) and websocket-proxy. See [2] if you really care. 
5. Another idea: Try to use something simpler than the engine to see if the system can access the database. Not sure if it's easy to find something that does that and does not need the engine - you can try e.g. log-collector. 

[1] http://www.ovirt.org/Migrate_to_Hosted_Engine 
[2] https://bugzilla.redhat.com/1024707 

Good luck, and please report back/ask more if you get any insight! 
-- 
Didi 
----- Original Message -----

> From: "Steve Dainard" <sdainard at miovision.com>
> To: "Yedidyah Bar David" <didi at redhat.com>
> Cc: "Alon Bar-Lev" <alonbl at redhat.com>, "users" <users at ovirt.org>, "Eli
> Mesika" <emesika at redhat.com>
> Sent: Thursday, January 30, 2014 9:04:35 PM
> Subject: Re: [Users] engine-backup restore how to

> 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 | Rethink Traffic
> 519-513-2407 ex.250
> 877-646-8476 (toll-free)

> Blog | LinkedIn | Twitter | Facebook
> 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 | Rethink Traffic
> 
> > 519-513-2407 ex.250
> 
> > 877-646-8476 (toll-free)
> 

> > Blog | LinkedIn | Twitter | Facebook
> 
> > 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
> > 
> 

-- 
Didi 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20140130/aa1948fa/attachment-0001.html>

More information about the Users mailing list