8:44 p.m.
Hi,
After an attempt to clear the DB by running './create_db_devel.sh -u
postgres', I got an error:
*Failed to create database engine*
I then run 'dropdb -U postgres engine', and then 'create_db_devel.sh'
again, but still I get the same error.
When I tried to login from the admin web interface, I get authentication
error. This is from the jboss log:
USER_FAILED_TO_AUTHENTICATE_ACCOUNT_IS_LOCKED_OR_DISABLED
I also tried running './create_db_devel.sh -u postgres -d engine_new', but
it gives the same error ("Failed to create database engine_new").
I tried restarting the posgresql service, it didn't help.
Please advice.
Thanks,
Elad
9:23 p.m.
On 05/21/2012 01:50 PM, Yair Zaslavsky wrote:
there's a good
chance your
/usr/local/jboss/standalone/configutration/standalone.xml is pointing to
a different DB otherwise I can figure out how create_db_devel.sh have
put the domain values for you.
pls paste the engine.log and the output of:
grep ovirt /usr/local/jboss/standalone/configuration/standalone.xml
9:55 p.m.
I don't have external director server. I'm trying to login using the
default username (admin) which used to work before I run the create db
script.
[elad@ovirt dbscripts]$ grep postgresql
/usr/share/jboss-as/standalone/configuration/standalone.xml
<connection-url>jdbc:postgresql://localhost:5432/engine</connection-url>
<driver>postgresql</driver>
<driver name="postgresql"
module="org.postgresql">
<xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
Attached engine.log
On Mon, May 21, 2012 at 2:24 PM, Roy Golan <rgolan(a)redhat.com> wrote:
11:05 p.m.
This is a multi-part message in MIME format.
--------------010402010305020904050007
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
On 05/21/2012 02:55 PM, Elad Tabak wrote:
try this:
psql ovirt postgres -c "update vdc_options set option_value='123' where
option_name = 'AdminPassword';"
then login with admin/123
--------------010402010305020904050007
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
On 05/21/2012 02:55 PM, Elad Tabak wrote:
<blockquote
cite="mid:CA+NSCuvbWCEOOsRRB6pgjcBA_ooen_5NUvH=Lcs_H9vOaZzetQ@mail.gmail.com"
type="cite">
<div dir="ltr">I don't have external director server. I'm
trying
to login using the default username (admin) which used to work
before I run the create db script.<br>
<br>
[elad@ovirt dbscripts]$ grep postgresql
/usr/share/jboss-as/standalone/configuration/standalone.xml <br>
<connection-url>jdbc:postgresql://localhost:5432/engine</connection-url><br>
<driver>postgresql</driver><br>
<driver name="postgresql"
module="org.postgresql"><br>
<xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class><br>
<br>
Attached engine.log<br>
<br>
</div>
</blockquote>
try this:<br>
psql ovirt postgres -c "update vdc_options set option_value='123'
where option_name = 'AdminPassword';"<br>
<br>
then login with admin/123<br>
<br>
<blockquote
cite="mid:CA+NSCuvbWCEOOsRRB6pgjcBA_ooen_5NUvH=Lcs_H9vOaZzetQ@mail.gmail.com"
type="cite">
<div dir="ltr"><br>
<div class="gmail_quote">On Mon, May 21, 2012 at 2:24 PM, Roy
Golan <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:rgolan@redhat.com"
target="_blank">rgolan(a)redhat.com</a>&gt;</span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">On
05/21/2012 02:23 PM, Roy Golan wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
On 05/21/2012 01:50 PM, Yair Zaslavsky wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
On 05/21/2012 01:44 PM, Elad Tabak wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
After an attempt to clear the DB by running
'./create_db_devel.sh -u<br>
postgres', I got an error:<br>
*Failed to create database engine*<br>
I then run 'dropdb -U postgres engine', and then
'create_db_devel.sh'<br>
again, but still I get the same error.<br>
When I tried to login from the admin web interface, I
get authentication<br>
error. This is from the jboss log:<br>
USER_FAILED_TO_AUTHENTICATE_ACCOUNT_IS_LOCKED_OR_DISABLED<br>
<br>
I also tried running './create_db_devel.sh -u postgres
-d engine_new',<br>
but it gives the same error ("Failed to create
database engine_new").<br>
I tried restarting the posgresql service, it didn't
help.<br>
<br>
Please advice.<br>
<br>
Thanks,<br>
Elad<br>
</blockquote>
Elad - are you trying to authenticate with Active
directory?<br>
</blockquote>
there's a good chance your
/usr/local/jboss/standalone/configutration/standalone.xml
is pointing to a different DB otherwise I can figure out
how create_db_devel.sh have put the domain values for you.<br>
pls paste the engine.log and the output of:<br>
grep ovirt
/usr/local/jboss/standalone/configuration/standalone.xml<br>
</blockquote>
oops its grep postgresql
/usr/local/jboss/standalone/configuration/standalone.xml<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Kind regards,<br>
Yair<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
<br>
_______________________________________________<br>
Engine-devel mailing list<br>
<a moz-do-not-send="true"
href="mailto:Engine-devel@ovirt.org"
target="_blank">Engine-devel(a)ovirt.org</a><br>
<a moz-do-not-send="true"
href="http://lists.ovirt.org/mailman/listinfo/engine-devel"
target="_blank">http://lists.ovirt.org/mailman/listinfo/engi...
</blockquote>
_______________________________________________<br>
Engine-devel mailing list<br>
<a moz-do-not-send="true"
href="mailto:Engine-devel@ovirt.org"
target="_blank">Engine-devel(a)ovirt.org</a><br>
<a moz-do-not-send="true"
href="http://lists.ovirt.org/mailman/listinfo/engine-devel"
target="_blank">http://lists.ovirt.org/mailman/listinfo/engi...
</blockquote>
<br>
_______________________________________________<br>
Engine-devel mailing list<br>
<a moz-do-not-send="true"
href="mailto:Engine-devel@ovirt.org"
target="_blank">Engine-devel(a)ovirt.org</a><br>
<a moz-do-not-send="true"
href="http://lists.ovirt.org/mailman/listinfo/engine-devel"
target="_blank">http://lists.ovirt.org/mailman/listinfo/engi...
</blockquote>
<br>
_______________________________________________<br>
Engine-devel mailing list<br>
<a moz-do-not-send="true"
href="mailto:Engine-devel@ovirt.org"
target="_blank">Engine-devel(a)ovirt.org</a><br>
<a moz-do-not-send="true"
href="http://lists.ovirt.org/mailman/listinfo/engine-devel"
target="_blank">http://lists.ovirt.org/mailman/listinfo/engi...
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>
--------------010402010305020904050007--
4746
days inactive
4746
days old
6 comments
3 participants
participants (3)
-
Elad Tabak -
Roy Golan -
Yair Zaslavsky