Setup of the Discover Server

The server has been implemented on a Windows NT4.0 based platform; as well as Linux platforms

Step 1: Downloads

The following applications are needed.
These version numbers are the ones that we currently used, you should of course try to get the latest versions of each application
The DISCOVER zipped file can be downloaded here
The directory structure of the extracted files is:



/Discover/Client/java and /Discover/Client/java contain the sources and
/Discover/Server/class and /Discover/Server/class the class objects
/Discover/Portal contains the web portal pages


Step 2: Installation and Source file modifications
Setting up the downloaded tools is the matter of following the installation process of each application.
Concerning Apache/PHP/mySQL setup help can be found at www.devshed.com

Hints on configuration file modifications for each application:

Apache
Add to the access.conf file the path to the web portal files
(When doing this, Make sure that the AccessConfig parameter in httpd.conf is enabled) For instance : Alias /discover "D:\Discover\Portal"
Apache JServ
Is configured by two main files, jserv.conf and jserv.properties
Add a servlet zone in jserv.properties that you could call discover
In the same section (zone) add the path to the discover.properties file that you should keep in your servlets directory.
The first line of the discover.properties file (in the servlets directory) has to be modified and directed to your servlets directory.
Finally in jserv.conf, in the ApJServMount section add (or modify) the /servlets URL to map to the discover zone.
Important Note: In discover.protperties file add in the startup servlets section 
servlets.startup=DaemonHttpServlet

You can check for a correct installation by going to http://localhost/jserv/
mySQL
The first thing to do once mySQL is installed is set a password for the root user; this is done using the command 
 mysqladmin -u root password theselectedpassword

A PHP project called phpMyAdmin is helpfull for managing mySQL. It is a front-end to access mySQL databases
It can be found at http://www.phpwizard.net/phpMyAdmin/
PHP PHP4 comes with support to mysql so no changes needs to be made, just follow the installation procedure.

Once the DISCOVER files have been downloaded, the server's URLs that have been harcoded need to be redirected to your URL.


In DbHandler.java and LoginDbHandler Modify JDBC connection login and password to the 'DiscoverData' Database.


Step 3: Setting up the Database

The file 'DiscoverData.sql' contains the Table creation of the DiscoverData database.
You can populate the database as you intend.
The structure of this database is:



where Applications contains:


acl, The access control list contains:


The users table contains


The requests table contains:


The responses table contains:


The updates table contains:


First, create the DiscoverData database:
mysqladmin - u your_login -pyour_password create DiscoverData
then create the tables using the DiscoverData.sql file
mysql -u your_login -pyour_password DiscoverData < DiscoverData.sql

Once the Db and The tables are crated you need to enter the list of your users in the users table and their privileges in the acl table.
Privileges are:
  • 1 for no views and no commands
  • 2 for views only
  • 3 for views and commands

Summary Setting up the DISCOVER files:

Once the compressed file DISCOVER.zip is unzipped, you will get a structure that looks like this:

Here is a quick recapitulation of what was previously described regarding the final setup:

Once all the tools Apache, Apache JServ, php4, mysql, myODBC are installed and configured

The checkpoints for those tools are:
Apache
have an alias to the Discover/Portal directory

Apache JServ
add a zone (discover.properties) to the jserv.properties file in the zone section
add the discover.properties path to jserv.properties file in the zone section
modifiy the "ApJServMount /servlets /root" to" ApJServMount /servlets /discover"
add startup.servlets=DaemonHttpServlet in discover.properties.

mySQL populate the database with users

myODBC
add the username and password that you have chosen to connect to the mysql database.

Done: Ready for Application Connections

Once the Apache server is running, applications are ready to connect to the server.