[IPT] IPT connection problem

[Mickael Graf]

Thanks Markus.

I'm looking forward for it, but probably I won't be able to try before
tomorrow morning.

Cheers,
Mickaël

On Tue, 2009-05-12 at 10:17 +0200, "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
-- 
---------------------------------
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