Versions Compared

Key

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

...

  • Framework ECM is installed and in use.
  • Framework Logistics Tablet is installed and in use.

Table of Contents
maxLevel1


Step 01 - Web Portal Pre-Requisite Checklist

...

info
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

...


  1. Open Microsoft SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio).
  2. Connect to the required server.
  3. Expand: [Server Name] > Security
  4. Right-click Logins and select New Login. The Login - New dialog will be displayed.



  5. In the Login Name field, enter: FworkPortalUser
  6. Tick: SQL Server authentication
  7. In the Password field, enter: P@ssword
  8. 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.


  9. From the Default database drop-down list, select: master
  10. From the sidebar, select User Mapping.



  11. From the Users Mapped to This Login list, tick the required Framework database(s).
  12. 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
  13. Click the OK button.
  14. Close Microsoft SQL Server Management Studio.

...

  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:

    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 NameDefault SettingRequired Setting
safe_mode

Off

Off
max_execution_time3060
error_reporting **E_ALLE_ERROR & E_WARNING
register_globalsOff

Off

Offregister_long_arraysOffOff
regOffister_argc_argvOffOff
auto_gOnlobals_jitOnOn
magic_quOffotes_gpcOffOff
extension_dir"./""C:\php\ext"
enable_dlOnOff
cgi.force_redirect *10
fastcgi.impersonate *11
SMTPlocalhost[server name or IP address]
smtp_port25[server's smtp port number]
sendmail_from *me@example.com[administrator@acmehomes.com.au]
odbc.defaultlrl409665536
session.auto_start00

* 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.

...