[IPT] IPT connection problem

Mon May 18 16:53:14 CEST 2009

Hi Mickael,

So, something on the machine is blocking Tomcat from talking to mysql  
("Caused by: java.net.ConnectException: Connection refused").

It could be something like a firewall or perhaps you have a rule in  
the /etc/hosts.deny ?
I have never had to but I read that adding 127.0.0.1 to /etc/ 
hosts.allow might be required.

Cheers,

Tim

On 18 May 2009, at 16:42, Mickael Graf wrote:

> 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
> <ipt.log.tar.bz2>_______________________________________________
> IPT mailing list
> IPT at lists.gbif.org
> http://lists.gbif.org/mailman/listinfo/ipt

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