Page Comparison

...

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 kfsonly default character set 'utf8' default collate 'utf8_bin'; create database rice default character set 'utf8' default collate 'utf8_bin'; create user kfs@localhost identified by 'kfs'; create user kfs@'%' identified by 'kfs'; create user kfsonly@localhost identified by 'kfsonly'; create user kfsonly@'%' identified by 'kfsonly'; create user rice@localhost identified by 'rice'; create user rice@'%' identified by 'rice'; grant all on kfs.* to kfs@localhost; grant all on kfs.* to kfs@'%'; grant all on kfsonly.* to kfsonly@localhost; grant all on kfsonly.* to kfsonly@'%'; grant all on rice.* to rice@localhost; grant all on rice.* to rice@'%';

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

   Code Block
   datasource.driver=com.mysql.jdbc.Driver kfs.datasource.ddl.username=kfsonly kfs.datasource.ddl.password=kfsonly kfs.datasource.ddl.url=jdbc:mysql://localhost/kfsonly rice.datasource.ddl.url=jdbc:mysql://localhost/rice rice.datasource.ddl.username=rice rice.datasource.ddl.password=rice updateDatabaseFullRebuild=true updateDatabaseContext=demo

3. Create a properties file for LiquiRelational to populate the kfs database.  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 kfs.datasource.ddl.url=jdbc:mysql://localhost/kfs rice.datasource.ddl.url=jdbc:mysql://localhost/kfs rice.datasource.ddl.username=kfs rice.datasource.ddl.password=kfs updateDatabaseFullRebuild=true updateDatabaseContext=unit

4. Run LiquiRelational for kfsonly 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-kfsonly.properties co.kuali.financials.datatools.liquirelational.LiquiRelational

5. Run LiquiRelational for kfs  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-kfs.properties co.kuali.financials.datatools.liquirelational.LiquiRelational

...