Versions Compared

Version Old Version 27 New Version Current
Changes made by

Former user

Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

...

  1. Checkout the project
    No Format
    svn checkout https://svn.kuali.org/repos/ole/branches/dev/50-upgrade-test-1 ole
  2. Change into the directory for the ole-sql module
    No Format
    cd ole/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,mysql -N
  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
    5. The server is listening for connections on port 3306
    6. The JDBC connection URL that must respond which is the default
    7. 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

The URL the MySQL dba user connects to

Name

Default

Description

mysql.dba.url

jdbc:mysql://localhost

mysql.dba.username

root

MySQL user with dba privileges

mysql.dba.password

NONE

Special value meaning there is no password for root

oracle mysql.dba.url

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

The JDBC URL the Oracle dba user 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 and /database/schema to create

jdbc.password

OLE

The password for the OLE user

...

CUSTOMIZATION

  1. Any of the properties in that table can be overridden as needed
  2. Use Default property values can be customized by
    1. Setting a system property. You can do this on the command line using -Dname=value
    on the Maven command line
    1. No Format
      mvn initialize -Pdb
    ,mysql
    1.  -Dmysql.dba.password=xyz
    Add
    1. Adding them to the properties file
      No Format
      ~/.kuali/ole/ole-
    sql
    1. fs.properties
  3. System properties always win if the same customized property value is provided in more than one spot