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
