[IPT] IPT connection problem

[Tim Robertson]

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