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

2014-04-07 Thread Yaniv Dary
try to add:
# ./js-export.sh --users --output-dir 
-DmasterPropsSource=/var/lib/ovirt-engine-reports/build-conf


Yaniv

- Original Message -
 From: Gianluca Cecchi gianluca.cec...@gmail.com
 To: Yaniv Dary yd...@redhat.com
 Cc: Alon Bar-Lev alo...@redhat.com, users users@ovirt.org
 Sent: Sunday, April 6, 2014 9:57:35 PM
 Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
 
 On Sun, Apr 6, 2014 at 8:03 PM, Yaniv Dary yd...@redhat.com wrote:
 
  # cd /usr/share/jasperreports-server/buildomatic
  # export masterPropsSource=/var/lib/ovirt-engine-reports/build-conf
  # ./js-export.sh --users --output-dir  some folder 
 
  now edit password of the user you would like to change
 
  # ./js-import.sh --input-dir  same some folder 
 
 
 [sorry for the previous e-mail only sent to Yaniv]
 
 Hello, I get this during export:
 
 [root@tekkaman ~]# cd /usr/share/jasperreports-server/buildomatic
 [root@tekkaman buildomatic]# export
 masterPropsSource=/var/lib/ovirt-engine-reports/build-conf
 [root@tekkaman buildomatic]# mkdir /tmp/js_export
 [root@tekkaman buildomatic]# ./js-export.sh --users --output-dir
 /tmp/js_export
 Using CE setup
 First resource
 path:/usr/share/jasperreports-server/buildomatic/conf_source/ieCe/applicationContext-cascade.xml
 Started to load resources
 Resource name: applicationContext.xml
 Resource name: applicationContext-cascade.xml
 Resource name: applicationContext-data-snapshots.xml
 Resource name: applicationContext-events-logging.xml
 Resource name: applicationContext-export-config.xml
 Resource name: applicationContext-export-import.xml
 Resource name: applicationContext-logging.xml
 Resource name: applicationContext-olap-connection.xml
 Resource name: applicationContext-report-scheduling.xml
 Resource name: applicationContext-search.xml
 Resource name: applicationContext-security.xml
 Resource name: applicationContext-themes.xml
 Resource name: applicationContext-virtual-data-source.xml
 org.springframework.beans.factory.BeanInitializationException: Could
 not load properties; nested exception is
 java.io.FileNotFoundException: class path resource
 [js.jdbc.properties] cannot be opened because it does not exist
 org.springframework.beans.factory.BeanInitializationException: Could
 not load properties; nested exception is
 java.io.FileNotFoundException: class path resource
 [js.jdbc.properties] cannot be opened because it does not exist
 at
 org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:87)
 at
 org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:681)
 at
 org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:656)
 at
 org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:446)
 at
 com.jaspersoft.jasperserver.export.BaseExportImportCommand.createSpringContext(BaseExportImportCommand.java:129)
 at
 com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:82)
 at
 com.jaspersoft.jasperserver.export.ExportCommand.main(ExportCommand.java:43)
 Caused by: java.io.FileNotFoundException: class path resource
 [js.jdbc.properties] cannot be opened because it does not exist
 at
 org.springframework.core.io.ClassPathResource.getInputStream(ClassPathResource.java:158)
 at
 org.springframework.core.io.support.PropertiesLoaderSupport.loadProperties(PropertiesLoaderSupport.java:181)
 at
 org.springframework.core.io.support.PropertiesLoaderSupport.mergeProperties(PropertiesLoaderSupport.java:161)
 at
 org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:78)
 ... 6 more
 [root@tekkaman buildomatic]#
 
 do I have to install anything that normally is installed only on
 developer stations?
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


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

2014-04-06 Thread Gianluca Cecchi
On Sun, Apr 6, 2014 at 2:13 AM, Alon Bar-Lev alo...@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
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


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

2014-04-06 Thread Alon Bar-Lev


- Original Message -
 From: Gianluca Cecchi gianluca.cec...@gmail.com
 To: Alon Bar-Lev alo...@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 alo...@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
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


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

2014-04-06 Thread Gianluca Cecchi
On Sun, Apr 6, 2014 at 10:26 AM, Alon Bar-Lev alo...@redhat.com wrote:


 - Original Message -
 From: Gianluca Cecchi gianluca.cec...@gmail.com
 To: Alon Bar-Lev alo...@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 alo...@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=sharing

I suppose I have to remove again build-conf before proceedings with
other suggestions...

Gianluca
___
Users mailing

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

2014-04-06 Thread Gianluca Cecchi
On Sun, Apr 6, 2014 at 11:34 AM, Alon Bar-Lev alo...@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
___
Users mailing list
Users@ovirt.org

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

2014-04-06 Thread Alon Bar-Lev


- Original Message -
 From: Gianluca Cecchi gianluca.cec...@gmail.com
 To: Alon Bar-Lev alo...@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 alo...@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.
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


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

2014-04-06 Thread Alon Bar-Lev


- Original Message -
 From: Alon Bar-Lev alo...@redhat.com
 To: Gianluca Cecchi gianluca.cec...@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.cec...@gmail.com
  To: Alon Bar-Lev alo...@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 alo...@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.
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


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

2014-04-06 Thread Gianluca Cecchi
On Sun, Apr 6, 2014 at 3:37 PM, Alon Bar-Lev alo...@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=sharing

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...
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


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

2014-04-06 Thread Yaniv Dary


- Original Message -
 From: Yaniv Dary yd...@redhat.com
 To: Alon Bar-Lev alo...@redhat.com
 Cc: Gianluca Cecchi gianluca.cec...@gmail.com
 Sent: Sunday, April 6, 2014 8:53:46 PM
 Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
 
 
 
 - Original Message -
  From: Alon Bar-Lev alo...@redhat.com
  To: Yaniv Dary yd...@redhat.com
  Cc: Gianluca Cecchi gianluca.cec...@gmail.com
  Sent: Sunday, April 6, 2014 6:17:20 PM
  Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
  
  
  
  - Original Message -
   From: Gianluca Cecchi gianluca.cec...@gmail.com
   To: Alon Bar-Lev alo...@redhat.com
   Sent: Sunday, April 6, 2014 6:01:31 PM
   Subject: Re: [Users] Upgrading dwh and reports from 3.3.4 to 3.4.0?
   
   here it is
   https://drive.google.com/file/d/0BwoPbcrMv8mvM3AtTEJYQldMNFk/edit?usp=sharing
   
  
  Oh... so what happens is that we set the password you enter, but then we
  overwrite it with preserved password from initialization stage. So
  unfortunately, we cannot override admin password in this method.
  
  Yaniv, what is the procedure to reset jasper admin user? Do you want to
  support it via setup or you want some specific procedure for this?
 
 Export, set password in the file and then import.

# cd /usr/share/jasperreports-server/buildomatic
# export masterPropsSource=/var/lib/ovirt-engine-reports/build-conf
# ./js-export.sh --users --output-dir  some folder 

now edit password of the user you would like to change

# ./js-import.sh --input-dir  same some folder 

 
 
 
 Yaniv
 
  
  Alon
  
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


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

2014-04-06 Thread Gianluca Cecchi
On Sun, Apr 6, 2014 at 8:03 PM, Yaniv Dary yd...@redhat.com wrote:

 # cd /usr/share/jasperreports-server/buildomatic
 # export masterPropsSource=/var/lib/ovirt-engine-reports/build-conf
 # ./js-export.sh --users --output-dir  some folder 

 now edit password of the user you would like to change

 # ./js-import.sh --input-dir  same some folder 


[sorry for the previous e-mail only sent to Yaniv]

Hello, I get this during export:

[root@tekkaman ~]# cd /usr/share/jasperreports-server/buildomatic
[root@tekkaman buildomatic]# export
masterPropsSource=/var/lib/ovirt-engine-reports/build-conf
[root@tekkaman buildomatic]# mkdir /tmp/js_export
[root@tekkaman buildomatic]# ./js-export.sh --users --output-dir /tmp/js_export
Using CE setup
First resource 
path:/usr/share/jasperreports-server/buildomatic/conf_source/ieCe/applicationContext-cascade.xml
Started to load resources
Resource name: applicationContext.xml
Resource name: applicationContext-cascade.xml
Resource name: applicationContext-data-snapshots.xml
Resource name: applicationContext-events-logging.xml
Resource name: applicationContext-export-config.xml
Resource name: applicationContext-export-import.xml
Resource name: applicationContext-logging.xml
Resource name: applicationContext-olap-connection.xml
Resource name: applicationContext-report-scheduling.xml
Resource name: applicationContext-search.xml
Resource name: applicationContext-security.xml
Resource name: applicationContext-themes.xml
Resource name: applicationContext-virtual-data-source.xml
org.springframework.beans.factory.BeanInitializationException: Could
not load properties; nested exception is
java.io.FileNotFoundException: class path resource
[js.jdbc.properties] cannot be opened because it does not exist
org.springframework.beans.factory.BeanInitializationException: Could
not load properties; nested exception is
java.io.FileNotFoundException: class path resource
[js.jdbc.properties] cannot be opened because it does not exist
at 
org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:87)
at 
org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:681)
at 
org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:656)
at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:446)
at 
com.jaspersoft.jasperserver.export.BaseExportImportCommand.createSpringContext(BaseExportImportCommand.java:129)
at 
com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:82)
at com.jaspersoft.jasperserver.export.ExportCommand.main(ExportCommand.java:43)
Caused by: java.io.FileNotFoundException: class path resource
[js.jdbc.properties] cannot be opened because it does not exist
at 
org.springframework.core.io.ClassPathResource.getInputStream(ClassPathResource.java:158)
at 
org.springframework.core.io.support.PropertiesLoaderSupport.loadProperties(PropertiesLoaderSupport.java:181)
at 
org.springframework.core.io.support.PropertiesLoaderSupport.mergeProperties(PropertiesLoaderSupport.java:161)
at 
org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:78)
... 6 more
[root@tekkaman buildomatic]#

do I have to install anything that normally is installed only on
developer stations?
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


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

2014-04-05 Thread Alon Bar-Lev


- Original Message -
 From: Gianluca Cecchi gianluca.cec...@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.

 

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

2014-04-05 Thread Gianluca Cecchi
On Sat, Apr 5, 2014 at 10:43 PM, Alon Bar-Lev alo...@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=sharing




  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/reportsconstants.py,cm


 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=sharing

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


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

2014-04-05 Thread Alon Bar-Lev


- Original Message -
 From: Gianluca Cecchi gianluca.cec...@gmail.com
 To: Alon Bar-Lev alo...@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 alo...@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=sharing

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/reportsconstants.py,cm
 
 
  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=sharing
 
 Gianluca
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


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

2014-04-05 Thread Gianluca Cecchi
On Sat, Apr 5, 2014 at 11:54 PM, Alon Bar-Lev alo...@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=sharing

 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/

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
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


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

2014-04-05 Thread Alon Bar-Lev


- Original Message -
 From: Gianluca Cecchi gianluca.cec...@gmail.com
 To: Alon Bar-Lev alo...@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 alo...@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=sharing
 
  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/
 
 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
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


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

2014-04-05 Thread Alon Bar-Lev


- Original Message -
 From: Alon Bar-Lev alo...@redhat.com
 To: Gianluca Cecchi gianluca.cec...@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.cec...@gmail.com
  To: Alon Bar-Lev alo...@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 alo...@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=sharing
  
   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/
  
  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
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


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

2014-04-05 Thread Gianluca Cecchi
On Sun, Apr 6, 2014 at 12:09 AM, Alon Bar-Lev alo...@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=sharing

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
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


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

2014-04-05 Thread Alon Bar-Lev


- Original Message -
 From: Gianluca Cecchi gianluca.cec...@gmail.com
 To: Alon Bar-Lev alo...@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 alo...@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=sharing


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
 
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


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

2014-04-05 Thread Gianluca Cecchi
On Sun, Apr 6, 2014 at 1:25 AM, Alon Bar-Lev alo...@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.

 [1] http://gerrit.ovirt.org/#/c/25998/

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.5T.
/usr/share/ovirt-engine/setup/plugins/ovirt-engine-setup/ovirt-engine-dwh/legacy/config.py
-- the only one I expected
S.5T.
/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.5T.
/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.fc19ovirt-stable1.2
M
 ovirt-engine-dwh-setupnoarch
  3.4.0-2.fc19ovirt-stable 48
k
 ovirt-engine-reports  noarch
  3.4.0-2.fc19ovirt-stable1.0
M
 ovirt-engine-reports-setupnoarch
  3.4.0-2.fc19ovirt-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=sharing


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
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users


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

2014-04-05 Thread Alon Bar-Lev


- Original Message -
 From: Gianluca Cecchi gianluca.cec...@gmail.com
 To: Alon Bar-Lev alo...@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 alo...@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.
 
  [1] http://gerrit.ovirt.org/#/c/25998/
 
 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.5T.
 /usr/share/ovirt-engine/setup/plugins/ovirt-engine-setup/ovirt-engine-dwh/legacy/config.py
 -- the only one I expected
 S.5T.
 /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.5T.
 /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.fc19ovirt-stable1.2
 M
  ovirt-engine-dwh-setupnoarch
   3.4.0-2.fc19ovirt-stable 48
 k
  ovirt-engine-reports  noarch
   3.4.0-2.fc19ovirt-stable1.0
 M
  ovirt-engine-reports-setupnoarch
   3.4.0-2.fc19ovirt-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=sharing
 
 
 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