[IPT] IPT connection problem

["Markus Döring (GBIF)"]

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
>>
>