Installing Pro Schedule Web

When you have a functioning web server you will then install the software into your web server's script folder. For example, when using IIS your scripts folder might be C:\Inetpub\Scripts. Run the Setup.exe program and choose this scripts folder as the destination folder.

System Requirements

To run this software you will nee a functioning Windows-based web server that can run Windows CGI executables. A common web server is Microsoft's IIS. Pro Schedule Web should run on any Windows compatible web server. If it doesn't work with yours let us know.

Running Pro Schedule Web on your clients

To launch Pro Schedule from a client browser simply enter its URL. For example, "http://127.0.0.1/scripts/ProSchedWeb.exe" or "http://localhost/scripts/ProSchedWeb.exe". Replace the "127.0.0.1/scripts" or "localhost/scripts" part with whatever your tcp-ip address, logical script library is.

Configuring Pro Schedule Web


To configure Pro Schedule Web select the Configuration link at the top of the Pro Schedule Web screen. The Configuration screen allows changes to the Pro Schedule Web configuration.

Using Data From a Previous Version


If you have been using Pro Schedule Standard or Pro Schedule Client-Server you may wish to use this data with Pro Schedule Web. To use the old data perform these steps:
1. Make a backup of your existing old data
2. Delete the Security.Dat and Security.idx files from your old data folder
3. Copy the remaining tables over to the new data folder on your server

Setting Permissions in IIS

You must give execute permissions to the CGI web folder (for IIS this is the scripts folder), this is the folder where our program executable is located. In the IIS console's "Directory Security" tab "Execute Permissions" should be set to "Scripts and Executables" for the Scripts folder. No IIS permissions need to be set at all for the SCRIPTS\DATA folder.

Select "Integrated Windows Authentication".

Don't set "Web Sharing", only NT Directory Permissions. For the anonymous Internet user (i.e. IUSR_xxx) account, set as following:

SCRIPTS ("All" - since anonymous cannot do anything bad via web anyway)
SCRIPTS\DATA ("All" - since anonymous cannot do anything bad...)
SCRIPTS\TEMP ("All" - since anonymous cannot do anything bad...)

For the Temp folder, you should make sure the Allow inheritable permissions from parent to propagate to this object is set. This is because subfolders are created when reports are run.

If you can run the software but you see little boxes with a red X in them the PSFiles folder does not have read access permissions set.

In the scripts folder you'll see a folder called PSFiles. This folder contains the images used in the application. You must set read access security for the Internet Guest account (IUSR_machinename) on this folder or these images will not show up in the web application. Similarily, the PSReports folder must also have read access in order to view reports.

IIS 6 Notes

The ProSchedWeb.exe file must be specifically given permission to run in IIS 6. Enabling executables in the web properties for the site is NOT enough. You have to add ProSchedWeb.exe to the Web Applications section.

Troubleshooting


If you are having problems running the software try entering this url in your browser:
http://127.0.0.1
If you have an index.html or default.html file in your web server's root folder you should see it now. If not your web server is not running.

If you see your default web page but still cannot run our software try downloading this file:
http://www.cyber-matrix.com/download/consolecgi.zip
Unzip this file into your scripts folder and run it by entering this url in your browser:
http://127.0.0.1/scripts/ConsoleCGI.exe
If successful you should see a page of system information. If not your server is not setup to run CGI executables.

If the ConsoleCGI test worked but you cannot run our software this means the Data folder, containing the database tables does not have the appropriate permissions set. The most common reason is that the Internet Guest account (IUSR_machinename), which is by default part of the "Everyone" group, does not have Write permissions on the database files. To fix this problem, use the Security tab in Explorer to adjust the properties for the Data folder so that the Internet Guest account has the correct permissions.

If you can run the software but you see little boxes with a red X in them, the PSFiles folder does not have read access permissions set.

Apache Server Installation

Install the CyberMatrix Pro Schedule Web software by running the pswsetup.exe program. When prompted for a folder to install the application to, choose a new directory outside of the Apache document tree. For example, use C:\CyberMatrix.

Note: You should not install the application to the Apache cgi-bin directory! It will not operate correctly if installed to this location.

Configure Apache

Open the Apache httpd.conf file in Notepad or other text editor. You can open it with Start -> All Programs -> Apache HTTP Server -> Configure Apache Server -> Edit the Apache httpd.conf Configuration File, or the default location of this file is C:\Program Files\Apache Group\Apache2\conf\httpd.conf.

Add the following section to the httpd.conf file. If you are not using a virtual hosting configuration, add these lines to the bottom of the file. Otherwise, add them to the appropriate VirtualHost section.

  Alias /CyberMatrix C:/CyberMatrix

  <Directory "C:/CyberMatrix">
    Options +ExecCGI
    AddHandler cgi-script .exe
  </Directory>

  <Directory "C:/CyberMatrix/ProSData">
    Order Deny,Allow
    Deny from all
  </Directory>

The Alias line tells Apache to map all URL's that start with /CyberMatrix to the C:/CyberMatix directory (i.e. the directory you installed the application to above. If you used a different directory, then use that directory instead of C:/CyberMatrix throughout these configuration lines.)

The next section tells Apache that files that end with .exe are to be executed as CGI applications. All other files (images, etc.) are handled using the default static content handler.

The last section protects files in the ProSData directory from being downloaded directly through client browsers.

Save your changes to the httpd.conf file.

Test Configuration

Restart the Apache Server so it will re-read the configuration file. Use the Apache Services Monitor icon on the taskbar or restar the server with Start -> All Programs -> Apache HTTP Server -> Control Apache Server -> Restart.

If the server fails to restart, you may have made an error in the configuration settings. Review the Error Log to see what the problem is and double-check the configuration file.

When the server has restarted, execute the Pro Schedule Web application by navigating to http://localhost/CyberMatrix/ProSchedWeb.exe. This URL is formed by combining the server name, the value used in the Alias directive above, and the application file name.