Setting ResourceSpace Up On Windows 10 With Apache/PHP/MySQL

693 views
Skip to first unread message

Marc B.

unread,
Oct 11, 2017, 12:35:48 PM10/11/17
to ResourceSpace
I initially installed ResourceSpace on a Linux box, but the problem was that since I work in a corporate office dominated by Windows it didn’t integrate as well as I would have liked. The installation instructions on ResourceSpace’s website are a little out of date, so I’m sharing my method here in the event anyone else might find it useful. Keep in mind that I am not using Windows IIS Server but, instead, will walk you through how to install Apache, PHP, and MySQL instead.

Much of this information is taken from other resources I found online. I’m simply tailoring it specifically for a ResourceSpace installation on Windows. Apache, PHP, and MySQL instructions were taken from Alessandro Castellani’s YouTube video: https://www.youtube.com/watch?v=kuMTZowwjus. Instructions for ResourceSpace installation were taken, though slightly modified, from ResourceSpace’s own website: https://www.resourcespace.com/knowledge-base/systemadmin/install_windows_7.

While these instructions were written for Windows 10, they should work with previous versions. Also, I am focusing on 64-bit software, but you should be able to do this with 32-bit as well. Just download the correct version of the software.

First, let’s get all the relevant software. Get the latest of each.

Visual C++ 2017 x64: https://go.microsoft.com/fwlink/?LinkId=746572 (I recommend renaming it since this file and the 2013 version have nearly identical names)
Visual C++ 2013 x64: https://support.microsoft.com/en-us/help/3179560/update-for-visual-c-2013-and-visual-c-redistributable-package (I recommend renaming it since this file and the 2017 version have nearly identical names)
Apache 2.4 x64 - https://www.apachelounge.com/download/
PHP x64 (TS) - http://windows.php.net/download/
MySQL x64 - https://dev.mysql.com/downloads/mysql/
PHPMyAdmin - https://www.phpmyadmin.net/downloads/
7-Zip: http://www.7-zip.org/download.html
ResourceSpace: https://www.resourcespace.com/download
ImageMagick (latest x64 static release): http://www.imagemagick.org/download/binaries/
Ghostscript x64: https://code.google.com/archive/p/ghostscript/downloads
FFMpeg x64: https://www.ffmpeg.org/download.html
ExifTool: https://sno.phy.queensu.ca/~phil/exiftool/


1. Install Visual C++ 2013 and 2017 if not already installed. (Reboot as requested.)

2. Decompress Apache to C:\Apache24

3. Decompress PHP to C:\php

4. Install MySQL. Custom, x64, to C:\MySQL

5. Decompress PHPMyAdmin to C:\Apache24\htdocs\phpmyadmin

6. Add following code to C:\Apache24\conf\httpd.conf:


LoadModule php7_module "c:/php/php7apache2_4.dll"

AddHandler application/x-httpd-php .php

# Configure the path to php.ini

PHPIniDir "C:/php"


7. Change DirectoryIndex from index.html to index.php

8. Change ServerName from www.example.com:80 to localhost

9. Open Cmd as Admin and run: c:\apache24\bin\httpd -k install

10. Rick-click Windows button and choose System, then System Info on the right. Click Advanced system settings on the left. Under Advanced tab click the Environment Variables button. Double-click Path, then New. Add:


C:\php

C:\Apache24

C:\Apache24\bin



11. Create a Temp folder in C:\ (i.e. C:\Temp)

12. Now we’re going to modify the php.ini file. Go to c:\php and duplicate (copy and paste) php.ini-development and rename the copy to php.ini. Open php.ini and find the following entries. If they are commented out with a semicolon (;) remove it, and if the entries aren’t there add them.


short_open_tag = on

memory_limit = 2000M

post_max_size = 1000M

upload_max_filesize = 1000M

max_file_uploads = 5000

default_socket_timeout = 60

upload_tmp_dir = "C:\Temp"

session.save_path = "C:\Temp"

error_log = "C:\Temp\php-errors.log"

cgi.force_redirect = 0

fastcgi.impersonate = 1

fastcgi.logging = 0

extension_dir = "c:\php\ext"



Now make sure the following extensions are uncommented:


extension=php_mysqli.dll

extension=php_gd2.dll

extension=php_ldap.dll

extension=php_mbstring.dll

extension=php_exif.dll

extension=php_openssl.dll



14. Save the file and close.

15. Now let’s get PHPMyAdmin setup. Go to C:\Apache24\htdocs\phpmyadmin and duplicate (copy and paste) config.sample.inc.php. Rename the copy to config.inc.php and open it. Add or edit the following settings:


$cfg['blowfish_secret'] = ''; # enter a long random string of letters and numbers you want for the secret at least 30 characters in length

$cfg['Servers'][$i]['auth_type'] = 'cookie';

$cfg['Servers'][$i]['host'] = '127.0.0.1';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['compress'] = false;

$cfg['Servers'][$i]['extension'] = 'mysql';

$cfg['Servers'][$i]['AllowNoPassword'] = false;



16. Save the file and close it. Now reboot your computer.

17. Once your computer starts, let’s get the rest of the software installed. Install to the following locations:

GhostScript - C:\gs
Python - C:\Python36
ImageMagick - C:\ImageMagick (uncheck Install FFmpeg)
Exfitool - C:\exfitool (remove -k from the filename exfitool-k)
PHP - C:\php

18. MySQL - Run the install and choose Custom. Click MySQL Servers, MyDQL Server, MySQL Server x.x, then click the x64 version followed by the arrow pointing right. Now click MySQL Server x.x in the right column and an Advanced Options will appear below. Click that and change the Install Directory to C:\MySQL. Then continue with the rest of the installation.

19. Open your web browser and go to: http://localhost/phpmyadmin. Use root as the username and the password you created during the MySQL installation. Create a new database called resourcespace (Collition type is fine).

20. Now decompress the ResourceSpace in C:\Apache24\htdocs. Now we need to edit the folder permissions for the “filestore” and “include” folders. For both, right-click the folder and choose Properties. Under the Security tab click Edit, then Add, and type in the bottom box Everyone. Click OK. Highlight Everyone under Group or User Names and check “Modify” under Allow. Click Apply and then OK.

21. Go to http://localhost and you will be presented with ResourceSpace’s configuration screen. Use the following settings:


MySQL Server -------> 127.0.0.1

MySQL Username -------> root

MySQL Password -------> same as MySQL installation

MySQL Database -------> resourcespace

MySQL Binary Path -------> "c:\mysql"

Application Name -------> "Name of Company"

Base URL -------> http://(name-of-server)

Admin username -------> first user of the system (part of "Super Admins" user group)

Admin password -------> password for the above user (cannot be empty and needs to respect the password policy which is set by default)

Email from address -------> valid-...@domainname.com

Email notify -------> valid-...@domainname.com

Spider Password -------> leave as is or change to anything you like

Scramble Key -------> leave as is or change to anything you like

Secure (https) mode -------> leave unchecked


Imagemagick Path -------> c:/imagemagick

Ghostscript Path -------> c:/gs/gsx.xx/bin (specify the actual folder name for the version)

FFMpeg Path -------> c:/ffmpeg/bin

Exiftool Path -------> c:/exiftool

AntiWord Path -------> leave blank

PDFtotext Path -------> leave blank



Click Begin Installation button.

That should be everything you need to do to get ResourceSpace up and running on a Windows system using Apache, PHP, and MySQL. Hopefully this will help some folks who might be interested in taking this approach.
Reply all
Reply to author
Forward
0 new messages