Mickael, do you get any feedback a) in the UI when saving a sql connection b) in the logs?
if not, how did you upgrade your installation? You might want to try: - stop tomcat - copy your existing data dir somewhere else - remove the exploded webapps folder - remove the cached version in tomcat/work/Catalina/localhost/ipt - start tomcat with ipt.war inside webapps - stop tomcat - update webapps/ipt/WEB-INF/classes/ipt.properties to point to your saved data dir - start tomcat
thats the procedure for upgrading to a new IPT version while keeping your data if its still living within the default webapps folder. Did you do this and still get no message when saving a not working db connection?
Markus
On May 13, 2009, at 12:24 PM, Mickael Graf wrote:
Markus,
The RC2 didn't help much, I'm totally blind as to find where the problem comes from.
I was wondering if you could tell me which files are involved in the process so I can get a better understanding?
Cheers, Mickaël
On Tue, 2009-05-12 at 11:47 +0200, "Markus Döring (GBIF)" wrote:
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@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@nrm.se
Swedish Museum of Natural History - http://www.nrm.se Box 50007 SE-104 05 Stockholm Sweden
IPT mailing list IPT@lists.gbif.org http://lists.gbif.org/mailman/listinfo/ipt
--
Mickaël Graf, Database developper GBIF Sweden - http://www.gbif.se mailto:mickael.graf@nrm.se tel: +46 8 5195 4045 Swedish Museum of Natural History - http://www.nrm.se Box 50007 SE-104 05 Stockholm Sweden