> 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. 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' ----- 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 >>> >>> >>> >> >> > > >
