Quickstart Setup

You are here:Overview > Downloading, Installing, and Configuring

Quickstart Setup

Use the following installation instructions to guide you through the baseline out-of-the-box setup.

Information on more advanced configuration and customization can be found in the public documentation.

Before You Begin - The following are required:

• Java 1.5

• Servlet 2.4 / JSP 2.0 Compatible Servlet Container such as Apache Tomcat 5.5

• Oracle database instance or MySQL database instance

•

	To set up Streamlyne Research (and Streamlyne platform) database: Streamlyne Research database release contains all SQL scripts needed to install a new schema or upgrade a Streamlyne Research 3.0 or 3.0.1 database using Streamlyne platform bundled or embedded mode with the database objects (tables, constraints, bootstrap data) for the Streamlyne Research application. If installing in an embedded Streamlyne platform environment you will be prompted to install/upgrade Streamlyne platform. If your Streamlyne platform server has been upgraded already you will answer no to the question (Streamlyne Research-specific data will still be added to your Streamlyne platform server).
	Installation Steps for Oracle Installation has been tested with sqlplus and SQL Developer. Other tools may require modification of the scripts.
1.	Create Oracle username of less than 8 characters
2.	Make sure Oracle user has following privileges: * DEFAULT TABLESPACE set to <Users Tablespace> (the intended location where the schema database structures and base bootstrap data are stored). * QUOTA UNLIMITED ON <Users Tablespace> * CREATE SESSION * CREATE SYNONYM * CREATE PROCEDURE * CREATE TRIGGER * CREATE TABLE * CREATE TYPE * CREATE VIEW * CREATE SEQUENCE A user’s DEFAULT TABLESPACE is set with the CREATE USER statement or ALTER USER statement. The TABLESPACE should not be the SYSTEM tablespace. A New install will COMPLETELY clear data from any existing Streamlyne Research tables in this schema!
	Installation Steps for MySQL Installation has been tested with mysql client. Other tools may require modification of the scripts.
1.	Set the following settings in MySQL: max_allowed_packet=1M transaction-isolation=READ-COMMITTED lower_case_table_names=1 max_connections=1000
2.	Create MySQL username of less than 8 characters.
3.	Create MySQL default schema for username with the default character set of UTF8. If a different character set is desired, the ddl scripts will need to be updated to the new character set.
4.	Make sure MySQL user has following privileges on the schema * Select * Insert * Update * Delete * Create * Drop * Index * Alter * Create_view * Create_routine * Alter_routine * Create_tmp_table * Lock_tables Be sure the schema is empty before a NEW installation.
End of activity.

	To populate data into Streamlyne Research (and Streamlyne platform) database:
	Installation Steps for Both Oracle and MySQL
1.	Run the appropriate install script in db_scripts/main (KC_Install.bat for Windows or KC_Install.sh for Linux/Unix).
2.	You will be prompted for the following: - Streamlyne platform Mode = Choose one: Bundle, Embed - DB_Server = Choose one: Oracle, MySQL - Version = Choose one: New, 3.0, 3.0.1, 3.1, 4.0 - username = The Streamlyne Research database username name to install database scripts with (bundled Streamlyne platform goes here too). - password = the password for username - DB_server_name = the tns name (Oracle) or schema name (MySQL) used to connect to Streamlyne Research database. If embedded mode selected the following will be asked: - Streamlyne platform Username = the Streamlyne platform database username to install Streamlyne platform scripts with (embedded Streamlyne platform). - Streamlyne platform Password = password for Streamlyne platform username - Streamlyne platform DB Server name = the tns/schema name used to connect to Streamlyne platform database. - Do you wish to Install/Upgrade your Embedded Streamlyne platform Server (Don't perform if your server was upgraded separately)
3.	Review .log files for installation errors (in LOGS directory).
4.	(Optional) Install demonstration data. Convenience install scripts for demonstration data can be found in the db_scripts/main folder (KC_Install_Demo.sh/bat) . The demonstration data is only guaranteed to install cleanly into a new Streamlyne Research install. If you have previous test data or demonstration data then you will encounter errors, which may or may not affect functionality. Demonstration data is for testing functionality of the software only and should not be included in an actual implementation. Take a backup of your database before applying demonstration data or be prepared to reinstall from scratch before implementation.
End of activity.

Configuration Parameters

Tip: Refer to “”Appendix A: Configuration Parameters” on page Error! Bookmark not defined.” within this documentation set for supplementary information that will prove helpful by providing default values and handy tips for both Streamlyne Research-specific and Streamlyne platform parameters.