This document provides an overview of how to setup infoScoop OpenSource.

Installation Requirements

These are requirements that needs before the setup of infoScoop OpenSource.

Apache Ant

Apache Ant is used for settings of deploying WAR file. Install later version than Ant 1.6.5.

Database

infoScoop OpenSource supports following DBMS.

• MySQL 5.1
• DB2 9.5, 9.7
• Oracle10g R2 or higher(Note: An error reported with the JDBC driver of 10.2.0.1; when ones after Update2 works with the driver, initial data import tool causes an error.)

Setup for Repository Database

Create database for infoscoop repository in using DBMS.

Note : The database that can process multibyte characters is needed to be created if multibyte characters are used.
Note : Specify 32k for page size in DB2

Schema Definition

Add tables to prepared database. Schema is prepared in the directory of each database.
Execute file named tools/initdb/schema//init.sql init.sql and define table.

Example :  For MySQL, tools/initdb/schema/mysql> mysql -uroot -proot < mysqlinit.sql

Import of initial data

Import tool initdb/import.bat(sh) is used for inserting initial data.

Copy of JDBC driver

Copy the jar file including JDBC driver of using database to following directory.

tools/initdb/lib

Settings of database

Settings of database is described in bin/datasource.xml. The following is the example of settings for MySQL.

…abbr…
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
  <property name="driverClassName">
   <value>com.mysql.jdbc.Driver</value>
  property>
  <property name="url">
   <value>jdbc:mysql://localhost:3306/iscoop
  </property>
  
   rootvalue>
  </property>
prop>
     <prop key="hibernate.show_sql">true</prop>
  property> 

…abbr…

Property name	Description
driverClassName	Class name of JDBC driver Default：com.mysql.jdbc.Driver
url	Database URL Default：jdbc:mysql://localhost:3306/iscoop?useUnicode=true&characterEncoding=UTF-8
username	User Name of Database Connection Default：root
password	User Password of Database Connection Default：
hibernate.dialect	Specify following values as using database MySQL: org.hibernate.dialect.MySQLDialect Oracle: org.hibernate.dialect.Oracle10gDialect DB2: org.hibernate.dialect.DB2Dialect
hibernate.default_schema	Schema name of repository database. Setting is not required for MySQL

Adding User

Specify adding user to repository database in advanced. Describe user in the following CSV file.
tools/initdb/data/accounts/import.csv

CSV is described in following format.
,,

Note: Do not delete user "admin" as it is administrator by default.

Executing import.bat(sh)

Execute import.bat(sh) in command line.

Prepare Web application server

infoScoop OpenSource is worked on web application server that conform to J2EE. Prepare for web application server to deploy infoScoop OpenSource.

Define prepared database as the datasource of  web application server.

jdbc/infoscoop is specified for default JNDI name that is also specified in WAR file of infoScoop OpenSource.

Follow the manual of using web application server and define datasource.

Deploying Web Application Module

Change Settings of WAR File

infoScoop OpenSource is distributed in WAR file format. The settings of WAR file can be changed by using tool  called "remakewar.bat". "remakewar.bat" is in the following directory.
infoscoop/remakewar.bat

Specify the file below for executing property of "remakewar.bat".
infoscoop/build.properties

The property required in minimum configuration is explained below.

Property Name	Descriptuion
datasource.jndiName	Specify JNDI name of datasource. This property does not need to be changed if the JNDI name of datasource is set as "jdbc/infoscoop" by default in Web application server.
datasource.schema	Schema name of repository database. Setting is not required for MySQL
datasource.dialect	Specify following values as using database MySQL: org.hibernate.dialect.MySQLDialect Oracle: org.hibernate.dialect.Oracle10gDialect DB2: org.hibernate.dialect.DB2Dialect

Refer to Install Manual of infoScoop OpenSource for other properties.

"dist" directory is created and WAR file for deployment is created in the "dist" directory if remakewar.bat(sh) is executed.

Deploying WAR File

Setup is done after deploying this WAR file to web application server and start context.

Start Apache Tomcat, and then access the following URL and login as admin using a password, "admin".
http://:8080/infoscoop/

infoScoop OpenSource's main portal screen is to be shown up.

infoScoop OpenSource now provides 10 test user accounts since version 2.2 so that you can check how it works with several users;