[IPT] IPT connection problem

Mon May 18 16:42:54 CEST 2009

Hello Markus

The issue of data dir outside not working was an issue of ownership.
This one is solved.

About the connection, the IPT interface provides med with "Could not
establish db connection: Communications link failure Last packet sent to
the server was 0 ms ago."

The log file is compressed and attached to this mail.

Thanks,
Mickaël

On Mon, 2009-05-18 at 15:20 +0200, "Markus Döring (GBIF)" wrote:
> Mickael,
> real sorry from my side. Seemed that I've uploaded a wrong snapshot  
> version to our ftp server. The war there didnt give any message to me  
> neither.
> I've updated the file and the current ftp war (same name) does work  
> for me now. But I really had to remove tomcats cached work folder  
> files in order to be taken up, pretty stupid, but well.
> 
> You mentioned pointing IPT to a data dir outside didnt work?
> That would be a serious issue, but I cant reproduce that. If that  
> still is true for you, can you please let us know what exactly happens?
> 
> cheers,
> Markus
> 
> 
> 
> 
> 
> On May 14, 2009, at 11:56, Mickael Graf wrote:
> 
> > Markus,
> >
> > I undeployed IPT from the manager interface of tomcat. Then I uploaded
> > the RC2 file from the same interface. This removed all the settings.
> >
> > Since then I restarted tomcat numerous times. I removed the cache this
> > morning but nothing changed.
> >
> > Now I just did what you wrote below, but I copied back the data
> > directory because IPT didn't like having dataDir pointing to another
> > place.
> >
> > So when I come to my existing resource, under Source Data/SQL Data
> > Sources I get the following message:
> > "No Database connected. Please adjust connection parameters to use SQL
> > sources"
> >
> > The I click on Edit, all my parameters are in place and I save it.
> > Then I come back to the previous page I get the message
> > "Resource has been updated successfully." but the message under SQL  
> > Data
> > Sources is the same as before.
> >
> > This is what is logged after starting tomcat, login and getting to the
> > resource and saving the database information, and it's not much:
> >
> > INFO main-AppConfig.reloadLogger(416) | Reloaded log4j settings
> > from /usr/share/tomcat5/webapps/ipt/data/logging/ipt-developer.xml
> > INFO main-AppConfig.<init>(57) |
> > --------------------
> > IPT_DATA_DIR: /usr/share/tomcat5/webapps/ipt/data
> > IPT_WEBAPP_DIR: /usr/share/tomcat5/webapps/ipt
> > IPT_BASE_URL: http://www.gbif.se:8080/ipt
> > IPT_GEOSERVER_URL: http://www.gbif.se:8080/geoserver
> > IPT_GEOSERVER_DATA_DIR: /usr/share/tomcat5/webapps/geoserver/data
> > --------------------
> >
> > Cheers,
> > Mickaël
> >
> > On Wed, 2009-05-13 at 21:21 +0200, "Markus Döring (GBIF)" wrote:
> >> 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 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
> >>>>>>
> >>>>>
> >>>>
> >>> -- 
> >>> ---------------------------------
> >>> Mickaël Graf, Database developper
> >>> GBIF Sweden - http://www.gbif.se
> >>> mailto:mickael.graf at nrm.se
> >>> tel: +46 8 5195 4045
> >>> 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
> > mailto:mickael.graf at nrm.se
> > tel: +46 8 5195 4045
> > 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
-- 
---------------------------------
Mickaël Graf, Database developper
GBIF Sweden - http://www.gbif.se 
mailto:mickael.graf at nrm.se
tel: +46 8 5195 4045 
Swedish Museum of Natural History - http://www.nrm.se
Box 50007 
SE-104 05 Stockholm 
Sweden
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ipt.log.tar.bz2
Type: application/x-bzip-compressed-tar
Size: 3356 bytes
Desc: not available
Url : http://lists.gbif.org/pipermail/ipt/attachments/20090518/e4330dc0/attachment-0001.bin 