[Engine-devel] Engine DB - user locked

[Elad Tabak]

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


On Mon, May 21, 2012 at 2:24 PM, Roy Golan <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
>>>> http://lists.ovirt.org/**mailman/listinfo/engine-devel<http://lists.ovirt.org/mailman/listinfo/engine-devel>
>>>>
>>> ______________________________**_________________
>>> Engine-devel mailing list
>>> Engine-devel at ovirt.org
>>> http://lists.ovirt.org/**mailman/listinfo/engine-devel<http://lists.ovirt.org/mailman/listinfo/engine-devel>
>>>
>>
>> ______________________________**_________________
>> Engine-devel mailing list
>> Engine-devel at ovirt.org
>> http://lists.ovirt.org/**mailman/listinfo/engine-devel<http://lists.ovirt.org/mailman/listinfo/engine-devel>
>>
>
> ______________________________**_________________
> Engine-devel mailing list
> Engine-devel at ovirt.org
> http://lists.ovirt.org/**mailman/listinfo/engine-devel<http://lists.ovirt.org/mailman/listinfo/engine-devel>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/devel/attachments/20120521/db054d5a/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: engine.log
Type: application/octet-stream
Size: 539627 bytes
Desc: not available
URL: <http://lists.ovirt.org/pipermail/devel/attachments/20120521/db054d5a/attachment-0002.obj>