PHP install/upgrade
- PHP 5.4 is compatible with Supplier Connect Response Portal Version 7. It is recommended for security reasons to update to PHP version 7.1
Microsoft Web Platform Installer
- Logon to the machine running the IIS
- Download and install Microsoft Web Platform Installer 5.0 is not already installed.
Link https://www.microsoft.com/web/downloads/platform.aspx or Search 'Microsoft Web Platform Installer'
Packages to be installed
'PHP 7.1.7 (x86) for IIS Express'
'Microsoft Drivers 4.3 (x86) for PHP v7.1 for SQL Server in IIS'
'Windows Cache Extension 2.0 (x86) for PHP 7.1 in IIS Express (Automaitcally selected when PHP is selected)
'PHP Manager for IIS'
- Click on Products and Search for PHP 7.1
- Search for PHP Manager
- Install the following packages
Configure PHP.ini File
Edit the C:\Program Files (x86)\PHP\v7.1\php.ini
Update the following Settings
| FieldName | DefaultSetting | Required Setting |
|---|---|---|
| sql.safe_mode | Off | Off |
| max_execution_time | 300 | 60 |
| error_reporting | E_ALL & ~E_DEPRECATED & ~E_STRICT | E_ERROR & E_WARNING |
| register_argc_argv | Off | Off |
| auto_globals_jit | On | On |
| extension_dir * | "./" | "./" |
| enable_dl | Off | Off |
| cgi.force_redirect * | 1 | 0 |
| fastcgi.impersonate * | 1 | 1 |
| SMTP | localhost | [servername or IP address] |
| smtp_port | 25 | [server'ssmtp portnumber] |
| 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, it MUST be removed.
Find the Windows Extensions section of the php.ini file
Add the following
- extension=php_odbc.dll
Save the php.ini file
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. (If your SQL Server is configured on a different port use that port number) |
| 53 | Optional | The DNS port is not required by Framework however is sometimes enabled to address network communications performance issues. |
Configure ODBC DSN Connection
Install SQL Native Client if not already installed on to the IIS Server.
Framework ECM - ODBC DSN Configuration
1. Open Data Sources (ODBC).
2. Select the System DSN tab.
3. Click the Add button. The Create New Data Source dialog will be displayed.
4. Select SQL Native Client for the SQL Server version being used.
5. Click the Finish button. The Create a New Data Source to SQL Server dialog will be displayed.
6. Enter the following details:
- Name: FworkSQLECM
- Description (optional): Enter a description for the database connection. For example, Framework ECM.
- Server: Select the SQL Server from 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 button.
8. Select With SQLServer authentication using a login ID and password entered by the user.
9. In the Login ID field, enter: eg. FworkPortalUser
10. In the Password field,enter: eg. P@ssword
Click the Next button.
11. Tick Change the default database to.
12. From the drop-down list select: FworkSQLEcm
13. Click the Next button.
14. Click the Finish button. The ODBC Microsoft SQL Server Setup dialog will be displayed.
15. Click the Test Data Source... button.
16. If successful, click the OK button.
17. Click the OK button. The ODBC Microsoft SQL Server Setup dialog will close.
18. Click the OK button. The Data Sources (ODBC) dialog will close.
Framework License - ODBC DSN Configuration
1. Open Data Sources (ODBC).
2. Select the System DSN tab.
3. Click the Add button. The Create New Data Source dialog will be displayed.
4. Select SQL Native Client for the SQL Server version being used.
5. Click the Finish button. The Create a New Data Source to SQL Server dialog will be displayed.
6. Enter the following details:
- Name: FworkSQLLic
- Description (optional): Enter a description for the database connection. For example, Framework ECM.
- Server: Select the SQL Server from 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 button.
8. Select With SQLServer authentication using a login ID and password entered by the user.
9. In the Login ID field, enter: eg. FworkPortalUser
10. In the Password field, enter: eg. P@ssword
11. Click the Next button.
12. Tick Change the default database to.
13. From the drop-down list select: FworkSQLLic
14. Click the Next button.
15. Click the Finish button. The ODBC Microsoft SQL Server Setup dialog will be displayed.
16. Click the Test Data Source... button.
17. If successful, click the OK button.
18. Click the OK button. The ODBC Microsoft SQL Server Setup dialog will close.
19. Click the OK button. The Data Sources (ODBC) dialog will close.
Implement Website Files
Copy the Website files to C:\inetpub\wwwroot\SupplierConnect (make sure to backup existing files if they exist)
Folder Permissions for InternetGuestAccount(servername_IUSR)
| Folder | Permissions |
|---|---|
| C:\inetpub\wwwroot\SupplierConnect\ | Read |
| C:\inetpub\wwwroot\SupplierConnect\Sessions | Read Write Modify |
Configure Website Files
Edit the file 'C:\inetpub\wwwroot\SupplierConnect\inc_files\config.php' using Notepad.
Modify the following lines with the DSN Name, Username and Password you used to create the ODBC Connection above.
$dsn = "FworkSQLEcm"; // ODBC connection of database.
$user = "FworkPortalUser"; // username for connecting to the DB
$pass = "P@ssword"; // Password for connecting to the DB
$footerText = "Copyright Insula Group Pty Ltd"; - You can insert your company name between the quotes
$emailFromAddr = "SupplierConnect@frameworkecm.com.au"; // From email addresses,
Setting below is used to determine if the Email Receipt checkbox is automatically checked (on) or not checked (off).Setting below is used to determine if the Email Receipt checkbox is automatically checked (on) or not checked (off). Switch between "on" and "off". NOTE: If the response is a call off the checkbox will NOT be checked regardless of this setting.
$emailResponseReceiptOn = "off";
Check FrameworkSupplierConnect Portal
Once FrameworkSupplierConnect is installed and configured, the website must be tested.
To access the newly created website:
1. Open Web Browser.
2. In the URL,enter: http://[servername]/SupplierConnect/response/response.php
