[IPT] IPT connection problem

[Mickael Graf]

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