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