[Engine-devel] Engine DB - user locked
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
On 05/21/2012 01:44 PM, Elad Tabak wrote:
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
Elad - are you trying to authenticate with Active directory? Kind regards, Yair
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel
On 05/21/2012 01:44 PM, Elad Tabak wrote:
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 Elad - are you trying to authenticate with Active directory?
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
Kind regards, Yair
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel
On 05/21/2012 02:23 PM, Roy Golan wrote:
On 05/21/2012 01:44 PM, Elad Tabak wrote:
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 Elad - are you trying to authenticate with Active directory?
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 oops its grep postgresql /usr/local/jboss/standalone/configuration/standalone.xml
Kind regards, Yair
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel
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@redhat.com> wrote:
On 05/21/2012 02:23 PM, Roy Golan wrote:
On 05/21/2012 01:50 PM, Yair Zaslavsky wrote:
On 05/21/2012 01:44 PM, Elad Tabak wrote:
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
Elad - are you trying to authenticate with Active directory?
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
oops its grep postgresql /usr/local/jboss/standalone/** configuration/standalone.xml
Kind regards, Yair
______________________________**_________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/**mailman/listinfo/engine-devel<http://lists.ovirt.org/mailman/listinfo/engine-devel>
______________________________**_________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/**mailman/listinfo/engine-devel<http://lists.ovirt.org/mailman/listinfo/engine-devel>
______________________________**_________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/**mailman/listinfo/engine-devel<http://lists.ovirt.org/mailman/listinfo/engine-devel>
______________________________**_________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/**mailman/listinfo/engine-devel<http://lists.ovirt.org/mailman/listinfo/engine-devel>
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:
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
try this: psql ovirt postgres -c "update vdc_options set option_value='123' where option_name = 'AdminPassword';" then login with admin/123
On Mon, May 21, 2012 at 2:24 PM, Roy Golan <rgolan@redhat.com <mailto:rgolan@redhat.com>> wrote:
On 05/21/2012 02:23 PM, Roy Golan wrote:
On 05/21/2012 01:50 PM, Yair Zaslavsky wrote:
On 05/21/2012 01:44 PM, Elad Tabak wrote:
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
Elad - are you trying to authenticate with Active directory?
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
oops its grep postgresql /usr/local/jboss/standalone/configuration/standalone.xml
Kind regards, Yair
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org <mailto:Engine-devel@ovirt.org> http://lists.ovirt.org/mailman/listinfo/engine-devel
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org <mailto:Engine-devel@ovirt.org> http://lists.ovirt.org/mailman/listinfo/engine-devel
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org <mailto:Engine-devel@ovirt.org> http://lists.ovirt.org/mailman/listinfo/engine-devel
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org <mailto:Engine-devel@ovirt.org> http://lists.ovirt.org/mailman/listinfo/engine-devel
--------------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@redhat.com</a>></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@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/engine-devel</a><br> </blockquote> _______________________________________________<br> Engine-devel mailing list<br> <a moz-do-not-send="true" href="mailto:Engine-devel@ovirt.org" target="_blank">Engine-devel@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/engine-devel</a><br> </blockquote> <br> _______________________________________________<br> Engine-devel mailing list<br> <a moz-do-not-send="true" href="mailto:Engine-devel@ovirt.org" target="_blank">Engine-devel@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/engine-devel</a><br> </blockquote> <br> _______________________________________________<br> Engine-devel mailing list<br> <a moz-do-not-send="true" href="mailto:Engine-devel@ovirt.org" target="_blank">Engine-devel@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/engine-devel</a><br> </blockquote> </div> <br> </div> </blockquote> <br> </body> </html> --------------010402010305020904050007--
Thanks, that seems to solve the problem! :) On Mon, May 21, 2012 at 4:05 PM, Roy Golan <rgolan@redhat.com> wrote:
On 05/21/2012 02:55 PM, Elad Tabak wrote:
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
try this: psql ovirt postgres -c "update vdc_options set option_value='123' where option_name = 'AdminPassword';"
then login with admin/123
On Mon, May 21, 2012 at 2:24 PM, Roy Golan <rgolan@redhat.com> wrote:
On 05/21/2012 02:23 PM, Roy Golan wrote:
On 05/21/2012 01:50 PM, Yair Zaslavsky wrote:
On 05/21/2012 01:44 PM, Elad Tabak wrote:
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
Elad - are you trying to authenticate with Active directory?
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
oops its grep postgresql /usr/local/jboss/standalone/configuration/standalone.xml
Kind regards, Yair
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel
_______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel
participants (3)
-
Elad Tabak -
Roy Golan -
Yair Zaslavsky