Re: [Users] engine reports and dwh setup in 3.3.2
On Thu, Jan 16, 2014 at 4:57 PM, Yaniv Dary wrote: The oVirt 3.3.3 release should be working for all install and upgrade flows. Please use that on your setup once it's released. Yaniv - Original Message - From: Yaniv Dary yd...@redhat.com To: Gianluca Cecchi gianluca.cec...@gmail.com Cc: users users@ovirt.org Sent: Sunday, January 5, 2014 3:54:40 PM Subject: Re: [Users] engine reports and dwh setup in 3.3.2 - Original Message - From: Gianluca Cecchi gianluca.cec...@gmail.com To: Yaniv Dary yd...@redhat.com Cc: users users@ovirt.org Sent: Saturday, January 4, 2014 12:59:46 AM Subject: Re: [Users] engine reports and dwh setup in 3.3.2 On Wed, Dec 25, 2013 at 1:00 AM, Yaniv Dary wrote: Hi, We have found a few blockers on the setup of dwh and reports. We hope to resolve the issues in the next few days. If you restore your environment using the backups, you will be able to upgrade. I've put a note to let you know when new packages are available. Ok, I'll wait good news about these items Just a question: when you write about blockers, are you referring to updates only or also to new setups directly made in 3.3.2 environments? Local fresh installs should work and upgrades\remote fresh install will not probably. thanks in advance, Gianluca Just to note that on my oVirt 3.3.2-1 allinone on fedora 19, after enabling updates-testing I get the same failure using 3.3.3rc [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-20140129214203.log Version: otopi-1.1.2 (otopi-1.1.2-1.fc19) [ INFO ] Stage: Environment packages setup [ INFO ] Stage: Programs detection [ INFO ] Stage: Environment setup [ INFO ] Stage: Environment customization --== PACKAGES ==-- [ INFO ] Checking for product updates... Setup has found updates for some packages, do you wish to update them now? (Yes, No) [Yes]: [ INFO ] Checking for an update for Setup... --== 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 ==-- --== OVIRT ENGINE CONFIGURATION ==-- Skipping storing options as database already prepared --== PKI CONFIGURATION ==-- PKI is already configured --== APACHE CONFIGURATION ==-- --== SYSTEM CONFIGURATION ==-- --== END OF CONFIGURATION ==-- [ INFO ] Stage: Setup validation During execution engine service will be stopped (OK, Cancel) [OK]: [ INFO ] Cleaning stale zombie tasks --== CONFIGURATION PREVIEW ==-- Database name : engine Database secured connection: False Database host : localhost Database user name : engine Database host name validation : False Datbase 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 Upgrade packages : True Please confirm installation settings (OK, Cancel) [OK]: [ INFO ] Cleaning async tasks and compensations [ INFO ] Checking the DB consistency [ INFO ] Stage: Transaction setup [ INFO ] Stopping engine service [ INFO ] Stopping websocket-proxy service [ INFO ] Stage: Misc configuration [ INFO ] Fixing DB inconsistencies [ INFO ] Stage: Package installation [ INFO ] Yum Status: Downloading Packages [ INFO ] Yum Download/Verify: ovirt-engine-3.3.3-1.fc19.noarch [ INFO ] Yum Downloading: (2/8): ovirt-engine-backend-3.3.3-1.fc19.noarch.rpm 1.6 M(44%) [ INFO ] Yum Downloading: (2/8): ovirt-engine-backend-3.3.3-1.fc19.noarch.rpm 2.8 M(76%) [ INFO ] Yum Download/Verify: ovirt-engine-backend-3.3.3-1.fc19.noarch [ INFO ] Yum Download/Verify: ovirt-engine-dbscripts-3.3.3-1.fc19.noarch [ INFO ] Yum Downloading: (4/8): ovirt
Re: [Users] engine reports and dwh setup in 3.3.2
On Wed, Jan 29, 2014 at 10:49 PM, Gianluca Cecchi wrote: [ INFO ] Backing up database to '/var/lib/ovirt-engine/backups/engine-20140129223909.I3iTp5.sql'. [ INFO ] Updating database schema [ ERROR ] Failed to execute stage 'Misc configuration': [Errno 2] No such file or directory: '/var/lib/ovirt-engine/deployments/ovirt-engine-reports.war' [ INFO ] Yum Performing yum transaction rollback Is the patch to be put yet for final 3.3.3? Or will there be any particular note in release (for example to deinstall reports..)? Gianluca Note that my current situation is: [root@tekkaman ~]# ll /var/lib/ovirt-engine/deployments total 8 lrwxrwxrwx. 1 root root 34 Jan 7 2013 engine.ear - /usr/share/ovirt-engine/engine.ear -rw-r--r--. 1 ovirt ovirt 10 Dec 21 12:28 engine.ear.deployed lrwxrwxrwx. 1 root root 48 Feb 19 2013 ovirt-engine-reports.war - /usr/share/ovirt-engine/ovirt-engine-reports.war -rw-r--r--. 1 ovirt ovirt 24 Dec 21 15:43 ovirt-engine-reports.war.dodeploy with /usr/share/ovirt-engine/ovirt-engine-reports.war being a broken link [root@tekkaman ~]# ll /usr/share/ovirt-engine total 52 drwxr-xr-x. 2 root root 4096 Jan 29 22:38 bin drwxr-xr-x. 3 root root 4096 Jan 21 11:10 branding drwxr-xr-x. 2 root root 4096 Jan 21 11:10 conf drwxr-xr-x. 3 root root 4096 Jan 29 22:39 dbscripts drwxr-xr-x. 8 ovirt ovirt 4096 Jan 29 22:38 engine.ear drwxr-xr-x. 2 root root 4096 Jan 29 22:38 files drwxr-xr-x. 4 root root 4096 Jan 21 11:10 firewalld drwxr-xr-x. 2 root root 4096 Jan 29 22:38 manual drwxr-xr-x. 4 root root 4096 Jan 21 11:10 modules drwxr-xr-x. 3 root root 4096 Nov 24 20:51 scripts drwxr-xr-x. 5 root root 4096 Jan 21 11:10 services drwxr-xr-x. 6 root root 4096 Jan 21 11:10 setup drwxr-xr-x. 2 root root 4096 Jan 21 11:10 ui-plugins Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
- Original Message - From: Gianluca Cecchi gianluca.cec...@gmail.com To: Yaniv Dary yd...@redhat.com Cc: users users@ovirt.org Sent: Wednesday, January 29, 2014 11:49:04 PM Subject: Re: [Users] engine reports and dwh setup in 3.3.2 Just to note that on my oVirt 3.3.2-1 allinone on fedora 19, after enabling updates-testing I get the same failure using 3.3.3rc Can it be that the following is dead symlink? if so please remove. /var/lib/ovirt-engine/deployments/ovirt-engine-reports.war ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
On Wed, Jan 29, 2014 at 10:55 PM, Alon Bar-Lev wrote: - Original Message - From: Gianluca Cecchi To: Yaniv Dary Cc: users users@ovirt.org Sent: Wednesday, January 29, 2014 11:49:04 PM Subject: Re: [Users] engine reports and dwh setup in 3.3.2 Just to note that on my oVirt 3.3.2-1 allinone on fedora 19, after enabling updates-testing I get the same failure using 3.3.3rc Can it be that the following is dead symlink? if so please remove. /var/lib/ovirt-engine/deployments/ovirt-engine-reports.war I confirm that - rollback (made automatically during the failed engine-setup first run) - rm /var/lib/ovirt-engine/deployments/ovirt-engine-reports.war - engine-setup again now it completes correctly Probably it is worth to put a note in release notes. But I don't know where: http://wiki.ovirt.org/OVirt_3.3.3_release_notes or http://wiki.ovirt.org/OVirt_3.2_to_3.3_upgrade ? Because I previously used (in December I think) the latest link to migrate from f18+3.2 to f19+3.3.2 Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
- Original Message - From: Gianluca Cecchi gianluca.cec...@gmail.com To: Alon Bar-Lev alo...@redhat.com Cc: Yaniv Dary yd...@redhat.com, users users@ovirt.org Sent: Thursday, January 30, 2014 12:20:46 AM Subject: Re: [Users] engine reports and dwh setup in 3.3.2 On Wed, Jan 29, 2014 at 10:55 PM, Alon Bar-Lev wrote: - Original Message - From: Gianluca Cecchi To: Yaniv Dary Cc: users users@ovirt.org Sent: Wednesday, January 29, 2014 11:49:04 PM Subject: Re: [Users] engine reports and dwh setup in 3.3.2 Just to note that on my oVirt 3.3.2-1 allinone on fedora 19, after enabling updates-testing I get the same failure using 3.3.3rc Can it be that the following is dead symlink? if so please remove. /var/lib/ovirt-engine/deployments/ovirt-engine-reports.war I confirm that - rollback (made automatically during the failed engine-setup first run) - rm /var/lib/ovirt-engine/deployments/ovirt-engine-reports.war - engine-setup again now it completes correctly Probably it is worth to put a note in release notes. But I don't know where: http://wiki.ovirt.org/OVirt_3.3.3_release_notes or http://wiki.ovirt.org/OVirt_3.2_to_3.3_upgrade ? Because I previously used (in December I think) the latest link to migrate from f18+3.2 to f19+3.3.2 I guess both... as people can upgrade directly to 3.3.3 ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
- Original Message - From: Gianluca Cecchi gianluca.cec...@gmail.com To: Sandro Bonazzola sbona...@redhat.com Cc: Yaniv Dary yd...@redhat.com, users users@ovirt.org Sent: Saturday, January 18, 2014 12:32:36 AM Subject: Re: [Users] engine reports and dwh setup in 3.3.2 On Fri, Jan 17, 2014 at 12:10 PM, Gianluca Cecchi wrote: engine web admin available and reportsportal too but the password set up during first broken install for ovirt-admin user doesn't work Invalid credentials supplied. Could not login to JasperReports Server. Any hints on how to solve? Manually change in Postgres? Ok, digging into /bin/ovirt-engine-reports-setup I see that actually the password is written in clear text inside file /usr/share/ovirt-engine-reports/reports/users/ovirt-002dadmin.xml This was only due to setup failing in the middle, this is improved in 3.4 and you won't see that anymore. Not a great security choice, also because the file is currently readable by everyone on the system (and rpm -qVv doesn't complain about its permissions). I was then able to connect to reports portal and to see some output reports... Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
On Sun, Jan 26, 2014 at 4:29 PM, Yaniv Dary wrote: - Original Message - From: Gianluca Cecchi [snip] Ok, digging into /bin/ovirt-engine-reports-setup I see that actually the password is written in clear text inside file /usr/share/ovirt-engine-reports/reports/users/ovirt-002dadmin.xml This was only due to setup failing in the middle, this is improved in 3.4 and you won't see that anymore. Not a great security choice, also because the file is currently readable by everyone on the system (and rpm -qVv doesn't complain about its permissions). I was then able to connect to reports portal and to see some output reports... Gianluca Ok. see also my NOTES from the previous e-mail about possible improvements: Thanks Gianluca NOTES: - keep an eye about ovirt-engine not restarted after reports setup error, not a good thing IMHO - in patched file I see some lines above logging.debug(Imporing users) without the t So when it happens to further modify the file you can put this type fix too... - in main reports page if you click on Need help logging in? link, the pop-up says rhevm-admin instead of what setup specified as ovirt-admin (none of these logins works: (Please choose a password for the reports admin user(s) (ovirt-admin): ) ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
On Thu, Jan 16, 2014 at 5:55 PM, Yaniv Dary wrote: I think a this point it is safe to install. If I can go, can I use https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.3-Beta/html/Installation_Guide/Installing_and_Configuring_the_History_Database.html as a workflow input? (with changes where needed, as rhevm-dwh -- ovirt-engine-dwh) You can try it, but not sure everything will be applicable. Let me know so that I can try Gianluca dwh part went ok and ovirt_engine_history db was created. The reports part got error # ovirt-engine-reports-setup Welcome to ovirt-engine-reports setup utility In order to proceed the installer must stop the ovirt-engine service Would you like to stop the ovirt-engine service (yes|no): yes Stopping ovirt-engine... [ DONE ] Editing XML files... [ DONE ] Setting DB connectivity...[ DONE ] Please choose a password for the reports admin user(s) (ovirt-admin): Warning: Weak Password. Retype password: Warning: Weak Password. Deploying Server... [ DONE ] Updating Redirect Servlet... [ DONE ] Importing reports... [ DONE ] Customizing Server... [ DONE ] global name 'preserveReportsJobs' is not defined Error encountered while installing ovirt-engine-reports, please consult the log file: /var/log/ovirt-engine/ovirt-engine-reports-setup-2014_01_17_11_20_29.log It seems the main point in log file, as in standard output is this: 2014-01-17 11:22:22::ERROR::ovirt-engine-reports-setup::1196::root:: Failed to complete the setup of the reports package! 2014-01-17 11:22:22::DEBUG::ovirt-engine-reports-setup::1197::root:: Traceback (most recent call last): File /bin/ovirt-engine-reports-setup, line 1163, in main if preserveReportsJobs: NameError: global name 'preserveReportsJobs' is not defined Let me know if you need full logs or if this is sufficient to debug code and propose a solution to try then again. Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
Il 17/01/2014 11:40, Gianluca Cecchi ha scritto: On Thu, Jan 16, 2014 at 5:55 PM, Yaniv Dary wrote: I think a this point it is safe to install. If I can go, can I use https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.3-Beta/html/Installation_Guide/Installing_and_Configuring_the_History_Database.html as a workflow input? (with changes where needed, as rhevm-dwh -- ovirt-engine-dwh) You can try it, but not sure everything will be applicable. Let me know so that I can try Gianluca dwh part went ok and ovirt_engine_history db was created. The reports part got error # ovirt-engine-reports-setup Welcome to ovirt-engine-reports setup utility In order to proceed the installer must stop the ovirt-engine service Would you like to stop the ovirt-engine service (yes|no): yes Stopping ovirt-engine... [ DONE ] Editing XML files... [ DONE ] Setting DB connectivity...[ DONE ] Please choose a password for the reports admin user(s) (ovirt-admin): Warning: Weak Password. Retype password: Warning: Weak Password. Deploying Server... [ DONE ] Updating Redirect Servlet... [ DONE ] Importing reports... [ DONE ] Customizing Server... [ DONE ] global name 'preserveReportsJobs' is not defined Error encountered while installing ovirt-engine-reports, please consult the log file: /var/log/ovirt-engine/ovirt-engine-reports-setup-2014_01_17_11_20_29.log It seems the main point in log file, as in standard output is this: 2014-01-17 11:22:22::ERROR::ovirt-engine-reports-setup::1196::root:: Failed to complete the setup of the reports package! 2014-01-17 11:22:22::DEBUG::ovirt-engine-reports-setup::1197::root:: Traceback (most recent call last): File /bin/ovirt-engine-reports-setup, line 1163, in main if preserveReportsJobs: NameError: global name 'preserveReportsJobs' is not defined This has been fixed yesterday http://gerrit.ovirt.org/#/c/23304/ Let me know if you need full logs or if this is sufficient to debug code and propose a solution to try then again. Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users -- Sandro Bonazzola Better technology. Faster innovation. Powered by community collaboration. See how it works at redhat.com ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
On 01/17/2014 12:50 PM, Sandro Bonazzola wrote: Il 17/01/2014 11:40, Gianluca Cecchi ha scritto: On Thu, Jan 16, 2014 at 5:55 PM, Yaniv Dary wrote: I think a this point it is safe to install. If I can go, can I use https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.3-Beta/html/Installation_Guide/Installing_and_Configuring_the_History_Database.html as a workflow input? (with changes where needed, as rhevm-dwh -- ovirt-engine-dwh) You can try it, but not sure everything will be applicable. Let me know so that I can try Gianluca dwh part went ok and ovirt_engine_history db was created. The reports part got error # ovirt-engine-reports-setup Welcome to ovirt-engine-reports setup utility In order to proceed the installer must stop the ovirt-engine service Would you like to stop the ovirt-engine service (yes|no): yes Stopping ovirt-engine... [ DONE ] Editing XML files... [ DONE ] Setting DB connectivity...[ DONE ] Please choose a password for the reports admin user(s) (ovirt-admin): Warning: Weak Password. Retype password: Warning: Weak Password. Deploying Server... [ DONE ] Updating Redirect Servlet... [ DONE ] Importing reports... [ DONE ] Customizing Server... [ DONE ] global name 'preserveReportsJobs' is not defined Error encountered while installing ovirt-engine-reports, please consult the log file: /var/log/ovirt-engine/ovirt-engine-reports-setup-2014_01_17_11_20_29.log It seems the main point in log file, as in standard output is this: 2014-01-17 11:22:22::ERROR::ovirt-engine-reports-setup::1196::root:: Failed to complete the setup of the reports package! 2014-01-17 11:22:22::DEBUG::ovirt-engine-reports-setup::1197::root:: Traceback (most recent call last): File /bin/ovirt-engine-reports-setup, line 1163, in main if preserveReportsJobs: NameError: global name 'preserveReportsJobs' is not defined This has been fixed yesterday http://gerrit.ovirt.org/#/c/23304/ this is only merged in master. yaniv - which version is going to 3.3.3 - the otopi one? Let me know if you need full logs or if this is sufficient to debug code and propose a solution to try then again. Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
On Fri, Jan 17, 2014 at 12:10 PM, Gianluca Cecchi wrote: engine web admin available and reportsportal too but the password set up during first broken install for ovirt-admin user doesn't work Invalid credentials supplied. Could not login to JasperReports Server. Any hints on how to solve? Manually change in Postgres? Ok, digging into /bin/ovirt-engine-reports-setup I see that actually the password is written in clear text inside file /usr/share/ovirt-engine-reports/reports/users/ovirt-002dadmin.xml Not a great security choice, also because the file is currently readable by everyone on the system (and rpm -qVv doesn't complain about its permissions). I was then able to connect to reports portal and to see some output reports... Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
The oVirt 3.3.3 release should be working for all install and upgrade flows. Please use that on your setup once it's released. Yaniv - Original Message - From: Yaniv Dary yd...@redhat.com To: Gianluca Cecchi gianluca.cec...@gmail.com Cc: users users@ovirt.org Sent: Sunday, January 5, 2014 3:54:40 PM Subject: Re: [Users] engine reports and dwh setup in 3.3.2 - Original Message - From: Gianluca Cecchi gianluca.cec...@gmail.com To: Yaniv Dary yd...@redhat.com Cc: users users@ovirt.org Sent: Saturday, January 4, 2014 12:59:46 AM Subject: Re: [Users] engine reports and dwh setup in 3.3.2 On Wed, Dec 25, 2013 at 1:00 AM, Yaniv Dary wrote: Hi, We have found a few blockers on the setup of dwh and reports. We hope to resolve the issues in the next few days. If you restore your environment using the backups, you will be able to upgrade. I've put a note to let you know when new packages are available. Ok, I'll wait good news about these items Just a question: when you write about blockers, are you referring to updates only or also to new setups directly made in 3.3.2 environments? Local fresh installs should work and upgrades\remote fresh install will not probably. thanks in advance, Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
On Thu, Jan 16, 2014 at 4:57 PM, Yaniv Dary wrote: The oVirt 3.3.3 release should be working for all install and upgrade flows. Please use that on your setup once it's released. I have just updated another infra (not all-in-one) from 3.3.2 to 3.3.3.beta1. It is an environment on f19. One engine + 2 hosts There are currently no reports/dwh installed at all Can I go with install/test or do I have to wait rc and/or final 3.3.3? If I can go, can I use https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.3-Beta/html/Installation_Guide/Installing_and_Configuring_the_History_Database.html as a workflow input? (with changes where needed, as rhevm-dwh -- ovirt-engine-dwh) Let me know so that I can try Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
- Original Message - From: Gianluca Cecchi gianluca.cec...@gmail.com To: Yaniv Dary yd...@redhat.com Cc: users users@ovirt.org Sent: Thursday, January 16, 2014 6:19:57 PM Subject: Re: [Users] engine reports and dwh setup in 3.3.2 On Thu, Jan 16, 2014 at 4:57 PM, Yaniv Dary wrote: The oVirt 3.3.3 release should be working for all install and upgrade flows. Please use that on your setup once it's released. I have just updated another infra (not all-in-one) from 3.3.2 to 3.3.3.beta1. It is an environment on f19. One engine + 2 hosts There are currently no reports/dwh installed at all Can I go with install/test or do I have to wait rc and/or final 3.3.3? I think a this point it is safe to install. If I can go, can I use https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.3-Beta/html/Installation_Guide/Installing_and_Configuring_the_History_Database.html as a workflow input? (with changes where needed, as rhevm-dwh -- ovirt-engine-dwh) You can try it, but not sure everything will be applicable. Let me know so that I can try Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
- Original Message - From: Gianluca Cecchi gianluca.cec...@gmail.com To: Yaniv Dary yd...@redhat.com Cc: users users@ovirt.org Sent: Saturday, January 4, 2014 12:59:46 AM Subject: Re: [Users] engine reports and dwh setup in 3.3.2 On Wed, Dec 25, 2013 at 1:00 AM, Yaniv Dary wrote: Hi, We have found a few blockers on the setup of dwh and reports. We hope to resolve the issues in the next few days. If you restore your environment using the backups, you will be able to upgrade. I've put a note to let you know when new packages are available. Ok, I'll wait good news about these items Just a question: when you write about blockers, are you referring to updates only or also to new setups directly made in 3.3.2 environments? Local fresh installs should work and upgrades\remote fresh install will not probably. thanks in advance, Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
On Wed, Dec 25, 2013 at 1:00 AM, Yaniv Dary wrote: Hi, We have found a few blockers on the setup of dwh and reports. We hope to resolve the issues in the next few days. If you restore your environment using the backups, you will be able to upgrade. I've put a note to let you know when new packages are available. Ok, I'll wait good news about these items Just a question: when you write about blockers, are you referring to updates only or also to new setups directly made in 3.3.2 environments? thanks in advance, Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
Hello, as my past data are not important, is there at least any way to start from scratch with Dwh and Reports, reinitializing my current situation? Is it as simple as drop the two databases ovirtenginereports and ovirt_engine_history or are there any other steps to perform? Thanks in advance, Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] engine reports and dwh setup in 3.3.2
- Original Message - From: Gianluca Cecchi gianluca.cec...@gmail.com To: users users@ovirt.org Sent: Tuesday, December 24, 2013 3:46:08 PM Subject: Re: [Users] engine reports and dwh setup in 3.3.2 Hello, as my past data are not important, is there at least any way to start from scratch with Dwh and Reports, reinitializing my current situation? Is it as simple as drop the two databases ovirtenginereports and ovirt_engine_history or are there any other steps to perform? Hi, We have found a few blockers on the setup of dwh and reports. We hope to resolve the issues in the next few days. If you restore your environment using the backups, you will be able to upgrade. I've put a note to let you know when new packages are available. Yaniv Thanks in advance, Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[Users] engine reports and dwh setup in 3.3.2
Hello, I have some questions regarding wheat in subject fro 3.3.2. In November I upgraded my AIO install from fc18 3.2.3 to fc19 3.3.1 following: http://www.ovirt.org/OVirt_3.2_to_3.3_upgrade All went ok. In Fc18 reports and DWH worked ok if I rememebr correctly. Probably in November I didn't run any setup again for dwh and reports... after upgrade This is a test/home server Today I updated to 3.3.2 without problems and tried upgrade of dwh and reports too. One problem I found is that upgrading from f18 to f19, now my postgres user cannot directly connect to db without password. I see that my pg_hba.conf is now this way local all all md5 hostovirtenginereports engine_reports 0.0.0.0/0 md5 hostovirtenginereports engine_reports ::0/0 md5 hostall all 127.0.0.1/32md5 hostall all ::1/128 md5 so that running ovirt-engine-dwh-setup aborted because of db connections such as 2013-12-21 14:27:47::DEBUG::common_utils::908::root:: retcode = 0 2013-12-21 14:27:47::DEBUG::common_utils::864::root:: Executing command -- '/bin/su -l postgres -c /usr/bin/psql -U postgres -d template1 -tAc select 1;' in working directory '/root' 2013-12-21 14:27:47::DEBUG::common_utils::906::root:: output = 2013-12-21 14:27:47::DEBUG::common_utils::907::root:: stderr = Password for user postgres: psql: fe_sendauth: no password supplied I temporarily solved putting this entry for unix domains local access in my pg-hba.conf and restarting the db service local all postgres trust and dwh setup completed ok with this ouptut below where I see a possible bug in the initial username request But what if a fresh install? Would the setup give the same error for default fc19 restricted postgres setup? Also, It asks me if I want to create it and instead of asking the username it suddenly outputs an error also at first input But then it asks the username again and all goes well. The first request shouldn't give error... [root@tekkaman ~]# ovirt-engine-dwh-setup Welcome to ovirt-engine-dwh setup utility This utility can configure a read only user for DB access. Would you like to do so? (yes|no): yes Error: user name cannot be empty Provide a username for read-only user : ovirt_ruser Provide a password for read-only user: Warning: Weak Password. Re-type password: Should postgresql be setup with secure connection? (yes|no): yes Existing DB was found on the system. The size of the detected DB is 27 MB, free space in the backup folder /var/lib/ovirt-engine/backups is approximately 10.0 GB. The upgrade utility can backup the existing database. The time and space required for the database backup depend on its size. The detected DB size is 27 MB. This process takes time, and in some cases (for instance, when the size is few GBs) may take few hours to complete. Would you like to continue and backup the existing database? Answering no will skip the backup step and continue the upgrade without backing up the database (yes|no): yes Are you sure you would like to continue and backup database ovirt_engine_history? Answering no will stop the upgrade (yes|no): yes Backing up the DB... [ DONE ] Upgrade DB... [ DONE ] Creating read-only user...[ DONE ] Setting DB connectivity...[ DONE ] Starting ovirt-engine... [ DONE ] Starting oVirt-ETL... [ DONE ] Successfully installed ovirt-engine-dwh. The installation log file is available at: /var/log/ovirt-engine/ovirt-engine-dwh-setup-2013_12_21_14_56_37.log The DB was backed up as '/var/lib/ovirt-engine/backups/ovirt-engine-history.backup.2013_12_21_14_58_21' The DB backup was created with compression. You must use pg_restore command if you need to recover the DB from the backup. For reports setup I got instead this kind of error in war deploy [root@tekkaman ~]# ovirt-engine-reports-setup Welcome to ovirt-engine-reports setup utility In order to proceed the installer must stop the ovirt-engine service Would you like to stop the ovirt-engine service (yes|no): yes Stopping ovirt-engine... [ DONE ] Editing XML files... [ DONE ] Setting DB connectivity...[ DONE ] Exporting scheduled reports...[ DONE ] Exporting current users...[ DONE ] Deploying Server... [ ERROR ] Failed step import-minimal-ce of JasperReports Server Error encountered while installing ovirt-engine-reports, please consult the log file: /var/log/ovirt-engine/ovirt-engine-reports-setup-2013_12_21_14_59_36.log and in log [advanced-sql] Executing resource: