Thanks, that seems to solve the problem! :)
On Mon, May 21, 2012 at 4:05 PM, Roy Golan <rgolan(a)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(a)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(a)ovirt.org
>>>>
http://lists.ovirt.org/mailman/listinfo/engine-devel
>>>>
>>> _______________________________________________
>>> Engine-devel mailing list
>>> Engine-devel(a)ovirt.org
>>>
http://lists.ovirt.org/mailman/listinfo/engine-devel
>>>
>>
>> _______________________________________________
>> Engine-devel mailing list
>> Engine-devel(a)ovirt.org
>>
http://lists.ovirt.org/mailman/listinfo/engine-devel
>>
>
> _______________________________________________
> Engine-devel mailing list
> Engine-devel(a)ovirt.org
>
http://lists.ovirt.org/mailman/listinfo/engine-devel
>