[Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?

Hello, on F19 I upgraded engine from 3..3.4 to 3.4.0. Then yum update ovirt-engine-dwh ovirt-engine-reports ... Running transaction Installing : ovirt-engine-dwh-setup-3.4.0-2.fc19.noarch 1/8 Installing : ovirt-engine-reports-setup-3.4.0-2.fc19.noarch 2/8 Updating : jasperreports-server-5.5.0-7.fc19.noarch 3/8 Updating : ovirt-engine-reports-3.4.0-2.fc19.noarch 4/8 Updating : ovirt-engine-dwh-3.4.0-2.fc19.noarch 5/8 Cleanup : ovirt-engine-reports-3.3.4-1.fc19.noarch 6/8 Cleanup : jasperreports-server-5.5.0-1.noarch 7/8 Cleanup : ovirt-engine-dwh-3.3.4-1.fc19.noarch 8/8 Verifying : jasperreports-server-5.5.0-7.fc19.noarch 1/8 Verifying : ovirt-engine-reports-setup-3.4.0-2.fc19.noarch 2/8 Verifying : ovirt-engine-dwh-setup-3.4.0-2.fc19.noarch 3/8 Verifying : ovirt-engine-dwh-3.4.0-2.fc19.noarch 4/8 Verifying : ovirt-engine-reports-3.4.0-2.fc19.noarch 5/8 Verifying : jasperreports-server-5.5.0-1.noarch 6/8 Verifying : ovirt-engine-reports-3.3.4-1.fc19.noarch 7/8 Verifying : ovirt-engine-dwh-3.3.4-1.fc19.noarch 8/8 Dependency Installed: ovirt-engine-dwh-setup.noarch 0:3.4.0-2.fc19 ovirt-engine-reports-setup.noarch 0:3.4.0-2.fc19 Updated: ovirt-engine-dwh.noarch 0:3.4.0-2.fc19 ovirt-engine-reports.noarch 0:3.4.0-2.fc19 Dependency Updated: jasperreports-server.noarch 0:5.5.0-7.fc19 Complete! But now I see I have neither ovirt-engine-dwh-setup nor ovirt-engine-reports.setup as in 3.3.4... What to do? I only see this thread http://lists.ovirt.org/pipermail/users/2014-March/022205.html and other infos that suggests for new installation engine-setup should care about dwh too (but I don't know for reports...) What about pre-existing 3.3.4 installations with dwh and reports? The engine-setup for upgrade from 3.3.4 to 3.4 didn't notice anything about dwh/reports and didn't update any package: --== CONFIGURATION PREVIEW ==-- Engine database name : engine Engine database secured connection : False Engine database host : localhost Engine database user name : engine Engine database host name validation : False Engine database port : 5432 NFS setup : True Firewall manager : iptables Update Firewall : True Configure WebSocket Proxy : True Host FQDN : tekkaman.localdomain.local NFS mount point : /ISO Set application as default page : True Configure Apache SSL : False Require packages rollback : False Upgrade packages : True Please confirm installation settings (OK, Cancel) [OK]: If I try to run engine-setup again I get [root@tekkaman ~]# engine-setup [ INFO ] Stage: Initializing [ INFO ] Stage: Environment setup Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-aio.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-aio.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-setup-20140405184435.log Version: otopi-1.2.0 (otopi-1.2.0-1.fc19) [ ERROR ] Failed to execute stage 'Environment setup': initial_value must be unicode or None, not str [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140405184435.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed If I patch as in http://gerrit.ovirt.org/#/c/26005/ I get # engine-setup [ INFO ] Stage: Initializing [ ERROR ] Failed to execute stage 'Initializing': type object 'ConfigEnv' has no attribute 'LEGACY_REPORTS_WAR' [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140405190842.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed any hint? Gianluca

----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "users" <users@ovirt.org> Sent: Saturday, April 5, 2014 8:12:31 PM Subject: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
Hello, on F19 I upgraded engine from 3..3.4 to 3.4.0. Then yum update ovirt-engine-dwh ovirt-engine-reports ... Running transaction Installing : ovirt-engine-dwh-setup-3.4.0-2.fc19.noarch 1/8 Installing : ovirt-engine-reports-setup-3.4.0-2.fc19.noarch 2/8 Updating : jasperreports-server-5.5.0-7.fc19.noarch 3/8 Updating : ovirt-engine-reports-3.4.0-2.fc19.noarch 4/8 Updating : ovirt-engine-dwh-3.4.0-2.fc19.noarch 5/8 Cleanup : ovirt-engine-reports-3.3.4-1.fc19.noarch 6/8 Cleanup : jasperreports-server-5.5.0-1.noarch 7/8 Cleanup : ovirt-engine-dwh-3.3.4-1.fc19.noarch 8/8 Verifying : jasperreports-server-5.5.0-7.fc19.noarch 1/8 Verifying : ovirt-engine-reports-setup-3.4.0-2.fc19.noarch 2/8 Verifying : ovirt-engine-dwh-setup-3.4.0-2.fc19.noarch 3/8 Verifying : ovirt-engine-dwh-3.4.0-2.fc19.noarch 4/8 Verifying : ovirt-engine-reports-3.4.0-2.fc19.noarch 5/8 Verifying : jasperreports-server-5.5.0-1.noarch 6/8 Verifying : ovirt-engine-reports-3.3.4-1.fc19.noarch 7/8 Verifying : ovirt-engine-dwh-3.3.4-1.fc19.noarch 8/8
Dependency Installed: ovirt-engine-dwh-setup.noarch 0:3.4.0-2.fc19 ovirt-engine-reports-setup.noarch 0:3.4.0-2.fc19
Updated: ovirt-engine-dwh.noarch 0:3.4.0-2.fc19 ovirt-engine-reports.noarch 0:3.4.0-2.fc19
Dependency Updated: jasperreports-server.noarch 0:5.5.0-7.fc19
Complete!
But now I see I have neither ovirt-engine-dwh-setup nor ovirt-engine-reports.setup as in 3.3.4...
What to do?
I only see this thread http://lists.ovirt.org/pipermail/users/2014-March/022205.html
and other infos that suggests for new installation engine-setup should care about dwh too (but I don't know for reports...)
What about pre-existing 3.3.4 installations with dwh and reports?
The engine-setup for upgrade from 3.3.4 to 3.4 didn't notice anything about dwh/reports and didn't update any package:
--== CONFIGURATION PREVIEW ==--
Engine database name : engine Engine database secured connection : False Engine database host : localhost Engine database user name : engine Engine database host name validation : False Engine database port : 5432 NFS setup : True Firewall manager : iptables Update Firewall : True Configure WebSocket Proxy : True Host FQDN : tekkaman.localdomain.local NFS mount point : /ISO Set application as default page : True Configure Apache SSL : False Require packages rollback : False Upgrade packages : True
Please confirm installation settings (OK, Cancel) [OK]:
If I try to run engine-setup again I get
[root@tekkaman ~]# engine-setup [ INFO ] Stage: Initializing [ INFO ] Stage: Environment setup Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-aio.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-aio.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-setup-20140405184435.log Version: otopi-1.2.0 (otopi-1.2.0-1.fc19) [ ERROR ] Failed to execute stage 'Environment setup': initial_value must be unicode or None, not str [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140405184435.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed
Please attach setup log, need to see where it comes from.
If I patch as in http://gerrit.ovirt.org/#/c/26005/
You should not patch unless we find an issue, but this error is strange, as patch does contains this variable[1] [1] http://gerrit.ovirt.org/#/c/26005/4/packaging/setup/ovirt_engine_setup/repor...
I get # engine-setup [ INFO ] Stage: Initializing [ ERROR ] Failed to execute stage 'Initializing': type object 'ConfigEnv' has no attribute 'LEGACY_REPORTS_WAR' [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140405190842.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed
any hint?
Thanks!

On Sat, Apr 5, 2014 at 10:43 PM, Alon Bar-Lev <alonbl@redhat.com> wrote:
If I try to run engine-setup again I get
[root@tekkaman ~]# engine-setup [ INFO ] Stage: Initializing [ INFO ] Stage: Environment setup Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-aio.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-aio.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-setup-20140405184435.log Version: otopi-1.2.0 (otopi-1.2.0-1.fc19) [ ERROR ] Failed to execute stage 'Environment setup': initial_value must be unicode or None, not str [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140405184435.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed
Please attach setup log, need to see where it comes from.
here it is: https://drive.google.com/file/d/0BwoPbcrMv8mvMnRMSm5oTF9NRUU/edit?usp=sharin...
If I patch as in http://gerrit.ovirt.org/#/c/26005/
You should not patch unless we find an issue, but this error is strange, as patch does contains this variable[1]
[1] http://gerrit.ovirt.org/#/c/26005/4/packaging/setup/ovirt_engine_setup/repor...
I get # engine-setup [ INFO ] Stage: Initializing [ ERROR ] Failed to execute stage 'Initializing': type object 'ConfigEnv' has no attribute 'LEGACY_REPORTS_WAR' [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140405190842.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed
any hint?
Thanks!
I tried that patch because actually I also found this thread some days ago with the same error and it was suggested to do so... http://lists.ovirt.org/pipermail/users/2014-April/023083.html the setup log about the run after patching is here: https://drive.google.com/file/d/0BwoPbcrMv8mvWEc5UVV4a1BuNlk/edit?usp=sharin... Gianluca

----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "users" <users@ovirt.org> Sent: Sunday, April 6, 2014 12:45:51 AM Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
On Sat, Apr 5, 2014 at 10:43 PM, Alon Bar-Lev <alonbl@redhat.com> wrote:
If I try to run engine-setup again I get
[root@tekkaman ~]# engine-setup [ INFO ] Stage: Initializing [ INFO ] Stage: Environment setup Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-aio.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-aio.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-setup-20140405184435.log Version: otopi-1.2.0 (otopi-1.2.0-1.fc19) [ ERROR ] Failed to execute stage 'Environment setup': initial_value must be unicode or None, not str [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140405184435.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed
Please attach setup log, need to see where it comes from.
here it is: https://drive.google.com/file/d/0BwoPbcrMv8mvMnRMSm5oTF9NRUU/edit?usp=sharin...
This was solved in[1], be available in next z-stream. You can manually modify it, one letter... :) [1] http://gerrit.ovirt.org/#/c/26118/
If I patch as in http://gerrit.ovirt.org/#/c/26005/
You should not patch unless we find an issue, but this error is strange, as patch does contains this variable[1]
[1] http://gerrit.ovirt.org/#/c/26005/4/packaging/setup/ovirt_engine_setup/repor...
I get # engine-setup [ INFO ] Stage: Initializing [ ERROR ] Failed to execute stage 'Initializing': type object 'ConfigEnv' has no attribute 'LEGACY_REPORTS_WAR' [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140405190842.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed
any hint?
Thanks!
I tried that patch because actually I also found this thread some days ago with the same error and it was suggested to do so... http://lists.ovirt.org/pipermail/users/2014-April/023083.html
the setup log about the run after patching is here: https://drive.google.com/file/d/0BwoPbcrMv8mvWEc5UVV4a1BuNlk/edit?usp=sharin...
Gianluca

On Sat, Apr 5, 2014 at 11:54 PM, Alon Bar-Lev <alonbl@redhat.com> wrote:
Please attach setup log, need to see where it comes from.
here it is: https://drive.google.com/file/d/0BwoPbcrMv8mvMnRMSm5oTF9NRUU/edit?usp=sharin...
This was solved in[1], be available in next z-stream.
You can manually modify it, one letter... :)
ok. Are you telling me that I have to put again original /usr/share/ovirt-engine/setup/ovirt_engine_setup/reportsconstants.py /usr/share/ovirt-engine/setup/plugins/ovirt-engine-setup/ovirt-engine-reports/jasper/deploy.py that I modified to apply http://gerrit.ovirt.org/#/c/26005/ and then apply instead http://gerrit.ovirt.org/#/c/26118/ or do I have to apply it on the current already modified environment? Gianluca

----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "users" <users@ovirt.org> Sent: Sunday, April 6, 2014 12:59:19 AM Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
On Sat, Apr 5, 2014 at 11:54 PM, Alon Bar-Lev <alonbl@redhat.com> wrote:
Please attach setup log, need to see where it comes from.
here it is: https://drive.google.com/file/d/0BwoPbcrMv8mvMnRMSm5oTF9NRUU/edit?usp=sharin...
This was solved in[1], be available in next z-stream.
You can manually modify it, one letter... :)
ok. Are you telling me that I have to put again original /usr/share/ovirt-engine/setup/ovirt_engine_setup/reportsconstants.py /usr/share/ovirt-engine/setup/plugins/ovirt-engine-setup/ovirt-engine-reports/jasper/deploy.py that I modified to apply http://gerrit.ovirt.org/#/c/26005/ and then apply instead http://gerrit.ovirt.org/#/c/26118/ or do I have to apply it on the current already modified environment?
I think you can yum reinstall ovirt-engine-dwh-setup, this should revert the changes and then you can perform [1] change.
Gianluca

----- Original Message -----
From: "Alon Bar-Lev" <alonbl@redhat.com> To: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> Cc: "users" <users@ovirt.org> Sent: Sunday, April 6, 2014 1:02:16 AM Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "users" <users@ovirt.org> Sent: Sunday, April 6, 2014 12:59:19 AM Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
On Sat, Apr 5, 2014 at 11:54 PM, Alon Bar-Lev <alonbl@redhat.com> wrote:
Please attach setup log, need to see where it comes from.
here it is: https://drive.google.com/file/d/0BwoPbcrMv8mvMnRMSm5oTF9NRUU/edit?usp=sharin...
This was solved in[1], be available in next z-stream.
You can manually modify it, one letter... :)
ok. Are you telling me that I have to put again original /usr/share/ovirt-engine/setup/ovirt_engine_setup/reportsconstants.py /usr/share/ovirt-engine/setup/plugins/ovirt-engine-setup/ovirt-engine-reports/jasper/deploy.py that I modified to apply http://gerrit.ovirt.org/#/c/26005/ and then apply instead http://gerrit.ovirt.org/#/c/26118/ or do I have to apply it on the current already modified environment?
I think you can yum reinstall ovirt-engine-dwh-setup, this should revert the changes and then you can perform [1] change.
Sorry... you have changed reports... so yum reinstall ovirt-engine-reports-setup will do the revert.
Gianluca
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

On Sun, Apr 6, 2014 at 12:09 AM, Alon Bar-Lev <alonbl@redhat.com> wrote:
I think you can yum reinstall ovirt-engine-dwh-setup, this should revert the changes and then you can perform [1] change.
Sorry... you have changed reports... so yum reinstall ovirt-engine-reports-setup will do the revert.
reverted the two backed up files and then applied the one character pathc. Now setup proceeds but fails at this stage: ... [ INFO ] Stage: Misc configuration [ INFO ] Backing up database localhost:engine to '/var/lib/ovirt-engine/backups/engine-20140406010658.a7sKzy.sql'. [ INFO ] Updating Engine database schema [ INFO ] Backing up database localhost:ovirt_engine_history to '/var/lib/ovirt-engine-dwh/backups/dwh-20140406010717.D2aTFC.sql'. [ INFO ] Creating/refreshing DWH database schema [ INFO ] Exporting data out of Jasper [ INFO ] Regenerating Jasper's build configuration files [ ERROR ] Failed to execute stage 'Misc configuration': Command './js-ant' failed to execute [ INFO ] Yum Performing yum transaction rollback [ INFO ] Rolling back database schema [ INFO ] Clearing Engine database engine [ INFO ] Restoring Engine database engine [ INFO ] Rolling back DWH database schema [ INFO ] Clearing DWH database ovirt_engine_history [ INFO ] Restoring DWH database ovirt_engine_history [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140406010543.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed Log is here: https://drive.google.com/file/d/0BwoPbcrMv8mvSVg3dk1lcU5EbW8/edit?usp=sharin... SO I come back here: http://lists.ovirt.org/pipermail/users/2014-April/023083.html ;-) do I have now to try to apply again http://gerrit.ovirt.org/26005 as suggested? BTW: the failed action above left engine down but running systemctl start ovirt-engine let the service up again and web admin portal usable... Gianluca

----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "users" <users@ovirt.org> Sent: Sunday, April 6, 2014 2:14:43 AM Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
On Sun, Apr 6, 2014 at 12:09 AM, Alon Bar-Lev <alonbl@redhat.com> wrote:
I think you can yum reinstall ovirt-engine-dwh-setup, this should revert the changes and then you can perform [1] change.
Sorry... you have changed reports... so yum reinstall ovirt-engine-reports-setup will do the revert.
reverted the two backed up files and then applied the one character pathc. Now setup proceeds but fails at this stage: ... [ INFO ] Stage: Misc configuration [ INFO ] Backing up database localhost:engine to '/var/lib/ovirt-engine/backups/engine-20140406010658.a7sKzy.sql'. [ INFO ] Updating Engine database schema [ INFO ] Backing up database localhost:ovirt_engine_history to '/var/lib/ovirt-engine-dwh/backups/dwh-20140406010717.D2aTFC.sql'. [ INFO ] Creating/refreshing DWH database schema [ INFO ] Exporting data out of Jasper [ INFO ] Regenerating Jasper's build configuration files [ ERROR ] Failed to execute stage 'Misc configuration': Command './js-ant' failed to execute [ INFO ] Yum Performing yum transaction rollback [ INFO ] Rolling back database schema [ INFO ] Clearing Engine database engine [ INFO ] Restoring Engine database engine [ INFO ] Rolling back DWH database schema [ INFO ] Clearing DWH database ovirt_engine_history [ INFO ] Restoring DWH database ovirt_engine_history [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140406010543.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed
Log is here: https://drive.google.com/file/d/0BwoPbcrMv8mvSVg3dk1lcU5EbW8/edit?usp=sharin...
""" Target "gen-config-ce" does not exist in the project "buildomatic". """ Hmm... it should have been gen-config without the -ce. The tags of ovirt-engine-dwh/ovirt-engine-reports are incorrect or correct but the release misses fixes as far as I can see, so I do not know what exactly do you have... But I think this[1] is the fix. [1] http://gerrit.ovirt.org/#/c/25998/
SO I come back here: http://lists.ovirt.org/pipermail/users/2014-April/023083.html
;-)
do I have now to try to apply again http://gerrit.ovirt.org/26005 as suggested?
BTW: the failed action above left engine down but running systemctl start ovirt-engine let the service up again and web admin portal usable...
Yes, if there is a failure services are not automatically restarted.
Gianluca

On Sun, Apr 6, 2014 at 1:25 AM, Alon Bar-Lev <alonbl@redhat.com> wrote:
""" Target "gen-config-ce" does not exist in the project "buildomatic". """
Hmm... it should have been gen-config without the -ce.
The tags of ovirt-engine-dwh/ovirt-engine-reports are incorrect or correct but the release misses fixes as far as I can see, so I do not know what exactly do you have... But I think this[1] is the fix.
My packages should be the official ones at the moment: rpm -q ovirt-engine-dwh ovirt-engine-reports ovirt-engine-dwh-setup ovirt-engine-reports-setup ovirt-engine-dwh-3.4.0-2.fc19.noarch ovirt-engine-reports-3.4.0-2.fc19.noarch ovirt-engine-dwh-setup-3.4.0-2.fc19.noarch ovirt-engine-reports-setup-3.4.0-2.fc19.noarch hum... tried also approach of reinstall, as I saw that some .pyc files resulted modified after my first tried patch when I edited reportsconstants.py and deploy.py don't know if expected that also .pyc files are modified after changing .py files but I had now: # rpm -qV ovirt-engine-dwh ovirt-engine-reports ovirt-engine-dwh-setup ovirt-engine-reports-setup S.5....T. /usr/share/ovirt-engine/setup/plugins/ovirt-engine-setup/ovirt-engine-dwh/legacy/config.py --> the only one I expected S.5....T. /usr/share/ovirt-engine/setup/plugins/ovirt-engine-setup/ovirt-engine-dwh/legacy/config.pyc .......T. /usr/share/ovirt-engine/setup/ovirt_engine_setup/reportsconstants.pyc S.5....T. /usr/share/ovirt-engine/setup/plugins/ovirt-engine-setup/ovirt-engine-reports/jasper/deploy.pyc So # yum reinstall ovirt-engine-dwh ovirt-engine-reports ovirt-engine-dwh-setup ovirt-engine-reports-setup Reinstalling: ovirt-engine-dwh noarch 3.4.0-2.fc19 ovirt-stable 1.2 M ovirt-engine-dwh-setup noarch 3.4.0-2.fc19 ovirt-stable 48 k ovirt-engine-reports noarch 3.4.0-2.fc19 ovirt-stable 1.0 M ovirt-engine-reports-setup noarch 3.4.0-2.fc19 ovirt-stable 49 k [root@tekkaman ~]# rpm -qV ovirt-engine-dwh ovirt-engine-reports ovirt-engine-dwh-setup ovirt-engine-reports-setup [root@tekkaman ~]# then applied http://gerrit.ovirt.org/#/c/26118/ for config.py But now I see that if I run engine-setup again it tries a fresh install and doesn't recognize it is an already configured anvironment (I pressed Ctrl-C at RDBMS question to avoid further problems...) [root@tekkaman ~]# engine-setup [ INFO ] Stage: Initializing [ INFO ] Stage: Environment setup Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-aio.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-aio.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-setup-20140406013743.log Version: otopi-1.2.0 (otopi-1.2.0-1.fc19) [ INFO ] Stage: Environment packages setup [ INFO ] Stage: Programs detection [ INFO ] Stage: Environment setup [ INFO ] Stage: Environment customization --== PRODUCT OPTIONS ==-- Configure Reports on this host (Yes, No) [Yes]: --== PACKAGES ==-- [ INFO ] Checking for product updates... [ INFO ] No product updates found --== NETWORK CONFIGURATION ==-- [WARNING] Failed to resolve tekkaman.localdomain.local using DNS, it can be resolved only locally Setup can automatically configure the firewall on this system. Note: automatic configuration of the firewall may overwrite current settings. Do you want Setup to configure the firewall? (Yes, No) [Yes]: [ INFO ] iptables will be configured as firewall manager. --== DATABASE CONFIGURATION ==-- Where is the Reports database located? (Local, Remote) [Local]: ^C[ ERROR ] Failed to execute stage 'Environment customization': SIG2 [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140406013743.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed setup log here: https://drive.google.com/file/d/0BwoPbcrMv8mvQnd4WGxuOENzZTg/edit?usp=sharin... Now it is time to go to sleep to be sure not to do worse... ;-) But if you have any hint about this problem tomorrow (today actually.. ;-) I can dig more. Thanks again Gianluca

----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "users" <users@ovirt.org> Sent: Sunday, April 6, 2014 2:50:24 AM Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
On Sun, Apr 6, 2014 at 1:25 AM, Alon Bar-Lev <alonbl@redhat.com> wrote:
""" Target "gen-config-ce" does not exist in the project "buildomatic". """
Hmm... it should have been gen-config without the -ce.
The tags of ovirt-engine-dwh/ovirt-engine-reports are incorrect or correct but the release misses fixes as far as I can see, so I do not know what exactly do you have... But I think this[1] is the fix.
My packages should be the official ones at the moment:
rpm -q ovirt-engine-dwh ovirt-engine-reports ovirt-engine-dwh-setup ovirt-engine-reports-setup ovirt-engine-dwh-3.4.0-2.fc19.noarch ovirt-engine-reports-3.4.0-2.fc19.noarch ovirt-engine-dwh-setup-3.4.0-2.fc19.noarch ovirt-engine-reports-setup-3.4.0-2.fc19.noarch
hum... tried also approach of reinstall, as I saw that some .pyc files resulted modified after my first tried patch when I edited reportsconstants.py and deploy.py don't know if expected that also .pyc files are modified after changing .py files but I had now:
# rpm -qV ovirt-engine-dwh ovirt-engine-reports ovirt-engine-dwh-setup ovirt-engine-reports-setup S.5....T. /usr/share/ovirt-engine/setup/plugins/ovirt-engine-setup/ovirt-engine-dwh/legacy/config.py --> the only one I expected S.5....T. /usr/share/ovirt-engine/setup/plugins/ovirt-engine-setup/ovirt-engine-dwh/legacy/config.pyc .......T. /usr/share/ovirt-engine/setup/ovirt_engine_setup/reportsconstants.pyc S.5....T. /usr/share/ovirt-engine/setup/plugins/ovirt-engine-setup/ovirt-engine-reports/jasper/deploy.pyc
So # yum reinstall ovirt-engine-dwh ovirt-engine-reports ovirt-engine-dwh-setup ovirt-engine-reports-setup
Reinstalling: ovirt-engine-dwh noarch 3.4.0-2.fc19 ovirt-stable 1.2 M ovirt-engine-dwh-setup noarch 3.4.0-2.fc19 ovirt-stable 48 k ovirt-engine-reports noarch 3.4.0-2.fc19 ovirt-stable 1.0 M ovirt-engine-reports-setup noarch 3.4.0-2.fc19 ovirt-stable 49 k
[root@tekkaman ~]# rpm -qV ovirt-engine-dwh ovirt-engine-reports ovirt-engine-dwh-setup ovirt-engine-reports-setup [root@tekkaman ~]#
then applied http://gerrit.ovirt.org/#/c/26118/ for config.py
But now I see that if I run engine-setup again it tries a fresh install and doesn't recognize it is an already configured anvironment (I pressed Ctrl-C at RDBMS question to avoid further problems...)
[root@tekkaman ~]# engine-setup [ INFO ] Stage: Initializing [ INFO ] Stage: Environment setup Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-aio.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-aio.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-setup-20140406013743.log Version: otopi-1.2.0 (otopi-1.2.0-1.fc19) [ INFO ] Stage: Environment packages setup [ INFO ] Stage: Programs detection [ INFO ] Stage: Environment setup [ INFO ] Stage: Environment customization
--== PRODUCT OPTIONS ==--
Configure Reports on this host (Yes, No) [Yes]:
--== PACKAGES ==--
[ INFO ] Checking for product updates... [ INFO ] No product updates found
--== NETWORK CONFIGURATION ==--
[WARNING] Failed to resolve tekkaman.localdomain.local using DNS, it can be resolved only locally Setup can automatically configure the firewall on this system. Note: automatic configuration of the firewall may overwrite current settings. Do you want Setup to configure the firewall? (Yes, No) [Yes]: [ INFO ] iptables will be configured as firewall manager.
--== DATABASE CONFIGURATION ==--
Where is the Reports database located? (Local, Remote) [Local]: ^C[ ERROR ] Failed to execute stage 'Environment customization': SIG2 [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140406013743.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed
setup log here: https://drive.google.com/file/d/0BwoPbcrMv8mvQnd4WGxuOENzZTg/edit?usp=sharin...
Now it is time to go to sleep to be sure not to do worse... ;-) But if you have any hint about this problem tomorrow (today actually.. ;-) I can dig more.
This is a progress... :) Now... do you have anything at: /usr/share/jasperreports-server/buildomatic/build_conf/default/master.properties Do you have: /var/lib/ovirt-engine-reports/build-conf/master.properties
Thanks again Gianluca

On Sun, Apr 6, 2014 at 2:13 AM, Alon Bar-Lev <alonbl@redhat.com> wrote:
This is a progress... :)
I have not understood in what sense, but I trust you...
Now... do you have anything at:
/usr/share/jasperreports-server/buildomatic/build_conf/default/master.properties
Do you have:
/var/lib/ovirt-engine-reports/build-conf/master.properties
yes see below. Note that I didn't complete the engine-setup process But if this influences only my reports/dwh installation and not engine itself is ok for me to run it again.... I suppose in case I have to drop before my preexisting reports/dwh rdbms and so loose my previous data? [g.cecchi@tekkaman ~]$ cat /usr/share/jasperreports-server/buildomatic/build_conf/default/master.properties appServerType=jboss7 # JBoss app server root dir appServerDir=/usr/share/ovirt-engine # database type dbType=postgresql # database location and connection settings dbHost=localhost dbPort=5432 dbUsername=engine_reports dbPassword=<an apparently encrypted password> # JasperServer db name js.dbName=ovirtenginereports # web app name # (set one of these to deploy to a non-default war file name) webAppNameCE=ovirt-engine-reports # JDBC driver # (uncomment to change to a non-default setting) # # driver will be found here: <path>/buildomatic/conf_source/db/postgresql/jdbc # # maven.jdbc.groupId=postgresql # maven.jdbc.artifactId=postgresql maven.jdbc.version=jdbc # Skip JDBC Driver Deploy # Flag used to skip JDBC driver deploying during deployment process # (uncomment to change to a non-default setting) deployJDBCDriver=false [g.cecchi@tekkaman ~]$ sudo cat /var/lib/ovirt-engine-reports/build-conf/master.properties # File locations reportsHome=/var/lib/ovirt-engine-reports reportsWar=/var/lib/ovirt-engine-reports/ovirt-engine-reports.war currentConf=/var/lib/ovirt-engine-reports/build-conf appServerDir=/var/lib/ovirt-engine-reports appServerType=jboss7 # database type dbType=postgresql # database location and connection settings dbHost=localhost dbPort=5432 dbUsername=engine_reports dbPassword=<the same as above encrypted password> js.dbName=ovirtenginereports # web app name # (set one of these to deploy to a non-default war file name) webAppNameCE=ovirt-engine-reports webAppNamePro=ovirt-engine-reports # Database maven.jdbc.groupId=postgresql maven.jdbc.artifactId=postgresql maven.jdbc.version=9.2-1002.jdbc4 deployJDBCDriver=false

----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "users" <users@ovirt.org> Sent: Sunday, April 6, 2014 10:57:42 AM Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
On Sun, Apr 6, 2014 at 2:13 AM, Alon Bar-Lev <alonbl@redhat.com> wrote:
This is a progress... :)
I have not understood in what sense, but I trust you...
Now... do you have anything at:
/usr/share/jasperreports-server/buildomatic/build_conf/default/master.properties
Do you have:
/var/lib/ovirt-engine-reports/build-conf/master.properties
yes see below. Note that I didn't complete the engine-setup process But if this influences only my reports/dwh installation and not engine itself is ok for me to run it again.... I suppose in case I have to drop before my preexisting reports/dwh rdbms and so loose my previous data?
OK, this is a bug, as the /var/lib/ovirt-engine-reports/build-conf/master.properties should been left only on success, while I see that if fail it is left, I will open a bug. Please remove /var/lib/ovirt-engine-reports/build-conf and re-run setup should attempt to upgrade again. Thanks, Alon

On Sun, Apr 6, 2014 at 10:26 AM, Alon Bar-Lev <alonbl@redhat.com> wrote:
----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "users" <users@ovirt.org> Sent: Sunday, April 6, 2014 10:57:42 AM Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
On Sun, Apr 6, 2014 at 2:13 AM, Alon Bar-Lev <alonbl@redhat.com> wrote:
This is a progress... :)
I have not understood in what sense, but I trust you...
Now... do you have anything at:
/usr/share/jasperreports-server/buildomatic/build_conf/default/master.properties
Do you have:
/var/lib/ovirt-engine-reports/build-conf/master.properties
yes see below. Note that I didn't complete the engine-setup process But if this influences only my reports/dwh installation and not engine itself is ok for me to run it again.... I suppose in case I have to drop before my preexisting reports/dwh rdbms and so loose my previous data?
OK, this is a bug, as the /var/lib/ovirt-engine-reports/build-conf/master.properties should been left only on success, while I see that if fail it is left, I will open a bug.
Please remove /var/lib/ovirt-engine-reports/build-conf and re-run setup should attempt to upgrade again.
Thanks, Alon
ok, done. I see your opened bugzilla entry. Now: [ INFO ] Stage: Setup validation During execution engine service will be stopped (OK, Cancel) [OK]: [ INFO ] Cleaning stale zombie tasks --== CONFIGURATION PREVIEW ==-- Engine database name : engine Engine database secured connection : False Engine database host : localhost Engine database user name : engine Engine database host name validation : False Engine database port : 5432 NFS setup : True Firewall manager : iptables Update Firewall : True Configure WebSocket Proxy : True Host FQDN : tekkaman.localdomain.local NFS mount point : /ISO DWH installation : True DWH database name : ovirt_engine_history DWH database secured connection : False DWH database host : localhost DWH database user name : engine_history DWH database host name validation : False DWH database port : 5432 Reports installation : True Reports database name : ovirtenginereports Reports database secured connection : False Reports database host : localhost Reports database user name : engine_reports Reports database host name validation : False Reports database port : 5432 Please confirm installation settings (OK, Cancel) [OK]: [ INFO ] Cleaning async tasks and compensations [ INFO ] Checking the Engine database consistency [ INFO ] Stage: Transaction setup [ INFO ] Stopping engine service [ INFO ] Stopping dwh service [ INFO ] Stopping websocket-proxy service [ INFO ] Stage: Misc configuration [ INFO ] Stage: Package installation [ INFO ] Stage: Misc configuration [ INFO ] Backing up database localhost:engine to '/var/lib/ovirt-engine/backups/engine-20140406105216.IjEVb2.sql'. [ INFO ] Updating Engine database schema [ INFO ] Backing up database localhost:ovirt_engine_history to '/var/lib/ovirt-engine-dwh/backups/dwh-20140406105234.jk3lc9.sql'. [ INFO ] Creating/refreshing DWH database schema [ INFO ] Exporting data out of Jasper [ INFO ] Regenerating Jasper's build configuration files [ ERROR ] Failed to execute stage 'Misc configuration': Command './js-ant' failed to execute [ INFO ] Yum Performing yum transaction rollback [ INFO ] Rolling back database schema [ INFO ] Clearing Engine database engine [ INFO ] Restoring Engine database engine [ INFO ] Rolling back DWH database schema [ INFO ] Clearing DWH database ovirt_engine_history [ INFO ] Restoring DWH database ovirt_engine_history [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140406105032.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed we come back with the problem you outlined with BUILD FAILED Target "gen-config-ce" does not exist in the project "buildomatic". in setup log see here: https://drive.google.com/file/d/0BwoPbcrMv8mvM29QdXU2UUlHRHc/edit?usp=sharin... I suppose I have to remove again build-conf before proceedings with other suggestions... Gianluca

----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "users" <users@ovirt.org> Sent: Sunday, April 6, 2014 11:57:27 AM Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
On Sun, Apr 6, 2014 at 10:26 AM, Alon Bar-Lev <alonbl@redhat.com> wrote:
----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "users" <users@ovirt.org> Sent: Sunday, April 6, 2014 10:57:42 AM Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
On Sun, Apr 6, 2014 at 2:13 AM, Alon Bar-Lev <alonbl@redhat.com> wrote:
This is a progress... :)
I have not understood in what sense, but I trust you...
Now... do you have anything at:
/usr/share/jasperreports-server/buildomatic/build_conf/default/master.properties
Do you have:
/var/lib/ovirt-engine-reports/build-conf/master.properties
yes see below. Note that I didn't complete the engine-setup process But if this influences only my reports/dwh installation and not engine itself is ok for me to run it again.... I suppose in case I have to drop before my preexisting reports/dwh rdbms and so loose my previous data?
OK, this is a bug, as the /var/lib/ovirt-engine-reports/build-conf/master.properties should been left only on success, while I see that if fail it is left, I will open a bug.
Please remove /var/lib/ovirt-engine-reports/build-conf and re-run setup should attempt to upgrade again.
Thanks, Alon
ok, done. I see your opened bugzilla entry.
Now: [ INFO ] Stage: Setup validation During execution engine service will be stopped (OK, Cancel) [OK]: [ INFO ] Cleaning stale zombie tasks
--== CONFIGURATION PREVIEW ==--
Engine database name : engine Engine database secured connection : False Engine database host : localhost Engine database user name : engine Engine database host name validation : False Engine database port : 5432 NFS setup : True Firewall manager : iptables Update Firewall : True Configure WebSocket Proxy : True Host FQDN : tekkaman.localdomain.local NFS mount point : /ISO DWH installation : True DWH database name : ovirt_engine_history DWH database secured connection : False DWH database host : localhost DWH database user name : engine_history DWH database host name validation : False DWH database port : 5432 Reports installation : True Reports database name : ovirtenginereports Reports database secured connection : False Reports database host : localhost Reports database user name : engine_reports Reports database host name validation : False Reports database port : 5432
Please confirm installation settings (OK, Cancel) [OK]: [ INFO ] Cleaning async tasks and compensations [ INFO ] Checking the Engine database consistency [ INFO ] Stage: Transaction setup [ INFO ] Stopping engine service [ INFO ] Stopping dwh service [ INFO ] Stopping websocket-proxy service [ INFO ] Stage: Misc configuration [ INFO ] Stage: Package installation [ INFO ] Stage: Misc configuration [ INFO ] Backing up database localhost:engine to '/var/lib/ovirt-engine/backups/engine-20140406105216.IjEVb2.sql'. [ INFO ] Updating Engine database schema [ INFO ] Backing up database localhost:ovirt_engine_history to '/var/lib/ovirt-engine-dwh/backups/dwh-20140406105234.jk3lc9.sql'. [ INFO ] Creating/refreshing DWH database schema [ INFO ] Exporting data out of Jasper [ INFO ] Regenerating Jasper's build configuration files [ ERROR ] Failed to execute stage 'Misc configuration': Command './js-ant' failed to execute [ INFO ] Yum Performing yum transaction rollback [ INFO ] Rolling back database schema [ INFO ] Clearing Engine database engine [ INFO ] Restoring Engine database engine [ INFO ] Rolling back DWH database schema [ INFO ] Clearing DWH database ovirt_engine_history [ INFO ] Restoring DWH database ovirt_engine_history [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140406105032.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed
we come back with the problem you outlined with
BUILD FAILED Target "gen-config-ce" does not exist in the project "buildomatic".
in setup log see here: https://drive.google.com/file/d/0BwoPbcrMv8mvM29QdXU2UUlHRHc/edit?usp=sharin...
I suppose I have to remove again build-conf before proceedings with other suggestions...
You need to remove and apply this[1] to fix that problem, I thought you applied it. [1] http://gerrit.ovirt.org/#/c/25998/
Gianluca

On Sun, Apr 6, 2014 at 11:34 AM, Alon Bar-Lev <alonbl@redhat.com> wrote:
You need to remove and apply this[1] to fix that problem, I thought you applied it.
[1] http://gerrit.ovirt.org/#/c/25998/
Gianluca
Ah ok, right. I forgot that. Now all ended ok (see below) I see that now the user is defined into the db instead of palin file as in 3.3. ovirtenginereports=# select * from jiuser; id | username | tenantid | fullname | emailaddress | password | externallydefined | enable d | previouspasswordchangetime -----+---------------+----------+------------------+--------------+----------------------------------+-------------------+------- --+---------------------------- 5 | jasperadmin | 1 | jasperadmin User | | 349AFAADD5C5A2BD477309618DCD58B9 | f | f | 2013-10-17 00:58:10.01 6 | anonymousUser | 1 | anonymousUser | | CF35D2E88192D6EB | f | f | 2013-10-17 00:58:10.346 129 | ovirt-admin | 1 | ovirt-admin | | D41B13B925B503A13CF5EBB35EB9BFF7 | f | t | 130 | admin | 1 | admin | | 5C598ADA6CCE35AA | f | f | (4 rows) How can I reset the password of ovirt-admin? (previously I used it only at certain times and watched the clear text file /usr/share/ovirt-engine-reports/reports/users/ovirt-002dadmin.xml I forgot it ;-) ) so that I can try and check previous data? At the end of the e-mail what I wrote as a summary and if right I can add into release notes... ... Please confirm installation settings (OK, Cancel) [OK]: [ INFO ] Cleaning async tasks and compensations [ INFO ] Checking the Engine database consistency [ INFO ] Stage: Transaction setup [ INFO ] Stopping engine service [ INFO ] Stopping dwh service [ INFO ] Stopping websocket-proxy service [ INFO ] Stage: Misc configuration [ INFO ] Stage: Package installation [ INFO ] Stage: Misc configuration [ INFO ] Backing up database localhost:engine to '/var/lib/ovirt-engine/backups/engine-20140406140343.eSKtje.sql'. [ INFO ] Updating Engine database schema [ INFO ] Backing up database localhost:ovirt_engine_history to '/var/lib/ovirt-engine-dwh/backups/dwh-20140406140401.A6N4NM.sql'. [ INFO ] Creating/refreshing DWH database schema [ INFO ] Regenerating Jasper's build configuration files [ INFO ] Exporting data out of Jasper [ INFO ] Backing up database localhost:ovirtenginereports to '/var/lib/ovirt-engine-reports/backups/reports-20140406140547.a7FquY.sql'. [ INFO ] Deploying Jasper [ INFO ] Importing data into Jasper [ INFO ] Configuring Jasper Java resources [ INFO ] Configuring Jasper Database resources [ INFO ] Customizing Jasper [ INFO ] Customizing Jasper metadata [ INFO ] Generating post install configuration file '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf' [ INFO ] Stage: Transaction commit [ INFO ] Stage: Closing up --== SUMMARY ==-- SSH fingerprint: FE:C6:E1:DE:5D:44:DC:30:CB:12:A3:F7:01:3A:49:83 Internal CA 55:D5:F1:1F:1A:65:45:61:D5:17:A5:74:36:84:65:3B:E5:53:6E:84 Web access is enabled at: http://tekkaman.localdomain.local:80/ovirt-engine https://tekkaman.localdomain.local:443/ovirt-engine --== END OF SUMMARY ==-- [ INFO ] Starting engine service [ INFO ] Restarting httpd [ INFO ] Restarting nfs services [ INFO ] Starting dwh service [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20140406140949-setup.conf' [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140406140253.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ INFO ] Execution of setup completed successfully The workflow for upgrade from configured 3.3 dwh and reports should be this Coming from a 3.3.4 with dwh and reports already configured, in my case I start with ovirt-engine-dwh-3.3.4-1.fc19.noarch ovirt-engine-reports-3.3.4-1.fc19.noarch after first tun of engine-setup, that updates only engine itself you have to: 1) yum update and you will get ovirt-engine-dwh-3.4.0-2.fc19.noarch ovirt-engine-reports-3.4.0-2.fc19.noarch and also these 2 new packages installed ovirt-engine-dwh-setup-3.4.0-2.fc19.noarch ovirt-engine-reports-setup-3.4.0-2.fc19.noarch 2) patch as from http://gerrit.ovirt.org/#/c/26118/ and http://gerrit.ovirt.org/#/c/25998/ 3) engine-setup (no more ovirt-engine-dwh-setup and ovirt-engine-reports-setup to run) And if you have run 3) before 2) you have to remove the directory tree under /var/lib/ovirt-engine-reports/build-conf and run 2) and 3) again due to currently targeted for 3.4.1 bug: https://bugzilla.redhat.com/show_bug.cgi?id=1084749 Gianluca

----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "users" <users@ovirt.org> Sent: Sunday, April 6, 2014 3:43:09 PM Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
On Sun, Apr 6, 2014 at 11:34 AM, Alon Bar-Lev <alonbl@redhat.com> wrote:
You need to remove and apply this[1] to fix that problem, I thought you applied it.
[1] http://gerrit.ovirt.org/#/c/25998/
Gianluca
Ah ok, right. I forgot that. Now all ended ok (see below) I see that now the user is defined into the db instead of palin file as in 3.3.
Great.
How can I reset the password of ovirt-admin? (previously I used it only at certain times and watched the clear text file /usr/share/ovirt-engine-reports/reports/users/ovirt-002dadmin.xml I forgot it ;-)
I think you can run: # engine-setup --otopi-environment="OVESETUP_REPORTS_CONFIG/adminPassword=str:<password>" Or interactively: # engine-setup --otopi-environment="OVESETUP_REPORTS_CONFIG/adminPassword=none:"
so that I can try and check previous data? At the end of the e-mail what I wrote as a summary and if right I can add into release notes...
Well, better to wait for 3.4.1 I think.
after first tun of engine-setup, that updates only engine itself you have to:
1) yum update and you will get ovirt-engine-dwh-3.4.0-2.fc19.noarch ovirt-engine-reports-3.4.0-2.fc19.noarch
and also these 2 new packages installed ovirt-engine-dwh-setup-3.4.0-2.fc19.noarch ovirt-engine-reports-setup-3.4.0-2.fc19.noarch
2) patch as from http://gerrit.ovirt.org/#/c/26118/ and http://gerrit.ovirt.org/#/c/25998/
3) engine-setup (no more ovirt-engine-dwh-setup and ovirt-engine-reports-setup to run)
And if you have run 3) before 2) you have to remove the directory tree under /var/lib/ovirt-engine-reports/build-conf and run 2) and 3) again due to currently targeted for 3.4.1 bug: https://bugzilla.redhat.com/show_bug.cgi?id=1084749
Thank you for your help! Alon.

----- Original Message -----
From: "Alon Bar-Lev" <alonbl@redhat.com> To: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> Cc: "users" <users@ovirt.org> Sent: Sunday, April 6, 2014 4:37:01 PM Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "users" <users@ovirt.org> Sent: Sunday, April 6, 2014 3:43:09 PM Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
On Sun, Apr 6, 2014 at 11:34 AM, Alon Bar-Lev <alonbl@redhat.com> wrote:
You need to remove and apply this[1] to fix that problem, I thought you applied it.
[1] http://gerrit.ovirt.org/#/c/25998/
Gianluca
Ah ok, right. I forgot that. Now all ended ok (see below) I see that now the user is defined into the db instead of palin file as in 3.3.
Great.
How can I reset the password of ovirt-admin? (previously I used it only at certain times and watched the clear text file /usr/share/ovirt-engine-reports/reports/users/ovirt-002dadmin.xml I forgot it ;-)
I think you can run:
# engine-setup --otopi-environment="OVESETUP_REPORTS_CONFIG/adminPassword=str:<password>"
Or interactively:
# engine-setup --otopi-environment="OVESETUP_REPORTS_CONFIG/adminPassword=none:"
ּSorry, interactive will not work if there is existing installation.
so that I can try and check previous data? At the end of the e-mail what I wrote as a summary and if right I can add into release notes...
Well, better to wait for 3.4.1 I think.
after first tun of engine-setup, that updates only engine itself you have to:
1) yum update and you will get ovirt-engine-dwh-3.4.0-2.fc19.noarch ovirt-engine-reports-3.4.0-2.fc19.noarch
and also these 2 new packages installed ovirt-engine-dwh-setup-3.4.0-2.fc19.noarch ovirt-engine-reports-setup-3.4.0-2.fc19.noarch
2) patch as from http://gerrit.ovirt.org/#/c/26118/ and http://gerrit.ovirt.org/#/c/25998/
3) engine-setup (no more ovirt-engine-dwh-setup and ovirt-engine-reports-setup to run)
And if you have run 3) before 2) you have to remove the directory tree under /var/lib/ovirt-engine-reports/build-conf and run 2) and 3) again due to currently targeted for 3.4.1 bug: https://bugzilla.redhat.com/show_bug.cgi?id=1084749
Thank you for your help!
Alon.

On Sun, Apr 6, 2014 at 3:37 PM, Alon Bar-Lev <alonbl@redhat.com> wrote:
How can I reset the password of ovirt-admin? (previously I used it only at certain times and watched the clear text file /usr/share/ovirt-engine-reports/reports/users/ovirt-002dadmin.xml I forgot it ;-)
I think you can run:
# engine-setup --otopi-environment="OVESETUP_REPORTS_CONFIG/adminPassword=str:<password>"
the command went ok but not able to login with ovirt-admin. And the select from db gives the same encrypted password for ovirt-admin user, so I think it din't change the password. suppose my password is the word changeme I used the command engine-setup --otopi-environment="OVESETUP_REPORTS_CONFIG/adminPassword=str:changeme" is it ok? Also, it would be nice not to stop/reconfigure/start the whole engine only to change reports password....
At the end of the e-mail what I wrote as a summary and if right I can add into release notes...
Well, better to wait for 3.4.1 I think.
OK, but I think something needs to be written into release notes for 3.4. In fact at the moment you see this kind of index: https://drive.google.com/file/d/0BwoPbcrMv8mvQTlQQU8zdVdDeDQ/edit?usp=sharin... but actually there is no reference at all to reports and dwh and anyone who wants to setup and/or upgrade them would retain more than a doubt...
Thank you for your help!
Alon.
To tell it with Kevin Spacey words in his great film: When someone does you a big favor, don't pay it back... pay it forward I think it could be valid in IT too... not only in real life ;-) My forward will be to sponsor oVirt...

----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "users" <users@ovirt.org> Sent: Sunday, April 6, 2014 5:01:19 PM Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
On Sun, Apr 6, 2014 at 3:37 PM, Alon Bar-Lev <alonbl@redhat.com> wrote:
How can I reset the password of ovirt-admin? (previously I used it only at certain times and watched the clear text file /usr/share/ovirt-engine-reports/reports/users/ovirt-002dadmin.xml I forgot it ;-)
I think you can run:
# engine-setup --otopi-environment="OVESETUP_REPORTS_CONFIG/adminPassword=str:<password>"
the command went ok but not able to login with ovirt-admin. And the select from db gives the same encrypted password for ovirt-admin user, so I think it din't change the password.
Well, there may be shortcuts... using jasper magics.
suppose my password is the word changeme I used the command engine-setup --otopi-environment="OVESETUP_REPORTS_CONFIG/adminPassword=str:changeme"
is it ok? Also, it would be nice not to stop/reconfigure/start the whole engine only to change reports password....
Yes, can you please send me log file? I would like to see what happens, as far as I can see if this variable contain anything it should be put into database. Alon
participants (2)
-
Alon Bar-Lev
-
Gianluca Cecchi