WebCollab Setup

SETUP INDEX

WebCollab Setup Program
Upgrading to Newer WebCollab Version
Manual Setup for MySQL
Manual Setup for PostgreSQL

WEBCOLLAB SETUP PROGRAM

Note: To enable the setup program to write to your configuration file, the file '/config/config.php' must be made writable by the web server. If the file is not writable, then only the databases can be created.

1. First Time Setup

  1. Navigate to your main WebCollab directory.
  2. For UNIX: Make [webcollab_directory]/config/config.php file writable by everyone.
    #chmod 666 config.php
    
  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. Follow the on-screen instructions to setup WebCollab.
  5. For UNIX: Make config.php protected again.
    #chmod 664 config.php
    
  6. Login at http://your_site/webcollab_directory/index.php (The default username/password is admin / admin123).

3. Altering Setup

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

UPGRADING WEBCOLLAB TO A NEWER VERSION

  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. All done!
  11. You can now delete your old WebCollab directory, and rename the new WebCollab directory to match the old. Note that you must change the $BASE_URL parameter in /config/config.php to match the correct directory.
  12. For UNIX: Make config.php protected again.

The database upgrades (if required) are backwardly compatible and do not affect stored data. However, as with all upgrades, backing up your data is a sensible precaution.
Database upgrades are required on pre-1.40 and pre-1.60 databases.

MANUAL SETUP FOR MYSQL

1. Database Setup and Customisation:

Note: If you are using Linux, you can automate database creation and populating with tables. See below.

  1. Make sure you have a valid user account and password for MySQL. (We'll call them 'user_name' and 'your_password' in this example).
  2. Choose a new MySQL database name with a convenient name of your choice. (We'll call the database 'webcollab' in this example).
  3. Enter the MySQL database command mode. Make sure that your user_name has enough rights to make new databases. Enter your password when prompted.
    # mysql -u user_name -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 114 to server version: 3.23.54
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    
    mysql>
    
  4. Create the database 'webcollab', and then quit the command mode. Don't forget the semi-colon at the end of the first line!
    mysql> CREATE DATABASE webcollab;
    Query OK, 1 row affected (0.05 sec)
    
    mysql> \q
    Bye
    #
    

2. Populate Database:

  1. Use the provided "webcollab-*.**/db/mysql.sql" script to populate the webcollab database.
  2. For a *nix system navigate to your web server root directory. Enter your password again when prompted.
    #mysql -u user_name -p webcollab<./webcollab-*.**/db/schema_mysql.sql
    
  3. If you are installing to a Windows system, then from the command prompt, work your way into the "webcollab/db" folder. Then, run the following command:
     mysql -uuser_name -pyour_password webcollab>schema_mysql.sql
    

3. Configuration File Customization:

  1. Open the file webcollab/config/config.php with your favourite text editor.
  2. Fill in $BASE_URL with the address of your site:
    $BASE_URL = "http//yourdomain.com/webcollab-*.**/";
    
  3. Fill in $DATABASE_NAME, $DATABASE_USER and $DATABASE_PASSWORD:
    $DATABASE_NAME="webcollab";
    $DATABASE_USER="user_name";
    $DATABASE_PASSWORD="your_password";
    
  4. If you are using a database on a remote machine, then change the default value of $DATABASE_HOST too.
  5. Save and close the file.

4. Getting Online:

5. Change Admin Password and Email Address

6. Admin Config Setup

  1. From the main screen, click on the 'Admin config' link in the menu boxes, left hand side of page. Depending on your screen resolution, you may have to scroll down to see it.
  2. Enter the requisite email addresses for your site into the boxes. Click on the descriptions for more help.
  3. The default check box settings in the lower part of the form can be left for now.
  4. Press the update button.

AUTOMATED MYSQL INSTALLATION FOR LINUX

  1. Proceed through steps 1 and 2 as above.
  2. Create and Populate the Database

MANUAL SETUP FOR POSTGRESQL

1. PostgreSQL Database Setup and Customisation:

Note: If you are using Linux, you can automate database creation and populating with tables. See below.

2. Populate Database:

  1. Use the provided "webcollab-*.**/db/pgsql.sql" script to populate the webcollab database.
  2. For a *nix system navigate to your web server root directory. Enter your password again when prompted.
    # psql -U 'database_user' -e 'database_name' < schema-pgsql.sql
    

3. Configuration File Customization:

  1. Open the file webcollab/config.php with your favourite text editor.
  2. Fill in $BASE_URL with the address of your site:
    $BASE_URL = "http//yourdomain.com/webcollab-*.**/";
    
  3. Fill in $DATABASE_NAME, $DATABASE_USER, $DATABASE_PASSWORD and DATABASE_TYPE:
    $DATABASE_NAME="webcollab";
    $DATABASE_USER="user_name";
    $DATABASE_PASSWORD="your_password";
    $DATABASE_TYPE="postgresql"
    
  4. Do not change the default value of $DATABASE_HOST unless you have re-configured PostgreSQL to accept TCP/IP connections
  5. Save and close the file.
  6. Follow on from the MySQL instructions above

AUTOMATED POSTGRESQL INSTALLATION FOR LINUX

  1. Create and Populate the Database