Versions Compared

Version Old Version 1 New Version 2
Changes made by

Former user

Former user

Saved on

Key

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

DEFAULT PROCESS

  1. Checkout the project Open the default local properties file
    No Format
    svn checkout https://svn~/.kuali.org/repos/ole/branches/dev/50-upgrade-test-1
  2. Change into the directory for the ole-sql module
    No Format
    cd ole-app/ole-db/ole-sql
  3. Bundle the SQL
    No Format
    mvn clean install
  4. Change directories back to the OLE FS directory
    No Format
    cd ../../ole-fs
  5. Execute the SQL
    No Format
    mvn initialize -Pdb
  6. The default MySQL process assumes
    1. There is a MySQL server running locally
    2. The MySQL server is version 5.1+
    3. The MySQL server is listening for connections on the default MySQL port which is 3306
    4. The root user for MySQL does not have a password which is the default
    5. There is a response from the default MySQL jdbc url which is jdbc:mysql://localhost
  7. The process will create a database user named OLE with the password set to OLE
  8. The process will create and populate a database named OLE
  9. To execute the SQL against an Oracle database
    No Format
    mvn initialize -Pdb,oracle

PROPERTIES

Name

Default

Description

mysql.dba.username

root

MySQL user with dba privileges

mysql.dba.password

NONE

Special value meaning there is no password for root

mysql.dba.url

jdbc:mysql://localhost

The JDBC URL root connects to

oracle.dba.username

SYS AS SYSDBA

Oracle user with dba privileges

oracle.dba.password

CHANGE_ON_INSTALL

The default password after a new install

oracle.dba.url

jdbc:oracle:thin:@localhost:1521:XE

The JDBC URL the Oracle dba user connects to

jdbc.username

OLE

The name of the user/database/schema to create

jdbc.password

OLE

The password for the OLE user

CUSTOMIZATION

  1. Default property values can be customized by
  2. Setting a system property. You can do this on the command line using -Dname=value
    No Format
    mvn initialize -Pdb -Dmysql.dba.password=xyz
    3. Adding them to the properties file 
    fs/ole-fs.properties
  3. Add the workflow ingestion property
    No Format
    ole.workflow.unpack=true
  4. Start Tomcat

DETAILS

  1. During application startup the workflow XML files for OLE FS will be automatically unpacked into the default pending directory
    No Format
    ~/.kuali/ole/
    ole-fs.propertiesSystem properties always win if the same customized property value is provided in more than one spot
    fs/work/staging/workflow/pending