<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi all, <div><br></div><div><div><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: 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: 0; "><div style="font: normal normal normal 10pt/normal Tahoma, Verdana, sans-serif; ">PS. I agree with Jörg that a convenient way to keep the old data directory when upgrading the IPT would be cute.</div></span></blockquote><div><br></div><div>This is indeed the case. We will aim wherever possible to make upgrading as simple as it can be. </div><div>For bug fix releases, such as this snapshot, with no structural change the data directory can be migrated directly. In future releases, we might require a "one time" migration task be run. I anticipate the first one being required when the DwC standard is ratified.</div><div><br></div><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: 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: 0; "><div style="font: normal normal normal 10pt/normal Tahoma, Verdana, sans-serif; ">PPS. And a convinient way to add a thematic extension to the DwC (for testing and demonstration) would also be very useful. I am thinking of the draft DwC germplasm extension - as well as a new draft for germplasm trait observation data I have started to work on. I assume this perhaps could be done as an addition in the IPT code somewhere around "WEB-INF/classes/org/gbif/provider/model/" ...?</div></span></blockquote><div><br></div><div>A good suggestion. We should look at setting up some sandbox repository for exactly this purpose.</div><div><br></div><div>Dag, for testing and demonstration you could do the following, but please be very careful not to register these datasets with GBIF.</div><div>- The IPT will call (<a href="http://gbrds.gbif.org/registry/ipt/extensions.json">http://gbrds.gbif.org/registry/ipt/extensions.json</a> and <a href="http://gbrds.gbif.org/registry/ipt/thesauri.json)">http://gbrds.gbif.org/registry/ipt/thesauri.json)</a> to get the extensions and the thesauri. </div><div>- The response is fairly self explanatory, and for a test, you could override gbrds.gbif.org in you host file, and put up a different version locally for example referencing your test extensions. </div><div>- Then simply update your extensions through the IPT.</div><div>- Sorry, not the easiest work around, but might get you able to demonstrate how you can start to build your community without waiting for the sandbox repository.</div><div><br></div><div>Best wishes,</div><div><br></div><div>Tim</div><div><br></div><br><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: 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: 0; "><div style="font: normal normal normal 10pt/normal Tahoma, Verdana, sans-serif; "><br><br><blockquote style="border-left-width: 2px; border-left-style: solid; border-left-color: rgb(0, 0, 255); padding-left: 5px; margin-left: 5px; margin-right: 0px; "><hr><b>From:</b><span class="Apple-converted-space"> </span>Holetschek, Jörg [<a href="mailto:j.holetschek@bgbm.org">mailto:j.holetschek@bgbm.org</a>]<br><b>To:</b><span class="Apple-converted-space"> </span>'Mickael Graf' [<a href="mailto:mickael.graf@nrm.se">mailto:mickael.graf@nrm.se</a>], "\"Markus Döring (GBIF)\"" [<a href="mailto:mdoering@gbif.org">mailto:mdoering@gbif.org</a>]<br><b>Cc:</b><span class="Apple-converted-space"> </span><a href="mailto:ipt@lists.gbif.org">ipt@lists.gbif.org</a> [<a href="mailto:ipt@lists.gbif.org">mailto:ipt@lists.gbif.org</a>]<br><b>Sent:</b><span class="Apple-converted-space"> </span>Tue, 12 May 2009 13:55:36 +0200<br><b>Subject:</b><span class="Apple-converted-space"> </span>Re: [IPT] IPT connection problem<br><br>Dear Mickael,<br><br>just a small hint... in a former version I also had some problems with SQL connections:<br><a href="http://code.google.com/p/gbif-providertoolkit/issues/detail?id=121" target="_blank">http://code.google.com/p/gbif-providertoolkit/issues/detail?id=121</a><br><br>Maybe try to restart tomcat to make sure it's not the same problem.<br><br>Just an idea,<br>Jörg<br><br>-----Ursprüngliche Nachricht-----<br>Von:<span class="Apple-converted-space"> </span><a href="mailto:ipt-bounces@lists.gbif.org">ipt-bounces@lists.gbif.org</a><span class="Apple-converted-space"> </span>[mailto:<a href="mailto:ipt-bounces@lists.gbif.org">ipt-bounces@lists.gbif.org</a>]Im<br>Auftrag von Mickael Graf<br>Gesendet: Dienstag, 12. Mai 2009 13:28<br>An: "Markus Döring (GBIF)"<br>Cc:<span class="Apple-converted-space"> </span><a href="mailto:ipt@lists.gbif.org">ipt@lists.gbif.org</a><br>Betreff: Re: [IPT] IPT connection problem<br><br><br>Markus,<br><br>I undeployed RC1 and deployed RC2 and it creates a logfile ipt.log.<br>But it doesn't log any error at all related to the connection problem.<br><br>BTW, I never wrote it before but the message is "No Database connected.<br>Please adjust connection parameters to use SQL sources"<br><br>I send you the logfile in case of there is something useful in it.<br><br>Cheers<br>Mickaël<br><br>On Tue, 2009-05-12 at 11:47 +0200, "Markus Döring (GBIF)" wrote:<br>> Mickael,<br>> the latest IPT war snapshot can be found here:<br>><br>><span class="Apple-converted-space"> </span><a href="ftp://ftp.gbif.org/projects/ipt/downloads/ipt-1.0RC2-SNAPSHOT.war" target="_blank">ftp://ftp.gbif.org/projects/ipt/downloads/ipt-1.0RC2-SNAPSHOT.war</a><br>><br>> This version logs connection problems and also uses in addition to<br>> tomcat logging an ipt.log file inside the data/logging dir.<br>> It also shows a simple message if you configure a bad connection in<br>> the manager UI.<br>> If you have time, please use this to find out more about your mysql<br>> conenction problem.<br>><br>> thanks,<br>> Markus<br>><br>><br>><br>> On May 12, 2009, at 10:17 AM, Markus Döring (GBIF) wrote:<br>><br>> > Mickael,<br>> > I looked at the source again and the IPT really doesn't log any<br>> > errors when changing the db connection.<br>> > This is obviously not very helpful, so I've updated the code already<br>> > to do so. I will upload a new war file today, so if you like you can<br>> > try this version and hopefully find the reason for your connection<br>> > problem. Will post the links later.<br>> ><br>> > many thanks,<br>> > Markus<br>> ><br>> ><br>> ><br>> > On May 11, 2009, at 6:03 PM, Tim Robertson wrote:<br>> ><br>> >> Hej Mickael,<br>> >><br>> >> Can you please post the logs you get when you configure and save the<br>> >> database connection?<br>> >><br>> >> Many thanks,<br>> >><br>> >> Tim<br>> >><br>> >><br>> >><br>> >> On 11 May 2009, at 14:36, Mickael Graf wrote:<br>> >><br>> >>> Sorry for posting at the wrong place.<br>> >>><br>> >>> The database name is correct, and IPT runs on the same server as the<br>> >>> mysql database. This database works perfectly with our TAPIRLink<br>> >>> provider.<br>> >>><br>> >>> The MySQL server version is 5.0.45 and Connector/J has version<br>> >>> 5.1.7. It<br>> >>> has been tested against Java 1.6.0 (OpenJDK) and against Sun Java 6<br>> >>> Update 12. None of this worked.<br>> >>><br>> >>><br>> >>> Cheers,<br>> >>> Mickaël<br>> >>><br>> >>><br>> >>> On Mon, 2009-05-11 at 10:49 +0200, Tim Robertson wrote:<br>> >>>> Hi Mickael,<br>> >>>><br>> >>>><br>> >>>> Please always post questions to the list, to help us keep an FAQ up<br>> >>>> to<br>> >>>> date and allow for others to search etc.<br>> >>>><br>> >>>><br>> >>>> I have just tested it myself with the following:<br>> >>>><br>> >>>><br>> >>>> Database connection URL: jdbc:mysql://localhost:3306/portal<br>> >>>> Database User: tim<br>> >>>> Database Password: password<br>> >>>><br>> >>>><br>> >>>> and it worked... so, to get started debugging your issue may I<br>> >>>> please<br>> >>>> ask some basic questions:<br>> >>>><br>> >>>><br>> >>>> - You wrote "jdbc:mysql://localhost:3306/databasename" - is your<br>> >>>> database name correct?<br>> >>>> - You are running the IPT on the same machine as the database?<br>> >>>> - You are using mysql?<br>> >>>><br>> >>>><br>> >>>> Cheers,<br>> >>>><br>> >>>><br>> >>>> Tim<br>> >>>><br>> >>>><br>> >>>><br>> >>>> On 11 May 2009, at 10:26, Mickael Graf wrote:<br>> >>>><br>> >>>>> Hi Tim,<br>> >>>>><br>> >>>>> I'm trying to create a resource in IPT but I encounter a problem<br>> >>>>> while<br>> >>>>> creating the link to the database: in "Source Data" it is written<br>> >>>>> under<br>> >>>>> "SQL Data Sources" I have the message "No Database connected.<br>> >>>>> Please<br>> >>>>> adjust connection parameters to use SQL sources" while it keeps my<br>> >>>>> settings correctly. I hope I wrote the jdbc string well:<br>> >>>>> jdbc:mysql://localhost:3306/databasename.<br>> >>>>><br>> >>>>> I surprised because I am using the same parameters as with<br>> >>>>> TAPIRLink<br>> >>>>> in<br>> >>>>> which I don't have any problem. I don't think I should make any<br>> >>>>> changes<br>> >>>>> in my grants on my database.<br>> >>>>><br>> >>>>> Cheers,<br>> >>>>> Mickaël<br>> >>>>><br>> >>>>> --<br>> >>>>> ---------------------------------<br>> >>>>> Mickaël Graf<br>> >>>>> Database developper, GBIF Sweden -<span class="Apple-converted-space"> </span><a href="http://www.gbif.se" target="_blank">http://www.gbif.se</a><br>> >>>>> tel: +46 8 5195 4045<br>> >>>>> mailto:<a href="mailto:mickael.graf@nrm.se">mickael.graf@nrm.se</a><br>> >>>>><br>> >>>>> Swedish Museum of Natural History -<span class="Apple-converted-space"> </span><a href="http://www.nrm.se" target="_blank">http://www.nrm.se</a><br>> >>>>> Box 50007<br>> >>>>> SE-104 05 Stockholm<br>> >>>>> Sweden<br>> >>>>><br>> >>>>><br>> >>>>><br>> >>>><br>> >>>><br>> >>> --<br>> >>> ---------------------------------<br>> >>> Mickaël Graf<br>> >>> Database developper, GBIF Sweden -<span class="Apple-converted-space"> </span><a href="http://www.gbif.se" target="_blank">http://www.gbif.se</a><br>> >>> tel: +46 8 5195 4045<br>> >>> mailto:<a href="mailto:mickael.graf@nrm.se">mickael.graf@nrm.se</a><br>> >>><br>> >>> Swedish Museum of Natural History -<span class="Apple-converted-space"> </span><a href="http://www.nrm.se" target="_blank">http://www.nrm.se</a><br>> >>> Box 50007<br>> >>> SE-104 05 Stockholm<br>> >>> Sweden<br>> >>><br>> >>><br>> >><br>> >> _______________________________________________<br>> >> IPT mailing list<br>> >><span class="Apple-converted-space"> </span><a href="mailto:IPT@lists.gbif.org">IPT@lists.gbif.org</a><br>> >><span class="Apple-converted-space"> </span><a href="http://lists.gbif.org/mailman/listinfo/ipt" target="_blank">http://lists.gbif.org/mailman/listinfo/ipt</a><br>> >><br>> ><br>><br>--<br>---------------------------------<br>Mickaël Graf<br>Database developper, GBIF Sweden -<span class="Apple-converted-space"> </span><a href="http://www.gbif.se" target="_blank">http://www.gbif.se</a><br>tel: +46 8 5195 4045<br>mailto:<a href="mailto:mickael.graf@nrm.se">mickael.graf@nrm.se</a><br><br>Swedish Museum of Natural History -<span class="Apple-converted-space"> </span><a href="http://www.nrm.se" target="_blank">http://www.nrm.se</a><br>Box 50007<br>SE-104 05 Stockholm<br>Sweden<br>_______________________________________________<br>IPT mailing list<br><a href="mailto:IPT@lists.gbif.org">IPT@lists.gbif.org</a><br><a href="http://lists.gbif.org/mailman/listinfo/ipt" target="_blank">http://lists.gbif.org/mailman/listinfo/ipt</a><br></blockquote>_______________________________________________<br>IPT mailing list<br><a href="mailto:IPT@lists.gbif.org">IPT@lists.gbif.org</a><br><a href="http://lists.gbif.org/mailman/listinfo/ipt">http://lists.gbif.org/mailman/listinfo/ipt</a><br></div></span></blockquote></div><br></div></body></html>