<html><head><base href="x-msg://9/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Hi Alex,</div><div><br></div><div>have you been able to solve these problems in the meantime? Looks like somethings is wrong with the way you access the web - maybe a proxy or something? I would really like to help, but this seems to be a problem with you environment which makes it hard to give you a good answer :-/</div><div><br></div><div>Let me know if there is anything I can do to help you...</div><div><br></div><div>Don't give up! ;-)</div><div><br></div><div>Benjamin</div><div><br></div><div><br></div><div><div>Am 28.04.2012 um 21:34 schrieb Alex Rhys-Hurn:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0); ">Hi Benjamin,<br><br>Sorry to be a bother, but I am really struggling with this install.<br><br>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.<br><br>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.<br><br>but now I see all sorts of errors in the first stages of mvn install as below:<br><br>Then things fail to build.<span class="Apple-converted-space"> </span><br><br>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.<br><br>Any tips are appreciated.<br><br>root@core ~/RT-REST# mvn install<br>[INFO] Scanning for projects...<br>Downloading:<span class="Apple-converted-space"> </span><a href="https://services.boksa.de/maven/repositories/boksa/de/boksa/maven/defaults/maven-default-pom/0.1.0/maven-default-pom-0.1.0.pom">https://services.boksa.de/maven/repositories/boksa/de/boksa/maven/defaults/maven-default-pom/0.1.0/maven-default-pom-0.1.0.pom</a><br>4K downloaded (maven-default-pom-0.1.0.pom)<br>Downloading:<span class="Apple-converted-space"> </span><a href="https://services.boksa.de/maven/repositories/boksa/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.pom">https://services.boksa.de/maven/repositories/boksa/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.pom</a><br>[INFO] Unable to find resource 'org.apache.maven.wagon:wagon-ssh:pom:1.0' in repository boksa-repository (<a href="https://services.boksa.de/maven/repositories/boksa">https://services.boksa.de/maven/repositories/boksa</a>)<br>Downloading:<span class="Apple-converted-space"> </span><a href="http://repo1.maven.org/maven2/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.pom">http://repo1.maven.org/maven2/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.pom</a><br><br>[WARNING] *** CHECKSUM FAILED - Checksum failed on download: local = 'ad2eb5e1bb1de5e9347cbd9178c9dd8034eb0d0f'; remote = '<!DOCTYPE' - RETRYING<br>Downloading:<span class="Apple-converted-space"> </span><a href="http://repo1.maven.org/maven2/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.pom">http://repo1.maven.org/maven2/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.pom</a><br><br>[WARNING] *** CHECKSUM FAILED - Checksum failed on download: local = '67f056ad160d74130ae07ad6133d0c5a55293e2e'; remote = '<!DOCTYPE' - IGNORING<br>[WARNING] POM for 'org.apache.maven.wagon:wagon-ssh:pom:1.0:runtime' is invalid.<br><br>Its dependencies (if any) will NOT be available to the current build.<br>Downloading:<span class="Apple-converted-space"> </span><a href="https://services.boksa.de/maven/repositories/boksa/org/codehaus/plexus/plexus-utils/1.1/plexus-utils-1.1.pom">https://services.boksa.de/maven/repositories/boksa/org/codehaus/plexus/plexus-utils/1.1/plexus-utils-1.1.pom</a><br>[INFO] Unable to find resource 'org.codehaus.plexus:plexus-utils:pom:1.1' in repository boksa-repository (<a href="https://services.boksa.de/maven/repositories/boksa">https://services.boksa.de/maven/repositories/boksa</a>)<br>Downloading:<span class="Apple-converted-space"> </span><a href="http://repo1.maven.org/maven2/org/codehaus/plexus/plexus-utils/1.1/plexus-utils-1.1.pom">http://repo1.maven.org/maven2/org/codehaus/plexus/plexus-utils/1.1/plexus-utils-1.1.pom</a><br><br>Downloading:<span class="Apple-converted-space"> </span><a href="https://services.boksa.de/maven/repositories/boksa/org/codehaus/plexus/plexus/1.0.4/plexus-1.0.4.pom">https://services.boksa.de/maven/repositories/boksa/org/codehaus/plexus/plexus/1.0.4/plexus-1.0.4.pom</a><br>[INFO] Unable to find resource 'org.codehaus.plexus:plexus:pom:1.0.4' in repository boksa-repository (<a href="https://services.boksa.de/maven/repositories/boksa">https://services.boksa.de/maven/repositories/boksa</a>)<br>Downloading:<span class="Apple-converted-space"> </span><a href="http://repo1.maven.org/maven2/org/codehaus/plexus/plexus/1.0.4/plexus-1.0.4.pom">http://repo1.maven.org/maven2/org/codehaus/plexus/plexus/1.0.4/plexus-1.0.4.pom</a><br><br>Downloading:<span class="Apple-converted-space"> </span><a href="https://services.boksa.de/maven/repositories/boksa/org/codehaus/plexus/plexus-utils/1.1/plexus-utils-1.1.jar">https://services.boksa.de/maven/repositories/boksa/org/codehaus/plexus/plexus-utils/1.1/plexus-utils-1.1.jar</a><br>Downloading:<span class="Apple-converted-space"> </span><a href="https://services.boksa.de/maven/repositories/boksa/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.jar">https://services.boksa.de/maven/repositories/boksa/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.jar</a><br>[INFO] Unable to find resource 'org.codehaus.plexus:plexus-utils:jar:1.1' in repository boksa-repository (<a href="https://services.boksa.de/maven/repositories/boksa">https://services.boksa.de/maven/repositories/boksa</a>)<br>Downloading:<span class="Apple-converted-space"> </span><a href="http://repo1.maven.org/maven2/org/codehaus/plexus/plexus-utils/1.1/plexus-utils-1.1.jar">http://repo1.maven.org/maven2/org/codehaus/plexus/plexus-utils/1.1/plexus-utils-1.1.jar</a><br>[INFO] Unable to find resource 'org.apache.maven.wagon:wagon-ssh:jar:1.0' in repository boksa-repository (<a href="https://services.boksa.de/maven/repositories/boksa">https://services.boksa.de/maven/repositories/boksa</a>)<br>Downloading:<span class="Apple-converted-space"> </span><a href="http://repo1.maven.org/maven2/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.jar">http://repo1.maven.org/maven2/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.jar</a><br><br>[WARNING] *** CHECKSUM FAILED - Checksum failed on download: local = '7292de5afb0da59af2adc323dd29f5e62c3a27b6'; remote = '<!DOCTYPE' - RETRYING<br>Downloading:<span class="Apple-converted-space"> </span><a href="http://repo1.maven.org/maven2/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.jar">http://repo1.maven.org/maven2/org/apache/maven/wagon/wagon-ssh/1.0/wagon-ssh-1.0.jar</a><br><br>[WARNING] *** CHECKSUM FAILED - Checksum failed on download: local = '3e456700be9f7ad363f06d772ee2c2a5ed0e192d'; remote = '<!DOCTYPE' - IGNORING<br><br>[INFO] ------------------------------------------------------------------------<br>[INFO] Building Unnamed - de.boksa.rt:rt-rest:jar:0.0.1-SNAPSHOT<br>[INFO] task-segment: [install]<br>[INFO] ------------------------------------------------------------------------<br>Downloading:<span class="Apple-converted-space"> </span><a href="http://repo1.maven.org/maven2/org/apache/maven/plugins/maven-resources-plugin/2.5/maven-resources-plugin-2.5.pom">http://repo1.maven.org/maven2/org/apache/maven/plugins/maven-resources-plugin/2.5/maven-resources-plugin-2.5.pom</a><br><br>[WARNING] *** CHECKSUM FAILED - Checksum failed on download: local = 'cd5e7eafb337ebd92081854151223244aab55d67'; remote = '<!DOCTYPE' - RETRYING<br>Downloading:<span class="Apple-converted-space"> </span><a href="http://repo1.maven.org/maven2/org/apache/maven/plugins/maven-resources-plugin/2.5/maven-resources-plugin-2.5.pom">http://repo1.maven.org/maven2/org/apache/maven/plugins/maven-resources-plugin/2.5/maven-resources-plugin-2.5.pom</a><br><br>[WARNING] *** CHECKSUM FAILED - Checksum failed on download: local = '2e6700b21c12955fbf1238b7ba2f5fd36e52690d'; remote = '<!DOCTYPE' - IGNORING<br>[INFO] ------------------------------------------------------------------------<br>[ERROR] BUILD ERROR<br>[INFO] ------------------------------------------------------------------------<br>[INFO] Error building POM (may not be this project's POM).<br><br><br>Project ID: org.apache.maven.plugins:maven-resources-plugin<br>POM Location: /root/.m2/repository/org/apache/maven/plugins/maven-resources-plugin/2.5/maven-resources-plugin-2.5.pom<br><br>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<br><br><br>[INFO] ------------------------------------------------------------------------<br>[INFO] For more information, run Maven with the -e switch<br>[INFO] ------------------------------------------------------------------------<br>[INFO] Total time: 20 seconds<br>[INFO] Finished at: Sat Apr 28 19:27:28 UTC 2012<br>[INFO] Final Memory: 3M/8M<br>[INFO] ------------------------------------------------------------------------<br><br><br><br><br><hr id="zwchr"><div style="color: rgb(0, 0, 0); font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica, Arial, sans-serif; font-size: 12pt; "><b>From:<span class="Apple-converted-space"> </span></b>"Benjamin Boksa" <<a href="mailto:mailinglists@boksa.de">mailinglists@boksa.de</a>><br><b>To:<span class="Apple-converted-space"> </span></b>"Alex Rhys-Hurn" <<a href="mailto:alex@itworx.co.ke">alex@itworx.co.ke</a>><br><b>Sent:<span class="Apple-converted-space"> </span></b>Saturday, 28 April, 2012 3:56:34 PM<br><b>Subject:<span class="Apple-converted-space"> </span></b>Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)]<br><br><div>Hi Alex,</div><div><br></div><div>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.</div><div><br></div><div>If that does not help I can send you the required file as an attachment to drop in you local maven repository.</div><div><br></div><div>Hope that helps :-)</div><div><br></div><div>Greetings from Cologne</div><div><br></div><div>Benjamin</div><div><br></div><div><br></div><br><div><div>Am 28.04.2012 um 12:11 schrieb Alex Rhys-Hurn:</div><br class="Apple-interchange-newline"><blockquote><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0); ">Hi Benjamin,<br><br>I am having real troubles building the RT-Jasper. It seems a server is down:<br><br>[WARNING] Unable to get resource 'de.boksa.maven.defaults:maven-default-pom:pom:0.1.0' from repository boksa-repository (<a href="https://services.boksa.de/maven/repositories/boksa" target="_blank">https://services.boksa.de/maven/repositories/boksa</a>): Error transferring file: Connection timed out<br><br>Can you help with that?<br><br>Thanks again,<br><br>Alex<br><br><hr id="zwchr"><div style="color: rgb(0, 0, 0); font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica, Arial, sans-serif; font-size: 12pt; "><b>From:<span class="Apple-converted-space"> </span></b>"Benjamin Boksa" <<a href="mailto:mailinglists@boksa.de" target="_blank">mailinglists@boksa.de</a>><br><b>To:<span class="Apple-converted-space"> </span></b>"rt-users" <<a href="mailto:rt-users@lists.bestpractical.com" target="_blank">rt-users@lists.bestpractical.com</a>><br><b>Sent:<span class="Apple-converted-space"> </span></b>Friday, 27 April, 2012 2:09:58 PM<br><b>Subject:<span class="Apple-converted-space"> </span></b>Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)]<br><br>(Only sent out a private answer before, reposting to rt-users)<div><br></div><div><div>Hi Alex,</div><div><br></div><div>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:</div><div><br></div><div><a href="http://requesttracker.wikia.com/wiki/REST" target="_blank">http://requesttracker.wikia.com/wiki/REST</a></div><div><br></div><div>Among other data you get the "TimeWorked" field already calculated ;-)</div><div><br></div><div>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).</div><div><br></div><div>I have also updated the installation instructions on<span class="Apple-converted-space"> </span><a href="http://projects.boksa.de/RT-Jasper" target="_blank">http://projects.boksa.de/RT-Jasper</a><span class="Apple-converted-space"> </span>after some feedback (Thx Marco!).</div><div><br></div><div>Looking forward to you feedback</div><div><br></div><div>Benjamin</div></div><div><br></div><div><br></div><div><br><div><div>Am 27.04.2012 um 12:09 schrieb Alex Rhys-Hurn:</div><br class="Apple-interchange-newline"><blockquote><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0); ">Dear Benjamin,<br><div style="color: rgb(0, 0, 0); font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica, Arial, sans-serif; font-size: 12pt; "><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0); "><br>Thanks for all the hard work.<br><br>I have in fact played with Jasper and RT before.<br><br>I gave up as the reports I was trying to generate were to do with time worked.<br><br>RT seems to have two different places where time is recorded and calculated, and so querying the DB gets complicated.<br><br>Does your integration of Jasper with RT make this clearer / easier?<br><br>or do you have any example SQL queries for reporting on Time worked in RT?<br><br>Thanks so much,<br><br>Alex<br><br><hr id="zwchr"><div style="color: rgb(0, 0, 0); font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica, Arial, sans-serif; font-size: 12pt; "><b>From:<span class="Apple-converted-space"> </span></b>"Benjamin Boksa" <<a href="mailto:mailinglists@boksa.de" target="_blank">mailinglists@boksa.de</a>><br><b>To:<span class="Apple-converted-space"> </span></b>"Albert Shih" <<a href="mailto:Albert.Shih@obspm.fr" target="_blank">Albert.Shih@obspm.fr</a>><br><b>Cc:<span class="Apple-converted-space"> </span></b><a href="mailto:rt-users@lists.bestpractical.com" target="_blank">rt-users@lists.bestpractical.com</a><br><b>Sent:<span class="Apple-converted-space"> </span></b>Thursday, 26 April, 2012 10:59:37 PM<br><b>Subject:<span class="Apple-converted-space"> </span></b>Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)]<br><br>Hi Albert,<br><br>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).<br><br>Regarding your questions:<br><br>1) See the private mail I sent you.<br>2) No.<br><br>If you have further questions just let me know.<br><br>Greetings from Cologne<br><br>Benjamin<br><br><br><br><br>Am 26.04.2012 um 21:28 schrieb Albert Shih:<br><br>> Le 22/04/2012 ? 19:11:23+0200, Benjamin Boksa a écrit<br>> Hi.<br>><span class="Apple-converted-space"> </span><br>>><span class="Apple-converted-space"> </span><br>>> it's done :-) I have setup two GitHub repositories to host everything you need to run you own RT an JasperReports Server integration:<br>>><span class="Apple-converted-space"> </span><br>>><span class="Apple-converted-space"> </span><br>>> RT-REST:<span class="Apple-converted-space"> </span><a href="http://projects.boksa.de/RT-REST/" target="_blank">http://projects.boksa.de/RT-REST/</a><br>>> RT-REST is a Java class library to interact with RT: Request Tracker's REST Interface.<br>>><span class="Apple-converted-space"> </span><br>>> RT-Jasper:<span class="Apple-converted-space"> </span><a href="http://projects.boksa.de/RT-Jasper/" target="_blank">http://projects.boksa.de/RT-Jasper/</a><br>>> RT-Jasper is a toolkit to integrate RT: Request Tracker as a queryable data source in JasperServer.<br>>><span class="Apple-converted-space"> </span><br>>><span class="Apple-converted-space"> </span><br>>> 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<br>>><span class="Apple-converted-space"> </span><br>>><span class="Apple-converted-space"> </span><a href="http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%204.5.0/JasperReports-Server-CP-Install-Guide.pdf/download" target="_blank">http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%204.5.0/JasperReports-Server-CP-Install-Guide.pdf/download</a><span class="Apple-converted-space"> </span>.<br>>><span class="Apple-converted-space"> </span><br>>> To help you with your questions I'll try to be around in #rt on<span class="Apple-converted-space"> </span><a href="http://irc.perl.org" target="_blank">irc.perl.org</a><span class="Apple-converted-space"> </span>.<br>>><span class="Apple-converted-space"> </span><br>>> 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.<br>>><span class="Apple-converted-space"> </span><br>>> Enjoy the rest of your weekends :-)<br>>><span class="Apple-converted-space"> </span><br>> Big thanks for your works.<br>><span class="Apple-converted-space"> </span><br>> Two questions before I spend lot of time to understand your works :<span class="Apple-converted-space"> </span><br>><span class="Apple-converted-space"> </span><br>> 1/ What kind of reports can we have (I never heard of jasper, only<br>> the city in Canada ...;-) ). I didn't find your demo jasperserver<br>> ...:-(<br>><span class="Apple-converted-space"> </span><br>> 2/ Is they are anything to modify on the RT server ?<span class="Apple-converted-space"> </span><br>><span class="Apple-converted-space"> </span><br>> thanks again.<br>><span class="Apple-converted-space"> </span><br>> Regards.<br>> --<span class="Apple-converted-space"> </span><br>> Albert SHIH<br>> DIO bâtiment 15<br>> Observatoire de Paris<br>> 5 Place Jules Janssen<br>> 92195 Meudon Cedex<br>> Téléphone : 01 45 07 76 26/06 86 69 95 71<br>> xmpp:<span class="Apple-converted-space"> </span><a href="mailto:jas@obspm.fr" target="_blank">jas@obspm.fr</a><br>> Heure local/Local time:<br>> jeu 26 avr 2012 21:25:37 CEST<br>></div></div></div></div></div></span></blockquote></div></div></div></div></div></span></blockquote></div></div></div></div></span></blockquote></div><br></body></html>