[Engine-devel] Engine DB - user locked

[Roy Golan]

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 at 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 at redhat.com 
> <mailto:rgolan at 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 at ovirt.org <mailto:Engine-devel at ovirt.org>
>                 http://lists.ovirt.org/mailman/listinfo/engine-devel
>
>             _______________________________________________
>             Engine-devel mailing list
>             Engine-devel at ovirt.org <mailto:Engine-devel at ovirt.org>
>             http://lists.ovirt.org/mailman/listinfo/engine-devel
>
>
>         _______________________________________________
>         Engine-devel mailing list
>         Engine-devel at ovirt.org <mailto:Engine-devel at ovirt.org>
>         http://lists.ovirt.org/mailman/listinfo/engine-devel
>
>
>     _______________________________________________
>     Engine-devel mailing list
>     Engine-devel at ovirt.org <mailto:Engine-devel at ovirt.org>
>     http://lists.ovirt.org/mailman/listinfo/engine-devel
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/engine-devel/attachments/20120521/578664a6/attachment.html>