Re: [ovirt-users] Answer file key for "nonlocal postgres"

[Jamie Lawrence]

> On Mar 25, 2017, at 10:57 PM, Yedidyah Bar David  wrote:
> 
> On Fri, Mar 24, 2017 at 3:08 AM, Jamie Lawrence
>  wrote:

[…]

>> Anyone know what I am missing?
> 
> Probably OVESETUP_PROVISIONING/postgresProvisioningEnabled
> and OVESETUP_DWH_PROVISIONING/postgresProvisioningEnabled .

Appreciate the reply - thanks!

> That said, I strongly recommend to not try and write the answer file
> by hand. Instead, do an interactive setup with the exact conditions […]

I know what I was doing is unsupported. I was wondering down the wrong 
troubleshooting path for a bit there, but I think ultimately what I need is 
also unsupported.

It was because I was trying to push this into our extant DB infrastructure, 
which is PG 9.5. Which I found doesn’t work with a local-install, either. (I 
was thinking it would work due to past experience with things that demand an 
old Postgres; IME, PG generally has pretty solid forward-compatibility.)

So that leads me to my next question: if I install under the supported  version 
and dump/load/reconfigure to PG9.5.3, is anyone aware of any actual problems 
(other than lack of official support)? In doing answerfile-driven installs 
repeatedly, the point where it now fails is after the DB load, with 
ovirt-aaa-jdbc-tool choking and failing the run.

The reason I’m considering that as my fallback, nothing-else-worked option is 
that the DB needs to live in one of our existing clusters. We are a heavy 
Postres shop with a lot of hardware, humans and process devoted to maintaining 
it, and the DBAs would hang my corpse up as a deterrent to others if I started 
installing ancient instances in random places for them to take care of.

> https://bugzilla.redhat.com/show_bug.cgi?id=1396925

Was unaware of that; thanks for sharing (and doing!) it.

Thanks for the help,

-j
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

Re: [ovirt-users] Answer file key for "nonlocal postgres"

[Yedidyah Bar David]

On Fri, Mar 24, 2017 at 3:08 AM, Jamie Lawrence
 wrote:
> Hello,
>
> I’m working on an answerfile for an unattended Ovirt install. The engine and 
> the data warehouse DBs live remotely. I think I have most of the relevant 
> keys defined, but appear to be missing one, because the installer is 
> attempting to manage a local Postgres.  Log and error below. Keys I’ve 
> defined so far are:
>
> OVESETUP_DB/secured=bool:False
> OVESETUP_DB/user=str:engine
> OVESETUP_DB/password=str:[SNIP]
> OVESETUP_DB/dumper=str:pg_custom
> OVESETUP_DB/database=str:ovirt_engine
> OVESETUP_DB/fixDbViolations=none:None
> OVESETUP_DB/host=str:[SNIP]
> OVESETUP_DB/port=int:5435
> OVESETUP_DB/filter=none:None
> OVESETUP_DB/restoreJobs=int:2
> OVESETUP_DB/securedHostValidation=bool:False
>
> And a similar set for the DWH.
>
> Anyone know what I am missing?

Probably OVESETUP_PROVISIONING/postgresProvisioningEnabled
and OVESETUP_DWH_PROVISIONING/postgresProvisioningEnabled .

That said, I strongly recommend to not try and write the answer file
by hand. Instead, do an interactive setup with the exact conditions
you want it for eventually (including remote DBs etc), and use the
generated one. You are of course welcome to review it and edit if
you think it's needed, but that's much easier than guessing what
needs to be added (or removed). See also:

https://www.ovirt.org/develop/developer-guide/engine/engine-setup/
http://www.ovirt.org/develop/developer-guide/engine/otopi/

And also:

https://bugzilla.redhat.com/show_bug.cgi?id=1396925

If eventually getting into 4.2 (no promises), it will not really
help you to _guess_, but will help better understand the relation
between the interaction and the generated answerfile.

>
>
> Thanks in advance,
>
> -j
>
> - - - -
> The user error is:
>
> [ INFO  ] Creating PostgreSQL 'ovirt_engine' database
> [ ERROR ] Failed to execute stage 'Misc configuration': Failed to start 
> service 'postgresql'
> [ INFO  ] Yum Performing yum transaction rollback
>
>
>
> From the installer log, it obviously still thinks it is supposed to set up PG 
> locally:

Indeed, but I'd say the user error (from your pov) isn't that this failed
(although why this failed is a good question too) but that it tried.
Are you sure you do not have the above keys set to True in the answer file?

Best,
-- 
Didi
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users