On Tue, Dec 7, 2021 at 7:44 AM Maitler <maitlerb@gmail.com> wrote:

Issue with oVirt fresh install, during step 3.5 'Installing and Configuring Data Warehouse on a Separate Machine': Following Guide: Installing oVirt as a standalone Engine with remote databases

The two nodes; ovirt-net and ovirt-ctl are both fresh installed RHEL 8.4 nodes, built to make this test environment. With ovirt-ctl being the engine host and ovirt-net hosting the postgres database and DWH services.

Please clarify the topology in more details. What exactly is intended to run where?

Upon following the steps through the engine-setup after confirming the installation settings,

On which machine?

the setup gets to '[INFO] Creating a user for Grafana'

This should only happen on the dwh machine ("ovirt-net"?)

then says the following error: [ ERROR ] Failed to execute stage 'Misc configuration': terminating connection due to administrator command server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

Afterwards within /etc/pki/ovirt-engine/ there's broken/empty symbolic links for apache certs and keys linking to apache-grafana which'll cause errors for further attempts are re-doing the engine-setup.

This is a known issue, but should be harmless - another engine-setup would overwrite the changes.

Here's the lines before and after the error in the output log from the setup:

2021-12-06 14:49:08,233-0330 DEBUG otopi.ovirt_engine_setup.engine_common.database database.execute:234 Database: 'None', Statement: ' select * from GetDwhHistoryTimekeepingByVarName( %(name)s ) ', args: {'name': 'dwhHostname'} 2021-12-06 14:49:08,233-0330 DEBUG otopi.ovirt_engine_setup.engine_common.database database.execute:239 Creating own connection 2021-12-06 14:49:08,253-0330 DEBUG otopi.ovirt_engine_setup.engine_common.database database.execute:284 Result: [{'var_name': 'dwhHostname', 'var_value': None, 'var_datetime': None}] 2021-12-06 14:49:08,254-0330 DEBUG otopi.ovirt_engine_setup.engine_common.database database.execute:234 Database: 'None', Statement: ' select UpdateDwhHistoryTimekeeping( %(name)s, %(value)s, NULL ) ', args: {'name': 'dwhHostname', 'value': 'cloud-ovirt-net.mun.cluster.dns'} 2021-12-06 14:49:08,254-0330 DEBUG otopi.context context._executeMethod:145 method exception Traceback (most recent call last): File "/usr/lib/python3.6/site-packages/otopi/context.py", line 132, in _executeMethod method['method']() File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine-dwh/core/single_etl.py", line 167, in _misc value=self.environment[osetupcons.ConfigEnv.FQDN] File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/dwh_history_timekeeping.py", line 63, in updateValueInTimekeeping ownConnection=False, File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 258, in execute args, psycopg2.OperationalError: terminating connection due to administrator command server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

2021-12-06 14:49:08,257-0330 ERROR otopi.context context._executeMethod:154 Failed to execute stage 'Misc configuration': terminating connection due to administrator command server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

A guess: Your setup (with the engine on one machine and its db+dwh+dwh_db on another) is not a common one, and was likely not tested with the addition of grafana integration (new in 4.4). So you can try this: 1. Setup DBs + engine (already done) 2. On engine-setup on the other machine, reply 'No' to 'Configure grafana?'. This should hopefully succeed. 3. Run there 'engine-setup --reconfigure-optional-components' and enable grafana. Hopefully will work this time... In any case, please file a bug in bugzilla. Thanks! Best regards, -- Didi