10:38 p.m.
Team,
I got two oVirt Servers. One in 4.0.2 and one in 3.6.X
I love the new 4.0 dashboard, But I need a way to continue to build
reports with ease, 3.6 Can do this with ovirt-reports. How can I make my
oVirt 4.0.2 send data for reports to my ovirt reports on 3.6?
Thanks for the help team!
Regards,
--
Fernando Fuentes
ffuentes(a)txweather.org
http://www.txweather.org
10:01 a.m.
On Sat, Aug 13, 2016 at 10:38 PM, Fernando Fuentes <ffuentes(a)darktcp.net> wrote:
Team,
I got two oVirt Servers. One in 4.0.2 and one in 3.6.X
I love the new 4.0 dashboard, But I need a way to continue to build
reports with ease, 3.6 Can do this with ovirt-reports. How can I make my
oVirt 4.0.2 send data for reports to my ovirt reports on 3.6?
Thanks for the help team!
I didn't try this myself, but pointing your reports setup to the 4.0 dwh
database should work. If you have problems, please give more details -
it's not clear what exactly you have on each machine.
Generally speaking, oVirt does not currently provide tools to make
the engine or dwh "send data" elsewhere (a 3.6 reports or whatever).
You can try doing this yourself using generic postgresql means/tools.
Best
--
Didi
6:57 p.m.
David,
Thats exactly what I am trying to accomplish.
When I re-run the ovirt setup on my 3.6 system, I give it the IP of my
ovirt 4.0 machine, Do I leave the DB to the default name? Is there a db
user and password on the 4.0 machine?
Sorry for so many questions... This is not documented...
Thank you for all the help!
Regards,
--
Fernando Fuentes
ffuentes(a)txweather.org
http://www.txweather.org
On Sun, Aug 14, 2016, at 02:01 AM, Yedidyah Bar David wrote:
On Sat, Aug 13, 2016 at 10:38 PM, Fernando Fuentes
<ffuentes(a)darktcp.net>
wrote:
> Team,
>
> I got two oVirt Servers. One in 4.0.2 and one in 3.6.X
> I love the new 4.0 dashboard, But I need a way to continue to build
> reports with ease, 3.6 Can do this with ovirt-reports. How can I make my
> oVirt 4.0.2 send data for reports to my ovirt reports on 3.6?
>
> Thanks for the help team!
I didn't try this myself, but pointing your reports setup to the 4.0 dwh
database should work. If you have problems, please give more details -
it's not clear what exactly you have on each machine.
Generally speaking, oVirt does not currently provide tools to make
the engine or dwh "send data" elsewhere (a 3.6 reports or whatever).
You can try doing this yourself using generic postgresql means/tools.
Best
--
Didi
8:31 a.m.
On Sun, Aug 14, 2016 at 6:57 PM, Fernando Fuentes <ffuentes(a)darktcp.net> wrote:
David,
Thats exactly what I am trying to accomplish.
When I re-run the ovirt setup on my 3.6 system, I give it the IP of my
ovirt 4.0 machine, Do I leave the DB to the default name? Is there a db
user and password on the 4.0 machine?
Sorry for so many questions... This is not documented...
Not for 3.6 vs 4.0, but it actually is, here:
http://www.ovirt.org/develop/release-management/features/engine/separate-...
See also:
http://www.ovirt.org/develop/release-management/features/engine/separate-...
In above, each of engine, dwh, reports is in its own machine.
You can do a similar thing with engine+dwh on one and reports on another.
Do not hesitate ping back if you are stuck!
Best,
Thank you for all the help!
Regards,
--
Fernando Fuentes
ffuentes(a)txweather.org
http://www.txweather.org
On Sun, Aug 14, 2016, at 02:01 AM, Yedidyah Bar David wrote:
> On Sat, Aug 13, 2016 at 10:38 PM, Fernando Fuentes <ffuentes(a)darktcp.net>
> wrote:
> > Team,
> >
> > I got two oVirt Servers. One in 4.0.2 and one in 3.6.X
> > I love the new 4.0 dashboard, But I need a way to continue to build
> > reports with ease, 3.6 Can do this with ovirt-reports. How can I make my
> > oVirt 4.0.2 send data for reports to my ovirt reports on 3.6?
> >
> > Thanks for the help team!
>
> I didn't try this myself, but pointing your reports setup to the 4.0 dwh
> database should work. If you have problems, please give more details -
> it's not clear what exactly you have on each machine.
>
> Generally speaking, oVirt does not currently provide tools to make
> the engine or dwh "send data" elsewhere (a 3.6 reports or whatever).
> You can try doing this yourself using generic postgresql means/tools.
>
> Best
> --
> Didi
--
Didi
6:16 p.m.
Thanks David!
Regards,
--
Fernando Fuentes
ffuentes(a)txweather.org
http://www.txweather.org
On Mon, Aug 15, 2016, at 12:31 AM, Yedidyah Bar David wrote:
On Sun, Aug 14, 2016 at 6:57 PM, Fernando Fuentes
<ffuentes(a)darktcp.net>
wrote:
> David,
>
> Thats exactly what I am trying to accomplish.
> When I re-run the ovirt setup on my 3.6 system, I give it the IP of my
> ovirt 4.0 machine, Do I leave the DB to the default name? Is there a db
> user and password on the 4.0 machine?
>
> Sorry for so many questions... This is not documented...
Not for 3.6 vs 4.0, but it actually is, here:
http://www.ovirt.org/develop/release-management/features/engine/separate-...
See also:
http://www.ovirt.org/develop/release-management/features/engine/separate-...
In above, each of engine, dwh, reports is in its own machine.
You can do a similar thing with engine+dwh on one and reports on another.
Do not hesitate ping back if you are stuck!
Best,
>
> Thank you for all the help!
>
> Regards,
>
> --
> Fernando Fuentes
> ffuentes(a)txweather.org
> http://www.txweather.org
>
> On Sun, Aug 14, 2016, at 02:01 AM, Yedidyah Bar David wrote:
>> On Sat, Aug 13, 2016 at 10:38 PM, Fernando Fuentes <ffuentes(a)darktcp.net>
>> wrote:
>> > Team,
>> >
>> > I got two oVirt Servers. One in 4.0.2 and one in 3.6.X
>> > I love the new 4.0 dashboard, But I need a way to continue to build
>> > reports with ease, 3.6 Can do this with ovirt-reports. How can I make my
>> > oVirt 4.0.2 send data for reports to my ovirt reports on 3.6?
>> >
>> > Thanks for the help team!
>>
>> I didn't try this myself, but pointing your reports setup to the 4.0 dwh
>> database should work. If you have problems, please give more details -
>> it's not clear what exactly you have on each machine.
>>
>> Generally speaking, oVirt does not currently provide tools to make
>> the engine or dwh "send data" elsewhere (a 3.6 reports or whatever).
>> You can try doing this yourself using generic postgresql means/tools.
>>
>> Best
>> --
>> Didi
--
Didi
12:09 a.m.
David,
After an attempt to run this remote setup something went really wrong
and my dwh went fubar on my ovirt 4.0
I got:
2016-08-15 16:03:34|ETL Service Started
ovirtEngineDbDriverClass|org.postgresql.Driver
ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidatingFactory
hoursToKeepDaily|43800
hoursToKeepHourly|1440
ovirtEngineDbPassword|**********************
runDeleteTime|3
ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory
runInterleave|20
limitRows|limit 1000
ovirtEngineHistoryDbUser|ovirt_engine_history
ovirtEngineDbUser|engine
deleteIncrement|10
timeBetweenErrorEvents|300000
hoursToKeepSamples|24
deleteMultiplier|1000
lastErrorSent|2011-07-03 12:46:47.000000
etlVersion|4.0.2
dwhAggregationDebug|false
dwhUuid|759f3eb5-5072-4c28-9686-a363eb956077
ovirtEngineHistoryDbDriverClass|org.postgresql.Driver
ovirtEngineHistoryDbPassword|**********************
Exception in component tJDBCInput_2
org.postgresql.util.PSQLException: ERROR: relation
"history_configuration" does not exist
Position: 65
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
at
ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.tJDBCInput_2Process(MinimalVersionCheck.java:1574)
at
ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.tJDBCInput_1Process(MinimalVersionCheck.java:1229)
at
ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.tJDBCConnection_2Process(MinimalVersionCheck.java:782)
at
ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.tJDBCConnection_1Process(MinimalVersionCheck.java:657)
at
ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.runJobInTOS(MinimalVersionCheck.java:3089)
at
ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.runJob(MinimalVersionCheck.java:2853)
at
ovirt_engine_dwh.historyetl_4_0.HistoryETL.tRunJob_2Process(HistoryETL.java:8009)
at
ovirt_engine_dwh.historyetl_4_0.HistoryETL$3.run(HistoryETL.java:11520)
2016-08-15
16:03:34|NAl0ai|349e7f|349e7f|OVIRT_ENGINE_DWH|MinimalVersionCheck|Default|6|Java
Exception|tJDBCInput_2|org.postgresql.util.PSQLException:ERROR: relation
"history_configuration" does not exist
Position: 65|1
Exception in component tRunJob_2
java.lang.RuntimeException: Child job running failed
at
ovirt_engine_dwh.historyetl_4_0.HistoryETL.tRunJob_2Process(HistoryETL.java:8032)
at
ovirt_engine_dwh.historyetl_4_0.HistoryETL$3.run(HistoryETL.java:11520)
2016-08-15
16:03:34|349e7f|349e7f|349e7f|OVIRT_ENGINE_DWH|HistoryETL|Default|6|Java
Exception|tRunJob_2|java.lang.RuntimeException:Child job running
failed|1
2016-08-15 16:03:34|ETL Service Stopped
Can you please help?
Regards,
--
Fernando Fuentes
ffuentes(a)txweather.org
http://www.txweather.org
On Mon, Aug 15, 2016, at 10:16 AM, Fernando Fuentes wrote:
Thanks David!
Regards,
--
Fernando Fuentes
ffuentes(a)txweather.org
http://www.txweather.org
On Mon, Aug 15, 2016, at 12:31 AM, Yedidyah Bar David wrote:
> On Sun, Aug 14, 2016 at 6:57 PM, Fernando Fuentes <ffuentes(a)darktcp.net>
> wrote:
> > David,
> >
> > Thats exactly what I am trying to accomplish.
> > When I re-run the ovirt setup on my 3.6 system, I give it the IP of my
> > ovirt 4.0 machine, Do I leave the DB to the default name? Is there a db
> > user and password on the 4.0 machine?
> >
> > Sorry for so many questions... This is not documented...
>
> Not for 3.6 vs 4.0, but it actually is, here:
>
>
http://www.ovirt.org/develop/release-management/features/engine/separate-...
>
> See also:
>
> http://www.ovirt.org/develop/release-management/features/engine/separate-...
>
> In above, each of engine, dwh, reports is in its own machine.
> You can do a similar thing with engine+dwh on one and reports on another.
>
> Do not hesitate ping back if you are stuck!
>
> Best,
>
> >
> > Thank you for all the help!
> >
> > Regards,
> >
> > --
> > Fernando Fuentes
> > ffuentes(a)txweather.org
> > http://www.txweather.org
> >
> > On Sun, Aug 14, 2016, at 02:01 AM, Yedidyah Bar David wrote:
> >> On Sat, Aug 13, 2016 at 10:38 PM, Fernando Fuentes
<ffuentes(a)darktcp.net>
> >> wrote:
> >> > Team,
> >> >
> >> > I got two oVirt Servers. One in 4.0.2 and one in 3.6.X
> >> > I love the new 4.0 dashboard, But I need a way to continue to build
> >> > reports with ease, 3.6 Can do this with ovirt-reports. How can I make
my
> >> > oVirt 4.0.2 send data for reports to my ovirt reports on 3.6?
> >> >
> >> > Thanks for the help team!
> >>
> >> I didn't try this myself, but pointing your reports setup to the 4.0
dwh
> >> database should work. If you have problems, please give more details -
> >> it's not clear what exactly you have on each machine.
> >>
> >> Generally speaking, oVirt does not currently provide tools to make
> >> the engine or dwh "send data" elsewhere (a 3.6 reports or
whatever).
> >> You can try doing this yourself using generic postgresql means/tools.
> >>
> >> Best
> >> --
> >> Didi
>
>
>
> --
> Didi
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
8:48 a.m.
On Tue, Aug 16, 2016 at 12:09 AM, Fernando Fuentes <ffuentes(a)darktcp.net> wrote:
David,
(Actually it's "Yedidyah" or "Didi", "Bar David" is my
surname)
After an attempt to run this remote setup something went really wrong
and my dwh went fubar on my ovirt 4.0
I got:
2016-08-15 16:03:34|ETL Service Started
ovirtEngineDbDriverClass|org.postgresql.Driver
ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidatingFactory
hoursToKeepDaily|43800
hoursToKeepHourly|1440
ovirtEngineDbPassword|**********************
runDeleteTime|3
ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory
runInterleave|20
limitRows|limit 1000
ovirtEngineHistoryDbUser|ovirt_engine_history
ovirtEngineDbUser|engine
deleteIncrement|10
timeBetweenErrorEvents|300000
hoursToKeepSamples|24
deleteMultiplier|1000
lastErrorSent|2011-07-03 12:46:47.000000
etlVersion|4.0.2
dwhAggregationDebug|false
dwhUuid|759f3eb5-5072-4c28-9686-a363eb956077
ovirtEngineHistoryDbDriverClass|org.postgresql.Driver
ovirtEngineHistoryDbPassword|**********************
Exception in component tJDBCInput_2
org.postgresql.util.PSQLException: ERROR: relation
"history_configuration" does not exist
Position: 65
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
at
ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.tJDBCInput_2Process(MinimalVersionCheck.java:1574)
at
ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.tJDBCInput_1Process(MinimalVersionCheck.java:1229)
at
ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.tJDBCConnection_2Process(MinimalVersionCheck.java:782)
at
ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.tJDBCConnection_1Process(MinimalVersionCheck.java:657)
at
ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.runJobInTOS(MinimalVersionCheck.java:3089)
at
ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.runJob(MinimalVersionCheck.java:2853)
at
ovirt_engine_dwh.historyetl_4_0.HistoryETL.tRunJob_2Process(HistoryETL.java:8009)
at
ovirt_engine_dwh.historyetl_4_0.HistoryETL$3.run(HistoryETL.java:11520)
2016-08-15
16:03:34|NAl0ai|349e7f|349e7f|OVIRT_ENGINE_DWH|MinimalVersionCheck|Default|6|Java
Exception|tJDBCInput_2|org.postgresql.util.PSQLException:ERROR: relation
"history_configuration" does not exist
Position: 65|1
Exception in component tRunJob_2
java.lang.RuntimeException: Child job running failed
at
ovirt_engine_dwh.historyetl_4_0.HistoryETL.tRunJob_2Process(HistoryETL.java:8032)
at
ovirt_engine_dwh.historyetl_4_0.HistoryETL$3.run(HistoryETL.java:11520)
2016-08-15
16:03:34|349e7f|349e7f|349e7f|OVIRT_ENGINE_DWH|HistoryETL|Default|6|Java
Exception|tRunJob_2|java.lang.RuntimeException:Child job running
failed|1
2016-08-15 16:03:34|ETL Service Stopped
Can you please help?
Please provide setup logs on the engine and reports machines. All of
/var/log/ovirt-engine/setup/* on both of them. Thanks.
>
> Regards,
>
> --
> Fernando Fuentes
> ffuentes(a)txweather.org
> http://www.txweather.org
>
> On Mon, Aug 15, 2016, at 10:16 AM, Fernando Fuentes wrote:
>> Thanks David!
>>
>> Regards,
>>
>>
>> --
>> Fernando Fuentes
>> ffuentes(a)txweather.org
>> http://www.txweather.org
>>
>> On Mon, Aug 15, 2016, at 12:31 AM, Yedidyah Bar David wrote:
>> > On Sun, Aug 14, 2016 at 6:57 PM, Fernando Fuentes
<ffuentes(a)darktcp.net>
>> > wrote:
>> > David,
>> > >
>> > > Thats exactly what I am trying to accomplish.
>> > > When I re-run the ovirt setup on my 3.6 system, I give it the IP of my
>> > > ovirt 4.0 machine, Do I leave the DB to the default name? Is there a
db
>> > > user and password on the 4.0 machine?
>> > >
>> > > Sorry for so many questions... This is not documented...
>> >
>> > Not for 3.6 vs 4.0, but it actually is, here:
>> >
>> >
http://www.ovirt.org/develop/release-management/features/engine/separate-...
>> >
>> > See also:
>> >
>> >
http://www.ovirt.org/develop/release-management/features/engine/separate-...
>> >
>> > In above, each of engine, dwh, reports is in its own machine.
>> > You can do a similar thing with engine+dwh on one and reports on another.
>> >
>> > Do not hesitate ping back if you are stuck!
>> >
>> > Best,
>> >
>> > >
>> > > Thank you for all the help!
>> > >
>> > > Regards,
>> > >
>> > > --
>> > > Fernando Fuentes
>> > > ffuentes(a)txweather.org
>> > > http://www.txweather.org
>> > >
>> > > On Sun, Aug 14, 2016, at 02:01 AM, Yedidyah Bar David wrote:
>> > >> On Sat, Aug 13, 2016 at 10:38 PM, Fernando Fuentes
<ffuentes(a)darktcp.net>
>> > >> wrote:
>> > >> > Team,
>> > >> >
>> > >> > I got two oVirt Servers. One in 4.0.2 and one in 3.6.X
>> > >> > I love the new 4.0 dashboard, But I need a way to continue to
build
>> > >> > reports with ease, 3.6 Can do this with ovirt-reports. How can
I make my
>> > >> > oVirt 4.0.2 send data for reports to my ovirt reports on 3.6?
>> > >> >
>> > >> > Thanks for the help team!
>> > >>
>> > >> I didn't try this myself, but pointing your reports setup to
the 4.0 dwh
>> > >> database should work. If you have problems, please give more
details -
>> > >> it's not clear what exactly you have on each machine.
>> > >>
>> > >> Generally speaking, oVirt does not currently provide tools to make
>> > >> the engine or dwh "send data" elsewhere (a 3.6 reports or
whatever).
>> > >> You can try doing this yourself using generic postgresql
means/tools.
>> > >>
>> > >> Best
>> > >> --
>> > >> Didi
>> >
>> >
>> >
>> > --
>> > Didi
>> _______________________________________________
>> Users mailing list
>> Users(a)ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
> _______________________________________________
> Users mailing list
> Users(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
--
Didi
8:56 a.m.
This looks like a DWH, not a reports issue. Are you sure you only install
reports remotely?
Yaniv Dary
Technical Product Manager
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109
Tel : +972 (9) 7692306
8272306
Email: ydary(a)redhat.com
IRC : ydary
On Tue, Aug 16, 2016 at 8:48 AM, Yedidyah Bar David <didi(a)redhat.com> wrote:
On Tue, Aug 16, 2016 at 12:09 AM, Fernando Fuentes
<ffuentes(a)darktcp.net>
wrote:
> David,
(Actually it's "Yedidyah" or "Didi", "Bar David" is my
surname)
>
> After an attempt to run this remote setup something went really wrong
> and my dwh went fubar on my ovirt 4.0
>
> I got:
>
> 2016-08-15 16:03:34|ETL Service Started
> ovirtEngineDbDriverClass|org.postgresql.Driver
> ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://
localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.
NonValidatingFactory
> hoursToKeepDaily|43800
> hoursToKeepHourly|1440
> ovirtEngineDbPassword|**********************
> runDeleteTime|3
> ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:
5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory
> runInterleave|20
> limitRows|limit 1000
> ovirtEngineHistoryDbUser|ovirt_engine_history
> ovirtEngineDbUser|engine
> deleteIncrement|10
> timeBetweenErrorEvents|300000
> hoursToKeepSamples|24
> deleteMultiplier|1000
> lastErrorSent|2011-07-03 12:46:47.000000
> etlVersion|4.0.2
> dwhAggregationDebug|false
> dwhUuid|759f3eb5-5072-4c28-9686-a363eb956077
> ovirtEngineHistoryDbDriverClass|org.postgresql.Driver
> ovirtEngineHistoryDbPassword|**********************
> Exception in component tJDBCInput_2
> org.postgresql.util.PSQLException: ERROR: relation
> "history_configuration" does not exist
> Position: 65
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
QueryExecutorImpl.java:2157)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(
QueryExecutorImpl.java:1886)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(
QueryExecutorImpl.java:255)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(
AbstractJdbc2Statement.java:555)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
AbstractJdbc2Statement.java:403)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(
AbstractJdbc2Statement.java:283)
> at
> ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.
tJDBCInput_2Process(MinimalVersionCheck.java:1574)
> at
> ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.
tJDBCInput_1Process(MinimalVersionCheck.java:1229)
> at
> ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.
tJDBCConnection_2Process(MinimalVersionCheck.java:782)
> at
> ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.
tJDBCConnection_1Process(MinimalVersionCheck.java:657)
> at
> ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCheck.
runJobInTOS(MinimalVersionCheck.java:3089)
> at
> ovirt_engine_dwh.minimalversioncheck_4_0.
MinimalVersionCheck.runJob(MinimalVersionCheck.java:2853)
> at
> ovirt_engine_dwh.historyetl_4_0.HistoryETL.tRunJob_2Process(
HistoryETL.java:8009)
> at
> ovirt_engine_dwh.historyetl_4_0.HistoryETL$3.run(HistoryETL.
java:11520)
> 2016-08-15
> 16:03:34|NAl0ai|349e7f|349e7f|OVIRT_ENGINE_DWH|
MinimalVersionCheck|Default|6|Java
> Exception|tJDBCInput_2|org.postgresql.util.PSQLException:ERROR: relation
> "history_configuration" does not exist
> Position: 65|1
> Exception in component tRunJob_2
> java.lang.RuntimeException: Child job running failed
> at
> ovirt_engine_dwh.historyetl_4_0.HistoryETL.tRunJob_2Process(
HistoryETL.java:8032)
> at
> ovirt_engine_dwh.historyetl_4_0.HistoryETL$3.run(HistoryETL.
java:11520)
> 2016-08-15
> 16:03:34|349e7f|349e7f|349e7f|OVIRT_ENGINE_DWH|HistoryETL|Default|6|Java
> Exception|tRunJob_2|java.lang.RuntimeException:Child job running
> failed|1
> 2016-08-15 16:03:34|ETL Service Stopped
>
> Can you please help?
Please provide setup logs on the engine and reports machines. All of
/var/log/ovirt-engine/setup/* on both of them. Thanks.
>
> Regards,
>
> --
> Fernando Fuentes
> ffuentes(a)txweather.org
> http://www.txweather.org
>
> On Mon, Aug 15, 2016, at 10:16 AM, Fernando Fuentes wrote:
>> Thanks David!
>>
>> Regards,
>>
>>
>> --
>> Fernando Fuentes
>> ffuentes(a)txweather.org
>> http://www.txweather.org
>>
>> On Mon, Aug 15, 2016, at 12:31 AM, Yedidyah Bar David wrote:
>> > On Sun, Aug 14, 2016 at 6:57 PM, Fernando Fuentes <
ffuentes(a)darktcp.net>
>> > wrote:
>> > > David,
>> > >
>> > > Thats exactly what I am trying to accomplish.
>> > > When I re-run the ovirt setup on my 3.6 system, I give it the IP of
my
>> > > ovirt 4.0 machine, Do I leave the DB to the default name? Is there
a db
>> > > user and password on the 4.0 machine?
>> > >
>> > > Sorry for so many questions... This is not documented...
>> >
>> > Not for 3.6 vs 4.0, but it actually is, here:
>> >
>> > http://www.ovirt.org/develop/release-management/features/
engine/separate-reports-host/
>> >
>> > See also:
>> >
>> > http://www.ovirt.org/develop/release-management/features/
engine/separate-dwh-host/
>> >
>> > In above, each of engine, dwh, reports is in its own machine.
>> > You can do a similar thing with engine+dwh on one and reports on
another.
>> >
>> > Do not hesitate ping back if you are stuck!
>> >
>> > Best,
>> >
>> > >
>> > > Thank you for all the help!
>> > >
>> > > Regards,
>> > >
>> > > --
>> > > Fernando Fuentes
>> > > ffuentes(a)txweather.org
>> > > http://www.txweather.org
>> > >
>> > > On Sun, Aug 14, 2016, at 02:01 AM, Yedidyah Bar David wrote:
>> > >> On Sat, Aug 13, 2016 at 10:38 PM, Fernando Fuentes <
ffuentes(a)darktcp.net>
>> > >> wrote:
>> > >> > Team,
>> > >> >
>> > >> > I got two oVirt Servers. One in 4.0.2 and one in 3.6.X
>> > >> > I love the new 4.0 dashboard, But I need a way to continue
to
build
>> > >> > reports with ease, 3.6 Can do this with ovirt-reports. How
can I
make my
>> > >> > oVirt 4.0.2 send data for reports to my ovirt reports on
3.6?
>> > >> >
>> > >> > Thanks for the help team!
>> > >>
>> > >> I didn't try this myself, but pointing your reports setup to
the
4.0 dwh
>> > >> database should work. If you have problems, please give more
details -
>> > >> it's not clear what exactly you have on each machine.
>> > >>
>> > >> Generally speaking, oVirt does not currently provide tools to
make
>> > >> the engine or dwh "send data" elsewhere (a 3.6 reports
or
whatever).
>> > >> You can try doing this yourself using generic postgresql
means/tools.
>> > >>
>> > >> Best
>> > >> --
>> > >> Didi
>> >
>> >
>> >
>> > --
>> > Didi
>> _______________________________________________
>> Users mailing list
>> Users(a)ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
> _______________________________________________
> Users mailing list
> Users(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
--
Didi
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
11:39 p.m.
Yaniv,
Thanks for the reply.
Didi,
Dully noted!
Thank you all for the reply. I got it all fixed.
Regards,
--
Fernando Fuentes
ffuentes(a)txweather.org
http://www.txweather.org
On Tue, Aug 16, 2016, at 12:56 AM, Yaniv Dary wrote:
This looks like a DWH, not a reports issue. Are you sure you only
install reports remotely?
Yaniv Dary Technical Product Manager Red Hat Israel Ltd. 34 Jerusalem
Road Building A, 4th floor Ra'anana, Israel 4350109 Tel : +972 (9)
7692306 8272306 Email: ydary(a)redhat.com IRC : ydary
On Tue, Aug 16, 2016 at 8:48 AM, Yedidyah Bar David
<didi(a)redhat.com> wrote:
> On Tue, Aug 16, 2016 at 12:09 AM, Fernando Fuentes
> <ffuentes(a)darktcp.net> wrote:
> > David,
>
> (Actually it's "Yedidyah" or "Didi", "Bar David" is
my surname)
>
>
> >
> > After an attempt to run this remote setup something went really
> > wrong
> > and my dwh went fubar on my ovirt 4.0
> >
> > I got:
> >
> > 2016-08-15 16:03:34|ETL Service Started
> > ovirtEngineDbDriverClass|org.postgresql.Driver
> > ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:54-
> > 32/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidati-
> > ngFactory
> > hoursToKeepDaily|43800
> > hoursToKeepHourly|1440
> > ovirtEngineDbPassword|**********************
> > runDeleteTime|3
> > ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engi-
> > ne?sslfactory=org.postgresql.ssl.NonValidatingFactory
> > runInterleave|20
> > limitRows|limit 1000
> > ovirtEngineHistoryDbUser|ovirt_engine_history
> > ovirtEngineDbUser|engine
> > deleteIncrement|10
> > timeBetweenErrorEvents|300000
> > hoursToKeepSamples|24
> > deleteMultiplier|1000
> > lastErrorSent|2011-07-03 12:46:47.000000
> > etlVersion|4.0.2
> > dwhAggregationDebug|false
> > dwhUuid|759f3eb5-5072-4c28-9686-a363eb956077
> > ovirtEngineHistoryDbDriverClass|org.postgresql.Driver
> > ovirtEngineHistoryDbPassword|**********************
> > Exception in component tJDBCInput_2
> > org.postgresql.util.PSQLException: ERROR: relation
> > "history_configuration" does not exist
> > Position: 65
> > at
> > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResp-
> > onse(QueryExecutorImpl.java:2157)
> > at
> > org.postgresql.core.v3.QueryExecutorImpl.processResults(Q-
> > ueryExecutorImpl.java:1886)
> > at
> > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExe-
> > cutorImpl.java:255)
> > at
> > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(Abstr-
> > actJdbc2Statement.java:555)
> > at
> > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFl-
> > ags(AbstractJdbc2Statement.java:403)
> > at
> > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(-
> > AbstractJdbc2Statement.java:283)
> > at
> > ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCh-
> > eck.tJDBCInput_2Process(MinimalVersionCheck.java:1574)
> > at
> > ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCh-
> > eck.tJDBCInput_1Process(MinimalVersionCheck.java:1229)
> > at
> > ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCh-
> > eck.tJDBCConnection_2Process(MinimalVersionCheck.java:782)
> > at
> > ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCh-
> > eck.tJDBCConnection_1Process(MinimalVersionCheck.java:657)
> > at
> > ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCh-
> > eck.runJobInTOS(MinimalVersionCheck.java:3089)
> > at
> > ovirt_engine_dwh.minimalversioncheck_4_0.MinimalVersionCh-
> > eck.runJob(MinimalVersionCheck.java:2853)
> > at
> > ovirt_engine_dwh.historyetl_4_0.HistoryETL.tRunJob_2Proce-
> > ss(HistoryETL.java:8009)
> > at
> > ovirt_engine_dwh.historyetl_4_0.HistoryETL$3.run(HistoryE-
> > TL.java:11520)
> > 2016-08-15
> > 16:03:34|NAl0ai|349e7f|349e7f|OVIRT_ENGINE_DWH|MinimalVersionChec-
> > k|Default|6|Java
> > Exception|tJDBCInput_2|org.postgresql.util.PSQLException:ERROR:
> > relation
> > "history_configuration" does not exist
> > Position: 65|1
> > Exception in component tRunJob_2
> > java.lang.RuntimeException: Child job running failed
> > at
> > ovirt_engine_dwh.historyetl_4_0.HistoryETL.tRunJob_2Proce-
> > ss(HistoryETL.java:8032)
> > at
> > ovirt_engine_dwh.historyetl_4_0.HistoryETL$3.run(HistoryE-
> > TL.java:11520)
> > 2016-08-15
> > 16:03:34|349e7f|349e7f|349e7f|OVIRT_ENGINE_DWH|HistoryETL|Default-
> > |6|Java
> > Exception|tRunJob_2|java.lang.RuntimeException:Child job running
> > failed|1
> > 2016-08-15 16:03:34|ETL Service Stopped
> >
> > Can you please help?
>
> Please provide setup logs on the engine and reports machines. All of
> /var/log/ovirt-engine/setup/* on both of them. Thanks.
>
>
> >
> > Regards,
> >
> > --
> > Fernando Fuentes
> > ffuentes(a)txweather.org
> > http://www.txweather.org
> >
> > On Mon, Aug 15, 2016, at 10:16 AM, Fernando Fuentes wrote:
> >> Thanks David!
> >>
> >> Regards,
> >>
> >>
> >> --
> >> Fernando Fuentes
> >> ffuentes(a)txweather.org
> >> http://www.txweather.org
> >>
> >> On Mon, Aug 15, 2016, at 12:31 AM, Yedidyah Bar David wrote:
> >> > On Sun, Aug 14, 2016 at 6:57 PM, Fernando Fuentes
> >> > <ffuentes(a)darktcp.net>
> >> > wrote:
> >> > > David,
> >> > >
> >> > > Thats exactly what I am trying to accomplish.
> >> > > When I re-run the ovirt setup on my 3.6 system, I give it the
> >> > > IP of my
> >> > > ovirt 4.0 machine, Do I leave the DB to the default name? Is
> >> > > there a db
> >> > > user and password on the 4.0 machine?
> >> > >
> >> > > Sorry for so many questions... This is not documented...
> >> >
> >> > Not for 3.6 vs 4.0, but it actually is, here:
> >> >
> >> >
http://www.ovirt.org/develop/release-management/features/engine/separate-...
> >> >
> >> > See also:
> >> >
> >> >
http://www.ovirt.org/develop/release-management/features/engine/separate-...
> >> >
> >> > In above, each of engine, dwh, reports is in its own machine.
> >> > You can do a similar thing with engine+dwh on one and reports
> >> > on another.
> >> >
> >> > Do not hesitate ping back if you are stuck!
> >> >
> >> > Best,
> >> >
> >> > >
> >> > > Thank you for all the help!
> >> > >
> >> > > Regards,
> >> > >
> >> > > --
> >> > > Fernando Fuentes
> >> > > ffuentes(a)txweather.org
> >> > > http://www.txweather.org
> >> > >
> >> > > On Sun, Aug 14, 2016, at 02:01 AM, Yedidyah Bar David wrote:
> >> > >> On Sat, Aug 13, 2016 at 10:38 PM, Fernando Fuentes
> >> > >> <ffuentes(a)darktcp.net>
> >> > >> wrote:
> >> > >> > Team,
> >> > >> >
> >> > >> > I got two oVirt Servers. One in 4.0.2 and one in 3.6.X
> >> > >> > I love the new 4.0 dashboard, But I need a way to
continue
> >> > >> > to build
> >> > >> > reports with ease, 3.6 Can do this with ovirt-reports.
How
> >> > >> > can I make my
> >> > >> > oVirt 4.0.2 send data for reports to my ovirt reports
on
> >> > >> > 3.6?
> >> > >> >
> >> > >> > Thanks for the help team!
> >> > >>
> >> > >> I didn't try this myself, but pointing your reports setup
to
> >> > >> the 4.0 dwh
> >> > >> database should work. If you have problems, please give more
> >> > >> details -
> >> > >> it's not clear what exactly you have on each machine.
> >> > >>
> >> > >> Generally speaking, oVirt does not currently provide tools
> >> > >> to make
> >> > >> the engine or dwh "send data" elsewhere (a 3.6
reports or
> >> > >> whatever).
> >> > >> You can try doing this yourself using generic postgresql
> >> > >> means/tools.
> >> > >>
> >> > >> Best
> >> > >> --
> >> > >> Didi
> >> >
> >> >
> >> >
> >> > --
> >> > Didi
> >> _______________________________________________
> >> Users mailing list
> >> Users(a)ovirt.org
> >> http://lists.ovirt.org/mailman/listinfo/users
> > _______________________________________________
> > Users mailing list
> > Users(a)ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
>
>
>
> --
> Didi
> _______________________________________________
> Users mailing list
> Users(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
3020
days inactive
3023
days old
8 comments
3 participants
participants (3)
-
Fernando Fuentes -
Yaniv Dary -
Yedidyah Bar David