[IPT] IPT connection problem

[Tim Robertson]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.gbif.org/pipermail/ipt/attachments/20090511/b75e8353/attachment.html