Eclipse Community Forums: OSEE » OSEE Quickstart

Help

Home

Home » Eclipse Projects » OSEE » OSEE Quickstart - Tutorial, Review

Show: Today's Messages :: Show Polls :: Message Navigator

OSEE Quickstart - Tutorial, Review [message #14595]

Wed, 06 May 2009 14:41

Ray Joseph

Messages: 87
Registered: July 2009

Member

In order to help me better understand what I dont know and to fix in
context the questions I have about the OSEE installation process, I have
annotated some of the information referenced in this newsgroup.
The starting point for this path starts at:
http://www.eclipse.org/newsportal/article.php?id=196&gro up=eclipse.technology.osee#196
[artifact 1]

Subject: OSEE Quickstart - Tutorial to get you up and running...
From: donald.g.dunne@xxxxxxxxxxxx (Don Dunne)
Newsgroups: eclipse.technology.osee
Organization: EclipseCorner
Date: Apr 20 2009 15:54:48

For those interested in getting OSEE up and running, we have posted our
tutorial slides from EcipseCon 2009 that brought attendees from eclipse
installation all the way through deploying OSEE with artifact/relation
types configuration and ATS configuration.

This presentation uses a fictitious company "T. Rex" as an example of how
to migrate and use OSEE.

http://www.eclipse.org/osee/OSEE_eclipsecon2009_tutorial_sli des.pdf
[artifact 2]

________________________________________
From artifact 2, page 3

Before we begin
This is an interactive session: feel free to ask questions
Tell us about yourself
Background Info
Operating Systems
Tutorial based on OSEE 0.7.0
The tutorial materials are available at
http://www.eclipse.org/osee/OSEE_eclipsecon2009_tutorial_mat erials.zip
[artifact 3]
________________________________________
From artifact 2, page 4

Requirements
System Requirements (non-eclipse)
System with at least 1GB of RAM
Java Runtime Environment (JRE) 1.6 or higher
Microsoft Office (For Demo Only)
Eclipse Dependencies
Eclipse 3.4.2 SDK
org.eclipse.gef
org.eclipse.draw2d
org.eclipse.birt
org.eclipse.datatools
The easiest solution is the Ganymede Eclipse install
Eclipse IDE for Java and Report Developers
http://www.eclipse.org/downloads/download.php?file=/technolo gy/epp/downloads/release/ganymede/SR2/eclipse-reporting-gany mede-SR2-win32.zip
[artifact 4]

________________________________________

From artifact 2, page 5

Installation
Database
Run the PostgreSql installer, located under the PostgreSql folder, for
your OS using the following settings
? Where is this PostgreSql folder?
Default install path
Default data directory
Password Postgre1
? The other guides say to use osee as the password. Please confirm.
I have tried both osee and Postrge1 and get the same log output..
? Is this the password for the default postrges database or for the
new OSEE database?
Port 5432
Default Locale
On last screen uncheck Launch Stack Builder
? I will be using PostgreSQL for Trac which requires the JDBC stack.
Will they interfere with the Eclipse function?
Setup database accounts and schemas by executing the bash/bat script for
your OS located under the PostgreSql folder
? Where is this PostgreSql folder where I can find these scripts?
Save db password using pgadmin
? What does this mean? Which role is this for, osee or postgres or
other? The password guide above says to use Postgre1 as the password.
osee_db_setup.bat Windows
osee_db_setup.sh Others
For more information or for the files mentioned above visit
http://www.eclipse.org/osee/documentation/installation/postg resql_install.php
? The files listed above are not addressed in the above link. Where
can I find them?
? The above link to the postgresql_install describes creating the osee
user, OSEE db, and osee schema. Is it the intent to have these action
done at this point?
________________________________________
From artifact 2, page 6

Installation - continued
JRE
Ensure the JRE 1.6 is in the path by typing java version at a command
prompt
OSEE Client
Extract the Eclipse base zip for your OS located under Eclipse Base to
a short path and then launch eclipse
? Is the Eclipse base addressed here the same as described above as
eclipse-reporting-ganymede-SR2-win32.zip [artifact 4]?
From the Eclipse update manager, install the update sites located under
OseeClient
? What sites should be under OseeClient? There are only two files and
they contain commands to run Eclipse for launching and DB initialization.

org.ecilpse.osee_integration_build_incubation.zip
! Per:
http://www.eclipse.org/newsportal/article.php?id=174&gro up=eclipse.technology.osee
! From: http://www.eclipse.org/downloads/download.php?
file=/technology/osee/updatesite/org.ecilpse.osee_integratio n_build_incubation.zip
[artifact 5]

osee.add.ons.updatesite.zip
! Per:
http://www.eclipse.org/newsportal/article.php?id=174&gro up=eclipse.technology.osee
! from
http://osee.microdoc.com/downloads/osee/add-ons/0.7/osee.add .ons.updatesite.zip
[artifact 6]

? What is are the steps to install the update sites? Is this the
process:
extract each file contents to a separate temporary folder
From Eclipse, navigate to Help | Software Updates, select the
tab Available Software, select Add Site, select Local, navigate to
the temporary folder and select it.
Check the upper most box so all child boxes will be checked and
then select the Install button.
Then remove the temporary folder?

________________________________________
From artifact 2, page 7

Initialization
Launch Application Server
Execute the launch script for your OS located under
OseeApplicationServer
osee_app_server.bat Windows
osee_app_server.sh Others
! This is from:
http://www.eclipse.org/osee/OSEE_eclipsecon2009_tutorial_mat erials.zip
[artifact 3]
? Does the line from this command file needs to lineup with the
current version:
! Command: -jar
osee_app_server/platform/org.eclipse.osgi_3.4.2.R34x_v200808 26-1230.jar
? Where does this file come from? I cannot find it and the
osee_app_server fails.
? There is a similar file in the zip at:
http://osee.microdoc.com/downloads/osee/server/0.7.0/server_ 0.7.0-2009-02-19_08_49.zip
[artifact 7]
? Is this the correct source? This source has not been mentioned in
this tutorial.
? It seems to be an older version, it is
org.eclipse.osgi_3.4.0.v20080326.jar

Wait until the server finishes the start up procedure
Do not close the console
Database Initialization
In a command prompt change to the eclipse install dir
eclipsec -application org.eclipse.osee.framework.database.configClient
-vmargs -Xmx512m
-Dosee.log.default=INFO -Dosee.application.server=http://localhost:8089
-Dosee.authentication.protocol=trustAll -Dosee.prompt.on.db.init=false
-Dosee.choice.on.db.init="OSEE Demo Database"
? Where does this database come from?

Once db init completes, type exit in the server console
________________________________________

I would like to go further on with this review of the tutorial material,
but at this point, without the demo database, nothing else works.

I am happy to do all I can to better understand how to install OSEE and
use it, and help others do the same. Please help me resolve how to do
this.

Regards,
Ray

PS: Artifact Summary
[artifact 1]Eclipse NewsPortal - eclipse_technology_osee.mht
[artifact 2]OSEE_eclipsecon2009_tutorial_slides.pdf
[artifact 3]OSEE_eclipsecon2009_tutorial_materials.zip
[artifact 4]eclipse-reporting-ganymede-SR2-win32.zip
[artifact 5]org.ecilpse.osee.client_integration_build_incubation.zip
[artifact 6]osee.add.ons.updatesite.zip
[artifact 7]server_0.7.0-2009-02-19_08_49.zip

Report message to a moderator

Re: OSEE Quickstart - Tutorial, Review [message #14744 is a reply to message #14595]

Thu, 07 May 2009 19:38

Roberto Escobar

Messages: 10
Registered: July 2009

Junior Member

Hi Ray,

We appear to have a disconnect between the tutorial material and data
supplied via the update sites.

We will be posting the 0.8.0 version of OSEE shortly and update the
tutorial information to reflect the new deployment style.

In the meantime, if you follow the application server launch instructions
located at the micro doc site you should be able to get going.

Basic Setup Steps:
1. Setup postgresql - follow instructions from
http://wiki.eclipse.org/OSEE/Users_Guide#PostgreSQL_Installa tion

2. Download application server from the Microdoc site - use the .sh
file/command line provided for local host bundled with the zip file.

3. Download the OSEE Client located at eclipse.org/osee/downloads... --
follow tutorial information starting from database initialization

Report message to a moderator

Re: OSEE Quickstart - Tutorial, Review [message #14916 is a reply to message #14744]

Mon, 11 May 2009 23:43

Ray Joseph

Messages: 87
Registered: July 2009

Member

Roberto Escobar wrote:
> Hi Ray,
<snip>
> In the meantime, if you follow the application server launch instructions
> located at the micro doc site you should be able to get going.
> Basic Setup Steps:
> 1. Setup postgresql - follow instructions from
> http://wiki.eclipse.org/OSEE/Users_Guide#PostgreSQL_Installa tion
> 2. Download application server from the Microdoc site - use the .sh
> file/command line provided for local host bundled with the zip file.
<snip>

I attempted the procedure but the command string would not complete. The
results are list below.

Per the above guide, I have PostgreSQL running. I have unzipped the
Microdoc app_server into a directory structure that looks like:
C:
\osee
\osee\app_server_0.7.0-2009-02-19_08_49 <- The app server is here
\osee\client <- Microdoc client is here
\osee\eclipse <- Old Java&reporting is here
\pgHome\8.3 <- Postgres is here

I entered the contents of the runServer-PgSqlLocalAll.sh file in a command
window openned at:
\osee\app_server_0.7.0-2009-02-19_08_49.
The command string is:
java -Dosee.log.default=INFO -Dorg.osgi.service.http.port=8089
-Dosgi.compatibility.bootdelegation=true -Xmx512m
-Dosee.db.connection.id=postgresqlLocalhost -Dequinox.ds.debug=true -jar
org.eclipse.osgi_3.4.0.v20080326.jar -console

BTW, where can I get the demo data?

The first section of the output was generated in seconds, the later
portion took much longer; it did not complete after 12 hours.

The command window results:

C:\osee\app_server_0.7.0-2009-02-19_08_49>java -Dosee.log.default=INFO
-Dorg.osgi.service.http.port=8089
-Dosgi.compatibility.bootdelegation=true -Xmx512m
-Dosee.db.connection.id=postgresqlLocalhost
-Dequinox.ds.debug=true -jar org.eclipse.osgi_3.4.0.v20080326.jar -console

osgi> May 9, 2009 9:01:57 PM org.mortbay.http.HttpServer doStart
INFO: Version Jetty/5.1.x
May 9, 2009 9:01:57 PM org.mortbay.util.Container start
INFO: Started org.mortbay.jetty.servlet.ServletHandler@b6e39f
May 9, 2009 9:01:57 PM org.mortbay.util.Container start
INFO: Started HttpContext[/,/]
May 9, 2009 9:01:57 PM org.mortbay.http.SocketListener start
INFO: Started SocketListener on 0.0.0.0:8089
May 9, 2009 9:01:57 PM org.mortbay.util.Container start
INFO: Started org.mortbay.http.HttpServer@1549f94
Adding:
org.eclipse.osee.framework.core.server.internal.ServerDataba seProvider @137d090
Registered servlet '/GET.ARTIFACT'

Sat May 09 21:02:04 CDT 2009
org.eclipse.osee.framework.core.server.CoreServerActivator
INFO org.eclipse.osee.framework.core.server.internal.ServerTaskSc heduler
addServerTask (41)
Adding task: Clean up join tables

Registered servlet '/osee/artifact'
Sat May 09 21:02:04 CDT 2009
org.eclipse.osee.framework.core.server.CoreServerActivator
INFO org.eclipse.osee.framework.core.server.OseeServerProperties
getOseeApplicationServerData (54)
Application Server Data: [C:\Documents and Settings\Administrator]

Registered servlet '/osee/branch'
Registered servlet '/osee/branch/exchange'
Registered servlet '/osee/install/info'
Registered servlet '/osee/resource'
Registered servlet '/osee/search'
Registered servlet '/osee/search/tagger'
Registered servlet '/osee/server/lookup'
Registered servlet '/osee/session'
Registered servlet '/osee/client/loopback'

Sat May 09 21:02:08 CDT 2009
org.eclipse.osee.framework.search.engine.internal.SearchEngi neTagger
INFO org.eclipse.osee.framework.search.engine.internal.StartUpRun nable
run (45)
Tagging on Server Startup was not run.

Sat May 09 21:02:09 CDT 2009
org.eclipse.osee.framework.db.connection.internal.InternalAc tivator
INFO org.eclipse.osee.framework.db.connection.OseeConnectionPool
getConnection (71)
getConnection - jdbc:postgresql://localhost:5432/OSEE - connection pool
size [1]

Sat May 09 21:02:09 CDT 2009
org.eclipse.osee.framework.db.connection.internal.InternalAc tivator
INFO org.eclipse.osee.framework.db.connection.OseeConnectionPool
getConnection (71)
getConnection - jdbc:postgresql://localhost:5432/OSEE - connection pool
size [2]

Sat May 09 21:02:10 CDT 2009
org.eclipse.osee.framework.core.server.CoreServerActivator
INFO
org.eclipse.osee.framework.core.server.internal.ApplicationS erverDataStore
deregisterWithDb (63)
Server lookup table not initialized

Sat May 09 21:02:10 CDT 2009
org.eclipse.osee.framework.core.server.CoreServerActivator
INFO
org.eclipse.osee.framework.core.server.internal.ApplicationS erverDataStore
registerWithDb (80)
Server lookup table not initialized

********** all above occured in a few seconds. The content below took
tens of minutes *****

Sat May 09 21:12:04 CDT 2009
org.eclipse.osee.framework.core.server.CoreServerActivator
WARNING
org.eclipse.osee.framework.core.server.internal.task.CleanJo inTablesServerTask
run (59)
org.postgresql.util.PSQLException: ERROR: relation "osee_join_artifact"
does not exist
org.eclipse.osee.framework.db.connection.exception.OseeDataS toreException:
org.postgresql.util.PSQLException: ERROR: relation "osee_join_artifact"
does not exist
at
org.eclipse.osee.framework.db.connection.ConnectionHandler.r unPreparedUpdate(ConnectionHandler.java:100)
at
org.eclipse.osee.framework.db.connection.ConnectionHandler.r unPreparedUpdate(ConnectionHandler.java:57)
at
org.eclipse.osee.framework.core.server.internal.task.CleanJo inTablesServerTask.run(CleanJoinTablesServerTask.java:56)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
Source)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknow n
Source)

at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu tureTask.access$101(Unknown
Source)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu tureTask.runPeriodic(Unknown
Source)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu tureTask.run(Unknown
Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unkno wn
Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"osee_join_artifact" does not exist
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorRespons e(QueryExecutorImpl.java:1608)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer yExecutorImpl.java:1343)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut orImpl.java:194)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(Abstract Jdbc2Statement.java:451)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags (AbstractJdbc2Statement.java:350)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(Ab stractJdbc2Statement.java:304)
at
org.eclipse.osee.framework.db.connection.ConnectionHandler.r unPreparedUpdate(ConnectionHandler.java:98)
... 11 more

Sat May 09 21:17:04 CDT 2009
org.eclipse.osee.framework.db.connection.internal.InternalAc tivator
INFO org.eclipse.osee.framework.db.connection.OseeConnectionPool
removeConnection (57)
removeConnection - jdbc:postgresql://localhost:5432/OSEE - connection pool
size[1]

Sat May 09 21:22:04 CDT 2009
org.eclipse.osee.framework.core.server.CoreServerActivator
WARNING
org.eclipse.osee.framework.core.server.internal.task.CleanJo inTablesServerTask
run (59)
org.postgresql.util.PSQLException: ERROR: relation "osee_join_artifact"
does not exist
org.eclipse.osee.framework.db.connection.exception.OseeDataS toreException:
org.postgresql.util.PSQLException: ERROR: relation "osee_join_artifact"
does not exist
at
org.eclipse.osee.framework.db.connection.ConnectionHandler.r unPreparedUpdate(ConnectionHandler.java:100)
at
org.eclipse.osee.framework.db.connection.ConnectionHandler.r unPreparedUpdate(ConnectionHandler.java:57)
at
org.eclipse.osee.framework.core.server.internal.task.CleanJo inTablesServerTask.run(CleanJoinTablesServerTask.java:56)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
Source)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknow n
Source)

at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu tureTask.access$101(Unknown
Source)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu tureTask.runPeriodic(Unknown
Source)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu tureTask.run(Unknown
Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unkno wn
Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"osee_join_artifact" does not exist
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorRespons e(QueryExecutorImpl.java:1608)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer yExecutorImpl.java:1343)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut orImpl.java:194)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(Abstract Jdbc2Statement.java:451)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags (AbstractJdbc2Statement.java:350)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(Ab stractJdbc2Statement.java:304)
at
org.eclipse.osee.framework.db.connection.ConnectionHandler.r unPreparedUpdate(ConnectionHandler.java:98)
... 11 more

Report message to a moderator