Installing WebCollab with MySQL and PostgreSQL

BASICS

You need to have access to webserver running Apache, MySQL and PHP. Operating system can be either Linux, Windows or a similar variant running the prerequiste software.

You also need to have the ability to create a MySQL database and tables on this machine or another networked machine

WebCollab can also be installed on a webserver running the PostgreSQL database. The procedure is similar to installing to MySQL. Just select PostgreSQL in the data entry screens

Notes for WebCollab 3.00 and above:

1. PHP minimum version is 5.2.0, with 5.3.2 recommended (for SHA256 support).
2. PHP is required to have the optional multibyte strings (mbstring) support compiled in.
3. The PDO database extension is required.

INSTALLATION

1. Download the most recent copy of WebCollab (see the download link).
2. Unpack the tarball/zip in your web root directory. For the tarball use:

   # tar -zxvf webcollab-*.**.tar.gz

   [Note: replace the *.** with the current version that you've got (e.g. webcollab-3.00.tar.gz).].
3. For *NIX systems (Linux): Navigate to your main WebCollab directory and make config.php writeable by everyone.

   # chmod 666 config.php

4. Point your web browser at http://your_site/webcollab-*.*/setup.php
   (Replace 'your_site'and 'webcollab-*.*' with the relevant values for your site.
5. Follow the on-screen instructions to setup WebCollab.
6. For *NIX systems: Make config.php protected again.

   # chmod 664 config.php

ALTERING AN EXISTING SETUP

1. For *NIX systems: Make config.php writeable by everyone.
2. Edit config.php and change $WEB_CONFIG = "Y" (it should have defaulted to "N" to enhance security).
3. Point your web browser at http://your_site/webcollab-*.*/setup.php
4. Enter an admin login and password.
5. Follow the on-screen instructions to setup WebCollab.
6. For *NIX systems: Make config.php protected again.

UPGRADING WEBCOLLAB TO A NEWER VERSION

Note: Database upgrades are required on all existing databases prior to version 3.00.

1. Install the new files in a new directory (You can install over the existing directory, but this method is safer).
2. For UNIX: Make sure [webcollab_directory]/config/config.php file is writable by everyone.
3. Point your web browser at http://your_site/webcollab_directory/setup.php (Replace 'your_site'and 'webcollab_directory' with the relevant values for your site.
4. At the first screen prompt, choose to use an existing database - instead of creating a new database.
5. Enter your current database details at the screen prompt that follows.
6. Let the setup program continue to the conclusion, but do not attempt to login.
7. Point your browser at http://your_site/webcollab_directory/update.php (Replace 'your_site'and 'webcollab_directory' with the relevant values for the new files on your site).
8. Login as requested...
9. Database upgrade is done automatically (If database upgrades are in fact not required, no harm will be done).
10. If you are storing uploaded files in the default upload directory of /files/filebase, you need to copy/move the existing uploaded files across to the same directory in the new WebCollab.
11. You can now delete (or archive) your old WebCollab directory, and rename the new WebCollab directory to match the old.
12. Note that you must also change the BASE_URL parameter in /config/config.php to match the correct directory. If you use the default file upload directory, you will need to the same for the FILE_BASE parameter. To do, either, or both of these items:
    • Open config.php with your favourite text editor
    • Find the line with BASE_URL. It is near the top of the file.

      define('BASE_URL', "http//your_domain.com/old_webcollab_directory/" );

    • Change this line to match the new directory (Don't forget the trailing slash...)

      define('BASE_URL', "http//your_domain.com/new_webcollab_directory/" );

    • Now make sure that FILE_BASE is pointing to the right upload directory. The entry needs to be a full path to the new upload directory:

      define('FILE_BASE', "/var/www/html/webcollab/files/filebase" );

    • Save the edited file.
13. All done!
14. For UNIX: Make config.php protected again.

The database upgrades (if required) are backwardly compatible for databases after version 2.00 and do not affect stored data. However, as with all upgrades, backing up your data is a sensible precaution.

MANUAL INSTALLATION

For a manual setup of WebCollab, see the detailed instructions here