perfSONAR User Q&A and Other Discussion

[Roman Lapacz <>]

Loukik Kudarimoti wrote:
> Hi Maciej,
>
> It looks like a problem with permissions.
>
> We now have a bug recorded
>
> https://bugzilla.perfsonar.net/show_bug.cgi?id=465
>
>
> Roman and Michalis, could you have a look please?
Hi

I suggest to take a look at ibatis config files 
(WEB-INF/classes/ibatis-SqlMapConfig-<metric>.xml) directly to be sure 
they are correct. If something is wrong there correct it and restart the 
Tomcat.

(example attached)

Roman

> thanks,
> Loukik
>
> Maciej Matachowski wrote:
> > Dear All,
> > I have established SQL MA service.
> > According to my configuration I would like to attach external database.
> > In http://localhost:8080/geant2-java-sql-ma/ , I go to SQL MA admin
> > and edit the entries with my details (like db location, db name ,
> > user, password).
> > When I confirm my changes such an error appears :
> >
> > Error! Error while modifying file, old file cannot be
> > renamed!/opt/perfsonar/tomcat/webapps/geant2-java-sql-ma/WEB-INF/classes//ibatis-SqlMapConfig-L2-status-interdomain.xml 
> >
> > /opt/perfsonar/tomcat/webapps/geant2-java-sql-ma/WEB-INF/classes//ibatis-L2-status-interdomain.xmlperfSONARWebAdmin.auxiliary.sqlma.ibatisFileManager.modifyIbatisFile(ibatisFileManager.java:177) 
> >
> > perfSONARWebAdmin.admin.sqlma.SQLMAdmin.editActions(SQLMAdmin.java:374)
> > perfSONARWebAdmin.admin.sqlma.SQLMAdmin.doPost(SQLMAdmin.java:160)
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 
> >
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
> >
> > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) 
> >
> > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) 
> >
> > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) 
> >
> > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
> >
> > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
> >
> > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) 
> >
> > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) 
> >
> > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) 
> >
> > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> > java.lang.Thread.run(Thread.java:619)
> >
> >
> > What can be wrong with my configuration ?
> >
> > Any help will be appreciated.
> >
> > thx,
> >
> > Regards,
> > Maciek
> >   

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig
          PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
          "http://www.ibatis.com/dtd/sql-map-config-2.dtd";>


<!-- $Id: ibatis-SqlMapConfig-utilization.template.xml 2566 2007-07-24 11:50:27Z roman $ -->
<!-- romradz -->


<sqlMapConfig>

    <settings useStatementNamespaces="false" />

    <transactionManager type="JDBC">
        <dataSource type="SIMPLE" >
            <property name="JDBC.Driver"        value="com.mysql.jdbc.Driver"/>
            <property name="JDBC.ConnectionURL" value="jdbc:mysql://127.0.0.1/perfsonar_ma"/>
            <property name="JDBC.Username"      value="perfsonar_ma"/>
            <property name="JDBC.Password"      value="testpass"/>
        </dataSource>
    </transactionManager>

    <sqlMap resource="ibatis-utilization.xml"/>

</sqlMapConfig>