Simple Groupware Update

Update to PHP 5.3.x


Until Simple Groupware 0.702, the updater is not compatible with PHP 5.3.x. So you need to update Simple Groupware to 0.703+ before updating to PHP 5.3.x. If you change the order, you'll need to do the old update procedure.


Version specific instructions: Update to 0.640+


Beginning with 0.640, Win32 and Debian binaries are no longer included in the default Simple Groupware package. To install them again, do a normal update, login as super administrator, click "Simple Grouwpare Extension Manager" in the admin summary page and install the binary package corresponding to your system.


Version specific instructions: Update to 0.530+


Unfortunately, RSS feeds on Sourceforge.net have changed. So updates from versions before 0.531 cannot be detected automatically. In order to update to the latest release, download a new tar.gz file here and place it under "<sgs-dir>/bin/". Then start the updater and select the new file.


Online/offline update procedure


If your server has a internet connection, you can use the new update procedure to download and install new versions with just 4 clicks in Simple Groupware:

  • Make a complete backup of your database (e.g. using phpMyAdmin)
  • Make a complete backup of your sgs folder (e.g. /var/www/html/sgs/)
  • Make sure both backups are complete!
  • Make the folder sgs/old world writable
  • Login as super administrator
  • Click "Update Simple Groupware" in the administration page
  • Choose the latest release and click "Install"
  • After the new version is processed, click "Continue"
  • When the setup is finished, click again "Continue"
  • Note: If you've changed modules, templates or source code, your changes won't be touched by the update. All files from the old version are moved to "<sgs-dir>/old" and can be merged manually with the new version. To make your changes persistent over updates, see the Customization page.
  • Enjoy Simple Groupware!


If your server has no internet connection, you can use the new update procedure introduced in 0.300 to install a new Simple Groupware package located in the local filesystem:

  • Make a complete backup of your database (e.g. using phpMyAdmin)
  • Make a complete backup of your sgs folder (e.g. /var/www/html/sgs/)
  • Make sure both backups are complete!
  • Make the folder sgs/old world writable
  • Login as super administrator
  • Click "Update Simple Groupware" in the administration page
  • Enter path and filename of the new package and click "Install"
  • After the new version is processed, click "Continue"
  • When the setup is finished, click again "Continue"
  • Note: If you've changed modules, templates or source code, your changes won't be touched by the update. All files from the old version are moved to "<sgs-dir>/old" and can be merged manually with the new version. To make your changes persistent over updates, see the Customization page.
  • Enjoy Simple Groupware!


Unattended update of Simple Groupware


You can update Simple Groupware without the web interface using this command in a shell:

php -d register_argc_argv=1 -q <sgs-dir>/bin/ext/update_unattended.php.txt <url> <admin-user> <admin-pw> <release> <no-backup>

The parameters in detail:

  • url = http://<your-server>/<your-sgs-dir>/bin/index.php
  • admin-user = super administrator username
  • admin-pw = super administrator password
  • release = e.g. 0.659 or latest
  • no-backup = 1=don't backup files, 0=backup files

If the script completes successfully, the return code is 0. If there are errors, return code is 1.


Example:

<perform a backup of your old files and database>

php -q -d register_argc_argv=1 /srv/www/htdocs/sgs/bin/ext/update_unattended.php.txt http://localhost/<sgs-url-dir>/bin/index.php admin admin latest 0


Version specific instructions


Update to 0.500:


To use the new "offline folder synchronization" feature, you need to create a new folder in the user's profile and assign the module "Offline folders" to it. Then set the folder's anchor to "offline_<username>" (directly in the database or under "/Workspace/System/Tree").

Note: New users will automatically have the new folder in their profile.


Update to 0.420:


In case Simple Groupware is used with the Funambol SyncML server, please make sure to uninstall the old Funambol server and install the Funambol v7 server. Also MySQL 5.x or PostgreSQL 8.x is required to run Funambol v7.


Update to 0.321:


This is the last release which is compatible to PHP 4.x.


Update to 0.320:


Upgrade to the new WebDAV server: Please make sure to deploy the new .htaccess from "<sgs-dir>/src/tools/webdav/".


Update to 0.292:


Using MySQL 4.0 is longer possible. So if you're using MySQL 4.0, please upgrade to MySQL 4.1 or 5.x.


Update to 0.291:


This version contains new views for birthdays and anniversaries in contacts and users. These views require a database with sub-query support. So if you're using MySQL 4.0, please upgrade to MySQL 4.1 or 5.x. Also MySQL has discontinued their community support for version 4.0.


Update to 0.270:


The chat module received individual permissions, so passwords are no longer required. The initial permissions include read and write permissions for everyone on each chat room, so you might need to change this after the update in order to protect the chat archives.


Update to 0.252:


In order to use more than one mail address per user, you need to create a new folder called "Mail identities" with the module "System: Mail identities" under "/Workspace/Organisation/".


Update to 0.250:


To get SyncML synchronization working in the user's personal contact folder: Go to "/Workstation/System/Tree" and modify the folder, set the anchor to "contacts_<username>". This marks the folder as the SyncML synchronization folder. If the folder already contains datasets, move the datasets to another folder and move them back, so the triggers can detect the datasets for synchronization. (The user's personal contact folder is located at "/Workspace/Personal folders/<username>/Contacts".)


Update to 0.029:


To get free/busy information about a user's calendar: Go to "/Workstation/System/Tree" and modify the folder, set the anchor to "calendar_<username>" and change the exceptional user rights to "freebusy:read:anonymous". This gives other users the right to read the free/busy information and to find the user's calendar in the tree. (The user's calendar is located at "/Workspace/Personal folders/<username>/Calendar".)


Update to 0.2 beta 11:


Column names have changed in simple_sys_tree. Therefore run this SQL query before doing the update:

ALTER TABLE simple_sys_tree CHANGE level level_old decimal

(e.g. using phpMyAdmin)


Update from 0.2 beta 1-6 to 0.2 beta 7:


Passwords are no longer saved in cleartext. Now the sha1 hash function is used. Therefore you need to modify your database with these sql commands before doing the update:

rename TABLE simple_users to simple_sys_users;

update simple_sys_users set password=sha1(password);

(e.g. using phpMyAdmin)


Update with Linux (e.g. Fedora 4) (old procedure)


  • Make a complete backup of your database (e.g. using phpMyAdmin)
  • Make a complete backup of your sgs folder (e.g. /var/www/html/sgs/)
  • Make sure both backups are complete!
  • DELETE all contents from the bin folder (e.g. /var/www/html/sgs/bin/)
  • Download the latest version of Simple Groupware here.
  • Extract the .tar.gz-file to a temporary folder (e.g. /tmp/sgs/)
    (You should now have an existing folder like /tmp/sgs/src)
  • Copy all files from the temporary folder to your sgs folder and overwrite existing files (e.g. copy from /tmp/sgs/ to /var/www/html/sgs/)
  • Open your browser and go to http://your_server/sgs/bin/.
  • After the translations are rebuilt, click "Continue".
  • Type in your database credentials (the same as in your previous version)
  • Type in your super administrator credentials
  • Confirm the GPLv2 and click "Install"
  • In the next screen click "Continue"
  • Note: If you've changed the configuration in setup settings, you'll need to make these changes again in the new version.
  • Enjoy Simple Groupware!


Update with Windows (old procedure)


  • Make a complete backup of your database (e.g. using phpMyAdmin)
  • Make a complete backup of your sgs folder (e.g. c:\xampp\xampplite\htdocs\sgs\)
  • Make sure both backups are complete!
  • DELETE all contents from the bin folder (e.g. c:\xampp\xampplite\htdocs\sgs\bin\)
  • Download the latest version of Simple Groupware here.
  • Extract the .tar.gz-file to a temporary folder (e.g. c:\temp\sgs\)
    (You should now have an existing folder like c:\temp\sgs\src)
  • Copy all files from the temporary folder to your sgs folder and overwrite existing files (e.g. copy from c:\temp\sgs\ to c:\xampp\xampplite\htdocs\sgs\)
  • Open your browser and go to http://localhost/sgs/.
  • After the translations are rebuilt, click "Continue".
  • Type in your database credentials (the same as in your previous version)
  • Type in your super administrator credentials
  • Confirm the GPLv2 and click "Install"
  • In the next screen click "Continue"
  • Note: If you've changed the configuration in setup settings, you'll need to make these changes again in the new version.
  • Enjoy Simple Groupware!