...
...
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Article Index
| Table of Contents |
|---|
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'
...
'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
...
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 * | [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
...
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
...
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
...
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
...
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.
...
$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.
...
2. In the URL,enter: http://[servername]/SupplierConnect/response/response.php?sp=
...
Test SMTP Relay from IIS Server
This requires the telnet client to be installed, to do that, please perform the below commands:
Run powershell as an administrator
Type: "Import-Module servermanager" without the quotes, press enter
Type "Add-WindowsFeature Telnet-client", press enter
Other ways to add this include through dism (cmd line), or via server manager directly.
Open up command prompt and type the following commands:
telnet smtp server name/ip/fqnd 25 (specify the server name, and that we want to connect via port 25), e.g. telnet exch-srvr1 25, telnet exch-srv1.domain.local 25, telnet 10.1.1.2 25
ehlo domainname.com.au (e.g. ehlo insulagroup.com.au - you can also use helo, depending on your exchange servers configuration)
mail from: supplierconnect@domainname.com.au
rcpt to: externaluser@externaldomain.com.au (this can be any domain that is not equal to your domain name, i.e. in the case of franchisees/business units that may operate under different names. E.g. Support@insulagroup.com.au)
data
subject: Test message from IIS Server
This is a test message only, no action required
. (period will close the command, so just the . then press enter)
type "quit" to exit the session.
After the above steps have been completed, you should get a message saying 'ok - message accepted', followed by an email sent to your inbox
...