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: maxim <>
  • To: 'Loukik Kudarimoti' <>
  • Cc: "'Asif, Mohammad'" <>, 'Maciej Glowiak' <>, 'Roman Lapacz' <>, , "'Li, Yee-Ting'" <>, 'Nicolas Simar' <>
  • Subject: RE: [pS-dev] Problem with SQL-MA!!
  • Date: Tue, 16 Jan 2007 10:09:52 -0600

Hi Loukik,
It was RRD MA distribution, so xxx-rrdma.jar was there. Once I;ve installed
and configured sql ma, then tomcat service configuration file got only
one service but it didnt work until I've removed xxxrrdma.jar . And yes,
the jar file was under ...webapps/axis/WEB-INF/lib ( I called it tomcat lib
directory
which perhaps should be called service lib directory ). There was no any
indication
in installation guide that rrdma.jar file must be removed before the
installation of sqlma.jar.
--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