[rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)]

Alex Rhys-Hurn alex at itworx.co.ke
Sat Apr 28 15:34:17 EDT 2012


Hi Benjamin, 

Sorry to be a bother, but I am really struggling with this install. 

The background: The machine is ubuntu 10.04 LTS. I have installed maven with apt-get maven2 I also apt-get install build-essential and apt-get install openjdk-6-jdk. I installed the jasperserver with the combined jasper stack for ubuntu. Jasper is working properly. 

I now have connectivity to your servers (there is an undersea fibre cable cut to my coutry at the moment) , my ISP has failed over to other international links. 

but now I see all sorts of errors in the first stages of mvn install as below: 

Then things fail to build. 

I apologise for being dumb with this but I am a networks guy and this is my first time to build any java kind of thing. I have found that I need to remove the .m2 directory and the whole RT-REST directories when I want to clean up and try again. 

Any tips are appreciated. 

root at core ~/RT-REST# mvn install 
[INFO] Scanning for projects... 
Downloading: https://services.boksa.de/maven/repositories/boksa/de/boksa/maven/defaults/maven-default-pom/0.1.0/maven-default-pom-0.1.0.pom 
4K downloaded (maven-default-pom-0.1.0.pom) 
Downloading: https://services.boksa.de/maven/repositories/boksa/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.pom 
[INFO] Unable to find resource 'org.apache.maven.wagon:wagon-ssh:pom:1.0' in repository boksa-repository (https://services.boksa.de/maven/repositories/boksa) 
Downloading: http://repo1.maven.org/maven2/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.pom 

[WARNING] *** CHECKSUM FAILED - Checksum failed on download: local = 'ad2eb5e1bb1de5e9347cbd9178c9dd8034eb0d0f'; remote = '<!DOCTYPE' - RETRYING 
Downloading: http://repo1.maven.org/maven2/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.pom 

[WARNING] *** CHECKSUM FAILED - Checksum failed on download: local = '67f056ad160d74130ae07ad6133d0c5a55293e2e'; remote = '<!DOCTYPE' - IGNORING 
[WARNING] POM for 'org.apache.maven.wagon:wagon-ssh:pom:1.0:runtime' is invalid. 

Its dependencies (if any) will NOT be available to the current build. 
Downloading: https://services.boksa.de/maven/repositories/boksa/org/codehaus/plexus/plexus-utils/1.1/plexus-utils-1.1.pom 
[INFO] Unable to find resource 'org.codehaus.plexus:plexus-utils:pom:1.1' in repository boksa-repository (https://services.boksa.de/maven/repositories/boksa) 
Downloading: http://repo1.maven.org/maven2/org/codehaus/plexus/plexus-utils/1.1/plexus-utils-1.1.pom 

Downloading: https://services.boksa.de/maven/repositories/boksa/org/codehaus/plexus/plexus/1.0.4/plexus-1.0.4.pom 
[INFO] Unable to find resource 'org.codehaus.plexus:plexus:pom:1.0.4' in repository boksa-repository (https://services.boksa.de/maven/repositories/boksa) 
Downloading: http://repo1.maven.org/maven2/org/codehaus/plexus/plexus/1.0.4/plexus-1.0.4.pom 

Downloading: https://services.boksa.de/maven/repositories/boksa/org/codehaus/plexus/plexus-utils/1.1/plexus-utils-1.1.jar 
Downloading: https://services.boksa.de/maven/repositories/boksa/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.jar 
[INFO] Unable to find resource 'org.codehaus.plexus:plexus-utils:jar:1.1' in repository boksa-repository (https://services.boksa.de/maven/repositories/boksa) 
Downloading: http://repo1.maven.org/maven2/org/codehaus/plexus/plexus-utils/1.1/plexus-utils-1.1.jar 
[INFO] Unable to find resource 'org.apache.maven.wagon:wagon-ssh:jar:1.0' in repository boksa-repository (https://services.boksa.de/maven/repositories/boksa) 
Downloading: http://repo1.maven.org/maven2/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.jar 

[WARNING] *** CHECKSUM FAILED - Checksum failed on download: local = '7292de5afb0da59af2adc323dd29f5e62c3a27b6'; remote = '<!DOCTYPE' - RETRYING 
Downloading: http://repo1.maven.org/maven2/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.jar 

[WARNING] *** CHECKSUM FAILED - Checksum failed on download: local = '3e456700be9f7ad363f06d772ee2c2a5ed0e192d'; remote = '<!DOCTYPE' - IGNORING 

[INFO] ------------------------------------------------------------------------ 
[INFO] Building Unnamed - de.boksa.rt:rt-rest:jar:0.0.1-SNAPSHOT 
[INFO] task-segment: [install] 
[INFO] ------------------------------------------------------------------------ 
Downloading: http://repo1.maven.org/maven2/org/apache/maven/plugins/maven-resources-plugin/2.5/maven-resources-plugin-2.5.pom 

[WARNING] *** CHECKSUM FAILED - Checksum failed on download: local = 'cd5e7eafb337ebd92081854151223244aab55d67'; remote = '<!DOCTYPE' - RETRYING 
Downloading: http://repo1.maven.org/maven2/org/apache/maven/plugins/maven-resources-plugin/2.5/maven-resources-plugin-2.5.pom 

[WARNING] *** CHECKSUM FAILED - Checksum failed on download: local = '2e6700b21c12955fbf1238b7ba2f5fd36e52690d'; remote = '<!DOCTYPE' - IGNORING 
[INFO] ------------------------------------------------------------------------ 
[ERROR] BUILD ERROR 
[INFO] ------------------------------------------------------------------------ 
[INFO] Error building POM (may not be this project's POM). 


Project ID: org.apache.maven.plugins:maven-resources-plugin 
POM Location: /root/.m2/repository/org/apache/maven/plugins/maven-resources-plugin/2.5/maven-resources-plugin-2.5.pom 

Reason: Not a v4.0.0 POM. for project org.apache.maven.plugins:maven-resources-plugin at /root/.m2/repository/org/apache/maven/plugins/maven-resources-plugin/2.5/maven-resources-plugin-2.5.pom 


[INFO] ------------------------------------------------------------------------ 
[INFO] For more information, run Maven with the -e switch 
[INFO] ------------------------------------------------------------------------ 
[INFO] Total time: 20 seconds 
[INFO] Finished at: Sat Apr 28 19:27:28 UTC 2012 
[INFO] Final Memory: 3M/8M 
[INFO] ------------------------------------------------------------------------ 




----- Original Message -----

From: "Benjamin Boksa" <mailinglists at boksa.de> 
To: "Alex Rhys-Hurn" <alex at itworx.co.ke> 
Sent: Saturday, 28 April, 2012 3:56:34 PM 
Subject: Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)] 


Hi Alex, 


according to my monitoring system all servers are up and running. If have at least on report of a completely external user who was able to build RT-Jasper just fine. Please check that it isn't a problem on your side (maybe is is blocked because of the SSL cert used?). Also please check the URL in your browser. 


If that does not help I can send you the required file as an attachment to drop in you local maven repository. 


Hope that helps :-) 


Greetings from Cologne 


Benjamin 






Am 28.04.2012 um 12:11 schrieb Alex Rhys-Hurn: 




Hi Benjamin, 

I am having real troubles building the RT-Jasper. It seems a server is down: 

[WARNING] Unable to get resource 'de.boksa.maven.defaults:maven-default-pom:pom:0.1.0' from repository boksa-repository ( https://services.boksa.de/maven/repositories/boksa ): Error transferring file: Connection timed out 

Can you help with that? 

Thanks again, 

Alex 

----- Original Message -----

From: "Benjamin Boksa" < mailinglists at boksa.de > 
To: "rt-users" < rt-users at lists.bestpractical.com > 
Sent: Friday, 27 April, 2012 2:09:58 PM 
Subject: Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)] 

(Only sent out a private answer before, reposting to rt-users) 



Hi Alex, 


the cool thing about my integration toolkit is, that it does not use SQL at all. It uses the REST Interface (see "Ticket Search") described here: 


http://requesttracker.wikia.com/wiki/REST 


Among other data you get the "TimeWorked" field already calculated ;-) 


The Queries used in Jasper are written in RTRIQL which itself is a superset of the Query Builder Query Language (which means you can use any Query Builder query from RT you already have). 


I have also updated the installation instructions on http://projects.boksa.de/RT-Jasper after some feedback (Thx Marco!). 


Looking forward to you feedback 


Benjamin 







Am 27.04.2012 um 12:09 schrieb Alex Rhys-Hurn: 

<blockquote>


Dear Benjamin, 



Thanks for all the hard work. 

I have in fact played with Jasper and RT before. 

I gave up as the reports I was trying to generate were to do with time worked. 

RT seems to have two different places where time is recorded and calculated, and so querying the DB gets complicated. 

Does your integration of Jasper with RT make this clearer / easier? 

or do you have any example SQL queries for reporting on Time worked in RT? 

Thanks so much, 

Alex 

----- Original Message -----

From: "Benjamin Boksa" < mailinglists at boksa.de > 
To: "Albert Shih" < Albert.Shih at obspm.fr > 
Cc: rt-users at lists.bestpractical.com 
Sent: Thursday, 26 April, 2012 10:59:37 PM 
Subject: Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)] 

Hi Albert, 

you can generate any kind of reports supported by JasperReports Server. RT-Jasper provides the DataSource necessary to query RT for tickets (the ticket's data can be used in the reports). 

Regarding your questions: 

1) See the private mail I sent you. 
2) No. 

If you have further questions just let me know. 

Greetings from Cologne 

Benjamin 




Am 26.04.2012 um 21:28 schrieb Albert Shih: 

> Le 22/04/2012 ? 19:11:23+0200, Benjamin Boksa a écrit 
> Hi. 
> 
>> 
>> it's done :-) I have setup two GitHub repositories to host everything you need to run you own RT an JasperReports Server integration: 
>> 
>> 
>> RT-REST: http://projects.boksa.de/RT-REST/ 
>> RT-REST is a Java class library to interact with RT: Request Tracker's REST Interface. 
>> 
>> RT-Jasper: http://projects.boksa.de/RT-Jasper/ 
>> RT-Jasper is a toolkit to integrate RT: Request Tracker as a queryable data source in JasperServer. 
>> 
>> 
>> Feel free to give the components a try and let me know what you think :-) I have chosen to drop full installation instructions in favor of a demo system (see the RT-Jasper page for more information) and I assume you already have a RT installation to play with. To learn how to install JasperReports Server please refer to 
>> 
>> http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%204.5.0/JasperReports-Server-CP-Install-Guide.pdf/download . 
>> 
>> To help you with your questions I'll try to be around in #rt on irc.perl.org . 
>> 
>> I am really curious to see what you will say about my work and I hope there will be enough users using it to ensure a constant flow of great ideas and improvements. 
>> 
>> Enjoy the rest of your weekends :-) 
>> 
> Big thanks for your works. 
> 
> Two questions before I spend lot of time to understand your works : 
> 
> 1/ What kind of reports can we have (I never heard of jasper, only 
> the city in Canada ...;-) ). I didn't find your demo jasperserver 
> ...:-( 
> 
> 2/ Is they are anything to modify on the RT server ? 
> 
> thanks again. 
> 
> Regards. 
> -- 
> Albert SHIH 
> DIO bâtiment 15 
> Observatoire de Paris 
> 5 Place Jules Janssen 
> 92195 Meudon Cedex 
> Téléphone : 01 45 07 76 26/06 86 69 95 71 
> xmpp: jas at obspm.fr 
> Heure local/Local time: 
> jeu 26 avr 2012 21:25:37 CEST 
> 





</blockquote>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120428/b9986a40/attachment.htm>


More information about the rt-users mailing list