Skip to Content.
Sympa Menu

perfsonar-dev - Re: [pS-dev] Problem with SQL-MA!!

Subject: perfsonar development work

List archive

Re: [pS-dev] Problem with SQL-MA!!


Chronological Thread 
  • 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: Wed, 17 Jan 2007 10:31:28 +0000

maxim wrote:
There was no any
indication
in installation guide that rrdma.jar file must be removed before the
installation of sqlma.jar.
umm..we are missing an uninstallation / upgrade section in our documentation. We will work on it. Thanks for your input.

Hopefully from next release onwarrds this situation will be easy to handle because uninstallation of a service will be as easy as deleting a folder (or removing a line of configuration in your tomcat).

Loukik.
--Maxim
-----Original Message-----
From: Loukik Kudarimoti [mailto:] Sent: Monday, January 15, 2007 5:37 AM
To: maxim
Cc: 'Asif, Mohammad'; 'Maciej Glowiak'; 'Roman Lapacz'; ; 'Li, Yee-Ting'; Nicolas Simar
Subject: Re: [pS-dev] Problem with SQL-MA!!

maxim wrote:
Hi Asif,
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.
Hi 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 are
some 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 the
same logs and error.
ls $AXIS_LIB
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 the
wiki or on the
wiki page for the tool) Suggestions?


Q: When installing a service and going through all the
steps of the
installation 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 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: 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?]
The 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
replied to the request"
or "Service sent a response", something has gone wrong.

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 set
of jars into
Tomcat). The list Jar names you should see in [WHERE?] can
be found
in the following ANT files:
- For SQL MA: axis-deploy-targets.xml and sqlma-axis-deploy-targets.xml (see copy targets) [what
does "see copy
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
appears once a month.
Why 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

http://wiki.perfsonar.net/jra1-wiki/index.php/Java_SQL_MA_Servic
e_Installation_Guide


The problem arrise, when I start testing it. It
gives an error
for which I don't have any idea what is happened wrong.
This error message appears usually when some jars (or
maybe just
one) are missing in Tomcat after deploy operation (deploy operation copies a set of jars into Tomcat). Or you
have all jars
but didn't restart Tomcat.
Hi Roman,
do you have a list of jars which should be there? For
verification?
Jar names can be found in Ant files. For SQL MA: axis-deploy-targets.xml and
sqlma-axis-deploy-targets.xml (see copy
targets).

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/exa
mple-instances/sonar/MetadataKey-Req.xml

[java] Response file:
/opt/perfSONAR-SQL_MA-src-snapshot-20060907/perfsonar/schema/exa
mple-instances/sonar/response.xml

[java] SOAPClient.makeRequest: General exception encountered by client
[java] AxisFault
[java] faultCode:
{http://schemas.xmlsoap.org/soap/envelope/}Server.userException
[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.createFault(SOAPFaultBu
ilder.java:222)

[java] at
org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBui
lder.java:129)

[java] at
org.apache.axis.encoding.DeserializationContext.endElement(Deser
ializationContext.java:1087)

[java] at
org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown
Source)
[java] at
org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(U
nknown
Source)
[java] at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentCo
ntentDispatcher.dispatch(Unknown
Source)
[java] at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocume
nt(Unknown
Source)
[java] at
org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[java] at
org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
[java] at
org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
[java] at javax.xml.parsers.SAXParser.parse(SAXParser.java:375)
[java] at
org.apache.axis.encoding.DeserializationContext.parse(Deserializ
ationContext.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.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustU
nderstandChecker.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.makeRequest(Unknown
Source)
[java] at
org.perfsonar.client.testHarness.SOAPClient.main(Unknown Source)
[java] Client exiting

BUILD SUCCESSFUL
Total time: 5 seconds

Error in catalina.out:

uxiliaryComponentManager.initManager: Read config
file name as: /opt/perfSONAR-SQL_MA-src-snapshot-20060907/perfsonar/conf/compo
nents.properties

AUX ComponentManager create [config] =

org.perfsonar.commons.auxiliary.components.configuration.propert
ies.PropertiesConfigurationComponent

AUX ComponentManager: init [config] AUX
ComponentManager create
[logger] =

org.perfsonar.commons.auxiliary.components.logger.log4j.Log4jLog
gerComponent

AUX ComponentManager: init [logger] AUX
ComponentManager create
[eventType_config] =

org.perfsonar.service.measurementArchive.eventTypeConfig.EventTy
peConfigurationComponent

AUX ComponentManager: init [eventType_config]


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 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:
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.MetadataKeyRequest






Archive powered by MHonArc 2.6.16.

Top of Page