perfsonar development work

[Roman Lapacz <>]

Are you sure you can access your database? You can test it using 
'run-mysql-sqlma-test1' target from 'sqlma/sqlma-test-run-targets.xml' 
(remember to change jdbc params).

Roman



Loukik Kudarimoti wrote:
> Roman,
>
> We installed SQL MA service using default settings. Using perfsonar 
> UI, we sent
> http://anonsvn.internet2.edu/svn/perfsonar/tags/JAVA-SQL-MA-1.1/schema/example-instances/perfSONAR/SetupData-L2status-Req-1.xml 
>
>
> and got this back
> <?xml version="1.0" encoding="UTF-8"?>
> <nmwg:message id="localhost.localdomain.74c28ded:112a01a1e3c:-655f_resp"
>  messageIdRef="localhost.localdomain.74c28ded:112a01a1e3c:-655f"
>  type="SetupDataResponse" xmlns:nmwg="http://ggf.org/ns/nmwg/base/2.0/";>
>  <nmwg:metadata id="resultCodeMetadata">
>    <nmwg:eventType>error.sqlma.db_connection</nmwg:eventType>
>  </nmwg:metadata>
>  <nmwg:data id="resultDescriptionData_for_resultCodeMetadata" 
> metadataIdRef="resultCodeMetadata">
>    <nmwgr:datum 
> xmlns:nmwgr="http://ggf.org/ns/nmwg/result/2.0/";>SQLStorageManager.fetch: 
> Unable to fetch data</nmwgr:datum>
>  </nmwg:data>
> </nmwg:message>
>
>
> The logs do not say why its unable to fetch data. How can we find out 
> the reason its failing?
>
> The service is running here:
>    
> http://srv2.ams.nl.geant2.net:8090/perfSONAR-SQL-MA-1.0/services/MeasurementArchiveService 
>
>
> Loukik