I. The purpose of this document

The course CSCI5234 requires you to complete its two projects. However, to have better understanding about how they work in the real environment, DCSL provides you the two servers (Web server and Database server) to install your project applications. This set of instructions will guide you how to install your Web project applications on DCSL servers.

 II. Who should read these instructions

Students who take the course CSCI5234 - Web Security offered by Dr. T. Andrew Yang

 III. How to install

Note:

The following assumptions are made:

You have connection to the Web server with IP address 192.168.7.10 and Database server with IP address 192.168.6.16 through VPN connection or DCSL Lab wireless connection or from the computers in D158.

To know how to connect to the DCSL Lab using wireless connection, refer to: http://www.dcsl-uhcl.net/public/DCSL Wireless.html

To know how to connect to the DCSL Lab using VPN connection, refer to:  http://www.dcsl-uhcl.net/public/DCSL vpn.html

Note: If you connect to DCSL Lab using the Internet connection from a corporate LAN, please ask the administrator if any policies preventing the VPN connection. For example, the VPN connection to DCSL Lab does not work if you use the Internet connection from the school PCLAB.

To test the connection, please using the following Windows command in the command prompt:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>ping 192.168.7.10

Pinging 192.168.7.10 with 32 bytes of data:

Reply from 192.168.7.10: bytes=32 time=5ms TTL=128
Reply from 192.168.7.10: bytes=32 time=4ms TTL=128
Reply from 192.168.7.10: bytes=32 time=4ms TTL=128
Reply from 192.168.7.10: bytes=32 time=5ms TTL=128

Ping statistics for 192.168.7.10:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 4ms, Maximum = 5ms, Average = 4ms

C:\Documents and Settings\Administrator>ping 192.168.6.16

Pinging 192.168.6.16 with 32 bytes of data:

Reply from 192.168.6.16: bytes=32 time=4ms TTL=128
Reply from 192.168.6.16: bytes=32 time=1ms TTL=128
Reply from 192.168.6.16: bytes=32 time=3ms TTL=128
Reply from 192.168.6.16: bytes=32 time=3ms TTL=128

Ping statistics for 192.168.6.16:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 1ms, Maximum = 4ms, Average = 2mspi

Your are created three accounts including: VPN account, Web server account and Database server account. Your three accounts are created with the same username and password, which help you easy to remember your username. If you change the password, please remember your password for each account. However, you can change to the same password for all three accounts.

In the Web Security projects, after connecting to the DCSL system through VPN connection, you will work with the two servers, which are the Web server with IP address 192.168.7.10 and Database server with IP address 192.168.6.16. The following will guide you how to copy your source code into Web server, create database in database server and test your web application.

1. Open Windows Explorer
2. Right click on My Computer, click Map network drive?. The Map Network drive dialog box appears, in the Folder, you type: \\192.168.7.10\webapps

   

3. Click on Connect using different user name. The Connect As? dialog box appear, in the Username, type your username, in the Password, type the password for Web-Server then click OK

4. In the Map Network Drive, click Finish.

5. Copy your source code into the new network drive.

1. Install MySQL 5.0 Client Program into your computer.
2. Open the command prompt
3. Change the path to the bin folder of your MySQL Client Program
4. Type the following in the command prompt: mysql ?h 192.168.6.16 ? u [username] ? p

               Where username is your username.

Note: The username in MySQL is case sensitive

5. Enter your password. Now you can work with MySQL database management program.

 Note: Disconnect the VPN connection before testing.

  -  Test your application using: http://www.dcsl- uhcl.net: 8080/your_ application or http://67.64.179.154: 8080/your_ application

  -  For example in your computer you use: http://localhost/ myapp to run your application.
      Now you should change to http://www.dcsl- uhcl.net: 8080/myapp/ or http://67.64.179.154: 8080/myapp/

 Note that your application now is installed on Web server and Database seserver then make any neccessary to the paths that connect to Database server.

  -  For example, Connection con = DriverManager. getConnection( "jdbc:mysql: //localhost/ webdata", "test", "abc" );

  -  Now you should change to Connection con = DriverManager. getConnection( "jdbc:mysql: //192.168.6.16/webdata", "test", "abc" );