Bug 1032745

Summary: [upgrade] upgrade 3.2 => 3.3 failed - password authentication failed for user "rhevm"
Product: Red Hat Enterprise Virtualization Manager Reporter: Pavel Stehlik <pstehlik>
Component: ovirt-engine-setupAssignee: Sandro Bonazzola <sbonazzo>
Status: CLOSED CURRENTRELEASE QA Contact: Pavel Stehlik <pstehlik>
Severity: urgent Docs Contact:
Priority: unspecified    
Version: 3.3.0CC: acathrow, bazulay, didi, iheim, pstehlik, Rhev-m-bugs, sbonazzo, yeylon
Target Milestone: ---Keywords: Regression, Triaged
Target Release: 3.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: integration
Fixed In Version: is26 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1044030    
Attachments:
Description Flags
ovirt-engine-setup-20131120183219.log.tgz none

Description Pavel Stehlik 2013-11-20 17:44:08 UTC
Created attachment 826777 [details]
ovirt-engine-setup-20131120183219.log.tgz

Description of problem:
 Upgrade from 3.2.4 => 3.3 (sf21.1 => is24) failed. 

[ ERROR ] Failed to execute stage 'Environment setup': Cannot connect to database: FATAL:  password authentication failed for user "rhevm" FATAL:  password authentication failed for user "rhevm" 

as root user, ~/.pgpass  contains:
localhost:5432:*:postgres:{hidden-in-this-BZ}
localhost:5432:*:engine:{hidden-in-this-BZ}
localhost:5432:rhevm:rhevm:{hidden-in-this-BZ}

I never changed password on this environ.

Version-Release number of selected component (if applicable):
is24

How reproducible:


Steps to Reproduce:
1. have sf21.1
2. yum update rhevm-setup;rhevm-setup
3.

Actual results:


Expected results:


Additional info:
...
2013-11-20 18:32:26 DEBUG otopi.ovirt_engine_setup.database database.execute:128 Creating own connection
2013-11-20 18:32:26 DEBUG otopi.ovirt_engine_setup.database database.tryDatabaseConnect:296 Connection failed
Traceback (most recent call last):
  File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/database.py", line 292, in tryDatabaseConnect
    transaction=False,
  File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/database.py", line 145, in execute
    sslmode=sslmode,
OperationalError: FATAL:  password authentication failed for user "rhevm"
FATAL:  password authentication failed for user "rhevm"

2013-11-20 18:32:26 DEBUG otopi.context context._executeMethod:137 method exception
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/otopi/context.py", line 127, in _executeMethod
    method['method']()
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/legacy/database.py", line 102, in _setup
    dbovirtutils.tryDatabaseConnect()
  File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/database.py", line 299, in tryDatabaseConnect
    error=e,
RuntimeError: Cannot connect to database: FATAL:  password authentication failed for user "rhevm"
FATAL:  password authentication failed for user "rhevm"

2013-11-20 18:32:26 ERROR otopi.context context._executeMethod:146 Failed to execute stage 'Environment setup': Cannot connect to database: FATAL:  password authentication failed for user "rhevm"
FATAL:  password authentication failed for user "rhevm"

2013-11-20 18:32:26 DEBUG otopi.context context.dumpEnvironment:441 ENVIRONMENT DUMP - BEGIN
2013-11-20 18:32:26 DEBUG otopi.context context.dumpEnvironment:456 ENV BASE/error=bool:'True'
...

Comment 1 Yedidyah Bar David 2013-11-25 15:33:38 UTC
I have a feeling that it's related to http://gerrit.ovirt.org/21186 but not sure.

Do you have by any chance, or can try to create, logs of a similar upgrade, on the same machine, to something a bit older, e.g. is23?

What's in /etc/ovirt-engine/.pgpass ? Generally (on 3.2) it should only have two lines (user and admin), not three (as you wrote above about /root/.pgpass).

Thanks!

Comment 2 Alex Lourie 2013-11-25 17:41:04 UTC
@Pavel

Following Didi's comment - the ~/.pgpass file should not exist on 3.2 system as we remove it/not create it in the first place. Additionally, 3.3 code doesn't read ~/.pgpass at all.

Let's see what contents you have in /etc/ovirt-engine/.pgpass and we'll see what can we do next.


@Didi
I don't think the mentioned patch is to blame, but more investigation is required in order to make sure.

Comment 7 Itamar Heim 2014-01-21 22:30:49 UTC
Closing - RHEV 3.3 Released

Comment 8 Itamar Heim 2014-01-21 22:30:51 UTC
Closing - RHEV 3.3 Released

Comment 9 Itamar Heim 2014-01-21 22:33:48 UTC
Closing - RHEV 3.3 Released