Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 256659

Summary: Tomcat Instance to Support BIRT
Product: Community Reporter: Scott Rosenbaum <scottr>
Component: EclipseConAssignee: Karl Matthias <karl.matthias>
Status: RESOLVED WONTFIX QA Contact:
Severity: normal    
Priority: P3 CC: jasonweathersby, karl.matthias, webmaster
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Whiteboard:

Description Scott Rosenbaum CLA 2008-11-26 10:53:19 EST
So far I have been generating reports about the conference using an off line copy of the database.  I would like to be able to have a Tomcat instance where I can install the BIRT war file so that I can run reports against the live database.  

I see this as useful to both the PC and to the scheduling effort.  In addition, I hope that I can offer the community to peruse the curriculum and have a look at the possible presentations in interesting ways using BIRT (if I can get around to it).  

I can provide the BIRT war file.  From that point, I would just need access to be able to upload to the reports directory in the exploded view of the war file.

Let me know what the next steps would entail.
Comment 1 Bjorn Freeman-Benson CLA 2008-11-26 12:28:06 EST
My concern here is privacy. I'm ok with providing you a Tomcat instance, but I'm really hesitant about providing a publicly available Tomcat instance running BIRT with full access to our live databases. We could, I suppose, build a shadow database, but then you're talking about real work that, realistically, isn't going to happen.
Comment 2 Scott Rosenbaum CLA 2008-11-26 12:52:47 EST
What if we have the BIRT instance hidden behind a web page that is serving up PDF files based on report type?  

We can control the reports that are published to the server, since I would be the only one committing reports to the server we know that the reports would only expose the data that we feel is appropriate.

If you want to go with a more secure solution, Actuate has volunteered an instance of their iServerExpress product for the duration of the conference.  Using their product we could lock down the read, write, and run options based to really control the content.  An added benefit of the iServerExpress is that it would be easy to add reporting content into the PHP site through the JavaScript API.  

I am not trying to make this a plug for Actuate's commercial products, I just know that they have built much of the functionality that we would want to have.

Comment 3 Bjorn Freeman-Benson CLA 2008-11-26 13:57:05 EST
(In reply to comment #2)
> We can control the reports that are published to the server, since I would be
> the only one committing reports to the server we know that the reports would
> only expose the data that we feel is appropriate.

As long as you are the only one committing reports (or the program committee are the only people committing reports), then I'll be fine. But I don't want to open it to anyone in the community without a deeper consideration of the data privacy issues.
Comment 4 Scott Rosenbaum CLA 2008-11-26 14:08:38 EST
That would work for me.  If it makes sense we can use some form of promotion scheme that moves things in and out of CVS, I just don't know what infrastructure is in place to support this.

I have included Jason Weathersby since he may have some thoughts on the best way to manage this as a secure BIRT Viewer instance.
Comment 5 Karl Matthias CLA 2008-11-26 14:23:40 EST
Hey Scott, I appreciate the offers of assistance.  But with all of the balls we have in the air this EclipseCon season and the limited resources we have, we're just not going to be able to make this happen.  If this kind of reporting continues to be a necessary part of planning for future EclipseCons, then we'll figure out a way to plan that into our time allocation.  I'm sorry we just didn't do that this time around.  It requires a lot of security work to implement this well in our infrastructure and that's really the time sink.  I'm sorry if this causes you any inconvenience.  

The nightly database snapshots could be made twice daily if it would help you out.  Just let me know.
Comment 6 Scott Rosenbaum CLA 2008-11-26 14:41:52 EST
I heard no, but I need a little clarification of what is and is not possible in the four months between now and the conference.  

Are you saying that there is no way for us to have a BIRT Web Viewer running on Tomcat?

Are you saying no we can't have the promotion?

Are you saying there is no way for us to get anything?
Comment 7 Karl Matthias CLA 2008-11-26 15:03:18 EST
(In reply to comment #6)
> I heard no, but I need a little clarification of what is and is not possible in
> the four months between now and the conference.  
> 
> Are you saying that there is no way for us to have a BIRT Web Viewer running on
> Tomcat?
> 
> Are you saying no we can't have the promotion?
> 
> Are you saying there is no way for us to get anything?

Scott, as I read this there is one issue and I'm not clear where it breaks down into parts.  We cannot setup a live reporting system using Tomcat for this conference.  Not a hidden Tomcat or a public one.  It's not clear to me why or how a CVS promotion to production system would be helpful without that.
Comment 8 Karl Matthias CLA 2008-12-19 19:24:01 EST
Scott, are Tomcat 5.0.28 and Java JDK 1.5.0.09 good enough to run this?  Those are already installed and running the 2005 website on this server.
Comment 9 Scott Rosenbaum CLA 2008-12-22 09:59:26 EST
That will work great.

Scott
Comment 10 Karl Matthias CLA 2008-12-22 12:24:12 EST
Excellent, Scott, that really saves some time and resources.
Comment 11 Karl Matthias CLA 2009-04-14 12:28:48 EDT
We did this a different way.  Closing.