SETUP INDEX
WebCollab Setup Program
Upgrading to Newer WebCollab Version
Manual Setup for MySQL
Manual Setup for PostgreSQL
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
- For UNIX and other *nix OS:
- Navigate to your main WebCollab directory.
- Make [webcollab_directory]/config/config.php file writable by everyone.
#chmod 666 config.php
- 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.
- Follow the on-screen instructions to setup WebCollab.
- For UNIX and other *nix OS:
- Make config.php protected again.
#chmod 664 config.php
2. Getting Online:
- Point your browser to http://your_site/webcollab_path/index.php. If all is well, you should see a login
page.
Username: admin
Password: admin123
3. Admin Config Setup
- 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.
- Enter the requisite email addresses for your site into the boxes. Click on the descriptions for more help.
- The default check box settings in the lower part of the form can be left for now.
- Press the update button.
4. Change Admin Password and Email Address
- Click on the 'Edit user details' button and change the admin password (and email address).
5. Altering Setup (if required)
- For UNIX: Make [webcollab_directory]/config/config.php writable by everyone.
- Edit config.php, and change $WEB_CONFIG = "Y" (it should have defaulted to "N").
- Point your web browser at http://your_site/webcollab_directory/setup/index.php
- Enter an admin login and password
- Follow the on-screen instructions to setup WebCollab.
- For UNIX: Make config.php protected again.
Note: The config.php can also be edited directly with a text editor. The comments in the file explain most of the
various configuration items.
- Install the new files in a new directory (You can install over the existing directory, but this method is
safer).
- For UNIX: Make sure [webcollab_directory]/config/config.php file is writable by everyone.
- 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.
- At the first screen prompt, choose to use an existing database. Do not create a new database.
- Enter your current database details at the screen prompt that follows.
- Let the setup program continue to the conclusion, but do not attempt to login.
- 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).
- Login as requested...
- Database upgrade is done automatically (If database upgrades are in fact not required, no harm will be done).
- 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.
- 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. You will also need
to the same for the FILE_BASE parameter, if you use the default directory. To do this:
- 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.
- 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.
Note: Database upgrades are required for all pre-2.20 databases.
1. Database Setup and Customisation:
Note: If you are using Linux, you can automate database creation and populating
with tables. See below.
- Make sure you have a valid user account and password for MySQL. (We'll call them 'user_name'
and 'your_password' in this example).
- Choose a new MySQL database name with a convenient name of your choice. (We'll call the database
'webcollab' in this example).
- 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 14
Server version: 5.0.32-Debian_7etch8-log Debian etch distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
- 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 CHARACTER SET utf8;
Query OK, 1 row affected (0.05 sec)
mysql> \q
Bye
#
2. Populate Database:
- Use the provided "webcollab-*.**/db/mysql.sql" script to populate the webcollab
database.
- 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
- 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:
- Open the file webcollab/config/config.php with your favourite text editor.
- Fill in the line define('BASE_URL', ""); with the address of your site:
define('BASE_URL', "http//your_domain.com/webcollab-*.**/" );
- Fill in the lines with DATABASE_NAME, DATABASE_USER and DATABASE_PASSWORD:
define('DATABASE_NAME', "webcollab" );
define('DATABASE_USER', "user_name" );
define('DATABASE_PASSWORD', "your_password" );
- If you are using a database on a remote machine, then change the default value of
DATABASE_HOST too.
- Save and close the file.
4. Getting Online:
- Point your browser to http://yourdomain.com/webcollab-*.**/index.php. If all is well, you
should see a login page.
Username: admin
Password: admin123
5. Admin Config Setup
- 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.
- Enter the requisite email addresses for your site into the boxes. Click on the descriptions for
more help.
- The default check box settings in the lower part of the form can be left for now.
- Press the update button.
6. Change Admin Password and Email Address
- Click on the 'Edit user details' button and change the admin password (and email address).
- Proceed through steps 1 and 2 as above.
- Create and Populate the Database
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:
- Use the provided "webcollab-*.**/db/pgsql.sql" script to populate the webcollab database.
- 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:
- Open the file webcollab/config.php with your favourite text editor.
- Fill in the line define('BASE_URL', ""); with the address of your site:
define('BASE_URL', "http//your_domain.com/webcollab-*.**/" );
- Fill in the lines with DATABASE_NAME, DATABASE_USER, DATABASE_PASSWORD and
DATABASE_TYPE:
define('DATABASE_NAME', "webcollab" );
define('DATABASE_USER', "user_name" );
define('DATABASE_PASSWORD', "your_password" );
define('DATABASE_TYPE', "postgresql" );
- Do not change the default value of DATABASE_HOST unless you have
re-configured PostgreSQL to accept TCP/IP connections
- Save and close the file.
4. Getting Online:
- Point your browser to http://yourdomain.com/webcollab-*.**/index.php. If all is well, you
should see a login page.
Username: admin
Password: admin123
5. Admin Config Setup
- 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.
- Enter the requisite email addresses for your site into the boxes. Click on the descriptions for
more help.
- The default check box settings in the lower part of the form can be left for now.
- Press the update button.
6. Change Admin Password and Email Address
- Click on the 'Edit user details' button and change the admin password (and email address).
- Create and Populate the Database