ESD process guide

Document Sample
ESD process guide Powered By Docstoc
					          A2.D2 EARLY SERVICE DISCOVERY SOFTWARE TOOLS




Document Number:                R011/CIT/V0.2

Title of Document:              A2 Early Service Discovery Software Tools

Work-Package:                   WP 2.1.1

Deliverable Type:               Installation Guide

Contractual Date of Delivery:   31-Aug-2005

Actual Date of Delivery:

Author/Responsible(s):          Konstantinos Zachos

Contributors                    Konstantinos Zachos (City) , Dips Sohal (City)

Approval of this report         Neil Maiden (City)

Summary of this report:         Installation Guide of ESD Software Tools

Keyword List:                   Early Service Discovery Software Tools

Dissemination level:            Confidential
                                      Change History

Version   Date               Status    Author (Partner)             Description

1.0       28th August 2005   Draft     Konstantinos Zachos (City)   Creation

2.0       15th August 2008   Draft     Dips Sohal (City)            Updated
                                                   Table of Contents

1.   Requirements and Prerequisites ..................................................................................................... 5
2.   Required Software Installation ....................................................................................................... 6
3.   ESD Software Installation .............................................................................................................. 7
4.   ESD Web Access ........................................................................................................................... 9
1. Requirements and Prerequisites
The following software is required for both ASP.NET and for the ESD Software Tools:
   Windows 2000 (Professional, Server, and Advanced Server), Windows XP Professional, or Windows
    Server 2003 family for both client and server applications
   Microsoft Visual Studio 2005 (with MSDN Libraries) and Web Application Extension
   Microsoft .NET Framework v2.0
   ASP.NET (http://www.asp.net)
   If you are not using ASP 3.5, then you have to install the AJAX ASP.NET framework.
   Windows 2000/XP Service Pack 2
   Internet Explorer 6.0 or above
   All the latest security updates from Microsoft's Security website.
   TCP/IP protocol support
   A tool that can read .zip files, to unpack the distribution file
   Enough space on the hard drive to unpack, install, and create the database (a minimum of 200
    megabytes is recommended.)
   Internet Information Services (IIS)
   MySQL 4.1.5 or above - Essentials Package (http://www.mysql.com)
   Connector/ODBC driver
   WordNet 2.0 (http://wordnet.princeton.edu/oldversions)
   WordNet 2.1 (http://wordnet.princeton.edu)
   Microsoft Word 2003
   Microsoft Excel 2003
   Recommended SQL GUI: SQLYog Community Edition 7.02
Note:    Windows   2000/XP         Professional   only  allows     10  concurrent connections. To
allow more would require          the OS to       be upgraded     to Windows 2000/XP Server (and
probably more memory.)


Useful URLs


Microsoft Visual Studio Web Application Extension (Team Suite Service Pack 1):
http://www.microsoft.com/downloads/details.aspx?FamilyID=bb4a75ab-e2d4-4c96-b39d-
37baf6b5b1dc&DisplayLang=en


AJAX ASP.NET Extension:
http://www.asp.net/ajax/default.aspx?wwwaspnetrdirset=1


Windows 2000/XP Service Pack 2:
http://www.microsoft.com/windows2000/downloads/servicepacks/sp2/default.asp


Microsoft Security: http://www.microsoft.com/security/


SQL Yog: http://www.webyog.com/en/downloads.php#sqlyog
2. Required Software Installation
The following steps should be followed to install the pre-requisite software on your host machine:
1. Install IIS on the server
         a. From Control Panel, open the Add/Remove Programs
         b. Choose Add/Remove Windows Components on the left side of the dialog box.
         c. Check Internet Information Services and then choose Next to begin installing IIS.
         d. Click Finish when installation is complete.
2. Install .NET Framework v2.0
         a. Download the Framework at
             http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-
             aab15c5e04f5&DisplayLang=en (24 MB)
3. Install Microsoft Visual Studio along with the MSDN libraries and the Web Application Extension.
4. Run the web server using the command (MS-DOS command prompt): Net start w3svc
5. Install ASP.NET using the command (MS-DOS command prompt): Aspnet_regiis –r
6. Install MySQL. Please follow the instruction described on
   http://www.stardeveloper.com/articles/display.html?article=2003052201&page=1 (first 6 pages).
7. Install WordNet 2.0 & 2.1
         a. Download WordNet-2.0 & WordNet-2.1
         b. Follow the installation instructions.
3. ESD Software Installation

The following steps should be followed to install the SeCSE ESD software on your host machine:
1. Install all required software as explained in section 2.

2. Download the ESD package (.zip file) from the following URL:
   http://sourceforge.net/project/showfiles.php?group_id=190626

3. Save the file, and then extract the package. You should find a folder named ‘ESD’ and 2 database files –
   ucare.sql and useradmin.sql.

4. When you installed Internet Information Services (IIS), it should have placed a folder on the C drive
   named ‘inetpub’. This is the default location for local websites. Place the ESD folder in
   C:\Inetpub\wwwroot\.

5. Open the IIS Admin tool – Start->Control Panel->Administrative Tools->Internet Information Services

6. This displays the current websites that are on your computer. Under ‘Default Web Site’, you should find
   the ‘ESD’ folder that was copied to ‘Inetpub’. Find the sub-folder ‘UCaRe’. Right-click on this folder, and
   select ‘Properties’. This should open up the properties window for that folder.

7. Under ‘Application Settings’, there should be a greyed out text box and a button labelled ‘Create’. Click
   this button. IIS will now recognise this folder as a website.

8. To identify the UCaRe homepage, we need to specify the default document. In the same properties
   window, click the ‘Documents’ tab. Ensure that the ‘Enable Default Document’ box is checked. Remove
   all existing documents from the list, and add ‘default.aspx’.

9. After that, click on the ASP.NET tab. Make sure that the ASP.NET version that is selected is 2.0 or
   higher. Then click ‘Apply’ at the bottom, saving the changes to the settings.

10. Now the site is setup, we need to set the file permissions so that ASP.NET is permitted to access and
    use these files. In Windows Explorer, go to c:\Inetpub\wwwroot. Right-click on the ESD folder and open
    the properties. Ensure that the ‘Internet Guest Account’ (IUSR) and ‘Launch IIS Process Account’
    (IWAM) are given full permissions (Full Control). Please note, these users may not appear in the list, so
    you may have to add them.

11. The ‘ASPNET’ user must be added to the ‘administrator’ group. This can be done by going to –
    Start -> Control Panel -> User Accounts, which will bring up a new screen containing the list of current
    users on your computer. If ‘ASPNET’ does not appear on the list, click ‘Add’.


Coding Note:
In file ‘ESD/UCaRe/Request/DiscoveredServices.aspx.cs’, line 451 reads:
string theConnectionstring = @"provider=Microsoft.Jet.OLEDB.4.0;data
source=D:\\Inetpub\\wwwroot\\SeCSE\\ESD\\UCaRe\\files\\OfflineServiceBrowser\\Of
flineSB.xls;Extended Properties=""Excel 8.0;HDR=YES;""";

The attribute ‘data source’ identifies a file location which has to be hard coded. This location must refer to
the file ‘ESD\UCaRe\files\OfflineServiceBrowser\OfflineSB.xls’. Please ensure that this location is pointing to
the correct place on your installation, otherwise the Export Service Browser function will not work. Note that
the OfflineSB.xls file does not appear in the files directory, as it is created on-the-fly during the export
procedure.
4. ESD Database Installation

1. Create an empty MySQL database called ucare with root as a username and SeCSE67194 as the
   password. You can use a GUI tool as well, such as SQLYog.
2. Execute the ucare.sql file which can be found in the ‘ESD DB’ directory on the CD. If you use a MySQL
   IDE than copy and paste the content of ucare.sql into the IDE and execute all queries within the ‘ucare’
   database which you created.
3. Create another database called ‘useradmin’ with the same username and password. Execute the
   ‘useradmin.sql’ file.
4. Create an ODBC Data Source for each database
           a. From Control Panel, open the Administrative Tools.
           b. Choose Data Source (ODBC).
           c. Select the System DSN tab and then choose Add….
           d. From the list choose MySQL ODBC 3.51 Driver and Click Finish.
           e. In the Connector/ODBC window enter the information as shown beneath. For Password
               enter: SeCSE67194




            f.   Test the connection by clicking Test. Once the test succeeds, click Ok.

5. Check the Component Services manager to make sure that IIS has been started.
6. Open Internet Explorer and type in http://localhost/ESD/ucare in the address bar.
7. A default admin account has been set up for initial use. To logon type in the following information:
                        Username: ucare
                        Password: ucare
   It is advised that you create a new account with confidential values for your username and password,
   and then remove the ‘ucare’ account.
5. ESD Web Access
Alternatively, you can access the application on http://achernar.soi.city.ac.uk/ucare which runs on one of
our local servers. Please contact a project administrator to set-up and issue your account information to use
UCaRe.


Project Administrators:


Dr Konstantinos Zachos:
kzachos@soi.city.ac.uk


Professor Neil Maiden
N.A.M.Maiden@soi.city.ac.uk

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:108
posted:6/15/2009
language:English
pages:9