Electronic Commerce – Exercise

David Billard – University of Geneva, Switzerland

Thema: Installing and configuring the uPortal.

 

    1. Installing uPortal

      2. This exercise is graded 1 point.

      We will use the uPortal free portal, from the JA-SIG (http://www.ja-sig.org/). This portal is free of use and is written in Java (therefore it can run under the Linux or Windows operating systems).

      Open a shell as user root, password ceenet.

      Go in the /server/archive directory.

      gunzip / untar destin.tar.gz in the directory /server/source

      in the /server/source/destin/uPortal/webpages/WEB-INF/web.xml file change the line:

      <param-value>/usr/local/portal/destin/uPortal/</param-value>

      by:

      <param-value>/server/source/destin/uPortal/</param-value>

       

      type the following instructions at the shell prompt:

      JAVA_HOME=/usr/java/jdk1.3.1; export JAVA_HOME

      PATH=$PATH:/usr/java/jdk1.3.1/bin; export PATH

      The JAVA_HOME variable tells the java programs where are the JAVA classes.

      The PATH must be updated in order to access the java compiler.

      start the tomcat server:

      cd server/source/destin/tomcat/bin

      ./startup.sh

      open the following URL with your web browser:

      http://localhost:8080/uPortal

       

    2. Play with uPortal as a User

      3. Log in the portal as user student, password demo.

      Exercise 1 (1 point).

      Add a new tab ceenet, with three columns. In the first column put a weather channel, in the second column put a clock channel, in the third column put a bookmark channel.

      Exercise 2 (1 point).

      Add the ceenet web site (http://www.ceenet.org) to the bookmarks of the portal.

    3. Connect to the MySQL database

The purpose of the exercises is to change the DBMS from Hypersonic SQL to MySQL.

Exercise 3 (1 point)

Start the MySQL server.

Create a new database ceenet_portal.

Use the createTables.script in the scripts/mysql directory and the populateTables in the scripts/Oracle directory.

Exercise 4 (1 point)

Connect to the http://mmmysql.sourceforge.net/ and retrieve the mm.mysql-2.0.4-bin.jar

file.

Put the file in the /usr/java/jdk1.3.1 directory. You will perhaps need to uncompress it.

Find the rdbm.properties file. Uncomment the use of the Hypersonic SQL DBMS.

Type those lines:

jdbcDriver= org.gjt.mm.mysql.Driver

jdbcUrl=jdbc:mysql://localhost/ceenet_portal

jdbcUser=root

jdbcPassword=

Save the file and restart the tomcat server.

Exercise 5 (1 point)

Modify the JSP files in the web-pages directory to replace the MyIBS logo by the ceenet logo.