Skip to end of metadata
Comment: Migrated to Confluence 4.0
Go to start of metadata

Update to http://xplanner.org/install.html

  • copy the jdbc driver into a new directory under xplanner/lib/jdbc-driver in 0.6.2 xplanner/lib/webapp/jdbc-driver in 0.6.3
  • no need to create a build.properties

Oracle installation.

Dear Oracle xplanner users. I am calling upon your generosity to update this page to make it as accurate as possible

In following steps:

  • Replace the <xxx> with your own values.
  • All file paths are relative to the root of the distribution zip file (usually xplanner_x.x.x, xplanner_0.6.2 for 0.6.2)

  1. Create a database <dbname> on the oracle server. This server will be named <server> for the rest of the instructions. If xplanner and oracle runs on the same server you can just use localhost.
  2. Create an oracle user with name <user> and password <password>. Grant <user> all access rights to <dbname> (schema and data manipulation is needed during install).
  3. Create an file resource/xplanner-custom.properties that you will use to add the properties you override from their default values located in resouces/xplanner.properties.

    Doing it this way instead of just copying the xplanner.properties entirely usually makes upgrading easier since you won't have to find what properties you modified.

  4. Add the oracle connection properties in it
    resource/xplanner-custom.properties
  5. In xplanner.properties, comment out the mysql connection properties by adding a # at the beginning of each line:
    resource/xplanner.properties
  6. Run ant install.db.schema
  7. Configure email by setting the following properties
    resource/xplanner-custom.properties
  8. Further customize xplanner following http://xplanner.org/customization.html
  9. Run ant war
  10. Deploy war by copying the xplanner.war to your application server webapps directory (in tomcat it is <TOMCAT_HOMR>/webapps)
  11. Start your application server (for tomcat it is <TOMCAT_HOME>/bin/startup.bat> on windows or <TOMCAT_HOME>/bin/startus.sh> on unix)
  12. Login to xplanner (if you are using default tomcat, the url to go to is http://localhost:8080/xplanner) as user sysadmin password admin

FAQ

XPlanner installation FAQ

Labels:
None
Edit Labels

2 Comments

Hide/Show Comments

  1. Jul 13, 2005

    Anonymous

    regarding oracle and other non-mysql databases:
    a small description on how to do changes in oracle-mapping-transform.xsl would be nice.

  2. Mar 08, 2006

    Anonymous

    1. download and unzip the xplanner-0.7b4-war.zip file in a temp directory,

    2. copy D:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar into jakarta-tomcat-5.0.30\webapps\xplanner\WEB-INF\lib\ folder

    3. edit the xplanner-custom.properties for Oracle 10g connection info.

    4. run the following SQL script to create the database tablespace, user, and access.

    5. run xplanner-0.7b4-war\install.bat new

    6. copy the xplanner-0.7b4-war\xplanner\ into jakarta-tomcat-5.0.30\webapps\xplanner\

    7. start tomcat

    8. open the url (http://localhost:8080/xplanner) in the browser to test the application. please find the username/password in the readme file.

    * * ** ** ** * * ** ** ** * * ** ** ** * * ** ** ** * * ** ** ** * * ** ** ** * * ** ** ** * * ** ** ** * * ** ** **

    The following script is for a fresh installation NOT for upgrade. The username, password must be same as in xplanner-custom.properties.

    Open SQLPLUS cli or SQuirrel client to execute this script after edit, cut and paste.

    then run install.bat new

    CREATE SMALLFILE TABLESPACE "XPLANNER"
    DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\XPLANNER.DBF'
    SIZE 32M REUSE
    AUTOEXTEND ON NEXT 32768K
    MAXSIZE 2048M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

    CREATE USER "XPLANNER"
    PROFILE "DEFAULT"
    IDENTIFIED BY "xp"
    DEFAULT TABLESPACE "XPLANNER"
    TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK
    GRANT UNLIMITED TABLESPACE TO "XPLANNER"
    GRANT "AUTHENTICATEDUSER" TO "XPLANNER"
    GRANT "DBA" TO "XPLANNER"