perfsonar-dev - Re: [pS-dev] Problem with SQL-MA!!
Subject: perfsonar development work
List archive
- From: Loukik Kudarimoti <>
- To: maxim <>
- Cc: "'Asif, Mohammad'" <>, 'Maciej Glowiak' <>, 'Roman Lapacz' <>, , "'Li, Yee-Ting'" <>, Nicolas Simar <>
- Subject: Re: [pS-dev] Problem with SQL-MA!!
- Date: Mon, 15 Jan 2007 11:37:26 +0000
maxim wrote:
Hi Asif,Hi Maxim,
I dont know if you solved your problem. I was having the same one today and
it was solved by removing the
perfSONAR-rrdma.jar from tomcat lib directory. For some unexplained reason
the cant live together.
That's what perfSONAR developers should stress in the installation guide.
Thanks,
Maxim.
So, is your SQL MA up and running ok now? Are you able to provide access to lightpath status data using this service?
It is indeed true that *in the current SQL MA and RRD MA* distribution that you both are using, one tomcat can only have one service installed. Hence, perfSONAR-rrdma.jar and perfSONAR-sqlma.jar can't live together.
I am curious as to how the perfSONAR-rrdma.jar file appeared in the tomcat/lib directory? Until rrdma-1.1-beta, all the jars files from the service were required to be in tomcat/webapps/axis/WEB-INF/lib directory. Did you copy the jar file manually into the tomcat/lib directory?
You are right that the documentation needs to be improved.
Loukik.
-----Original Message-----
From: Asif, Mohammad [mailto:] Sent: Friday, December 15, 2006 1:01 PM
To: Loukik Kudarimoti
Cc: Nicolas Simar; Maciej Glowiak; Roman Lapacz; ; Li, Yee-Ting
Subject: RE: [pS-dev] Problem with SQL-MA!!
Hello Loukik!!
The required properties files are attached with this mail. I am going to deploy a separate clean SQL-MA. I think you are right because I deployed rrdMA and lookservice at the the same time on this tomcat, infact it was giving this same problem. Then I undelpoy rrdma and lookservice and deployed a cleaned installation of SQL-MA.
best regards..
Asif
-----Original Message-----
From: Loukik Kudarimoti
[mailto:]
Sent: Fri 12/15/2006 3:55 AM
To: Asif, Mohammad
Cc: Nicolas Simar; Maciej Glowiak; Roman Lapacz; ; Li, Yee-Ting
Subject: Re: [pS-dev] Problem with SQL-MA!!
Asif,
I am a bit surprised with the jars present in your axis/lib directory. The version of SQL MA that you are installing requires you to install only one perfSONAR service in one tomcat. Looking at the jars in your axis/lib directory, I think more than one perfSONAR service *might* have been installed in the same tomcat. I say this because the following jars are not expected.
perfSONAR-rrdma.jar, perfSONAR-xmlls.jar and nmwg.jar.
Can you please mail us your catalina.properties file - you can find this in your tomcat (tomcat/conf directory)
After we have a look at your catalina.properites file, I will need to look at more configuration files (service.properties specifically) But this is only after I look at your Catalina.properties file.
Please note: Installation of the version of SQL-MA that you are using requires that you to install *only one service* inside one tomcat. If you have tried to install some other service in the same tomcat before, I suggest to:
* remove the axis directory in tomcat/webapps.
* install axis inside tomcat again.
* In catalina.properties, remove all entries starting with service.properties and components.properties (You might find duplicates
- remove them all)
* Download fresh copy of sql ma and install it.
Loukik.
Note: FYI, Very soon, users will be able to install more than one service in their tomcat. Its already possible for the latest snapshot of rrdma
Asif, Mohammad wrote:
jars in my axis/lib directory are given below. There aresome additional jar files like nmwg.jar but I don't think it will make any problem. Rest all the jars that Nicolas mentioned are available with the same exact version.I restarted the tomcat and tested again and it give thesame logs and error.ls $AXIS_LIBwiki or on the
activation-1.0.2.jar nmwg.jar
axis-ant.jar perfSONAR-generic.jar
axis.jar perfSONAR-rrdma.jar
commons-beanutils-1.7.0.jar perfSONAR-sqlma.jar
commons-collections-3.2.jar perfSONAR-xmlls.jar
commons-digester-1.7.jar postgresql-8.1-407.jdbc3.jar
commons-discovery-0.2.jar resolver.jar
commons-logging-1.0.4.jar rrdjtool.jar
commons-pool-1.1.jar saaj.jar
exist-db-1.0rc.jar wsdl4j-1.5.1.jar
exist-xmldb-1.0rc.jar xalan-2.7.0.jar
exist-xmlrpc-1.0rc.jar xercesImpl-2.6.2.jar
ibatis-common-2.1.7.597.jar xercesSamples.jar
ibatis-sqlmap-2.1.7.597.jar xml-apis-1.3.02.jar
jaxrpc.jar xmlParserAPIs-2.6.2.jar
jdom-1.0b8.jar xmlParserAPIs.jar
log4j-1.2.8.jar xmldb.jar
mail-1.3.2.jar xmlrpc-1.2-patched.jar
mysql-connector-java-5.0.3.jar xmlsec.jar
best regards..
Mohammad Asif
-----Original Message-----
From: Loukik Kudarimoti
[mailto:]
Sent: Wed 12/13/2006 7:29 AM
To: Nicolas Simar
Cc: Maciej Glowiak; Roman Lapacz; Asif, Mohammad; ; Li, Yee-Ting
Subject: Re: [pS-dev] Problem with SQL-MA!!
Nicolas Simar wrote:
Excellent suggestion! I am suggesting below a wording for the FAQ (please check it, I have listed few questions in [...])
(I don't know if it has to go on the perfsonar, on thesteps of thewiki page for the tool) Suggestions?
Q: When installing a service and going through all theparser toinstallation guide, when testing, I get the following error:
Error in Perfsonar.log:
2006-12-12 15:36:55,683 INFO - RequestHandler: Service received a request
2006-12-12 15:36:55,700 DEBUG - RequestHandler: Calling onreplied to the request"parse the requestThe above lines are no errors, they are normal logs. They appear everytime the service recieves a request. If the logs terminate at just this (and don't end with something like "Service
2006-12-12 15:36:56,117 DEBUG - RequestHandler: Trying to retrieve Message object from Handler
2006-12-12 15:36:56,117 INFO - RequestHandler: Message object constructed from request. Request is of type: MetadataKeyRequest
2006-12-12 15:36:56,120 DEBUG - MessageHandlerFactory: classname asked for is org.perfsonar.commons.messages.MetadataKeyReques
[Is it the proper piece of text to have to describe the error?]
or "Service sent a response", something has gone wrong.of jars into
The problem that Asif Mohammad has encountered is not very easy to diagnose. From the SQL MA instance that I have installed, the following list contains info on the jars that are present in the tomcat/webapps/axis/WEB-INF/lib directory. Can Asif have a look and let us know if his list contains all these jars? If yes, try to restart tomcat and test again.
The list:
activation-1.0.2.jar jdom-1.0b8.jar
axis-ant.jar
log4j-1.2.8.jar
axis.jar
commons-beanutils-1.7.0.jar
mail-1.3.2.jar
commons-collections-3.2.jar
mysql-connector-java-5.0.3.jar
commons-digester-1.7.jar perfSONAR-generic.jar
commons-discovery-0.2.jar
perfSONAR-sqlma.jar
commons-logging-1.0.4.jar postgresql-8.1-407.jdbc3.jar
commons-pool-1.1.jar saaj.jar
exist-db-1.0rc.jar wsdl4j-1.5.1.jar
exist-xmldb-1.0rc.jar xalan-2.7.0.jar
exist-xmlrpc-1.0rc.jar xercesImpl-2.6.2.jar
ibatis-common-2.1.7.597.jar
xml-apis-1.3.02.jar
ibatis-sqlmap-2.1.7.597.jar
xmlParserAPIs-2.6.2.jar
jaxrpc.jar
Loukik.
A: This error message appears
(i) when some jars (or maybe just one) are missing in Tomcat after the deploy operation. (the deploy operation copies a setbe foundTomcat). The list Jar names you should see in [WHERE?] candoes "see copyin the following ANT files:
- For SQL MA: axis-deploy-targets.xml and sqlma-axis-deploy-targets.xml (see copy targets) [whatappears once a month.targets" means]
- For RRD MA: [WHICH ONES?]
(ii) or you have all jars but Tomcat wasn't restarted.
Nicolas
Maciej Glowiak wrote:
Hi,
It's very common problem for new users. It usually
http://wiki.perfsonar.net/jra1-wiki/index.php/Java_SQL_MA_ServicWhy don't we put it on http://www.perfsonar.net/faq.html ?
Maciej
Roman Lapacz wrote:
Nicolas Simar wrote:
Roman Lapacz wrote:
Asif, Mohammad wrote:
I have gone through all the required steps for installing the SQL-MA, mentioned at
gives an errore_Installation_Guide
The problem arrise, when I start testing it. Itmaybe justfor which I don't have any idea what is happened wrong.This error message appears usually when some jars (or
have all jarsone) are missing in Tomcat after deploy operation (deploy operation copies a set of jars into Tomcat). Or youverification?but didn't restart Tomcat.Hi Roman,
do you have a list of jars which should be there? For
sqlma-axis-deploy-targets.xml (see copyJar names can be found in Ant files. For SQL MA: axis-deploy-targets.xml and/opt/perfSONAR-SQL_MA-src-snapshot-20060907/perfsonar/schema/exatargets).
Roman
Cheers,
Nicolas
Roman
ant -f build-sqlma.xml run-sqlma-client-key-util
Buildfile: build-sqlma.xml
run-sqlma-client-key-util:
[java] End point: http://localhost:8080/axis/services/MeasurementArchiveService
[java] Request file:
/opt/perfSONAR-SQL_MA-src-snapshot-20060907/perfsonar/schema/example-instances/sonar/MetadataKey-Req.xml
[java] Response file:
{http://schemas.xmlsoap.org/soap/envelope/}Server.userExceptionmple-instances/sonar/response.xml
[java] SOAPClient.makeRequest: General exception encountered by client
[java] AxisFault
[java] faultCode:
org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBu[java] faultSubcode:
[java] faultString: java.lang.reflect.InvocationTargetException
[java] faultActor:
[java] faultNode:
[java] faultDetail:
[java] {http://xml.apache.org/axis/}hostname:aegir
[java] java.lang.reflect.InvocationTargetException
[java] at
org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuiilder.java:222)
[java] at
org.apache.axis.encoding.DeserializationContext.endElement(Deserlder.java:129)
[java] at
org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(UializationContext.java:1087)
[java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown
Source)
[java] at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentConknown
Source)
[java] at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocumententDispatcher.dispatch(Unknown
Source)
[java] at
org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)nt(Unknown
Source)
[java] at
org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)[java] at
org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)[java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
[java] at
org.apache.axis.encoding.DeserializationContext.parse(Deserializ[java] at javax.xml.parsers.SAXParser.parse(SAXParser.java:375)
[java] at
org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUationContext.java:227)
[java] at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
[java] at org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
[java] at
org.perfsonar.client.testHarness.SOAPClient.makeRequest(UnknownnderstandChecker.java:62)
[java] at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
[java] at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
[java] at org.apache.axis.client.Call.invoke(Call.java:2767)
[java] at org.apache.axis.client.Call.invoke(Call.java:1792)
[java] at
org.perfsonar.client.testHarness.SOAPClient.main(Unknown Source)Source)
[java] at
file name as: /opt/perfSONAR-SQL_MA-src-snapshot-20060907/perfsonar/conf/compo[java] Client exiting
BUILD SUCCESSFUL
Total time: 5 seconds
Error in catalina.out:
uxiliaryComponentManager.initManager: Read config
org.perfsonar.commons.auxiliary.components.configuration.propertnents.properties
AUX ComponentManager create [config] =
ComponentManager createies.PropertiesConfigurationComponent
AUX ComponentManager: init [config] AUXorg.perfsonar.commons.auxiliary.components.logger.log4j.Log4jLog[logger] =
ComponentManager creategerComponent
AUX ComponentManager: init [logger] AUXorg.perfsonar.service.measurementArchive.eventTypeConfig.EventTy[eventType_config] =
Service receivedpeConfigurationComponent
AUX ComponentManager: init [eventType_config]
Error in Perfsonar.log:
2006-12-12 15:36:55,683 INFO - RequestHandler:Message objecta request
2006-12-12 15:36:55,700 DEBUG - RequestHandler: Calling on parser to parse the request
2006-12-12 15:36:56,117 DEBUG - RequestHandler: Trying to retrieve Message object from Handler
2006-12-12 15:36:56,117 INFO - RequestHandler:MetadataKeyRequestconstructed from request. Request is of type:
MessageHandlerFactory: classname2006-12-12 15:36:56,120 DEBUG -org.perfsonar.commons.messages.MetadataKeyRequestasked for is
- RE: [pS-dev] Problem with SQL-MA!!, maxim, 01/12/2007
- RE: [pS-dev] Problem with SQL-MA!!, Asif, Mohammad, 01/12/2007
- Re: [pS-dev] Problem with SQL-MA!!, Loukik Kudarimoti, 01/15/2007
- Re: [pS-dev] Problem with SQL-MA!!, Roman Lapacz, 01/15/2007
- Re: [pS-dev] Problem with SQL-MA!!, Loukik Kudarimoti, 01/15/2007
- Re: [pS-dev] Problem with SQL-MA!!, Loukik Kudarimoti, 01/15/2007
- Re: [pS-dev] Problem with SQL-MA!!, Roman Lapacz, 01/15/2007
- RE: [pS-dev] Problem with SQL-MA!!, maxim, 01/16/2007
- Re: [pS-dev] Problem with SQL-MA!!, Loukik Kudarimoti, 01/17/2007
- RE: [pS-dev] Problem with SQL-MA!! Support for ISO timestamp format ?, maxim, 01/16/2007
- Re: [pS-dev] Problem with SQL-MA!! Support for ISO timestamp format ?, Roman Lapacz, 01/17/2007
- Re: [pS-dev] Problem with SQL-MA!! Support for ISO timestamp format ?, Jeff W. Boote, 01/17/2007
- Problem with SQL-MA ( more problems ...), maxim, 01/18/2007
- Re: Problem with SQL-MA ( more problems ...), Roman Lapacz, 01/19/2007
- RE: Problem with SQL-MA ( more problems ...), maxim, 01/22/2007
- Re: Problem with SQL-MA ( more problems ...), Roman Lapacz, 01/23/2007
- Re: Problem with SQL-MA ( more problems ...), Roman Lapacz, 01/19/2007
- Problem with SQL-MA ( more problems ...), maxim, 01/18/2007
- Re: [pS-dev] Problem with SQL-MA!! Support for ISO timestamp format ?, Jeff W. Boote, 01/17/2007
- Re: [pS-dev] Problem with SQL-MA!! Support for ISO timestamp format ?, Roman Lapacz, 01/17/2007
- RE: [pS-dev] Problem with SQL-MA!!, Asif, Mohammad, 01/12/2007
Archive powered by MHonArc 2.6.16.