Description of problem: Make DWH required for engine for dashboards usage. 1. DWH setup plugin will be mandatory. In engine-setup 'configure dwh?' question, we'll add text saying that dwh is mandatory, and that if user chooses 'no', remote dwh should be set up. 2. We'll add a question about "minimal or full" sampling/history/etc. Minimal will be the default. 3. If on same host, update engine conf to access dwh. 4. If dwh is remote, add text to inform user how to update engine conf to access dwh. We should probably also: 5. Document how to change from full to partial history collection and vice-verse. 6. Update existing documentation for migrating dwh to a remote host to also mention needing to update engine conf.
What is the format and location of the conf file we need to add to the engine so that it can access the DWH database? Perhaps simply the existing one dwh uses /etc/ovirt-engine-dwh/ovirt-engine-dwh.d/10-setup-database.conf ? Perhaps copy it to /etc/ovirt-engine/engine.conf.d ?
I guess I can find answers to most of my questions in: https://gerrit.ovirt.org/#/c/54058/30/packaging/services/ovirt-engine/ovirt-engine.xml.in Moving needinfo to Alexander, just in case.
Yes, you can find the answers in ovirt-engine.xml.in but here they are just in case. DWH_DB_HOST="localhost" DWH_DB_PORT="5432" DWH_DB_USER="ovirt_engine_dwh" DWH_DB_PASSWORD="ovirt_engine_dwh" DWH_DB_DATABASE="ovirt_engine_history" DWH_DB_SECURED="False" DWH_DB_SECURED_VALIDATION="False" DWH_DB_DRIVER="org.postgresql.Driver" DWH_DB_URL="jdbc:postgresql://localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidatingFactory"
(In reply to Alexander Wels from comment #3) > Yes, you can find the answers in ovirt-engine.xml.in but here they are just > in case. > > DWH_DB_HOST="localhost" > DWH_DB_PORT="5432" > DWH_DB_USER="ovirt_engine_dwh" > DWH_DB_PASSWORD="ovirt_engine_dwh" > DWH_DB_DATABASE="ovirt_engine_history" > DWH_DB_SECURED="False" > DWH_DB_SECURED_VALIDATION="False" > DWH_DB_DRIVER="org.postgresql.Driver" > DWH_DB_URL="jdbc:postgresql://localhost:5432/ > ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidatingFactory" IOW, identical to what we already write in [1] for DWH's own use. BUT, note that in the copy for the engine, we'll keep the DWH machine FQDN, in both DWH_DB_HOST and DWH_DB_URL, IF db host is 'localhost' there, so that the engine can access it even if it's remote. It's then up to the user to make sure that this fqdn resolves correctly from the engine side (and is accessible in the firewall etc). [1] /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-database.conf
Moving from 4.0 alpha to 4.0 beta since 4.0 alpha has been already released and bug is not ON_QA.
The user should have a option in setup to reconfigure DWH to move from full blown to minimal and vice versa. The default should be minimal with the engine on tha same machine and full blown on a separate installation.
Setting doc text -. I expect proper documentation in the main docs etc. to accompany the dashboards themselves.
verified in ovirt-engine-4.0.0.4-0.1.el7ev.noarch
oVirt 4.0.0 has been released, closing current release.