Skip to Content.
Sympa Menu

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,

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?
Hi Tijmen,

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







Archive powered by MHonArc 2.6.16.

Top of Page