Page History

This guide details to steps to install ET using a zip file.

There is now a The binary release of Enterprise Tester available.  This release allows you to do an installation by using a “zip” file rather than using the Windows Installer executable installation files (.MSI fileexe). 

Installing Enterprise Tester from the binary release files is recommended for use by purchased users or those trial users who wish to deploy Enterprise Tester into an environment where they cannot configure the IIS Default Website to use the values required by the installer temporarily.

If you are trialing Enterprise Tester, we strongly advise using our MSI based installer or which allows you to easily install Enterprise Tester and its prerequisite components.

...

• Ensuring any prerequisite components are installed.
• Unpacking the binary zip file into a directory.
• Configuring the web.config file which the correct database settings.
• Configuring where attachments will be stored.
• Creating an application pool in IIS for Enterprise Tester.
• Creating a new application for Enterprise Tester.
• Accessing Enterprise Tester for the first time, so that ET can automatically run the required database migrations to prepare the database for first use.

Prerequisites

The Enterprise Tester binary zip release requires the following prerequisite components to be installed:

• .Net Framework 3.5 SP1
• IIS
• A support database (Sql Server, Oracle, PostgreSQL, MySql)

Advantages of Performing A Zip File Installation

...

Where can I get the Zip File from?

When you download Enterprise Tester there will be an additional file available called:You can download the binary installation files from the Enterprise Tester website EnterpriseTester-X.X.XXXXX-Bin.zip

...

When you unpack the zip file you will find this structure:

Image RemovedImage Added

The Data and Web folders are the same as those installed into the "Enterprise Tester" directory, when using the existing Windows Installer (.MSI file).

...

Prior to installing please ensure you have the following installed:

• .Net Framework 34.5 SP1 installed (http://msdn.microsoft.com/en-us/netframework/cc378097) installed
• IIS Installed Installed (via Windows Add/remove components) including ASP.Net support (http://msdn.microsoft.com/en-us/library/ms178477.aspx)
• A supported database (Sql Server, Oracle, PostgreSQL, MySql)

If you do not have a database, we recommend installing Sql Server Express 2008 2012 r2 (http://www.microsoft.com/express/Database/)

...

If you do not have a suitable tool installed for unzip files we suggest downloading 7-zip, which is a powerful (and free) zip/unzip tool for windows operating systems.    http://www.7-zip.org/

Once you have a suitable unzip tool, unpack the binary release file to a suitable directory - if you are unsure, popular locations include:

...

When the files have been unpacked you will find that you have a structure like this:

Image RemovedImage Added

Data Folder – MySql Express database is found here
Web Folder – Application files are in this folder
changes.txt - readme file summarizing changes in each version of Enterprise Tester
install.txt – the document you are reading now

Configure the web.config

...

database

...

details

...

Open the file using notepad, within it you will need to change 4 settings:

• "migration.providerName"
• Default connection string
• connection.driver_class
• dialect

These are the default settings:

"migration.providerName"

Code Block
<appSettings> <add key="migration.providerName" value="Migrator.Providers.SqlServer.SqlServer2005Dialect" /> </appSettings>

Default connection string

Code Block
<add name="Default" connectionString="Data Source=.;Initial Catalog=EnterpriseTester;Integrated Security=True;MultipleActiveResultSets=true;" />

connection.driver_class

Code Block
<add key="connection.driver_class" value="NHibernate.Driver.SqlClientDriver" />

dialect

Code Block
<add key="dialect" value="NHibernate.Dialect.MsSql2005Dialect" />

Following are the web.config values you will need for each type of database:

Sql Server

By default the web.config file comes with the settings necessary to connect to Sql Server or Sql Server Express - all you need to do is provide a connection string.

Your options are:

1. Use the provided database with user-attached connection string.

<add name="Default" connectionString="Data Source=.\SQLExpress;AttachDbFilename=c:\inetpub\wwwroot\EnterpriseTester\Data\EnterpriseTester.mdf;Initial Catalog=EnterpriseTester;Trusted_Connection=Yes;"/>

2. Connect to an existing database, using integrated security.

<add name="Default" connectionString="Data Source=.\SQLExpress;Initial Catalog=EnterpriseTester;Integrated Security=True;" />

3. Connect to an existing database, using a sql username & password.

<add name="Default" connectionString="Server=Server123;Database=EnterpriseTester;User ID=bob;Password=pass123;Trusted_Connection=False;" />

Oracle

Configuring Enterprise Tester to use Oracle requires some additional manual steps.

1. Install the Oracle ODAC/ODP.Net Client libraries for your edition of Oracle, as you normally would.
2. Determine if your operating system is 32bit or 64bit, and download the appropriate ODAC xcopy release from here:
   
   • 32bit: http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html 
   • 64bit: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
3. Download the "XCopy" zip file.

4. Once downloaded, unzip the file to a directory, and then copy the following files from the zip distribution in the \web\bin\ folder of your Enterprise Tester directory.

   Code Block
   \ODAC112021Xcopy\instantclient_11_2\oci.dll \ODAC112021Xcopy\instantclient_11_2\orannzsbb11.dll \ODAC112021Xcopy\instantclient_11_2\oraocci11.dll \ODAC112021Xcopy\instantclient_11_2\oraociei11.dll \ODAC112021Xcopy\odp.net20\bin\OraOps11w.dll \ODAC112021Xcopy\odp.net20\odp.net\bin\2.x\Oracle.DataAccess.dll

5. Once copied, edit the web.config file, locate the end of the config sections element:

</sectionGroup>
</configSections>

And insert the following block of xml on the next line:

And insert the following block of xml on the next line after </configSections>

<oracle.dataaccess.client>
  <settings>
   <add name="DllPath" value="C:\Program Files (x86)\Catch Limited\Enterprise Tester\Web\bin"></add>
   <add name="FetchSize" value="65536"></add>
   <add name="PromotableTransaction" value="promotable"></add>
   <add name="StatementCacheSize" value="10"></add>
   <add name="TraceFileName" value="c:\temp\odpnet2.log"></add>
   <add name="TraceLevel" value="0"></add> <!-- 63 -->
   <add name="TraceOption" value="0"></add> <!-- 1 -->
  </settings>
 </oracle.dataaccess.client>

Updating the DllPath value to point to the \web\bin\ directory of your Enterprise Tester install.

6. Now change the following values within the web.config:

migration.providerName: "Migrator.Providers.Oracle.OracleDialect"
connection.driver_class: "NHibernate.Driver.OracleDataClientDriver"
dialect: "NHibernate.Dialect.Oracle10gDialect"

And update the connection string to be something like the below (this will rely on TNSNAmes)

<add name="Default" connectionString="User ID=SYSTEM;Password=password;Data Source=192.168.1.10:1521/orcl"/>

Alternatively, you can specify the connection details inline, like this:

<add name="Default" connectionString="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.10)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ETPROD)));User Id=SYSTEM;Password=password;" />

For more examples of Oracle ODP.Net connection strings, please see: http://connectionstrings.com/oracle#p12

PostgreSql

Change Enterprise Tester to use these values:

migration.providerName: "Migrator.Providers.PostgreSQL.PostgreSQL82Dialect"
connection.driver_class: "NHibernate.Driver.NpgsqlDriver"
dialect: "NHibernate.Dialect.PostgreSQL82Dialect"

And update the connection string to be like this:

<add name="Default" connectionString="Server=192.168.1.10;Port=5432;Database=et-prod;User Id=postgres;Password=Password123;Timeout=60;CommandTimeout=120;" />

MySql

Change Enterprise Tester to use these values:

migration.providerName: "Migrator.Providers.Mysql.MysqlDialect"
connection.driver_class: "NHibernate.Driver.MySqlDataDriver"
dialect: "EnterpriseTester.Core.Dialects.MySqlDialectEx, EnterpriseTester.Core"

And update the connection string to be like this:

<add name="Default" connectionString="Server=192.168.1.10;Database=et-prod;Uid=etuser;Pwd=password;" />       

 More examples of connection strings can be found here: http://connectionstrings.com/mysql#p28

Attachment configuration (optional)

By default Enterprise Tester will store attachments in the database.  This behaviour can be configured, such that attachments are stored on the file system.  To do so, open the web.config file and locate the appSettings section:

<appSettings>
    <add key="migration.providerName" value="Migrator.Providers.SqlServer.SqlServer2005Dialect" />
    ...  
  </appSettings>

Now after the last "add" entry, append these settings:

<add key="attachment.storage.garbagecollection.dwell" value="5" />
<add key="attachment.storage.garbagecollection.disable" value="false" />
<add key="attachment.storage.method" value="FileSystemCas" />

This will then begin storing attachments in the default location of ../Data/Attachments/

Follow the directions in the Configure web.config topic to setup your database connection information

Configuring an application pool

Before configuring an application pool for Enterprise Tester to use, you should give some thought to the application pools identity.

By default in IIS6 application pools are configured with the identity "Network Service" or "Local System", under IIS7/7.5 they application pools are created configured with the identity  "ApplicationPoolIdentity" by default, but can also default to "Local System", "Local Service" or "Network Service".

...

1. Go to Control Panel -> Administrative Tools
2. Launch IIS Administrator
3.   Expand Expand the server node.
4. Click on "Application Pools"
5. Click on "Add Application Pool..." under Actions.
6. Give the new application pool a descriptive name such as "Enterprise Tester".
7. Select ".Net Framework v2v4.0.5072730319" from the .Net Framework version list.
8. Select "Integrated" for the managed pipeline mode.
9. Click OK to create the new application pool.
10. Right click on the new application pool and select "Advanced Settings.."
11. Under the "Process Model" section, change the Identity to your service account (if you have decided to use one).

IIS6:

...

...

...

1. Within IIS Manager, expand the "Sites" node.
2. Expand the "Default Web Site" node.
3. Right click and select "Add Application".
4. Enter an alias for the site we suggest "EnterpriseTester"
5. Click the "Select..." button next to the application pool, and select the application pool you created in the previous step.
6. Click the elipsis "..." next to the Physical Path, and browser to the "Web" folder of your Enterprise Tester install.
7. Click "OK" to create the new application.

IIS6:

1. Within IIS Manager, expand the "Web Sites" node.
2. Expand the "Default Web Site" node.
3. Right click and select "New -> Virtual Directory"
4. Click "Next"
5. Enter an alias for the virtual directory, we suggest "EnterpriseTester".
6. Click "Next"
7. Click "Browse.." and select the path to the "Web" folder of your Enterprise Tester install.
8. Click "Next"
9. Select  "Read" and "Run scripts" check boxes.
10. Click "Next"
11. Right click on the new site and select "Properties..."
12. Select the "Virtual Directory" tab and click "Create"
13. Select the application pool you created in the previous step from the "Application pool:" drop down list.
14. Click the "Configuration" button.
15. Under "wildcard application maps" click "Insert..."
16. Click "Browse..."
17. Browse to "C:\Windows\Microsoft.Net\Framework\v2.0.50727"
18. Select "aspnet_isapi.dll" and click "Open"
19. Uncheck "Verify that file exists"
20. Click "OK" to save the mapping.
21. Under "Application extensions" click the "Add..." button.
22. Click "Browse..."
23. Browse to "C:\Windows\Microsoft.Net\Framework\v2.0.50727"
24. Select "aspnet_isapi.dll" and click "Open"
25. Enter the extension ".rails"
26. Check "Script engine".
27. Uncheck "Verify that file exits".
28. Click "OK"
29. On the properties dialog for the new site, now switch to the "ASP.Net" tab.
30. From the "ASP.Net" version drop down ensure "2.0.50727" is selected.
31. Click OK to close the dialog and save changes.

You are now ready to launch Enterprise Tester for the first time.

...

You will experience a delay (normally between 1 and 2 minutes) while Enterprise Tester creates the necessary tables and populates them in the target database, after which you will see a "Step 1 of 3" wizard page displayed, prompting you to create a new organization.

At this stage you can continue with the installation and setup of Enterprise Tester as per the installation guide available for download from the Enterprise Tester website:

http://www.catchlimited.com/index.php?page=enterprise-tester

Refer to Section 3.3 "the topic Initial Configuration" for  for more detailsdetail.