Hi, the same happens, maybe the password somehow changed, or the file is
wrong? Is there a way to reset the password?
[root@ovirt-engine ~]# PGPASSWORD=CKBKMiSQrrPdq0w9RrWDXw psql -U engine -c
"update vdc_options set option_value = '900' where option_name =
'FenceQuietTimeBetweenOperationsInSec';" engine
psql: FATAL: Peer authentication failed for user "engine"
this is my 10-setup-database.conf file
[root@ovirt-engine ~]# cat
/etc/ovirt-engine/engine.conf.d/10-setup-database.conf
ENGINE_DB_HOST="localhost"
ENGINE_DB_PORT="5432"
ENGINE_DB_USER="engine"
ENGINE_DB_PASSWORD="CKBKMiSQrrPdq0w9RrWDXw"
ENGINE_DB_DATABASE="engine"
ENGINE_DB_SECURED="False"
ENGINE_DB_SECURED_VALIDATION="False"
ENGINE_DB_DRIVER="org.postgresql.Driver"
ENGINE_DB_URL="jdbc:postgresql://localhost:5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory"
Regards,
Bernardo
PGP Key <
Skype: mattraken
2017-09-06 4:32 GMT-03:00 Eli Mesika <emesika(a)redhat.com>:
Hi
try from shell prompt
PGPASSWORD=<engine password> psql -U engine -c "update vdc_options set
option_value = '900' where option_name =
'FenceQuietTimeBetweenOperationsInSec';"
engine
On Tue, Sep 5, 2017 at 6:34 PM, Bernardo Juanicó <bjuanico(a)gmail.com>
wrote:
> Hi Eli,
>
> I could not access the psql prompt, i tried with the credentials and
> values on /etc/ovirt-engine/engine.conf.d/10-setup-database.conf.
>
> I tried interactively and also with a .pgpass file containing:
> localhost:5432:engine:engine:PASSWORD
>
> And i get the following error:
>
> psql: FATAL: Peer authentication failed for user "engine"
>
> Thanks!
>
> Bernardo
>
>
> PGP Key <
http://pgp.mit.edu/pks/lookup?op=get&search=0x695E5BCE34263F5B>
> Skype: mattraken
>
> 2017-09-05 12:14 GMT-03:00 Eli Mesika <emesika(a)redhat.com>:
>
>> Hi Bernardo
>>
>> I would like to suggest a workaround to this problem , can you please
>> check that :
>>
>> We have a configuration value named FenceQuietTimeBetweenOperation
>> sInSec.
>> It controls the minimal timeout to wait between fence operation (stop,
>> start),
>> currently, it is defaulted to 180 sec , The key is not exposed to
>> engine-config, so, I would suggest to
>>
>> 1) Change this key value to 900 by running the following from psql
>> prompt :
>>
>> update vdc_options set option_value = '900' where option_name =
>> 'FenceQuietTimeBetweenOperationsInSec';
>>
>> 2) Restart the engine
>>
>> 3) Repeat the scenario
>>
>> Now, the engine will require 15 min between fencing operations and your
>> host can be up again without being fenced again.
>>
>> Please let me know if this workaround is working for you
>>
>> Thanks
>>
>> Eli
>>
>> On Tue, Sep 5, 2017 at 4:20 PM, Bernardo Juanicó <bjuanico(a)gmail.com>
>> wrote:
>>
>>> Martin, thanks for your reply, i was aware of the [1] BUG and the
>>> implemented solution, changing ServerRebootTimeout to 1200 didnt change a
>>> thing...
>>> Now i know about [2] and ill test the fix once it gets released.
>>>
>>> Regards,
>>>
>>> Bernardo
>>>
>>> PGP Key
>>> <
http://pgp.mit.edu/pks/lookup?op=get&search=0x695E5BCE34263F5B>
>>> Skype: mattraken
>>>
>>> 2017-09-05 8:23 GMT-03:00 Martin Perina <mperina(a)redhat.com>:
>>>
>>>> Hi Bernardo,
>>>>
>>>> we have added timeout to wait until host is booted [1] in oVirt 4.1.2.
>>>> This timeout is by default 5 minutes, but it can be extended using
>>>> following command:
>>>>
>>>> engine-config -s ServerRebootTimeout=NNN
>>>>
>>>> where NNN is number of seconds you want to wait until host is booted
>>>> up.
>>>>
>>>> But be aware that you may be affected by [2], which we are currently
>>>> trying to fix.
>>>>
>>>> Regards
>>>>
>>>> Martin Perina
>>>>
>>>>
>>>> [1]
https://bugzilla.redhat.com/show_bug.cgi?id=1423657
>>>> [2]
https://bugzilla.redhat.com/show_bug.cgi?id=1477700
>>>>
>>>>
>>>> On Fri, Sep 1, 2017 at 7:54 PM, Bernardo Juanicó
<bjuanico(a)gmail.com>
>>>> wrote:
>>>>
>>>>> Hi everyone,
>>>>>
>>>>> I installed 2 hosts on a new cluster and the servers take a really
>>>>> long to boot up (about 8 minutes).
>>>>>
>>>>> When a host crashes or is powered off the ovirt-manager starts it
via
>>>>> power management, since the servers takes all that time to boot up
the
>>>>> ovirt-manager thinks it failed to start and proceeds to reboot it,
several
>>>>> times before giving up, when the server is finally started (about 20
>>>>> minutes after the failure)
>>>>>
>>>>> I changed some engine variables with engine-config trying to set a
>>>>> higher timeout, but the problem persists.
>>>>>
>>>>> Any ideas??
>>>>>
>>>>>
>>>>> Regards,
>>>>> Bernardo
>>>>>
>>>>>
>>>>> PGP Key
>>>>>
<
http://pgp.mit.edu/pks/lookup?op=get&search=0x695E5BCE34263F5B>
>>>>> Skype: mattraken
>>>>>
>>>>> _______________________________________________
>>>>> Users mailing list
>>>>> Users(a)ovirt.org
>>>>>
http://lists.ovirt.org/mailman/listinfo/users
>>>>>
>>>>>
>>>>
>>>
>>
>