Is there also a database called 'rftDatabase', as specified in the connectionString parameter in the JNDI configuration? And does it contain the required tables? (http://www.globus.org/toolkit/docs/4.0/data/rft/admin-index.html#s-rft-admin-mysql)
-Martin Soumyadeep nandi wrote:
RFT uses a database to store persistence data. It looks like the database connection parameters are incomplete (username seems to be ''). Check the parameters in the section 'dbConfiguration' in $GLOBUS_LOCATION/etc/globus_wsrf_rft/jndi-config.xml and verify that you can connect to the database with the values that are provided there.I can connect to the mysql database with user=globus as "mysql -u globus", there is a database named cluster. The parameters in the $GLOBUS_LOCATION/etc/globus_wsrf_rft/jndi-config.xml file is as below: <resource name="dbConfiguration" type="org.globus.transfer.reliable.service.database.RFTDatabaseOptions"> <resourceParams> <parameter> <name>factory</name> <value>org.globus.wsrf.jndi.BeanFactory</value> </parameter> <parameter> <name>driverName</name> <value>com.mysql.jdbc.Driver</value> </parameter> <parameter> <name>connectionString</name> <value>jdbc:mysql:///rftDatabase</value> </parameter> <parameter> <name>userName</name> <value>globus</value> </parameter> <parameter> <name>password</name> <value></value> </parameter> <parameter> <name>maxActive</name> <value>20</value> </parameter> <parameter> <name>maxIdle</name> <value>10</value> </parameter> <parameter> <name>maxWait</name> <value>-1</value> </parameter> </resourceParams> </resource> ----- Original Message ---- From: Martin Feller <[email protected]> To: Soumyadeep nandi <[email protected]> Cc: [email protected] Sent: Saturday, February 7, 2009 7:47:19 PM Subject: Re: [gt-user] globusrun-ws: Job failed: Staging error for RSL element fileStageIn. RFT uses a database to store persistence data. It looks like the database connection parameters are incomplete (username seems to be ''). Check the parameters in the section 'dbConfiguration' in $GLOBUS_LOCATION/etc/globus_wsrf_rft/jndi-config.xml and verify that you can connect to the database with the values that are provided there. -Martin Soumyadeep nandi wrote:Thanks Martin, I am using Globus 4.0.3 in Rocks clusters 4.3. I can see only two files container.log and globus-fork.log in $GLOBUS_LOCATION/var/ is updated after subbmitting the job. Below is the content updated in container.log after submitting the job: 2009-02-07 12:01:07,736 INFO exec.StateMachine [RunQueueThread_13,logJobAccepted:3193] Job e6ce34b6-f4e0-11dd-903e-00e050002277 accepted for local user 'osdd' 2009-02-07 12:01:09,375 ERROR factory.ReliableFileTransferFactoryService [RunQueueThread_17,createReliableFileTransfer:243] Unable to create RFT resource org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Access denied for user ''@'localhost' to database 'rftDatabase' at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:101) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:722) at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:146) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:193) at org.globus.transfer.reliable.service.database.RFTDatabaseSetup.getDBConnection(RFTDatabaseSetup.java:200) at org.globus.transfer.reliable.service.database.ReliableFileTransferDbAdapter.storeTransferRequest(ReliableFileTransferDbAdapter.java:175) at org.globus.transfer.reliable.service.ReliableFileTransferResource.<init>(ReliableFileTransferResource.java:193) at org.globus.transfer.reliable.service.ReliableFileTransferHome.create(ReliableFileTransferHome.java:120) at org.globus.transfer.reliable.service.factory.ReliableFileTransferFactoryService.createReliableFileTransfer(ReliableFileTransferFactoryService.java:235) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:384) at org.globus.axis.providers.RPCProvider.invokeMethodSub(RPCProvider.java:107) at org.globus.axis.providers.PrivilegedInvokeMethodAction.run(PrivilegedInvokeMethodAction.java:42) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:396) at org.globus.gsi.jaas.GlobusSubject.runAs(GlobusSubject.java:55) at org.globus.gsi.jaas.JaasSubject.doAs(JaasSubject.java:90) at org.globus.axis.providers.RPCProvider.invokeMethod(RPCProvider.java:97) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:281) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:319) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:450) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:285) at org.apache.axis.transport.local.LocalSender.invoke(LocalSender.java:141) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) at org.apache.axis.client.Call.invokeEngine(Call.java:2727) at org.apache.axis.client.Call.invoke(Call.java:2710) at org.apache.axis.client.Call.invoke(Call.java:2386) at org.apache.axis.client.Call.invoke(Call.java:2309) at org.apache.axis.client.Call.invoke(Call.java:1766) at org.globus.rft.generated.bindings.ReliableFileTransferFactoryPortTypeSOAPBindingStub.createReliableFileTransfer(ReliableFileTransferFactoryPortTypeSOAPBindingStub.java:874) at org.globus.exec.service.exec.utils.StagingHelper.submitStagingRequest(StagingHelper.java:168) at org.globus.exec.service.exec.StateMachine.processStageOutState(StateMachine.java:1767) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.globus.exec.service.exec.StateMachine.processState(StateMachine.java:302) at org.globus.exec.service.exec.RunThread.run(RunThread.java:85) Caused by: java.sql.SQLException: Access denied for user ''@'localhost' to database 'rftDatabase' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3700) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1203) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2572) at com.mysql.jdbc.Connection.<init>(Connection.java:1485) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:95) ... 48 more 2009-02-07 12:01:09,718 INFO exec.StateMachine [RunQueueThread_7,logJobFailed:3212] Job e6ce34b6-f4e0-11dd-903e-00e050002277 failed 2009-02-07 12:01:16,508 ERROR impl.QueryAggregatorSource [Timer-3,pollGetMultiple:149] Exception Getting Multiple Resource Properties from https://172.16.5.118:8443/wsrf/services/ReliableFileTransferFactoryService: java.rmi.RemoteException: Failed to serialize resource property org.globus.transfer.reliable.service.factory.totalnumberofbytestransfer...@468034b6; nested exception is: org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Access denied for user ''@'localhost' to database 'rftDatabase' ----- Original Message ---- From: Martin Feller <[email protected]> To: Soumyadeep nandi <[email protected]> Cc: [email protected] Sent: Friday, February 6, 2009 10:50:33 PM Subject: Re: [gt-user] globusrun-ws: Job failed: Staging error for RSL element fileStageIn. Which version of the GT is that? From 4.0.5+ on there should be better error messages on the client-side. Does the GT logfile show more information? -Martin Soumyadeep nandi wrote:Hi, While submitting job description file with command "globusrun-ws -submit -s -f test-simple-1.xml". I am encountering the following error: Delegating user credentials...Done. Submitting job...Done. Job ID: uuid:af86eef0-f056-11dd-bca4-00e050002277 Termination time: 02/02/2009 11:51 GMT Current job state: StageIn Current job state: Failed Destroying job...Done. Cleaning up any delegated credentials...Done. globusrun-ws: Job failed: Staging error for RSL element fileStageIn. I am submitting the job in the same machine named sit.hpc.org and trying to get the out.log and err.log from /tmp to the home directory.. Following is the job description file: <?xml version="1.0" encoding="UTF-8"?> <job> <executable>/bin/echo</executable> <directory>/tmp</directory> <argument>Test</argument> <stdout>/tmp/out.log</stdout> <stderr>/tmp/err.log</stderr> <fileStageIn> <transfer> <sourceUrl>gsiftp://sit.hpc.org:2811/tmp/out.log <destinationUrl>file:///${GLOBUS_USER_HOME}/out.log</destinationUrl> </transfer> <transfer> <sourceUrl>gsiftp://sit.hpc.org:2811/tmp/err.log <destinationUrl>file:///${GLOBUS_USER_HOME}/err.log</destinationUrl> </transfer> </fileStageIn> </job> Could someone suggest me where I am going wrong? Thanking you, Regards, Soumyadeep
