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

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

   Code Block

   datasource.driver=com.mysql.jdbc.Driver kfs.datasource.ddl.username=kfsonlykfs kfs.datasource.ddl.password=kfsonly${kfs.datasource.ddl.username} kfs.datasource.ddl.url=jdbc:mysql://localhost/kfsonly${kfs.datasource.ddl.username} rice.datasource.ddl.url=jdbc:mysql://localhost/username=rice rice.datasource.ddl.usernamepassword=${rice.datasource.ddl.password} rice.datasource.ddl.password=riceurl=jdbc:mysql://localhost/${rice.datasource.ddl.password} updateDatabaseFullRebuild=true updateDatabaseContext=demo

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

   Code Block

   datasource.driver=com.mysql.jdbc.Driver kfs.datasource.ddl.username=kfsunit 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.password} 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 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-kfsonlykfs.properties org.kuali.kfs.sys.datatools.liquirelational.LiquiRelational

5. Run LiquiRelational for kfs 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-kfsunit.properties org.kuali.kfs.sys.datatools.liquirelational.LiquiRelational

...

Run catalina.bat run on Windows or catalina.sh run if not.

When tomcats starts up, you can access rice at http://localhost:8081/kr-dev/

Configuring Financials

Financials will need to know about your Rice instance.  You will need to create a properties file and pass the name of that file to Financials using the additional.kfs.config.locations system property.  Here is an example of that properties file:

...