Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
FWINST HEAD
FWINST HEAD
nopaneltrue

Article Index

Table of Contents

The following are summary topics that list the steps required on the day (or evening prior to) the installation of the Framework Product Suite Web Portal Software. This information is for internal IT staff responsible for the deployment of the Framework Product Suite Web Portal Software and its integration into internal systems and business processes.

Warning

Ensure you have read and completed the steps in the Web Portal Pre-Requisite Checklist.

Step 1 - Download PHP

PHP is a widely used scripting language that is designed for web development to produce dynamic web pages.

...

Framework's Web Portal Software currently uses PHP Version 5.3.xx (Zip Package version).

Step 2 - PHP Installation

PHP is a computer scripting language designed to help produce dynamic web pages. The Framework Product Suite Web Portal Software uses PHP to create the website and to connect the website to the required Framework databases. 

Warning

If PHP is already installed on the system, please Contact Insula Software.

  1. Unzip PHP to the folder: C:\php (on the target machine).

    Image Modified

  2. In the C:\php folder, rename the ini-recommended file to be php.ini.

Step 3 - Microsoft SQL Server Driver For PHP

The SQL Server Driver for PHP v1.0 is designed to enable reliable, scalable integration with SQL Server for PHP applications deployed on the Windows platform. The Driver for PHP is a PHP 5 extension that allows the reading and writing of SQL Server data from within PHP scripts. It provides a procedural interface for accessing data in all editions of SQL Server (including Express Editions).

Install - Microsoft SQL Server Driver For PHP

Warning

If the Microsoft SQL Server Driver for PHP is already installed on the system, please skip this step.

  1. Open Windows Explorer.

  2. Browse to: [fw folder]\Setup\Database - MSSQL\Microsoft SQL Server Driver for PHP\

  3. Double-click the setup file. The Microsoft SQL Server Driver for PHP installation will begin.

  4. Click the Yes The File Extraction step will be displayed.

  5. Enter a location to extract the files (e.g., C:\phpext\). If the folder does not exist, confirm the folder creation. The files will be extracted.

  6. Browse to the extracted file location (e.g., C:\phpext\).

  7. Copy the following files:

    • php_sqlsrv.dll

    • php_sqlsrv_ts.dll

  8. Browse to: C:\php\ext\

  9. Paste the files into the C:\php\ext\ folder.

    After pasting the files, the location of the extracted files can be safely deleted

Step 4 - PHP Configuration

  1. Open Windows Explorer.

  2. Browse to the location of the ini file (typically: C:\php\).

  3. Edit the ini file.

  4. Update the following settings:

The following default settings may be different to those listed depending on the PHP version (the following is based on PHP 5.3.xx).

Field Name

Default Setting

Required Setting

safe_mode

Off

Off

max_execution_time

30

60

error_reporting **

E_ALL

E_ERROR & E_WARNING

register_globals

Off

Off

register_long_arrays

Off

Off

register_argc_argv

Off

Off

auto_globals_jit

On

On

magic_quotes_gpc

Off

Off

extension_dir

"./"

"C:\php\ext"

enable_dl

On

Off

cgi.force_redirect *

1

0

fastcgi.impersonate *

1

1

SMTP

localhost

[server name or IP address]

smtp_port

25

[server's smtp port number]

sendmail_from *

me@example.com

[administrator@acmehomes.com.au]

odbc.defaultlrl

4096

65536

session.auto_start

0

0

* If a semi-colon (;) appears at the beginning of the line, users MUST remove it.
** Ensure the uncommented error_reporting field (with no semi-colon (;)) and not the commented ;error_reporting field (with semi-colon (;)) is updated.

  1. Find the Windows Extensions section of the ini file.

  2. Add the following extensions:

    • ;extension=php_sqlsrv.dll (including the leading semi-colon(;))

    • ;extension=php_sqlsrv_ts.dll (including the leading semi-colon(;))

    • extension=ixed\ixed.win

  3. Uncomment the following extension (by removing the leading semi-colon (;)):

    • extension=php_gd2.dll

  4. Save the php.ini file.

  5. Close the php.ini file.

Step 5 - Configure Firewall Settings

If the Framework Product Suite Web Portal Web Server is separated from the Framework database server by a network firewall (recommended), your firewall may require configuration of the following ports:

Microsoft SQL Ports

To configure the Firewall Ports, please consult your Microsoft documentation for more information.

Port

Required

Firewall Changes

1433

Compulsory

Microsoft SQL ODBC.

53

Optional

The DNS port is not required by Framework however is sometimes enabled to address network communications performance issues.

Step 6 - Install Microsoft SQL Server Native Client

Installs the native client for Microsoft SQL Server on the web server. The native client driver is required to connect the web portal software to the Framework ECM database.

  1. Open Windows Explorer.

  2. Browse to: \[fw folder]\Setup\Database - MSSQL 2008\Microsoft - SQL Server Native Client Driver\

  3. Double-click the relevant setup file. The Microsoft SQL Server Native Client installation will begin.

  4. Click the Next The Licence Agreement step will be displayed.

  5. Select I accept the terms in the licence agreement.

  6. Click the Next The Registration Information step will be displayed.

  7. Enter the registration details.

  8. Click the Next The Feature Selection step will be displayed.

  9. Click the Next The Ready To Install the Program step will be displayed.

  10. Click the Install button to begin the installation.

  11. Click the Finish button to complete the installation.

Step 3 - ODBC DSN Configuration

Provide Framework with the connection to read and write from the database.

Warning
title

CRITICAL

Microsoft 64-Bit Operating Systems include two ODBC Data Source Administrator executable files.

Depending on the operating system, use the following to open the correct ODBC Data Source:

On 32-Bit Operating Systems: Use either:
Start Menu > Control Panel > Administrative Tools > Data Sources (ODBC)
OR
\\%SystemRoot%\system32\odbcad32.exe (e.g., C:\Windows\system32\odbcad32.exe).

On 64-Bit Operating System: Use:
\\%SystemRoot%\SysWOW64\odbcad32.exe (e.g., C:\Windows\SysWOW64\odbcad32.exe).

ODBC DSN Configuration - Framework ECM

  1. Open Data Sources (ODBC).

  2. Select

    the 

    the System DSN

  3. Click

    the Add The 

    the Add The Create New Data

    Source 

    Source dialog will be displayed.

  4. Select 

    Select SQL Native

    Client 

    Client for the SQL Server version being used.

  5. Click

    the Finish The 

    the Finish The Create a New Data Source to SQL

    Server 

    Server dialog will be displayed.

  6. Enter the following details:

    1. Name: FworkSQLECM

    2. Description (optional): Enter a description for the database connection. For example, Framework ECM.

    3. Server: Select the SQL Server from

      the Server 

      the Server drop-down list.
      OR
      Enter the SQL Server name.

      If there is an error following Step 8, change the server name above to: \[server name]\SQLEXPRESS

  7. Click

    the 

    the Next

  8. Click

    the 

    the Next

  9. Tick 

    Tick Change the default database to.

  10. From the drop-down list select: FworkSQLEcm

  11. Click

    the 

    the Next

  12. Click

    the Finish The 

    the Finish The ODBC Microsoft SQL Server

    Setup 

    Setup dialog will be displayed.

  13. Click

    the 

    the Test Data Source...

  14. If successful, click

    the 

    the OK

  15. Click

    the OK The 

    the OK The ODBC Microsoft SQL Server

    Setup 

    Setup dialog will close.

  16. Click

    the OK 

    the OK The Data Sources (ODBC) dialog will close.

ODBC DSN Configuration - Framework Licence

  1. Open Data Sources (ODBC).

  2. Select

    the 

    the System

    DSN 

    DSN tab.

  3. Click

    the Add 

    the Add button.

    The 

    The Create New Data

    Source 

    Source dialog will be displayed.

  4. Select 

    Select SQL Native Client.

  5. Click

    the Finish 

    the Finish button.

    The 

    The Create a New Data Source to SQL

    Server 

    Server dialog will be displayed.

  6. Enter the following details:

    1. Name: FworkSQLLic

    2. Description (optional): Enter a description for the database connection. For example, Framework Licence.

    3. Server: Select the SQL Server from

      the Server 

      the Server drop-down list.
      OR
      Enter the SQL Server name.

      If there is an error following Step 8, change the server name above to: \[server name]\SQLEXPRESS.

  7. Click

    the Next 

    the Next button.

  8. Click

    the Next 

    the Next button.

  9. Tick 

    Tick Change the default database to.

  10. From the drop-down list select: FworkSQLLic

  11. Click

    the Next 

    the Next button.

  12. Click

    the Finish 

    the Finish button.

    The 

    The ODBC Microsoft SQL Server

    Setup 

    Setup dialog will be displayed.

  13. Click

    the 

    the Test Data Source... button.

  14. If successful, click

    the OK 

    the OK button.

  15. Click

    the OK 

    the OK button.

    The 

    The ODBC Microsoft SQL Server

    Setup 

    Setup dialog will close.

  16. Click

    the OK 

    the OK button. The Data Sources (ODBC) dialog will close.