Installing on Windows Server
IMPORTANT: Follow the below instructions but keep in mind you may need to adjust to be suitable for your own version of Windows Server OR preferences (name wise).
Please make sure the machine has a static IP and that you are using a user who is a member of the local administrators' group.
Set the IIS Web Server role
- Make sure Web Server -> Web Server -> Application Development -> CGI is ticked for FastCGI otherwise you may get an error like: "Handler "PHP_via_FastCGI" has a bad module "FastCgiModule" in its module list"
Install Web Platform Installer to help with PHP and MySQL install
- Open WPI
- Search for PHP and select the version of PHP you would like to install (e.g PHP 7.1.7 (x64) For IIS Express)
- Search MySQL and select the version of MySQL you want to install (e.g. MySQL Windows 5.5). Please set and remember the password used for "root".
See configuring php.ini for more information. Always adjust values based on your server hardware configuration.
- Open IIS Manager
- Create a new Application Pool called "ResourceSpaceAppPool"
- Edit Application pool -> Advanced Settings. Look for "Identity" and change it to "LocalSystem" then click OK
- Start the newly created Application Pool
- Create a new website called "ResourceSpace", make sure to specify the path to where you want to checkout ResourceSpace. Opt in to start website immediately.
Verify IIS settings for PHP with FastCGI
- Open IIS Manager
- Select the server name in the panel on the left side
- Select FastCGI Settings on the right panel
- Confirm the Full path is correct
- With the server name selected on the left panel, also check "Default Document" and make sure it has index.php in the list
Check PHP works
- Create a new file "index.php" in C:\inetpub\wwwroot
- Add the line
<?php phpinfo(); ?>
- Save and test in browser
- Delete file once done or at least comment it
- Go to http://www.imagemagick.org/download/binaries
- Download the newest portable version which should look like "ImageMagick-7.0.10-22-portable-Q16-x64.zip"
- Go to http://code.google.com/p/ghostscript/downloads/list
- Download the latest version for your OS
- Go to where you installed it, in gs/gsX.XX/bin folder and copy gswin64c.exe and rename the copy to gs.exe
- Go to https://www.ffmpeg.org
- Choose the latest release build (ie. NOT nightly git build) for x64 architecture, static
- Go to https://exiftool.org
- Extract the contents in your desired location in a folder called "exiftool"
- Go to "exiftool" folder
- Rename "exiftool(-k).exe" to "exiftool.exe"
Note: you should install libraries where it is appropriate for your system.
- Go to https://tortoisesvn.net
- When installing make sure to tick "command line client tools" to be installed as well
Set up ResourceSpace
- Go to the location where you want ResourceSpace to be installed (i.e web root folder or subfolder inside web root)
- Checkout from Subversion repository (See https://www.resourcespace.com/svn)
- Create a new folder called filestore
- Edit folder permissions for "filestore" and "include"
- Right-click the "filestore" folder and choose "Properties"
- Click the "Security" tab
- Click Edit
- Click Add
- Click Locations
- Navigate to and select the local machine name then click OK
- Type "Everyone" in the box under "Enter the object names to select" then click OK
- With the "Everyone" group selected in the "Groups or user names" section, check the box under the "Allow" column next to "Modify" then click Apply
- Click OK twice to get out of those windows.
- Repeat for "include" folder as well
- Create database ( CREATE DATABASE resourcespace CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; )
- In your browser, go to http(s)://localhost (note: if you installed in a subfolder, then obviously append the subfolder to the URL)
- Leave "MySQL binary path" blank
- In the Paths section just fill in the paths that you have set when you installed dependencies (should roughly be)
- Once installed, remove the folder permissions (ie undo allowing to Modify) for Everyone on the include folder. ResourceSpace will create the config.php file during the setup process. Once installed IIS only needs to be able to read the files.
- Set a scheduled task to run [webroot]/pages/tools/cron_copy_hitcount.php, where [webroot] is the location of your ResourceSpace installation.
Important: When the system is in full use (i.e. when you go live) the file 'cron_copy_hitcount.php' should be set to execute once each night to ensure relevance matching is accurate. You can do this using the Windows Task Scheduler utility:
- Action: "Start a program"
- Program/script: "path/to/php.exe"
- Add arguments: -f "path/to/cron_copy_hitcount.php"
- Install MySQL Workbench