Collabtive

Open Source Project Management

Collabtive is web-based project management software intended for small to medium-sizes businesses and freelancers. It is an open Source alternative to proprietary tools like Basecamp. Key features include tracking of projects, milestones, and tasks, importing from Basecamp, timetracking and reporting.

This appliance includes all the standard features in TurnKey Core, and on top of that:

  • Collabtive configurations:
    • Installed from upstream source code to /var/www/collabtive

      Security note: Updates to Collabtive may require supervision so they ARE NOT configured to install automatically. See below for updating Collabtive.

  • SSL support out of the box.
  • Adminer administration frontend for MySQL (listening on port 12322 - uses SSL).
  • Postfix MTA (bound to localhost) to allow sending of email (e.g., password recovery).
  • Webmin modules for configuring Apache2, PHP, MySQL and Postfix.

Supervised Manual Collabtive Update

Always ensure that you have a current and tested backup before performing an upgrade. Ideally also do a test upgrade proceedure on a development server, before updating your production server.

  1. Download the latest version of Collabtive:
    cd /var/www
    URL=https://sourceforge.net/projects/collabtive/files/latest/download
    wget $URL -O collabtive.zip
    
  2. Move the current config:
    mv /var/www/collabtive/config /var/www/collabtive/config.orig
    
  3. Unpack the Collabtive archive - replacing all existing files:
    unzip collabtive.zip -d /var/www/collabtive
    
  4. Move original config back into place:
    cp -R /var/www/collabtive/config.orig/* /var/www/collabtive/config/
    
  5. Ensure directory is owned by the webser user (www-data):
    chown -r www-data:www-data /var/www/collabtive
    
  6. Point your browser to update.php and follow the in browser instructions.
  7. Delete install.php and update.php from your server.

Usage details & Logging in for Administration

No default passwords: For security reasons there are no default passwords. All passwords are set at system initialization time.

Ignore SSL browser warning: browsers don't like self-signed SSL certificates, but this is the only kind that can be generated automatically. If you have a domain configured, then via Confconsole Advanced menu, you can generate free Let's Encypt SSL/TLS certificates.

Web - point your browser at either:

  1. http://12.34.56.789/ - not encrypted so no browser warning
  2. https://12.34.56.789/ - encrypted with self-signed SSL certificate

Note: some appliances auto direct http to https.

Username for adminer:

Login as username adminer

Username for collabtive:

Login as username admin

Username for database administration:

  1. Adminer; login as MySQL username adminer:

    https://12.34.56.789:12322/ - Adminer database management web app

  2. MySQL command line tool; log in as root (no password required):
    $ mysql --user root
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql>
    

Username for OS system administration:

Login as root except on AWS marketplace which uses username admin.

  1. Point your browser to:
  2. Login with SSH client:
    ssh root@12.34.56.789
    

    Special case for AWS marketplace:

    ssh admin@12.34.56.789
    

* Replace 12.34.56.789 with a valid IP or hostname.