perfsonar-user - Re: [perfsonar-user] Database connection to the LookupService is not established
Subject: perfSONAR User Q&A and Other Discussion
List archive
Re: [perfsonar-user] Database connection to the LookupService is not established
Chronological Thread
- From: Tijmen van den Brink <>
- To: Loukik Kudarimoti <>
- Cc:
- Subject: Re: [perfsonar-user] Database connection to the LookupService is not established
- Date: Fri, 08 Jun 2007 15:48:32 +0200
A quick update: Maciej kindly reminded me of the HTTP connector and the XMLRPC-like url. With the web client I was able to login using the XMLRPC-like url.
So I reconfigured the LookupService by issueing the command: ant configure
Then when the script asked me I told it to use xmlrpc instead of http. (I would like to use HTTP because it stated it would be much faster but for now I just wanted it to work)
I changed the portnumber in service.properties from 8680 to 8080 and restarted tomcat. This however didn't help. When I test the service I get the following error:
tijmen@perfsonar:~/perfsonar-bundle-2.0/XML-LS-1.1.1/perfsonar/ant$ ant -f build-xmlls.xml test-echo
Buildfile: build-xmlls.xml
Overriding previous definition of reference to classpath
copy-config-files-for-test:
[copy] Copying 1 file to /home/tijmen/perfsonar-bundle-2.0/XML-LS-1.1.1/perfsonar/build/perfsonar/conf
test-echo:
[java] Test: LS TESTING: [query] in [RequestHandler]
[java] Test: XML File = file:///home/tijmen/perfsonar-bundle-2.0/XML-LS-1.1.1/perfsonar/schema/example-instances/perfSONAR/LS/test/EchoRequest.xml
[java] AuxiliaryComponentManager.initManager: Read config file name as: /home/tijmen/perfsonar-bundle-2.0/XML-LS-1.1.1/perfsonar/build/perfsonar/conf/components.properties
[java] AUX ComponentManager create [config] = org.perfsonar.commons.auxiliary.components.configuration.properties.PropertiesConfigurationComponent
[java] AUX ComponentManager: init [config]
[java] PropertiesConfigurationComponent.initComponent:Read the file name as: /home/tijmen/perfsonar-bundle-2.0/XML-LS-1.1.1/perfsonar/build/perfsonar/conf/service.properties
[java] AUX ComponentManager create [logger] = org.perfsonar.commons.auxiliary.components.logger.log4j.Log4jLoggerComponent
[java] AUX ComponentManager: init [logger]
[java] java.lang.NullPointerException
[java] at org.perfsonar.service.commons.storage.xmldb.exist.xmlrpc.ExistDbXmlrpcXmlStorageManager.fetch(Unknown Source)
[java] at org.perfsonar.service.lookupService.xmlType.EchoRequestAction.getDBDateTime(Unknown Source)
[java] at org.perfsonar.service.lookupService.xmlType.EchoRequestAction.performAction(Unknown Source)
[java] at org.perfsonar.service.lookupService.xmlType.XmlTypeLSServiceEngine.takeAction(Unknown Source)
[java] at org.perfsonar.commons.messages.EchoRequest.executeEcho(Unknown Source)
[java] at org.perfsonar.commons.messages.EchoRequest.execute(Unknown Source)
[java] at org.perfsonar.service.web.RequestHandler.acceptCall(Unknown Source)
[java] at org.perfsonar.client.testHarness.LSTestClient.testRequestHandler(Unknown Source)
[java] at org.perfsonar.client.testHarness.LSTestClient.main(Unknown Source)
BUILD SUCCESSFUL
Total time: 7 seconds
Could this have anything todo with collection data missing?
Here is my service.properties
###############################################################################
##
## Service configuration file
## for Lookup Service
##
## ---------------------------------------------------------------------------
## Generated from template written by Maciej Glowiak
## ---------------------------------------------------------------------------
##
## $Id: service.properties.ls-template 1885 2007-01-08 10:18:48Z mac $ $
## Project: perfSONAR
##
###############################################################################
## --- general service properties --------------------------------------------------------
service.name=XML-LS-1.1.1
# --- directories -------------------------------------------------------------------------
service.basepath=/home/tijmen/perfsonar-bundle-2.0/tomcat/webapps
service.log.log4j.config=/home/tijmen/perfsonar-bundle-2.0/tomcat/webapps/XML-LS-1.1.1/WEB-INF/classes/perfsonar/conf/log4j.properties
service.sax_parser.config=/home/tijmen/perfsonar-bundle-2.0/tomcat/webapps/XML-LS-1.1.1/WEB-INF/classes/perfsonar/conf/objects.config
service.log.dir=/home/tijmen/perfsonar-bundle-2.0/tomcat/webapps/XML-LS-1.1.1/log
# --- registration ------------------------------------------------------------------------
# name of parameter which starts with "service.r." indicates that
# this parameter belongs to the Lookup Information
service.r.type=ls
service.r.access_point=http://perfsonar.tvdbrink.practicum.os3.nl:8080/XML-LS-1.1.1
service.r.service_name=Test Lookup Service
service.r.service_type=LS
service.r.service_description=Test Lookup Service, perfSONAR
# Lookup Service to register to - only for Registration to LS
#service.r.ls_url=%R_LOOKUP_SERVICE%
# --- cleanup -----------------------------------------------------------------------------
service.ls.ttl=3600
# --- Lookup Service properties --------------------------------------------------------
# Database username and password for ls_storage
service.ls.db_type=xmlrpc
service.ls.db_uri=xmldb:exist://127.0.0.1:8080/exist/xmlrpc
service.ls.db_username=manager
service.ls.db_password=MyPassword
#LS Cleanup loader
component.ls_cleanup_loader.interval=300
component.ls_cleanup_loader.scheduler_component=ls_scheduler
component.ls_cleanup_loader.storage_component=ls_storage
#Registrator loader - enable this secion if registration to another LS should be enabled
#component.registrator.interval=%REGISTER_INTERVAL%
#component.registrator.scheduler_component=ls_scheduler
#Updates
#Allow re-registration (simple update)
service.ls.allow_replace=yes
#test
ls.test.server=http://127.0.0.1:8080/XML-LS-1.1.1
# --- Service properties ---------------------------------------------------------------
service.ls.class_name=org.perfsonar.service.lookupService.xmlType.XmlTypeLSServiceEngine
service.ls.message_types=LSQueryRequest,LSRegisterRequest,LSDeregisterRequest,LSKeepaliveRequest,EchoRequest
# ------- END --------------------------------------------------------------------------
Loukik Kudarimoti schreef:
On 8 Jun 2007, at 13:11, Tijmen van den Brink wrote:
Hi everyone,Hi Tijmen,
I'm a student of the University of Amsterdam and doing a study on the possible use of perfSONAR in the GLIF infrastructure. I installed the LookupService with the use of the perl install script. It looked like everything went smoothly. However when I did a test-echo it gave me the following error:
LS EchoRequest (Test DB Connection) error: Database connection to the LookupService is not established. Nested exception is : XQuery by HTTP failed. Could not connect to eXist via pure http, nested exception was: class java.net.ConnectException : Connection refused
I checked the credentials of the user but they seem to be right. Can somebody help me?
We need some information from you to help. Here is how to find it
1. Find service.properties file ( perfsonar-bundle-2.0/webapps/XML-LS-1.1.1/WEB-INF/classes/conf/perfsonar/)
2. Mail us this service.properties file (you can remove username and password entries before mailing it to us)
Its very likely that the xml db url that you provided was incorrect. We should be able to correct it easily after having a look at the service.properties file.
Loukik.
Best regards,
Tijmen
This is the complete output:
tijmen@perfsonar:~/perfsonar-bundle-2.0/XML-LS-1.1.1/perfsonar/ant$ ant -f build-xmlls.xml test-echo
Buildfile: build-xmlls.xml
Overriding previous definition of reference to classpath
copy-config-files-for-test:
test-echo:
[java] Test: LS TESTING: [query] in [RequestHandler]
[java] Test: XML File = file:///home/tijmen/perfsonar-bundle-2.0/XML-LS-1.1.1/perfsonar/schema/example-instances/perfSONAR/LS/test/EchoRequest.xml
[java] AuxiliaryComponentManager.initManager: Read config file name as: /home/tijmen/perfsonar-bundle-2.0/XML-LS-1.1.1/perfsonar/build/perfsonar/conf/components.properties
[java] AUX ComponentManager create [config] = org.perfsonar.commons.auxiliary.components.configuration.properties.PropertiesConfigurationComponent
[java] AUX ComponentManager: init [config]
[java] PropertiesConfigurationComponent.initComponent:Read the file name as: /home/tijmen/perfsonar-bundle-2.0/XML-LS-1.1.1/perfsonar/build/perfsonar/conf/service.properties
[java] AUX ComponentManager create [logger] = org.perfsonar.commons.auxiliary.components.logger.log4j.Log4jLoggerComponent
[java] AUX ComponentManager: init [logger]
[java] AUX ComponentManager create [ls_scheduler] = org.perfsonar.commons.auxiliary.components.simplescheduler.Scheduler
[java] AUX ComponentManager: init [ls_scheduler]
[java] AUX ComponentManager create [ls_cleanup_loader] = org.perfsonar.service.lookupService.xmlType.LSCleanupLoader
[java] AUX ComponentManager: init [ls_cleanup_loader]
[java] [D] authorization Basic manager:myPasswordButThatJust4Me
[java] Output [683b]: <?xml version="1.0" encoding="UTF-8"?>
[java] <nmwg:message id="msg1_resp" messageIdRef="msg1" type="EchoResponse">
[java] <nmwg:metadata id="resultCodeMetadata">
[java] <nmwg:eventType>error.common.storage.xmldb.open</nmwg:eventType>
[java] </nmwg:metadata>
[java] <nmwg:data id="resultDescriptionData_for_resultCodeMetadata" metadataIdRef="resultCodeMetadata">
[java] <nmwgr:datum>LS EchoRequest (Test DB Connection) error: Database connection to the LookupService is not established. Nested exception is : XQuery by HTTP failed. Could not connect to eXist via pure http, nested exception was: class java.net.ConnectException : Connection refused</nmwgr:datum>
[java] </nmwg:data>
[java] </nmwg:message>
[java] [D] authorization Basic manager:myPasswordButThatJust4Me
- Database connection to the LookupService is not established, Tijmen van den Brink, 06/08/2007
- Re: [perfsonar-user] Database connection to the LookupService is not established, Loukik Kudarimoti, 06/08/2007
- Re: [perfsonar-user] Database connection to the LookupService is not established, Maciej Glowiak, 06/08/2007
- Re: [perfsonar-user] Database connection to the LookupService is not established, Tijmen van den Brink, 06/08/2007
- Re: [perfsonar-user] Database connection to the LookupService is not established, Maciej Glowiak, 06/08/2007
- Re: [perfsonar-user] Database connection to the LookupService is not established, Loukik Kudarimoti, 06/08/2007
Archive powered by MHonArc 2.6.16.