Thanks Martin, Wow.. Its working.. I restarted the whole cluster... and worked... Thank you so much... The globus user mailing list is very helpful with the presence of guys of profound knowledge like that of you.. Thanking you all for the suggestions and time...
With profound regards, Soumyadeep Nandi ----- Original Message ---- From: Martin Feller <[email protected]> To: Soumyadeep nandi <[email protected]> Cc: [email protected] Sent: Monday, February 9, 2009 7:40:44 PM Subject: Re: [gt-user] globusrun-ws: Job failed: Staging error for RSL element fileStageIn. Soumyadeep nandi wrote: >> Is there also a database called 'rftDatabase', as specified in the >> connectionString parameter in the JNDI configuration? > > There is no database named "rftDatabase". "show databases" lists only > "cluster" and "test". > >> And does it contain the required tables? >> (http://www.globus.org/toolkit/docs/4.0/data/rft/admin-index.html#s-rft-admin-mysql) > > From the above GT 4.0 RFT document I found MySQL schema file located in > "$GLOBUS_LOCATION/share/globus_wsrf_rft/rft_schema_mysql.sql". > > Since there is no RFT Database, I wanted to create and populate the database > with mysql schema as suggested in the doc. > > [r...@sit osdd]# mysqladmin -h localhost create rftDatabase > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user 'root'@'localhost' (using password: YES)' > > Do I need the root user password and create the database as root, and > populate the database. Yes, and grant permissions in MySQL then to the user who accesses the DB and tables in RFT, as defined in the JNDI configuration file $GLOBUS_LOCATION/etc/globus_wsrf_rft/jndi-config.xml. > > > Also when tried to create database from the mysql prompt as globus user I get > the following error: > > [o...@sit ~]$ mysql -u globus > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 3010 to server version: 4.1.20 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> create database rftDatabase; > ERROR 1044 (42000): Access denied for user ''@'localhost' to database > 'rftDatabase' > > Did you have a look at the MySQL webpages? There should be documentation about MySQL administration and permission management. "mysqladmin -u root -p -h localhost create rftDatabase" is probably a starting point to create the DB (I assume the -p was missing). -Martin > > ----- Original Message ---- > From: Martin Feller <[email protected]> > To: Soumyadeep nandi <[email protected]> > Cc: [email protected] > Sent: Sunday, February 8, 2009 10:10:41 PM > Subject: Re: [gt-user] globusrun-ws: Job failed: Staging error for RSL > element fileStageIn. > > 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 >>>> >>>> >>>> >>> >> >> > > >
