Versions Compared

Old Version 21

changes.mady.by.user Former user

Saved on

compared with

New Version 22

changes.mady.by.user Travis Foxley

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Login to Mysql as the root user.  Run these commands to create the databases, users and permissions.

    Code Block
    create database kfs default character set 'utf8' default collate 'utf8_bin';
create database rice default character set 'utf8' default collate 'utf8_bin';
create database unit default character set 'utf8' default collate 'utf8_bin';

create user kfs@localhost identified by 'kfs';
create user kfs@'%' identified by 'kfs';

create user rice@localhost identified by 'rice';
create user rice@'%' identified by 'rice';

create user unit@localhost identified by 'unit';
create user unit@'%' identified by 'unit';

grant all on kfs.* to kfs@localhost;
grant all on kfs.* to kfs@'%';

grant all on rice.* to rice@localhost;
grant all on rice.* to rice@'%';
 
grant all on unit.* to unit@localhost;
grant all on unit.* to unit@'%';

  2. Create a properties file for LiquiRelational to populate the kfs and rice databases.  Name the file lr-kfs.properties.  Here are the contents:

    Code Block
    datasource.driver=com.mysql.jdbc.Driver

kfs.datasource.ddl.username=kfs
kfs.datasource.ddl.password=${kfs.datasource.ddl.username}
kfs.datasource.ddl.url=jdbc:mysql://localhost/${kfs.datasource.ddl.username}

rice.datasource.ddl.username=rice
rice.datasource.ddl.password=${rice.datasource.ddl.passwordusername}
rice.datasource.ddl.url=jdbc:mysql://localhost/${rice.datasource.ddl.passwordusername}

updateDatabaseFullRebuild=true
updateDatabaseContext=demo

  3. Create a properties file for LiquiRelational to populate the unit database.  Name the file lr-unit.properties.  Here are the contents:

    Code Block
    datasource.driver=com.mysql.jdbc.Driver

kfs.datasource.ddl.username=unit
kfs.datasource.ddl.password=${kfs.datasource.ddl.username}
kfs.datasource.ddl.url=jdbc:mysql://localhost/${kfs.datasource.ddl.username}

rice.datasource.ddl.username=unit
rice.datasource.ddl.password=${rice.datasource.ddl.passwordusername}
rice.datasource.ddl.url=jdbc:mysql://localhost/${rice.datasource.ddl.passwordusername}

updateDatabaseFullRebuild=true
updateDatabaseContext=unit

  4. Run LiquiRelational for kfs and rice.  Make sure to adjust the paths appropriately.  You must be in the root of the financials project when running this.

    Code Block
    mvn -DskipTests clean package
 
java -Xmx4g -classpath ./kfs-web/target/kfs-web/WEB-INF/lib/*:/Users/user/java/drivers/mysql-connector-java-5.1.36.jar -Dadditional.kfs.config.locations=/Path/lr-kfs.properties org.kuali.kfs.sys.datatools.liquirelational.LiquiRelational

  5. Run LiquiRelational for the unit test database.  Make sure to adjust the paths appropriately.  You must be in the root of the financials project when running this.

    Code Block
    mvn -DskipTests clean package (you do not need to run this again if you ran it in step 4 without making code changes)
 
java -Xmx4g -classpath ./kfs-web/target/kfs-web/WEB-INF/lib/*:/Users/user/java/drivers/mysql-connector-java-5.1.36.jar -Dadditional.kfs.config.locations=/Path/lr-unit.properties org.kuali.kfs.sys.datatools.liquirelational.LiquiRelational

...