[IPT] IPT connection problem

["Markus Döring (GBIF)"]

from RC1 on there hasn't been a change in the data dir, so yes, you  
should be able to use your existing data dir without a problem.
Probably the best is to keep it outside of the webapps folder and  
update the ipt.properties

Markus


On May 12, 2009, at 2:05 PM, Holetschek, Jörg wrote:

> Hi Markus,
>
> is it possible to keep the old data directory with the new RC?
>
> Jörg
>
> -----Ursprüngliche Nachricht-----
> Von: ipt-bounces at lists.gbif.org [mailto:ipt-bounces at lists.gbif.org]Im
> Auftrag von "Markus Döring (GBIF)"
> Gesendet: Dienstag, 12. Mai 2009 11:48
> An: Mickael Graf
> Cc: ipt at lists.gbif.org
> Betreff: Re: [IPT] IPT connection problem
>
>
> Mickael,
> the latest IPT war snapshot can be found here:
>
> ftp://ftp.gbif.org/projects/ipt/downloads/ipt-1.0RC2-SNAPSHOT.war
>
> This version logs connection problems and also uses in addition to
> tomcat logging an ipt.log file inside the data/logging dir.
> It also shows a simple message if you configure a bad connection in
> the manager UI.
> If you have time, please use this to find out more about your mysql
> conenction problem.
>
> thanks,
> Markus
>
>
>
> On May 12, 2009, at 10:17 AM, Markus Döring (GBIF) wrote:
>
>> Mickael,
>> I looked at the source again and the IPT really doesn't log any
>> errors when changing the db connection.
>> This is obviously not very helpful, so I've updated the code already
>> to do so. I will upload a new war file today, so if you like you can
>> try this version and hopefully find the reason for your connection
>> problem. Will post the links later.
>>
>> many thanks,
>> Markus
>>
>>
>>
>> On May 11, 2009, at 6:03 PM, Tim Robertson wrote:
>>
>>> Hej Mickael,
>>>
>>> Can you please post the logs you get when you configure and save the
>>> database connection?
>>>
>>> Many thanks,
>>>
>>> Tim
>>>
>>>
>>>
>>> On 11 May 2009, at 14:36, Mickael Graf wrote:
>>>
>>>> Sorry for posting at the wrong place.
>>>>
>>>> The database name is correct, and IPT runs on the same server as  
>>>> the
>>>> mysql database. This database works perfectly with our TAPIRLink
>>>> provider.
>>>>
>>>> The MySQL server version is 5.0.45 and Connector/J has version
>>>> 5.1.7. It
>>>> has been tested against Java 1.6.0 (OpenJDK) and against Sun Java 6
>>>> Update 12. None of this worked.
>>>>
>>>>
>>>> Cheers,
>>>> Mickaël
>>>>
>>>>
>>>> On Mon, 2009-05-11 at 10:49 +0200, Tim Robertson wrote:
>>>>> Hi Mickael,
>>>>>
>>>>>
>>>>> Please always post questions to the list, to help us keep an FAQ  
>>>>> up
>>>>> to
>>>>> date and allow for others to search etc.
>>>>>
>>>>>
>>>>> I have just tested it myself with the following:
>>>>>
>>>>>
>>>>> Database connection URL: jdbc:mysql://localhost:3306/portal
>>>>> Database User: tim
>>>>> Database Password: password
>>>>>
>>>>>
>>>>> and it worked... so, to get started debugging your issue may I
>>>>> please
>>>>> ask some basic questions:
>>>>>
>>>>>
>>>>> - You wrote "jdbc:mysql://localhost:3306/databasename" - is your
>>>>> database name correct?
>>>>> - You are running the IPT on the same machine as the database?
>>>>> - You are using mysql?
>>>>>
>>>>>
>>>>> Cheers,
>>>>>
>>>>>
>>>>> Tim
>>>>>
>>>>>
>>>>>
>>>>> On 11 May 2009, at 10:26, Mickael Graf wrote:
>>>>>
>>>>>> Hi Tim,
>>>>>>
>>>>>> I'm trying to create a resource in IPT but I encounter a problem
>>>>>> while
>>>>>> creating the link to the database: in "Source Data" it is written
>>>>>> under
>>>>>> "SQL Data Sources" I have the message "No Database connected.
>>>>>> Please
>>>>>> adjust connection parameters to use SQL sources" while it keeps  
>>>>>> my
>>>>>> settings correctly. I hope I wrote the jdbc string well:
>>>>>> jdbc:mysql://localhost:3306/databasename.
>>>>>>
>>>>>> I surprised because I am using the same parameters as with
>>>>>> TAPIRLink
>>>>>> in
>>>>>> which I don't have any problem. I don't think I should make any
>>>>>> changes
>>>>>> in my grants on my database.
>>>>>>
>>>>>> Cheers,
>>>>>> Mickaël
>>>>>>
>>>>>> --
>>>>>> ---------------------------------
>>>>>> Mickaël Graf
>>>>>> Database developper, GBIF Sweden - http://www.gbif.se
>>>>>> tel: +46 8 5195 4045
>>>>>> mailto:mickael.graf at nrm.se
>>>>>>
>>>>>> Swedish Museum of Natural History - http://www.nrm.se
>>>>>> Box 50007
>>>>>> SE-104 05 Stockholm
>>>>>> Sweden
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>> --
>>>> ---------------------------------
>>>> Mickaël Graf
>>>> Database developper, GBIF Sweden - http://www.gbif.se
>>>> tel: +46 8 5195 4045
>>>> mailto:mickael.graf at nrm.se
>>>>
>>>> Swedish Museum of Natural History - http://www.nrm.se
>>>> Box 50007
>>>> SE-104 05 Stockholm
>>>> Sweden
>>>>
>>>>
>>>
>>> _______________________________________________
>>> IPT mailing list
>>> IPT at lists.gbif.org
>>> http://lists.gbif.org/mailman/listinfo/ipt
>>>
>>
>
> _______________________________________________
> IPT mailing list
> IPT at lists.gbif.org
> http://lists.gbif.org/mailman/listinfo/ipt
>