...
- Framework ECM is installed and in use.
- Framework Logistics Tablet is installed and in use.
Table of Contents | ||
---|---|---|
|
Step 01 - Web Portal Pre-Requisite Checklist
...
Warning |
---|
Your organisation may already have an authenticated Microsoft SQL User available. |
- The following server security changes are the minimum requirements to access the Framework databases. Refer to Microsoft SQL Server documentation for more information on Microsoft SQL Server security.
- The following procedure is based on Microsoft SQL Server 2008 Express Edition and should be used as a guide only
...
- Open Microsoft SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio).
- Connect to the required server.
- Expand: [Server Name] > Security
- Right-click Logins and select New Login. The Login - New dialog will be displayed.
- In the Login Name field, enter: FworkPortalUser
- Tick: SQL Server authentication
- In the Password field, enter: P@ssword
In the Confirm Password field, enter: P@ssword
Warning Ensure a record is kept of the username and password entered as they will be required in upcoming steps.
- From the Default database drop-down list, select: master
- From the sidebar, select User Mapping.
- From the Users Mapped to This Login list, tick the required Framework database(s).
- For the FworkSQLECM and FworkSQLLic databases, ensure the following two items are ticked in the Database role membership for: [framework database] list:
- db_owner
- public
- Click the OK button.
- Close Microsoft SQL Server Management Studio.
...
- Open Windows Explorer.
- Browse to the location of the ini file (typically: C:\php\).
- Edit the ini file.
Update the following settings:
info
.
The following default settings may be different to those listed depending on the PHP version (the following information is based on PHP 5.2.11)
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 |
Offregister_long_arrays | Off | Off |
regOffister_argc_argv | Off | Off |
auto_gOnlobals_jit | On | On |
magic_quOffotes_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. |
...