Using MySQL

RFT in 4.1.3 works with MySQL database. A MySQL schema file is provided at $GLOBUS_LOCATION/share/globus_wsrf_rft/rft_schema_mysql.sql. You will need to download MySQL drivers (MySQL connector/J 3.1 and not 3.0) from here and copy the driver jar to $GLOBUS_LOCATION/lib. You will also need to make following changes :

  1. Create a RFT Database and populate it with mysql schema.

    mysqladmin -h hostname create rftDatabase -p
    
    mysql -h hostname -D rftDatabase
    
    source share/globus_wsrf_rft/rft_schema_mysql.sql
    
    
    [Note]Note

    If you are using older ( earlier than 4.1 ) versions of MySQL, you will need to use the schema $GLOBUS_LOCATION/share/globus_wsrf_rft/rft_schema_mysql_pre4.0.sql to make RFT work. See Bug 3633 for more details.

  2. Edit $GLOBUS_LOCATION/etc/globus_wsrf_rft/jndi-config.xml and change the following values:

    • for connectionString, change jdbc:postgresql://host/rftDatabase to jdbc:mysql:///rftDatabase

    • for driverName, change org.postgresql.Driver to com.mysql.jdbc.Driver

    • and change the userName and password to whatever was set when users were created for MySQL.