perfsonar development work

[maxim <>]

 Hi Loukik,
I was testing my SQL MA with L2 status store data requests and I;ve found
that it does not support
this kind of time format  <ifevt:datum timeType="ISO"
timeValue="2007-01-16T22:25:00.0-6:00"> ???
Why is that ( taking in account that E2E MP supports this format ) ???
Thanks,
           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
> >>     
> >>>>>>>>>   
> >>>>>>>>>               
> >>>>>>>>>                   
> >>>>>>>>             
> >>>>>>>>                 
> >>>>>>         
> >>>>>>             
> >>>>>       
> >>>>>           
> >>>   
> >>>       
> >>
> >>
> >>     
> >
> >
> >   
> 
>