How to install Formspider to Linux or Mac OS X

This post became obsolete. You can download the MacOSX and Linux installer from our download page!!!

Prerequisites

In order to complete this installation, an instance of Oracle Database Server 10.2.0.1 or higher must be installed either on the local machine or a remote machine that is available through the network connection.

Installation files

Please download and extract installation files before starting installation process.

Installing database components.

If you are using SQLPlus,

  1. Login to your database’s SYS schema. Run script 001_sys.sql. This script creates FORMSPIDER user and grants necessary privileges to it.
  2. Open shell and navigate to the engine_db folder. Run sqlplus and login to Formspider* schema. Then execute the script install.sql. This script creates all necessary database objects for the Formspider Engine.
  3. Exit sqlplus and navigate to ide_db folder. Run sqlplus and login to Formspider schema. Then execute the script install.sql in the ide_db folder. This script installs Formspider IDE Application’s database objects.

If you are using any other sql editor;

  1. Login to your database’s SYS schema. Run script 001_sys.sql. This script creates FORMSPIDER user and grants necessary privileges to it.
  2. Login to Formspider schema* and make sure that DEFINE setting is off. Run the scripts under the engine_db folder one by one in their numerical order.
  3. Run script on ide_db folder one by one in their numerical order.

* : Password for Formspider schema is also FORMSPIDER by default. If you’d like, you can change it by editing the script 001_sys.sql.

Installing Formspider IDE

In order to install Formspider IDE, you should copy Formspider IDE\Formspider_IDE.xml file to an Oracle Directory. Then grant read privileges to Formspider with the following sql.

grant read on directory {your_oracle_directory} to Formspider;

After you grant privilege to FORMSPIDER schema, open script file Formspider IDE\Formspider IDE Load Application.sql  in your editor. Edit line 5, and type the name of the oracle directory that you used. Then execute the script. It will take several minutes for the Formspider IDE Application to be loaded.

Installing Formspider Middle -Tier

  1. Download Tomcat 6
  2. Download and install the latest stable version of Tomcat 6 from

    http://tomcat.apache.org/download-60.cgi

  3. Configuring Tomcat
    1. Add admin user
    2. Change the {tomcat_installation}/conf/tomcat-users.xml by adding these lines into tomcat-users tag:

      <role rolename="manager-gui"/>
      <user username="admin" password="admin" roles="manager-gui"/>

    3. Add database connection parameters of Formspider database schema

    Change {tomcat_installation}/conf/context.xml by adding these lines into Context tag:

    <Resource name="jdbc/fs" auth="Container"
    type="oracle.jdbc.pool.OracleDataSource"
    driverClassName="oracle.jdbc.OracleDriver"
    url="jdbc:oracle:thin:@[DATABASE_URL]:[ORACLE_PORT]:[ORACLE_SID]"
    user="[USERNAME]" password="[PASSWORD]" maxActive="10" maxIdle="5"
    maxWait="10" factory="oracle.jdbc.pool.OracleDataSourceFactory"/>

    Edit [DATABASE_URL], [ORACLE_PORT], [ORACLE_SID], [USERNAME], [PASSWORD] labels with appropriate values for your Oracle installation.

  4. Deploying Formspider WAR file
    1. Start tomcat:
      Open terminal and navigate to {tomcat_installation}/bin/ folder, then execute startup.sh.

      sh startup.sh

    2. Open tomcat manager: http://localhost:8080/manager/html and login as admin.
    3. From “WAR file to deploy” menu:
    4. Select fs.war file you have downloaded and press Deploy.

Running Formspider IDE

  1. Starting Formspider IDE
    Open your web browser and navigate to http://localhost:8080/fs/main.html?name=FormspiderIDE to Start Formspider IDE as a Web Application

  2. Starting Formspider IDE as Stand-alone Java Application

    Open terminal and type:

    java -jar Formspider-Java-Client.jar application.url=http://localhost:8080/fs/ application.startApplication.name=FormspiderIDE

    or you can create a new file named start-formspider.sh and paste the code above as its content. Then you can start Formspider IDE from the console:

    sh start-formspider.sh

Serkan Kasapbaşı