Bug 831040

Summary:	[rhevm-log-collector] - Remote DB - LC doesn't collect PG data correctly - Base SoS doesn't have the postgresql SoS plug-in
Product:	Red Hat Enterprise Virtualization Manager	Reporter:	David Botzer <dbotzer>
Component:	ovirt-engine-log-collector	Assignee:	Keith Robertson <kroberts>
Status:	CLOSED CURRENTRELEASE	QA Contact:	David Botzer <dbotzer>
Severity:	high	Docs Contact:
Priority:	unspecified
Version:	3.1.0	CC:	acathrow, dyasny, iheim, jmoran, mgoldboi, pstehlik, Rhev-m-bugs, ykaul
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:	integration
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2012-12-04 19:58:29 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:

Description David Botzer 2012-06-12 05:00:01 UTC

Description of problem:
Cannot collect PG data dump using rhevm-log-collector
Base SoS doesn't have the postgresql SoS plug-in 

Version-Release number of selected component (if applicable):
rhevm 3.1, si4

How reproducible:
always

Steps to Reproduce:
1.install rhevm 3.1 with remote databsse
2.add some entities
3.try to get the rhevm db (engine db) from the remote Host
  rhevm-log-collector --pg-dbhost=10.x.x.x collect
  

Actual results:
The PG data bieng collected is from localhost and not the pg-dbhost

Expected results:
Should get a dump & data on the remote PG DB

Additional info:
Base SoS doesn't have the postgresql SoS plug-in

Comment 1 David Botzer 2012-06-12 05:15:51 UTC

Added TCMS Test Case External Tracker
 - Case: 174963: Log Collector - Positive Test - Remote DB Collect All Logs

Comment 2 Keith Robertson 2012-08-29 20:43:35 UTC

Upstream patch: http://gerrit.ovirt.org/#/c/7590/

Comment 5 David Botzer 2012-10-10 09:09:19 UTC

Cannot work Remote DB setup on SI20
Login Issue

Comment 6 David Botzer 2012-10-10 09:59:35 UTC

Now i can
I had to clean the DBs - engine & rhevm-reports

Comment 7 David Botzer 2012-10-10 10:27:29 UTC

3.1/si20 Remote DB
Please advise how to verify this BZ ?
What should I look in the Zipped file ?

Comment 8 Keith Robertson 2012-10-10 14:34:54 UTC

1. Ensure that the DB is not local to the rhevm.
2. rhevm-log-collector --pg-dbhost=ip-address-of-pg-here collect
3. Unpack the archive created by the LC
4. CWD into <unpacked sos report dir>/tmp/RHEVH-and-PostgreSQL-reports/
5. Unpack the Postgres sos report therein.
6. Ensure that sos_pgdump.tar exists in the unpacked sos report.

Comment 9 David Botzer 2012-10-10 15:51:40 UTC

Fixed, 3.1/si20 Remote DB
All the above are correct
Fixed, 3.1/si20 Remote DB