------=_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--