Bug 1026947
| Summary: | [DWH-SETUP] - Remote db user is incorrectly configured in dwh service | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Barak Dagan <bdagan> | ||||||
| Component: | ovirt-engine-dwh | Assignee: | Sandro Bonazzola <sbonazzo> | ||||||
| Status: | CLOSED ERRATA | QA Contact: | Jiri Belka <jbelka> | ||||||
| Severity: | urgent | Docs Contact: | |||||||
| Priority: | unspecified | ||||||||
| Version: | 3.3.0 | CC: | aberezin, acathrow, bazulay, bdagan, iheim, jbelka, oschreib, pstehlik, Rhev-m-bugs, yeylon, ylavi | ||||||
| Target Milestone: | --- | Keywords: | Regression, Reopened | ||||||
| Target Release: | 3.3.0 | ||||||||
| Hardware: | Unspecified | ||||||||
| OS: | Unspecified | ||||||||
| Whiteboard: | integration | ||||||||
| Fixed In Version: | is28 - rhevm-dwh-3.3.0-26.el6ev.noarch.rpm | Doc Type: | Bug Fix | ||||||
| Doc Text: |
When configuring a remote database, the remote database user was incorrectly configured, so the rhevm-dwh service could not start. The setup now correctly configures the remote database user in the rhevm-dwh properties file, so this error no longer occurs.
|
Story Points: | --- | ||||||
| Clone Of: | Environment: | ||||||||
| Last Closed: | 2014-01-21 15:01:58 UTC | 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: | 1045846 | ||||||||
| Bug Blocks: | 1049022 | ||||||||
| Attachments: |
|
||||||||
please recreate with the last build. Please reproduce. moving to CLOSED INSUFFICIENT DATA, Please reopen if needed/reproduced Still happenes on IS26 (rhevm-dwh-3.3.0-24.el6ev.noarch) - reopened. rhevm-dwh-setup-2013_12_11_16_57_44.log: ======================================== 2013-12-11 16:58:23::DEBUG::common_utils::215::root:: starting ovirt-engine-dwhd 2013-12-11 16:58:23::DEBUG::common_utils::276::root:: executing action ovirt-engine-dwhd on service start 2013-12-11 16:58:23::DEBUG::common_utils::864::root:: Executing command --> '/sbin/service ovirt-engine-dwhd start' in working directory '/etc/yum.repos.d' 2013-12-11 16:58:34::DEBUG::common_utils::906::root:: output = Starting ovirt-engine-dwhd: at Wed Dec 11 16:58:24 IST 2013[FAILED] ovirt-engine-dwhd.log: ====================== 2013-12-11 16:58:24|ETL Service Started Exception in component tJDBCConnection_1 org.postgresql.util.PSQLException: FATAL: password authentication failed for user "engine_history" ... Created attachment 835318 [details]
rhevm-dwh-setup & ovirt-engine-dwhd logs
Please attach: /etc/ovirt-engine/ovirt-engine-dwh/Default.properties and the expected password. Yaniv So according to the log although user entered user named "remoteuser", "engine_history" is used instead in the dwh properties file. Yaniv ok, is32.2. remote installation works with: # egrep -i '^ovirt.*db' /etc/ovirt-engine/ovirt-engine-dwh/Default.properties ovirtEngineHistoryDbDriverClass=org.postgresql.Driver ovirtEngineHistoryDbJdbcConnection=jdbc\:postgresql\://testovic.rhev.lab.eng.brq.redhat.com\:5432/ovirt_engine_history?stringtype\=unspecified ovirtEngineHistoryDbUser=remote_engine_history ovirtEngineHistoryDbPassword=123456 ovirtEngineDbDriverClass=org.postgresql.Driver ovirtEngineDbJdbcConnection=jdbc\:postgresql\://testovic.rhev.lab.eng.brq.redhat.com\:5432/remoteengine?stringtype\=unspecified ovirtEngineDbUser=remoteengine ovirtEngineDbPassword=123456 Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. http://rhn.redhat.com/errata/RHBA-2014-0036.html |
Created attachment 819902 [details] installation logs Description of problem: DWH service fails to start, using remote DB configuration due to: 2013-11-05 21:01:22|SSGFb0|SSGFb0|SSGFb0|OVIRT_ENGINE_DWH|HistoryETL|Default|6|Java Exception|tRunJob_2|java.lang.RuntimeException:Child job running failed|1 2013-11-05 21:01:22|ETL Service Stopped 2013-11-05 21:01:22|m7O6JS|SSGFb0|SSGFb0|OVIRT_ENGINE_DWH|ParallelRun|Default|6|Java Exception|tJDBCConnection_2|org.postgresql.util.PSQLException:FATAL: password authentication failed for user "engine_history"|1 Version-Release number of selected component (if applicable): is21 How reproducible: 100% Steps to Reproduce: 1. install rhevm using remote setup configuration 2. install dwh setup, use "original" role name 3. start dwh service Actual results: service fails to start Expected results: service starts successfully Additional info: