[Engine-devel] Engine DB - user locked

[Elad Tabak]

Thanks, that seems to solve the problem! :)

On Mon, May 21, 2012 at 4:05 PM, Roy Golan <rgolan at 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 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> 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
>>>>>
>>>> _______________________________________________
>>>> Engine-devel mailing list
>>>> Engine-devel at ovirt.org
>>>> 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
>>>
>>
>> _______________________________________________
>> Engine-devel mailing list
>> 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/673ab4b6/attachment.html>