[Users] engine-backup restore how to
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. The best I've come up with is: 1. Install engine on new host 2. Stop engine 3. run engine-backup --mode=restore --file=filename --log=logfile Fail. Log shows: psql: FATAL: password authentication failed for user "engine" 2014-01-29 18:20:30 10285: FATAL: Can't connect to the database 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' Fails with same error. 5. change user to postgres, drop the old db, create a new db named engine, set password for engine user same as 'newpassword' 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' Restoring... Rewriting /etc/ovirt-engine/engine.conf.d/10-setup-database.conf Note: you might need to manually fix: - iptables/firewalld configuration - autostart of ovirt-engine service You can now start the engine service and then restart httpd Done. 7. start ovirt-engine, restart httpd, browse to web ui Blank page, no content. 8. stop firewall, browse to web ui Blank page, no content 9. Engine log contains: 2014-01-29 18:35:56,973 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-40) Value of property "SENSITIVE_KEYS" is ",ENGINE_DB_PASSWORD,ENGINE_PKI_TR UST_STORE_PASSWORD,ENGINE_PKI_ENGINE_STORE_PASSWORD". 2014-01-29 18:35:57,330 ERROR [org.ovirt.engine.core.bll.Backend] (MSC service thread 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 Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 15 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 *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.
----- Original Message -----
From: "Steve Dainard" <sdainard@miovision.com> To: "users" <users@ovirt.org> Sent: Thursday, January 30, 2014 1:59:08 AM Subject: [Users] engine-backup restore how to
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.
The best I've come up with is: 1. Install engine on new host 2. Stop engine 3. run engine-backup --mode=restore --file=filename --log=logfile
Fail.
Log shows: psql: FATAL: password authentication failed for user "engine" 2014-01-29 18:20:30 10285: FATAL: Can't connect to the database
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'
Fails with same error.
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.
5. change user to postgres, drop the old db, create a new db named engine, set password for engine user same as 'newpassword'
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'
Ok, this is correct now.
Restoring... Rewriting /etc/ovirt-engine/engine.conf.d/10-setup-database.conf Note: you might need to manually fix: - iptables/firewalld configuration - autostart of ovirt-engine service You can now start the engine service and then restart httpd Done.
7. start ovirt-engine, restart httpd, browse to web ui
Blank page, no content.
8. stop firewall, browse to web ui
Blank page, no content
9. Engine log contains:
2014-01-29 18:35:56,973 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-40) Value of property "SENSITIVE_KEYS" is ",ENGINE_DB_PASSWORD,ENGINE_PKI_TR UST_STORE_PASSWORD,ENGINE_PKI_ENGINE_STORE_PASSWORD". 2014-01-29 18:35:57,330 ERROR [org.ovirt.engine.core.bll.Backend] (MSC service thread 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 Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 15 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
It looks like the database is empty... are you sure the engine.bak is intact? does you see CheckDBConnection there? Thanks, Alon
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? 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 Wed, Jan 29, 2014 at 7:06 PM, Alon Bar-Lev <alonbl@redhat.com> wrote:
----- Original Message -----
From: "Steve Dainard" <sdainard@miovision.com> To: "users" <users@ovirt.org> Sent: Thursday, January 30, 2014 1:59:08 AM Subject: [Users] engine-backup restore how to
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.
The best I've come up with is: 1. Install engine on new host 2. Stop engine 3. run engine-backup --mode=restore --file=filename --log=logfile
Fail.
Log shows: psql: FATAL: password authentication failed for user "engine" 2014-01-29 18:20:30 10285: FATAL: Can't connect to the database
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'
Fails with same error.
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.
5. change user to postgres, drop the old db, create a new db named
engine,
set password for engine user same as 'newpassword'
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'
Ok, this is correct now.
Restoring... Rewriting /etc/ovirt-engine/engine.conf.d/10-setup-database.conf Note: you might need to manually fix: - iptables/firewalld configuration - autostart of ovirt-engine service You can now start the engine service and then restart httpd Done.
7. start ovirt-engine, restart httpd, browse to web ui
Blank page, no content.
8. stop firewall, browse to web ui
Blank page, no content
9. Engine log contains:
2014-01-29 18:35:56,973 INFO [org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-40) Value of property "SENSITIVE_KEYS" is ",ENGINE_DB_PASSWORD,ENGINE_PKI_TR UST_STORE_PASSWORD,ENGINE_PKI_ENGINE_STORE_PASSWORD". 2014-01-29 18:35:57,330 ERROR [org.ovirt.engine.core.bll.Backend] (MSC service thread 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 Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 15 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
It looks like the database is empty... are you sure the engine.bak is intact? does you see CheckDBConnection there?
Thanks, Alon
------=_Part_11276357_1295995532.1391066312043 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit
From: "Steve Dainard" <sdainard@miovision.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "users" <users@ovirt.org>, "Yedidyah Bar David" <didi@redhat.com>, "Eli Mesika" <emesika@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?
<b>Cc: </b>"users" <users@ovirt.org>, "Yedidyah Bar David" <didi@= redhat.com>, "Eli Mesika" <emesika@redhat.com><br><b>Sent: </b>Thu= rsday, January 30, 2014 7:44:01 AM<br><b>Subject: </b>Re: [Users] engine-ba= ckup restore how to<br><div><br></div><div dir=3D"ltr">I also see this erro= r 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.cor= e.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 check= dbconnection()}]; SQL state [25P02]; error code [0]; ERROR: current transac= tion is aborted, commands ignored until end of transaction block; nested ex= ception is org.postgresql.util.PSQLException: ERROR: current transaction is= aborted, commands ignored until end of transaction block</div><div><br></d= iv><div>It looks like the db inserted correctly, I took a quick look throug= h 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 t= his is referenced in that may not have been updated?</div></div></blockquot= e><div><br></div><div>In principle, the only needed file is <span styl= e=3D"font-family: Helvetica, Arial, sans-serif;" data-mce-style=3D"font-fam= ily: Helvetica, Arial, sans-serif;">/etc/ovirt-engine/engine.conf.d/10-setu=
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 ------=_Part_11276357_1295995532.1391066312043 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html><body><div style=3D"font-family: times new roman, new york, times, se= rif; font-size: 12pt; color: #000000"><div></div><blockquote style=3D"borde= r-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-w= eight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,A= rial,sans-serif;font-size:12pt;"><b>From: </b>"Steve Dainard" <sdainard@= miovision.com><br><b>To: </b>"Alon Bar-Lev" <alonbl@redhat.com><br= p-database.conf</span></div><div><span style=3D"font-family: Helvetica, Ari= al, sans-serif;" data-mce-style=3D"font-family: Helvetica, Arial, sans-seri= f;">which was updated by restore. Can you please verify that you can connec= t to the database</span></div><div><span style=3D"font-family: Helvetica, A= rial, sans-serif;" data-mce-style=3D"font-family: Helvetica, Arial, sans-se= rif;">using the credentials in this file? What are its permissions/owner?</= span></div><div><span style=3D"font-family: Helvetica, Arial, sans-serif;" = data-mce-style=3D"font-family: Helvetica, Arial, sans-serif;"><br></span></= div><div><span style=3D"font-family: Helvetica, Arial, sans-serif;" data-mc= e-style=3D"font-family: Helvetica, Arial, sans-serif;">Thanks,</span></div>= <div>-- <br></div><div><span name=3D"x"></span>Didi<span name=3D"x"></span>= <br></div><div><br></div></div></body></html> ------=_Part_11276357_1295995532.1391066312043--
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@redhat.com> wrote:
*From: *"Steve Dainard" <sdainard@miovision.com> *To: *"Alon Bar-Lev" <alonbl@redhat.com> *Cc: *"users" <users@ovirt.org>, "Yedidyah Bar David" <didi@redhat.com>, "Eli Mesika" <emesika@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
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@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@redhat.com>wrote:
*From: *"Steve Dainard" <sdainard@miovision.com> *To: *"Alon Bar-Lev" <alonbl@redhat.com> *Cc: *"users" <users@ovirt.org>, "Yedidyah Bar David" <didi@redhat.com>, "Eli Mesika" <emesika@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
------=_Part_11956419_636007185.1391120622799 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit 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@miovision.com> To: "Yedidyah Bar David" <didi@redhat.com> Cc: "Alon Bar-Lev" <alonbl@redhat.com>, "users" <users@ovirt.org>, "Eli Mesika" <emesika@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@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@redhat.com > wrote:
From: "Steve Dainard" < sdainard@miovision.com >
To: "Alon Bar-Lev" < alonbl@redhat.com >
Cc: "users" < users@ovirt.org >, "Yedidyah Bar David" < didi@redhat.com
, "Eli Mesika" < emesika@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
<div>Some random notes/ideas/questions:</div><div>1. Was the restore done = on a new clean system? The same system that the backup was on? Something el= se?</div><div>2. Was it done with the same version used for backup? Which v= ersion?</div><div>3. In case it wasn't obvious: It does not create a databa= se for you or manage postgres in any way. You already know that, just notin= g.</div><div>4. In general you should run engine-setup after restore. It fi= xes almost all the things that restore does not do. See [1] for details. Th= e 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) a= nd websocket-proxy. See [2] if you really care.</div><div>5. Another idea: = Try to use something simpler than the engine to see if the system can acces= s 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.</div><div><br></=
http://www.ovirt.org/Migrate_to_Hosted_Engine</a><a href=3D"http://www.ovi= rt.org/Migrate_to_Hosted_Engine" data-mce-href=3D"http://www.ovirt.org/Migr= ate_to_Hosted_Engine"></a></div><div>[2] <a href=3D"https://bugzilla.r= edhat.com/show_bug.cgi?id=3D1024707" data-mce-href=3D"https://bugzilla.redh= at.com/show_bug.cgi?id=3D1024707">https://bugzilla.redhat.com/1024707</a></=
<a href=3D"http://miovision.com/blog" target=3D"_blank">Blog</a> | &= nbsp;</strong><span color=3D"#999999" data-mce-style=3D"font-family: arial,= sans-serif; font-size: 13px; color: #999999;" style=3D"font-family: arial,= sans-serif; font-size: 13px; color: #999999;"><strong><a href=3D"https://w= ww.linkedin.com/company/miovision-technologies" target=3D"_blank">LinkedIn<= /a> | <a href=3D"https://twitter.com/miovision" target=3D"= _blank">Twitter</a> | <a href=3D"https://www.facebook.com/= miovision" target=3D"_blank">Facebook</a></strong></span> </span> <hr style=3D"font-family:arial,sans-serif;font-size:13px;color:#333333;clea= r:both"> <div style=3D"color:#999999;font-family:arial,sans-serif;font-size:13px;pad= ding-top:5px"> =09<span style=3D"font-family:arial,sans-serif;font-size:12px">Miovision Te= chnologies Inc. | 148 Manitou Drive, Suite 101, Kitchener, ON, Canada |&nbs=
-- Didi ------=_Part_11956419_636007185.1391120622799 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html><body><div style=3D"font-family: times new roman, new york, times, se= rif; font-size: 12pt; color: #000000"><div>It's supposed to exist, but by d= efault it contains only comments. So the fact that it's missing</div><div>d= oes not in itself cause problems, but might indicate that there are some ot= her problems.</div><div><br></div><div>Sorry for not replying to your previ= ous email - I really don't know how exactly to proceed.</div><div><br></div= div><div>[1] <a href=3D"http://www.ovirt.org/Migrate_to_Hosted_Engine"= div><div><br></div><div>Good luck, and please report back/ask more if you g= et any insight!</div><div>-- </div><div>Didi</div><hr id=3D"zwchr"><bl= ockquote style=3D"border-left:2px solid #1010FF;margin-left:5px;padding-lef= t:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;= font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>From: </b>"Steve= Dainard" <sdainard@miovision.com><br><b>To: </b>"Yedidyah Bar David"= <didi@redhat.com><br><b>Cc: </b>"Alon Bar-Lev" <alonbl@redhat.com= >, "users" <users@ovirt.org>, "Eli Mesika" <emesika@redhat.com&= gt;<br><b>Sent: </b>Thursday, January 30, 2014 9:04:35 PM<br><b>Subject: </= b>Re: [Users] engine-backup restore how to<br><div><br></div><div dir=3D"lt= r">Is this file supposed to exist:<div><span style=3D"font-family:arial,san= s-serif;font-size:13px">2014-01-30 10:24:18,990 WARN [org.ovirt.engin= e.core.utils.</span><span style=3D"font-family:arial,sans-serif;font-size:1= 3px">LocalConfig] (MSC service thread 1-23) The file "/etc/ovirt-engine/eng= ine.</span><span style=3D"font-family:arial,sans-serif;font-size:13px">conf= " doesn't exist or isn't readable. Will return an empty set of properties.<= /span><br> </div><div><span style=3D"font-family:arial,sans-serif;font-size:13px"><br>= </span></div><div><span style=3D"font-family:arial,sans-serif;font-size:13p= x">I can't find it anywhere on the system.</span></div></div><div class=3D"= gmail_extra"> <br clear=3D"all"><div><div dir=3D"ltr"><span style=3D"font-family:arial,sa= ns-serif;font-size:16px"><strong>Steve Dainard </strong></span><s= pan style=3D"font-size:12px"></span><br> <span style=3D"font-family:arial,sans-serif;font-size:12px">IT Infrastructu= re Manager<br> <a href=3D"http://miovision.com/" target=3D"_blank">Miovision</a> | <em>Ret= hink Traffic</em><br> 519-513-2407 ex.250<br> 877-646-8476 (toll-free)<br> <br> <strong style=3D"font-family:arial,sans-serif;font-size:13px;color:#999999"= p;N2C 1L3</span><br> =09<span style=3D"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 no= tify us immediately.</span></div> </div></div> <br><div><br></div><div class=3D"gmail_quote">On Thu, Jan 30, 2014 at 10:32= AM, Steve Dainard <span dir=3D"ltr"><<a href=3D"mailto:sdainard@miovisi= on.com" target=3D"_blank">sdainard@miovision.com</a>></span> wrote:<br><= blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px= #ccc solid;padding-left:1ex"> <div dir=3D"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 'po= stgres'.</div><div><div>engine=3D> \du</div> <div> List of roles</div><div> Rol= e name | Attributes | Member of </div><div>-----------+--------= -----+------------</div><div> engine | &nbs= p; | {postgres}</div><div> postgres | Super= user | {}</div><div> : Create role </div><d= iv> : Create DB = </div></div><div><br></div><div>If you meant file permissions they are:</di= v><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.2014= 0129183539</div><div>-rw-r--r--. 1 root root 33 Jan 15 15:58 1= 0-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-protocol= s.conf</div><div>-rw-r--r--. 1 root root 204 Dec 13 03:22 READM= E</div><div><br></div><div><br></div><div>On ovirt-engine restart (engine.l= og):</div><div> i</div> <div><div>2014-01-30 10:24:18,988 INFO [org.ovirt.engine.core.utils.L= ocalConfig] (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 readab= le. Will return an empty set of properties.</div> <div>2014-01-30 10:24:18,991 INFO [org.ovirt.engine.core.utils.LocalC= onfig] (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 [o= rg.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Loaded fi= le "/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.LocalC= onfig] (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.ov= irt.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.LocalC= onfig] (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.LocalC= onfig] (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_CACH= E" is "/var/cache/ovirt-engine".</div> <div>2014-01-30 10:24:18,998 INFO [org.ovirt.engine.core.utils.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_DB_CHECK_INTERVA= L" is "1000".</div><div>2014-01-30 10:24:18,998 INFO [org.ovirt.engin= e.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGI= NE_DB_CONNECTION_TIMEOUT" is "300000".</div> <div>2014-01-30 10:24:18,999 INFO [org.ovirt.engine.core.utils.LocalC= onfig] (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.co= re.utils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_D= B_DRIVER" is "org.postgresql.Driver".</div> <div>2014-01-30 10:24:19,000 INFO [org.ovirt.engine.core.utils.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_DB_HOST" is "loc= alhost".</div><div>2014-01-30 10:24:19,001 INFO [org.ovirt.engine.cor= e.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.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_DB_MIN_CONNECTIO= NS" 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.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_DB_PORT" is "543= 2".</div><div>2014-01-30 10:24:19,003 INFO [org.ovirt.engine.core.uti= ls.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_DB_SECU= RED" is "False".</div> <div>2014-01-30 10:24:19,004 INFO [org.ovirt.engine.core.utils.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_DB_SECURED_VALID= ATION" 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.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_DB_URL" is "jdbc= :postgresql://localhost:5432/engine?sslfactory=3Dorg.postgresql.ssl.NonVali= datingFactory".</div> <div>2014-01-30 10:24:19,006 INFO [org.ovirt.engine.core.utils.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_DB_USER" is "eng= ine".</div><div>2014-01-30 10:24:19,006 INFO [org.ovirt.engine.core.u= tils.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.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_DOC" is "/usr/sh= are/doc/ovirt-engine".</div><div>2014-01-30 10:24:19,008 INFO [org.ov= irt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of prope= rty "ENGINE_ETC" is "/etc/ovirt-engine".</div> <div>2014-01-30 10:24:19,008 INFO [org.ovirt.engine.core.utils.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_FQDN" is "ovirt0= 01.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.LocalC= onfig] (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.util= s.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.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_HTTPS_ENABLED" i= s "false".</div><div>2014-01-30 10:24:19,011 INFO [org.ovirt.engine.c= ore.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.LocalC= onfig] (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 &= nbsp;[org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Va= lue of property "ENGINE_HTTP_ENABLED" is "false".</div> <div>2014-01-30 10:24:19,013 INFO [org.ovirt.engine.core.utils.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_HTTP_PORT" is "N= one".</div><div>2014-01-30 10:24:19,013 INFO [org.ovirt.engine.core.u= tils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_JVM_A= RGS" is " -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=3D"/var/log/ovir= t-engine/dump"".</div> <div>2014-01-30 10:24:19,014 INFO [org.ovirt.engine.core.utils.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_LOG" is "/var/lo= g/ovirt-engine".</div><div>2014-01-30 10:24:19,014 INFO [org.ovirt.en= gine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "E= NGINE_LOG_TO_CONSOLE" is "false".</div> <div>2014-01-30 10:24:19,015 INFO [org.ovirt.engine.core.utils.LocalC= onfig] (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.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_PERM_MIN" is "25= 6m".</div><div>2014-01-30 10:24:19,017 INFO [org.ovirt.engine.core.ut= ils.LocalConfig] (MSC service thread 1-23) Value of property "ENGINE_PKI" i= s "/etc/pki/ovirt-engine".</div> <div>2014-01-30 10:24:19,017 INFO [org.ovirt.engine.core.utils.LocalC= onfig] (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 [or= g.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Value of p= roperty "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.LocalC= onfig] (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_ALIA= S" is "1".</div><div>2014-01-30 10:24:19,019 INFO [org.ovirt.engine.c= ore.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.LocalC= onfig] (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.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_PROPERTIES" is "= jsse.enableSNIExtension=3Dfalse".</div><div>2014-01-30 10:24:19,022 INFO &= nbsp;[org.ovirt.engine.core.utils.LocalConfig] (MSC service thread 1-23) Va= lue of property "ENGINE_PROXY_ENABLED" is "true".</div> <div>2014-01-30 10:24:19,022 INFO [org.ovirt.engine.core.utils.LocalC= onfig] (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.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_STOP_INTERVAL" i= s "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.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_TMP" is "/var/tm= p/ovirt-engine".</div><div>2014-01-30 10:24:19,024 INFO [org.ovirt.en= gine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "E= NGINE_UP_MARK" is "/var/lib/ovirt-engine/engine.up".</div> <div>2014-01-30 10:24:19,025 INFO [org.ovirt.engine.core.utils.LocalC= onfig] (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.LocalC= onfig] (MSC service thread 1-23) Value of property "ENGINE_VAR" is "/var/li= b/ovirt-engine".</div><div>2014-01-30 10:24:19,026 INFO [org.ovirt.en= gine.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "E= NGINE_VERBOSE_GC" is "false".</div> <div>2014-01-30 10:24:19,027 INFO [org.ovirt.engine.core.utils.LocalC= onfig] (MSC service thread 1-23) Value of property "JBOSS_HOME" is "/usr/sh= are/jboss-as".</div><div>2014-01-30 10:24:19,027 INFO [org.ovirt.engi= ne.core.utils.LocalConfig] (MSC service thread 1-23) Value of property "SEN= SITIVE_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 inacce= ssible. Original exception is: BadSqlGrammarException: CallableStatementCal= lback; bad SQL grammar [{call checkdbconnection()}]; nested exception is or= g.postgresql.util.PSQLException: ERROR: function checkdbconnection() does n= ot exist</div> <div class=3D"im"> <div> Hint: No function matches the given name and argument types. Yo= u might need to add explicit type casts.</div><div> Position: 15</div=
</div><div>2014-01-30 10:24:20,398 ERROR [org.ovirt.engine.core.bll.Backen= d] (MSC service thread 1-2) Error in getting DB connection. The database is= inaccessible. Original exception is: UncategorizedSQLException: CallableSt= atementCallback; uncategorized SQLException for SQL [{call checkdbconnectio= n()}]; SQL state [25P02]; error code [0]; ERROR: current transaction is abo= rted, commands ignored until end of transaction block; nested exception is = org.postgresql.util.PSQLException: ERROR: current transaction is aborted, c= ommands ignored until end of transaction block</div>
</div><div>[last error repeats]</div><div><br></div><div>Thanks,</div></div=
<div class=3D"gmail_extra"><div class=3D"im"><br clear=3D"all"><div><div d= ir=3D"ltr"><span style=3D"font-family:arial,sans-serif;font-size:16px"><str= ong>Steve Dainard </strong></span><span style=3D"font-size:12px">= </span><br>
<a href=3D"http://miovision.com/blog" target=3D"_blank">Blog</a> | &= nbsp;</strong><span color=3D"#999999" data-mce-style=3D"font-family: arial,= sans-serif; font-size: 13px; color: #999999;" style=3D"font-family: arial,= sans-serif; font-size: 13px; color: #999999;"><strong><a href=3D"https://w= ww.linkedin.com/company/miovision-technologies" target=3D"_blank">LinkedIn<= /a> | <a href=3D"https://twitter.com/miovision" target=3D"= _blank">Twitter</a> | <a href=3D"https://www.facebook.com/= miovision" target=3D"_blank">Facebook</a></strong></span> </span> <hr style=3D"font-family:arial,sans-serif;font-size:13px;color:#333333;clea= r:both"> <div style=3D"color:#999999;font-family:arial,sans-serif;font-size:13px;pad= ding-top:5px"> =09<span style=3D"font-family:arial,sans-serif;font-size:12px">Miovision Te= chnologies Inc. | 148 Manitou Drive, Suite 101, Kitchener, ON, Canada |&nbs=
<span style=3D"font-family:arial,sans-serif;font-size:12px">IT Infrastructu= re Manager<br> <a href=3D"http://miovision.com/" target=3D"_blank">Miovision</a> | <em>Ret= hink Traffic</em><br> <a href=3D"tel:519-513-2407" target=3D"_blank">519-513-2407</a> ex.250<br> <a href=3D"tel:877-646-8476" target=3D"_blank">877-646-8476</a> (toll-free)= <br> <br> <strong style=3D"font-family:arial,sans-serif;font-size:13px;color:#999999"= p;N2C 1L3</span><br> =09<span style=3D"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 no= tify us immediately.</span></div> </div></div> <br><div><br></div></div><div><div class=3D"h5"><div class=3D"gmail_quote">= On Thu, Jan 30, 2014 at 2:18 AM, Yedidyah Bar David <span dir=3D"ltr"><<= a href=3D"mailto:didi@redhat.com" target=3D"_blank">didi@redhat.com</a>>= </span> wrote:<br> <blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p= x #ccc solid;padding-left:1ex"> <div><div style=3D"font-size:12pt;font-family:times new roman,new york,time= s,serif"><div></div><blockquote style=3D"padding-left:5px;font-size:12pt;fo= nt-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=3D"mailto:sdainard@miovision.com" = target=3D"_blank">sdainard@miovision.com</a>><br><b>To: </b>"Alon Bar-Le= v" <<a href=3D"mailto:alonbl@redhat.com" target=3D"_blank">alonbl@redhat= .com</a>><br> <b>Cc: </b>"users" <<a href=3D"mailto:users@ovirt.org" target=3D"_blank"=
users@ovirt.org</a>>, "Yedidyah Bar David" <<a href=3D"mailto:didi@r= edhat.com" target=3D"_blank">didi@redhat.com</a>>, "Eli Mesika" <<a h= ref=3D"mailto:emesika@redhat.com" target=3D"_blank">emesika@redhat.com</a>&= gt;<br>
<b>Sent: </b>Thursday, January 30, 2014 7:44:01 AM<br><b>Subject: </b>Re: [= Users] engine-backup restore how to<div><br><div><br></div><div dir=3D"ltr"=
I also see this error in engine.log which repeats every second if I am try= ing to access the web ui.<div>
<br></div><div>2014-01-29 18:59:47,531 ERROR [org.ovirt.engine.core.bll.Bac= kend] (ajp--127.0.0.1-8702-4) Error in getting DB connection. The database = is inaccessible. Original exception is: UncategorizedSQLException: Callable= StatementCallback; uncategorized SQLException for SQL [{call checkdbconnect= ion()}]; SQL state [25P02]; error code [0]; ERROR: current transaction is a= borted, commands ignored until end of transaction block; nested exception i= s 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 th= is 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, i= s there any config file this is referenced in that may not have been update= d?</div></div></div></blockquote><div><br></div><div>In principle, the only= needed file is <span style=3D"font-family:Helvetica,Arial,sans-serif"=
/etc/ovirt-engine/engine.conf.d/10-setup-database.conf</span></div>
<div><span style=3D"font-family:Helvetica,Arial,sans-serif">which was updat= ed by restore. Can you please verify that you can connect to the database</= span></div><div><span style=3D"font-family:Helvetica,Arial,sans-serif">usin= g the credentials in this file? What are its permissions/owner?</span></div=
<div><span style=3D"font-family:Helvetica,Arial,sans-serif"><br></span></di= v><div><span style=3D"font-family:Helvetica,Arial,sans-serif">Thanks,</span=
</div><span><span color=3D"#888888" data-mce-style=3D"color: #888888;" sty= le=3D"color: #888888;"><div>-- <br></div><div><span></span>Didi<span></span= <br>
</div><div><br></div></span></span></div></div></blockquote></div><br></div=
</div></div> </blockquote></div><br></div> </blockquote><div><br><br></div><div><br></div><div>-- <br></div><div><span= name=3D"x"></span>Didi<span name=3D"x"></span><br></div></div></body></htm= l> ------=_Part_11956419_636007185.1391120622799--
participants (3)
-
Alon Bar-Lev -
Steve Dainard -
Yedidyah Bar David