Bug 839519

Summary: [ovirt-engine-dwh] ovirt-engine-dwh-setup can not parse .pgpass file
Product: Red Hat Enterprise Virtualization Manager Reporter: Kiril Nesenko <knesenko>
Component: ovirt-engine-dwhAssignee: Yaniv Lavi <ylavi>
Status: CLOSED CURRENTRELEASE QA Contact: David Botzer <dbotzer>
Severity: unspecified Docs Contact:
Priority: high    
Version: 3.1.0CC: alourie, dfediuck, dyasny, iheim, mgoldboi, pstehlik, Rhev-m-bugs, sgrinber, ykaul
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard: infra
Fixed In Version: SI10 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-12-04 19:58:06 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
fixed none

Description Kiril Nesenko 2012-07-12 08:08:26 UTC 
Description of problem:
 ovirt-engine-dwh-setup can not parse .pgpass file



2012-07-12 10:51:59::DEBUG::ovirt-engine-dwh-setup::154::root:: starting main()
2012-07-12 10:51:59::DEBUG::common_utils::381::root:: found existing pgpass file, fetching DB host value
2012-07-12 10:51:59::ERROR::ovirt-engine-dwh-setup::194::root:: Exception caught!
2012-07-12 10:51:59::ERROR::ovirt-engine-dwh-setup::195::root:: Traceback (most recent call last):
  File "/usr/bin/ovirt-engine-dwh-setup", line 156, in main
    db_dict = getDbDictFromOptions()
  File "/usr/bin/ovirt-engine-dwh-setup", line 93, in getDbDictFromOptions
    "host"      : utils.getDbHostName(),
  File "/usr/share/ovirt-engine-dwh/common_utils.py", line 363, in getDbHostName
    return getDbConfig("host")
  File "/usr/share/ovirt-engine-dwh/common_utils.py", line 395, in getDbConfig
    raise Exception(ERR_PGPASS_VALUE_NOT_FOUND % (dbconf_param, FILE_PG_PASS))
Exception: Error: requested value 'host' was not found in /root/.pgpass. Check oVirt Engine installation and that wildcards '*' are not used.


.pgpass:
# This section was created during RHEV Manager setup.
# DO NOT CHANGE IT MANUALLY - OTHER UTILITIES AND TOOLS DEPEND ON ITS STRUCTURE.
# Beginning of the oVirt Engine DB settings section
# DB ADMIN credentials.
localhost:5432:*:postgres:123456
# DB USER credentials.
localhost:5432:*:engine:123456
#####  End of RHEV Manager DB settings section.



Version-Release number of selected component (if applicable):
ovirt-engine-dwh-3.1.0-2.noarch

How reproducible:


Steps to Reproduce:
1. run  ovirt-engine-dwh-setup 
3.
  
Actual results:


Expected results:


Additional info:
Comment 1 Yaniv Lavi 2012-07-12 09:50:23 UTC 
Fixed in patch:
http://gerrit.ovirt.org/#/c/6186/


Yaniv
Comment 2 David Botzer 2012-07-16 07:14:01 UTC 
Fixed, Ok
SI10, setup runs correctly - see log attached
Fixed Ok,
Comment 3 David Botzer 2012-07-16 07:14:34 UTC 
Created attachment 598381 [details]
fixed